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