Shift Code Analytics - O'Fallon, MO
posted 5 days ago
Full-time - Mid Level
O'Fallon, MO
About the position
The Lead ETL Developer position at O'Fallon, MO, is a contract role focused on leading software engineering projects and enhancing software solutions. The role involves overseeing the development and maintenance of ETL processes, ensuring compliance with service level agreements (SLAs), and mentoring team members throughout the software development lifecycle (SDLC).
Responsibilities
- Successfully lead major projects and complex assignments with broad scope and long-term business implications.
- Create solutions with high level of innovation, cost effectiveness, high quality and faster time to market.
- Lead day to day system development and maintenance activities of the team to meet service level agreements (SLAs).
- Partner with Project Managers in implementation of processes per the evolving needs of the team and the solutions.
- Create detailed cost and time estimates for implementing business solutions, define technical scope and requirements of the project and assist project manager with managing scope during the lifecycle of the project.
- Ensure adequate test coverage in Unit Testing, System Testing/Integration Testing and Performance Testing.
- Perform Quality Inspections and Walkthroughs throughout the SDLC including Requirements Review, Architecture Review, Design Review, Code Review and Security Review to ensure compliance with Client standards.
- Coordinate offshore development and manage day to day activities. Support collection and reporting of project and software metrics.
- Actively look for opportunities to enhance standards and improve process efficiency. Mentor and guide other team members during all phases of the SDLC.
- Lead and guide team through all phases of the SDLC of an application. Successfully lead production incident and problem management, identification of root cause and remediation of the problems.
- Ensure compliance to the defined standards. Actively look for opportunities to modify and enhance standards per the needs of the department.
- Develop documentation templates, lead and enforce development of documentation throughout the development lifecycle of the solution.
- Ensure compliance of Audit Requirements by proactively educating team on Compliance Requirements and Integrating Compliance Requirements in SDLC.
Requirements
- Bachelor's degree in Information Systems, Information Technology, Computer Science, Engineering or equivalent experience
- Strong experience with SQL and PL/SQL development
- Experience working with relational databases such as SQL Server, Oracle, Postgres
- Proficient in building ETL pipelines with ETL tools like SSIS or Informatica
- Understanding of database design and modeling, performance tuning, and stored procedures
- Excellent analytical, collaboration and communications skills
- Critical thinking, logical reasoning and experience gathering and understanding business requirements to build ETL pipelines
- 5+ years of experience in related field, including experience in delivering secure solutions in Financial Services Sector
- Advanced knowledge and understanding of Software Engineering Concepts and Methodologies
Nice-to-haves
- Experience building dashboards with BI tools like Power BI, Tableau
