Sr Analytics & Reporting Consultant

Job-ID29299351Reference26-25836Open BidContract to hire...conversion salary ***KOnsite/hybrid in ChicagoJOB REQUIREMENTSBachelor's Degree and 4 years of experience in healthcare analytics, healthcare services, statistical analysis, data engineering, business intelligence, insurance economics, or a related field.3 years of experience designing, developing, and supporting data pipelines, data integration processes, and reporting solutions utilizing healthcare and pharmacy data.Strong experience with SQL, Python, Databricks, and modern data engineering frameworks for data transformation, automation, and analytics.Experience developing, maintaining, and optimizing ETL/ELT processes to support large-scale healthcare, claims, pharmacy, and population health datasets.Proficiency in data modeling, relational database design, data warehousing concepts, and creation of data marts that support reporting and analytics initiatives.Experience working with cloud-based data platforms and distributed computing environments to process and analyze large datasets efficiently.Partners with business stakeholders, analysts, and technology teams to understand data requirements and deliver scalable data solutions.Solves moderately complex to complex business and technical problems with a focus on data quality, performance, scalability, and reliability.Supports strategic initiatives through the development of trusted data assets, automated workflows, and self-service analytics capabilities.Participates in cross-functional project teams to deliver data solutions, enhancements, and operational improvements aligned with organizational objectives.Demonstrates understanding of healthcare data structures including claims, eligibility, pharmacy, provider, and population health data domains.Applies data governance, security, and regulatory compliance standards when managing healthcare data assets.Supports data framework for dashboards, ac hoc analysis, and downstream data deliveries.Supoort with complex data inquiries and data profiling.PREFERRED REQUIREMENTSAdvanced SQL expertise, including complex joins, window functions, query optimization, stored procedures, and performance tuning.Strong experience with Databricks, Spark, Delta Lake, and distributed data processing frameworks.Strong Python programming skills for data engineering, automation, data quality monitoring, and analytics enablement.Experience building and orchestrating ETL/ELT pipelines using tools such as Databricks Workflows, Airflow, Azure Data Factory, or similar technologies.Experience developing scalable data lake, data warehouse, and data mart solutions that support enterprise reporting and analytics.Knowledge of healthcare data standards and structures, including medical claims, pharmacy claims, member eligibility, provider, and population health data.Experience creating and supporting semantic layers, reporting datasets, and business intelligence solutions using Power BI, Tableau, or similar platforms.Familiarity with CI/CD practices, source control management (Git), automated testing, and DevOps concepts for data platforms.Experience implementing data quality frameworks, monitoring processes, and production support practices.[hr align="center" size="2" width="100%"]EEO:“Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of – Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans.”