Lead Director of Informatics - Data Engineer

Job DescriptionOur Sales Analytics team is seeking a self-motivated, experienced Data Engineer to join a talented team responsible for providing critical business information in support of Aetna's Commercial Business growth and retention strategy. This is a great opportunity to innovate and collaborate with a team of professionals across the enterprise to design and execute on data solutions that meet the needs of the business. The Sales Analytics team is a key business unit within Aetna's Sales Insights and effectiveness team with a primary focus on supporting Aetna's Commercial Business. This team is responsible for research and analysis of sales performance data, interpreting results and making data-driven recommendations to key stakeholders and executives to help achieve short and long-term business objectives.The fundamental components of the role include: Development and execution of highly complex and large-scale SQL data structures/pipelines to organize, collect and standardize data to generate insights and addresses reporting needs. Writes highly complex ETL (Extract / Transform / Load) processes, designs database systems and develops tools for real-time and offline analytic processing. Anticipates and solves highly complex problems with detailed knowledge of multiple programming languages and data infrastructure. Designs complex production systems and creates custom packages using multiple programming languages to solve challenging analytical problems. Implements and executes automated job scheduler to process stored procedures and refresh routine report data. Analyzes current information technology environments to identify and assess critical capabilities and recommend solutions. Designs and modifies components of new and existing IT systems to promote integrated corporate business systems. Motivates team members and probes into technical details, and mentors others to do the same. Collaborates cross-functionally to build and convert algorithms and models into production systems to support enterprise initiatives. Develop frameworks, standards & reference material for architecture and associated products. Provides guidance for enterprise-wide technology roadmap. Experiments with available tools and advises on new tools in order to determine optimal solution given the requirements dictated by the model/use case. Applies knowledge of systems and products to consult and advise on additional efforts across organization/enterprise.Required Qualifications 10 or more years of progressively complex related experience. Extensive knowledge/ Expert level SQL Server, SSIS, and Job Scheduling abilities.COVID RequirementsCOVID-19 Vaccination RequirementCVS Health requires certain colleagues to be fully vaccinated against COVID-19 (including any booster shots if required), where allowable under the law, unless they are approved for a reasonable accommodation based on disability, medical condition, religious belief, or other legally recognized reasons that prevents them from being vaccinated. You are required to have received at least one COVID-19 shot prior to your first day of employment and to provide proof of your vaccination status or apply for a reasonable accommodation within the first 10 days of your employment. Please note that in some states and roles, you may be required to provide proof of full vaccination or an approved reasonable accommodation before you can begin to actively work.Preferred Qualifications Minimum five years of experience working in healthcare analytics with complex data structures and large datasets in a real business setting. Additional experience working in marketing and operations analytics in the finance sector and building, validating, and monitoring statistical models and ensuring client guidelines are met. Additional experience delivering data analytics presentations to clients and executives, supervising projects, and leading teams, participating in project requirements, developing, coordinating, and managing offshore supplier resources, participating in high-level and low-level design meetings, and preparing initial design documents used to start development work. Experience with SQL, SSIS, Excel, PPT.EducationBachelor's degree in Computer Science, Information Technology, Engineering or a related field and 60 months of experience as Computer Programmer, Technology Lead, or related occupation.Business OverviewBring your heart to CVS HealthEvery one of us at CVS Health shares a single, clear purpose: Bringing our heart to every moment of your health. This purpose guides our commitment to deliver enhanced human-centric health care for a rapidly changing world. Anchored in our brand - with heart at its center - our purpose sends a personal message that how we deliver our services is just as important as what we deliver.Our Heart At Work Behaviors support this purpose. We want everyone who works at CVS Health to feel empowered by the role they play in transforming our culture and accelerating our ability to innovate and deliver solutions to make health care more personal, convenient and affordable. We strive to promote and sustain a culture of diversity, inclusion and belonging every day. CVS Health is an affirmative action employer, and is an equal opportunity employer, as are the physician-owned businesses for which CVS Health provides management services. We do not discriminate in recruiting, hiring, promotion, or any other personnel action based on race, ethnicity, color, national origin, sex/gender, sexual orientation, gender identity or expression, religion, age, disability, protected veteran status, or any other characteristic protected by applicable federal, state, or local law.

Created: 2024-11-02