SQL Developer

St. Louis

Job Description:

TechnicalSKills: 

  • SQL Development Skills
  • Teradata Experience 
  • AWS/Cloud is a huge plus
  • Front end development experience with Microstrategy is strongly preferred but not required. 

JobDescription:         

  • Senior Application Software Engineer (AWS Cloud Services)
    Formal Title – Senior Application Software Engineer (ETL)
  • Reports to IT Manager, Enterprise Data and Analytic Solutions
  • Position Purpose: Design, build, test and maintain scalable and stable application or custom built
    technology solutions to meet business needs. Act as a subject matter expert for Application Software
    developers and Engineers.

Responsibilities:

  • Contribute to the entire implementation process including driving the definition of improvements based on business need and architectural improvements
  • Meet with business partners to understand business needs
  • Responsible for overall design of the solution
  • Design, build and test applications
  • Conduct root cause analysis and advanced performance tuning for complex business processes and functionality
  • This role will be a member of a development scrum team of around 6-7 people
  • Research and understand data and application issues.
  • Tasks could include supporting on-premesis Teradata development, migration of on-prem development to the cloud (AWS & Redshift) and ongoing development and support of new products within the cloud environment.

Education/Experience:

  • Bachelor's degree in Computer Science, MIS, related field or equivalent experience. 3+ years of related experience.
  • Experience with SQL. Experience with various databases, including: Teradata, Oracle,PostgreSQL or SQL Server. Cloud experience preferred.


Preferred Skills/Experience:

  • Cloud environment (AWS, Azure, GCP)
  • Big Data (Hadoop, Redshift, Cassandra, MongoDB, etc.)
  • ETL (Talend, Glue, etc.)
  • Script/Programming (Python, Perl, Scala, R, etc.)
  • Business Intelligence Tools (MicroStrategy, Business Objects, Cognos or SAS)

Definitionof success:

  • Develops scalable, well-tuned processes that meet business’ needs.
  • Is able to troubleshoot medium to high complexity issues related to application functionality.
  • Is viewed by peers, IT management and business partners as a key contributor to maintaining quality support of the enterprise Financial Analytics tools.
  • Management is informed of roadblocks and issues that exceed standard response time.
  • Needed accomplishments
  • Become a Subject Matter Expert on Centene’s ad hoc reporting environment and data warehouse in order to support development by ad hoc users.
  • Become a Subject Matter Expert on Centene’s suite of enterprise dashboards and reports.
  • Specific Assignments
  • Develop and maintain data development and scheduling processes that support enterprise report and dashboard development
  • Troubleshoot issues and respond to inquiries related to the Financial Analytics suite of applications
  • Develop and maintain automated data quality and monitoring checks
  • Performance tuning for on-prem and cloud solutions
  • Rebuilding stored procedures and developing ETL processes as part of the Financial Analytics application migration to the cloud and contributing overall to development of cloud solutions

 

 


Key Skills:

  • TERA DATA

Share Profile