Fulltime / Direct Hire Position
Location - Rosemont, IL (hybrid role / 2 days a week onsite)
Our client is currently seeking a Data Analytics Engineer to join their Engineering team, and driving transformative initiatives to support the organizational goal of improving member experience and increasing operational efficiency through data-driven insights and creative solutioning.
In this role, you will support the development and optimization of data pipelines, data models, and cloud-based integration solutions that power business decisions across the organization. The ideal candidate will thrive amidst evolving requirements, boasting exceptional proficiency in SQL and Python. They will possess a keen curiosity for analytical exploration while collaborating closely with data analysts, scientists, architects, and business leaders. We are looking for someone with an entrepreneurial spirit, eager to build and design solutions that contribute to the success of our growing data platform.
DUTIES AND RESPONSIBILITIES
• Design, build, and maintain data models and tables in Redshift to support analytics, reporting, and experimentation efforts across Data Analytics
• Develop custom Python scripts to automate business workflows, run machine learning models, and perform ETL tasks such as file ingestion
• Collaborate on building, documenting, enhancing, and scaling AWS infrastructure to support growing use cases for business-critical web and enterprise applications
• Support the development and maintenance of backend data pipelines, S3 storage layers, and Redshift data sources for internally developed web applications
• Operate within a CI/CD framework using Azure DevOps and Git for source control, code review, and deployment processes
• Operationalize Data Science outputs, including LLM-based solutions like Amazon Bedrock, by designing production-grade pipelines and infrastructure
• Implement monitoring, alerting, and data quality checks to ensure reliability and trustworthiness of the data ecosystem
• Help to implement and build a case for new technologies to address gaps in existing processes and infrastructure as needed
• Collaborate with foundational areas such as Machine Learning Operations (MLOps), Claims and Provider Strategy, Data Science, Data Analytics, Data Architecture, and IT
REQUIRED QUALIFICATIONS
• Strong proficiency in SQL and Python, with the ability to write clean, reusable, and efficient code
• Experience with Amazon Redshift or other cloud warehouses
• Experience with cloud services (preferably AWS), including data storage, compute, and application integration
• Solid understanding of dimensional modeling and building robust ETL pipelines
• Familiarity with Git and working within a CI/CD environment
• Proven ability to handle multiple projects, communicate, and collaborate in a team environment
• Strong analytical skills with the ability to collect, aggregate, analyze, and wrangle significant amounts of information with attention to detail and accuracy
• Strong problem-solving skills, a passion for quality & attention to detail, and the ability to navigate ambiguity and deliver results
EDUCATION/BACKGROUND
• BS in Mathematics, Computer Science, Information Management, Statistics, or a Related Technical Field
• 3-5+ years’ data warehousing or analytics experience
• 2+ years’ data/analytics engineering experience
• 1+ years’ experience in health care industry would be a big plus
For all non-bonus, non-commission direct hire positions: The anticipated salary range for this position is ($105,000-$125,000). Actual salary will be based on a variety of factors including relevant experience, knowledge, skills and other factors permitted by law. A range of medical, dental, vision, retirement, paid time off, and/or other benefits are available.
