Lead Engineer - Data Analytics Tech

Maximus

1d•Remote

About The Position

Administers and improves the engineering behind MAXIMUS’ data warehousing for government, health care, and human services industries. Maintain and develop the MAXIMUS data warehouse system while ensuring data security controls by helping to debug, code, and develop the internal systems from which our business intelligence teams to draw necessary data.

Requirements

Bachelor’s Degree in Computer Science, Data Science, or Computer Engineering plus 7 years of experience performing data analysis and developing data integration solutions.
Snowflake
Streamsets Data Collector
Linux shell scripting
Boomi integration (cloud-based iPaaS)
Alteryx
SQL
Python
Service Now
AWS (Amazon Web Services) Cloud Services
GitHub
ETL applications
System and Requirement Analysis
Design and development
SIT, UAT support and production roll outs

Responsibilities

Administer and improve the engineering behind MAXIMUS’ data warehousing for government, health care, and human services industries.
Maintain and develop the MAXIMUS data warehouse system while ensuring data security controls by helping to debug, code, and develop the internal systems from which our business intelligence teams to draw necessary data.
Lead system and data analysis/development, including Business Intelligence, database, and ETL/ELT (Extraction, Loading, Transformation) processes following MAXIMUS Data and Security Standards including user creation and role based access control design.
Produce system impact analysis documentation, such as metadata and diagrams of entity relationships, business processes, and process flow.
Develop custom built frameworks and use them to implement Extraction, Loading, Transformation ingestion pipelines in Streamsets.
Convert procedures and other SQL code from source databases including MySQL, Oracle and SQL Server to Snowflake.
Lead the creation of optimal, efficient, and feasible analytics solutions to cater to all project requirements, which may be difficult and sometimes complex, considering potential future project changes.
Monitor, maintain and develop enhancements to existing analytics deployments due to infrastructure upgrades, changes in standards and security requirements.
Manage change control, code configuration and application security utilizing knowledge of information resource management.
Perform unit and integration testing of software to ensure proper and efficient execution, and requirements compliance. This includes Unit testing, component integration testing, system integration testing, user acceptance testing, performance testing, capacity testing and quality reviews.
Support systems in test and production environments and assist with problem resolution and debugging.
Use SQL Server, MySQL, and Oracle databases for migration of the system data to Snowflake Data warehouse cloud solution.
Communicate with project managers and project stakeholders on progress of open items and work with other development, quality assurance and infrastructure teams.
Produce standards and best practices documents, review functional specification to the DevOps teams and guide documents to the business teams.
Convert/optimize code from the source systems to Snowflake, to follow the technical parameters of software applications and to design and develop highly sophisticated software applications and algorithms.
Prepare Unit test scripts, component test script, user test scripts and incident logs for application development and data warehouse testing.
Work with onshore/offshore teams to support the project development, testing and deployments.
Provide training and consulting for various technical and non-technical internal teams and maintain client satisfaction by meeting client priorities and service level agreement targets in a timely manner.