Providence, Rhode island
Senior Marketing Campaign Data Analyst - Healthcare Job Opening in Providence, Rhode island - Swoon is actively hiring for our Fortune 10 Healthcare Client in Woonsocket, Rhode Island
This is a 6 Month Contract with Benefits - Medical - Vision - Dental
What about the Senior Marketing Campaign Data Analyst?
The Senior Marketing Campaign Data Analyst 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.
What is expected of the Senior Marketing Campaign Data Analyst?
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.
Perform quality assurance on data files to ensure flawless execution.
Participate on multiple projects of varied complexity (simple to moderate) 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.
data-related issues and recommend corrective actions.
Contribute to requirements and design phases for member communications operations projects.
What are the qualifications of the Senior Marketing Campaign Data Analyst?
Bachelors or equivalent amount of related-experience
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
5+ 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 baseline primarily with fractions, percentages, and proportional relationships.
Job Type: Full-time
Required education:
Bachelor's
Required experience:
Data manipulatin, query generation and report generation: 5 years
Campaign Management Software utilization (CRM): 3 years
SQL: 5 years
SAS: 3 years
Market Database: 3 years
|
