Lead Engineer - Data Analytics Tech

Maximus; Rancho Cordova (CA); On-site; USD 164,000 - 201,000; Full time

Benefits offered by this job

Health insurance

Life and disability insurance

Retirement savings plan

Paid holidays

Paid time off

Incentives programs

Job summary

Maximus Lead Engineer - Data Analytics Tech oversees data warehousing engineering for government, health care, and human services. You will enhance the data platform, apply security controls, and enable BI teams to access the data they need.

You will lead ETL/ELT pipelines, migrate procedures to Snowflake, and guide onshore and offshore teams through testing, deployment, and best practices. This role requires a Bachelor's degree and 7 years of data integration experience, plus expertise with

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.

Responsibilities

• Administer and improve the engineering behind MAXIMUS’ data warehousing for government, health care, and human services industries.
• Maintain and develop the data warehouse system while ensuring data security controls by helping to debug, code, and develop internal systems for BI teams.
• Lead system and data analysis/development, including BI, database, and ETL/ELT processes following MAXIMUS Data and Security Standards.
• 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 pipelines in Streamsets.

Skills

System and Requirement Analysis

Design and development

SIT, UAT support and production rolls

Education

Bachelor's Degree in Computer Science, Data Science, or Computer Engineering

Tools

Streamsets Data Collector

Boomi integration

AWS Cloud Services

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.

• health insurance coverage
• life and disability insurance
• a retirement savings plan
• paid holidays
• paid time off
• short- and long-term incentives as well as program-specific awards

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] .