The Data Engineer will focus on the development, implementation, and maintenance of our data warehouse using Amazon Redshift. The ideal candidate will have a strong background in data engineering, experience with AWS infrastructure, and expertise in managing data sourced from structured and unstructured data sources. Additionally, you will be responsible for creating insightful reports using Amazon QuickSight.

Key Responsibilities:

Design, develop, and maintain robust data warehouse solutions utilizing Amazon Redshift. Collaborate with cross-functional teams to gather data requirements and ensure seamless data integration from databases, external files, and other structured and unstructured data sources. Define, create, and optimize ETL processes to enhance data extraction, transformation, and loading using AWS services. Maintain data integrity and ensure high availability and performance of data storage systems. Implement data governance practices to ensure compliance and security of data assets. Develop and maintain data pipelines and workflows using AWS tools such as Glue, Lambda, Step Functions, Athena, DMS, Redshift, and others. Utilize Amazon QuickSight to design, develop, and publish dynamic reports and dashboards for business analytics. Perform data analysis and validation to ensure data accuracy and consistency across various data sources. Troubleshoot and resolve complex data processing issues in a timely manner. Stay current with industry trends and best practices related to data engineering and AWS technologies.

Skill Requirements: 

Minimum of 5 years’ experience as a Data Engineer, with a focus on data warehouse architecture and development. Proficiency in SQL and experience with AWS services including Redshift, S3, and QuickSight is required. Familiarity with data extraction and transformation using MySQL databases and Parquet files. Strong understanding of data modeling, database management, and data warehousing concepts. Experience with ETL tools and frameworks. Ability to work collaboratively in a team environment and communicate effectively. Strong problem-solving skills and attention to detail.

Education/Certification Requirements:

Bachelor’s degree in Computer Science, Information Technology, or a related field.  AWS Certified Data Analytics or AWS Certified Solutions Architect certification preferred.

Additional Requirements:

Experience with big data tools and technologies. Familiarity with data visualization and reporting tools. Ability to work across all time zones as needed and after hours on Deployments  Prospective candidates must be able to pass a background check and drug screening. 

At MHK we help health plans and pharmacy benefit managers deliver optimal care management across every member’s health journey.  We do this through state-of-the-art technology that provides critical insights from member enrollment and maintenance through every stage of care and compliance. 

COMMITMENT TO DIVERSITY & INCLUSION:

We are committed to cultivating and preserving a culture of inclusion and connectedness through collaboration. We grow and learn better together with a diverse team of employees. We welcome the unique contributions and the different perspectives of a diverse team.  We are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity or Veteran status.

If you need a reasonable accommodation for any part of the employment process, please contact us by email at careers@mhk.com and let us know the nature of your request and your contact information. Requests for accommodation will be considered on a case-by-case basis. Please note that only inquiries concerning a request for reasonable accommodation will be responded to from this email address. 

For more information, please visit Know Your Rights, Pay Transparency, and MHK EEO/AA Statement 

Benefits Snapshot:

Medical, vision, and dental plans for full time employees 401(k) offered with a generous match Benefits begin on first day of the month following employment    Exercise/Health Club reimbursement opportunity  Monthly dependent care reimbursement opportunity  Short Term and Long Term disability  Basic Term Life and AD&D Insurance 

Paid Time Off

17 days Paid Time Off   15 Company Paid Holidays   2 Community Service days