Lead Engineer - Data Analytics Tech

Maximus; Rancho Cordova (CA); On-site; USD 155,000 - 210,000; Full time

Job summary

MAXIMUS leads data warehousing initiatives across government, health care and human services. This Lead Engineer - Data Analytics Tech role focuses on engineering and expanding the MAXIMUS data warehouse, implementing secure, scalable analytics pipelines, and enabling BI teams to access trusted data.

You will drive ETL/ELT development, ensure data integrity, and translate business requirements into robust data solutions while coordinating with onshore and offshore teams and stakeholders for

Qualifications

• Bachelor’s Degree in Computer Science, Data Science, or Computer Engineering plus 7 years of experience performing data analysis and developing data integration solutions.
• Experience with system and requirement analysis, design and development, SIT/UAT support and production rollouts.

Responsibilities

• Administer and improve the engineering behind MAXIMUS’ data warehousing for government, health care, and human services industries.
• Maintain and develop the data warehouse while ensuring data security controls, debug, code and develop internal systems for BI teams.
• Lead system and data analysis, including BI, database and ETL/ELT processes following MAXIMUS standards.
• Produce system impact analyses and diagrams of entity relationships, processes and data flows.
• Develop custom frameworks and ETL/ELT ingestion pipelines in Streamsets; migrate from MySQL/Oracle/SQL Server to Snowflake.
• Lead analytics solution design to meet project requirements and future changes; monitor and enhance deployments.
• Perform unit and integration testing; support test/production environments and coordinate with DevOps teams.

Job description

Lead Engineer - Data Analytics Tech: 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.

I: Essential Job Functions:

• 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 scripts, 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.

II: Education and Experience Required:

• Bachelor’s Degree in Computer Science, Data Science, or Computer Engineering plus 7 years of experience performing data analysis and developing data integration solutions.

III. Special Skills Required:

• Streamsets Data Collector;
• Boomi integration (cloud-based iPaaS);
• AWS (Amazon Web Services) Cloud Services;
• System and Requirement Analysis;
• Design and development;
• SIT, UAT support and production roll outs.

Salary: $182,562 per year. Telecommuting Permitted within the Sacramento, CA metro area.

EEO Statement

Maximus is an equal opportunity employer. We evaluate qualified applicants without regard to race, color, religion, sex, age, national origin, disability, veteran status, genetic information and other legally protected characteristics.

Pay Transparency

Maximus compensation is based on various factors including but not limited to job location, a candidate's education, training, experience, expected quality and quantity of work, required travel (if any), external market and internal value analysis including seniority and merit systems, as well as internal pay alignment. Annual salary is just one component of Maximus's total compensation package. Other rewards may include short- and long-term incentives as well as program-specific awards. Additionally, Maximus provides a variety of benefits to employees, including health insurance coverage, life and disability insurance, a retirement savings plan, paid holidays and paid time off. Compensation ranges may differ based on contract value but will be commensurate with job duties and relevant work experience. An applicant's salary history will not be used in determining compensation. Maximus will comply with regulatory minimum wage rates and exempt salary thresholds in all instances.

Accommodations

Maximus provides reasonable accommodations to individuals requiring assistance during any phase of the employment process due to a disability, medical condition, or physical or mental impairment. If you require assistance at any stage of the employment process—including accessing job postings, completing assessments, or participating in interviews,—please contact People Operations at [e-mail] .