Aetna Medicaid Administrators, LLC, a CVS Health company, is hiring a Sr. Manager, Business Consultant to produce business intelligence by querying health care data and generating reports. Duties include: work with cross-functional and business teams and manage the flow of business intelligence to users to support business solution planning; manage the solutions development lifecycle and interface with health plan entities and internal business units to identify data patterns and trends, define reporting specifications, and translate business requirements into technical solutions; finalize technical reporting criteria and conduct peer review of data results; develop large-scale data structures, pipelines, and efficient Extract/Load/Transform (ETL) workflows to organize, collect and standardize data to generate business insight and address reporting needs; synthesize business intelligence, trend data, and user feedback related to Health Plans to support recommendations for action and create presentations illustrating the financial impact of Health Plans; enable real-time analytical solutions that leverage emerging technologies and develop prototypes and proof of concepts for complex data engineering projects; integrate business logic with upstream and downstream systems and generate programming logic to validate financial data; develop, implement, test, and deliver innovative analytics solutions, business intelligence tools, and technology architecture; maintain reusable knowledge assets, develop metrics and KPI data layers, and utilize data visualization tools to present business information and align with organizational goals; support development of data engineering solutions to leverage best practices and industry leading technologies to profile data, develop efficient ingestion, and build semantic data layers by sourcing data from PBM, Specialty, Retail and HealthCare business.