The Data Engineer of Campaign Targeting Development will be responsible for configuring, executing and validating CRM communications under a highly collaborative environment. This position has a high impact on communication programs that drive interventions to a base of over 80M members. This persons day-to-day function will include manipulating data to develop target lists for member communications based on business requirements. This activity requires a high comfort level with building queries in SQL or CRM tools.
This position is expected to:
Manipulate data tools for targeting including Campaign Relationship Management (CRM) system and Enterprise Data Warehouse (using SQL) to produce data files.
Team works with other team members and/or Manager on interactions with business partners to vet data requests and explore options and solving problems.
Work with Teradata, Hadoop, and SQL marts to create targeted audiences.
Develop campaigns on several platforms using SQL, Json, Python, and R working with business teams, technology teams, and vendor teams.
Perform quality assurance on data files to ensure flawless execution.
Participate on multiple projects of varied complexity simultaneously.
Manipulate data to develop target lists for member communications based on targeting requirements. This activity requires a high comfort level with building queries in SQL language or CRM tools.
Document and maintain procedures and queries necessary to prepare data based on targeting requirements and variations in data sources/formatting
Apply problem-solving and analytical skill in conjunction with SQL language in order to conduct quality assurance checks on data (from initial delivery to final merged data) in order to ensure data accuracy.
Work with other senior team members, business partners, including project managers, print production, client account managers and communications product managers, to assist on the flawless execution on data requests by asking appropriate questions and manipulating data accordingly
Troubleshoot/research data-related issues and recommend corrective actions
Contribute to requirements and design phases for member communications operations projects.
. Bachelors degree in computer science or related field of study or application development experience
5+ years of professional software development experience
4+ years of professional experience with relational databases using SQL such as: data manipulation, data conversion, query generation, import and export processes, and report generation
Strong problem-solving and analytical skills.
Proficient with SQL and/or SAS programming skills
Able to interpret instructions, ask analytical questions, validate report/query information, and detect flaws in requests or suggested methodologies
Understanding of all phases of the Software Development Life Cycle (SDLC) and process methodologies
Able to identify root causes of problems, and develop and implement solutions, incorporating business needs and consulting management as needed. Includes business considerations in analysis and offers direction to keep projects aligned.
Solid mathematical/statistical baseline primarily with fractions, percentages, and proportional relationships
Ability to work on multiple projects/assignments concurrently under aggressive deadlines
Ability to work with team members or independently on multiple projects in a fast pace environment
Preferred Qualifications 3+ years of professional experience with a Campaign Relationship Management (CRM) tool such as Teradata Relationship Manager (TRM), Aprimo Relationship Manager (ARM) or IBM (Unica Campaign)
3+ years of Database Marketing experience.
Masters degree or PhD preferred.
Bachelor's degree or equivalent work experience in Computer Science or related field of study or application development experience.
At CVS Health, we are joined in a common purpose: helping people on their path to better health. We are working to transform health care through innovations that make quality care more accessible, easier to use, less expensive and patient-focused. Working together and organizing around the individual, we are pioneering a new approach to total health that puts people at the heart.
We strive to promote and sustain a culture of diversity, inclusion and belonging every day. CVS Health is an equal opportunity and affirmative action employer. We do not discriminate in recruiting, hiring or promotion based on race, ethnicity, sex/gender, sexual orientation, gender identity or expression, age, disability or protected veteran status or on any other basis or characteristic prohibited by applicable federal, state, or local law. We proudly support and encourage people with military experience (active, veterans, reservists and National Guard) as well as military spouses to apply for CVS Health job opportunities.