Marketing Automation Data Analyst

Job Description

Pay Range : $35-$50 / hr. The pay rate may differ depending on your skills, education, experience, and other qualifications.

Featured Benefits :

• Medical Insurance in compliance with the ACA.
• 401(k).
• Sick leave in compliance with applicable state, federal, and local laws.

Must Have :

• Adept communication skills
• Advanced SQL Querying Programming SQL
• Salesforce Marketing Cloud

Nice To Have :

• Amazon DynamoDB
• AWS S3 buckets

Profile : Need a data analyst with marketing automation experience and advanced SQL skills will pull data from Salesforce Marketing Cloud and other internal applications (Dynamo DB / S3 buckets) and generate email lists for various campaigns must have worked with sensitive PII data.

Solid communication skills to collaborate with user requests / clarifications and the email producers.

In this role, you will :

Business Analysis and Data Strategy (10%) :

• Develop a deep understanding of the enterprise and marketing data landscape.
• Consult periodically with internal customers on how best to use actionable data in marketing and operational email communications.

Data Provisioning (60%) :

• Fulfill data requests from internal customers using a sound understanding of Cient data, data policies and governance.
• Create complex data extensions and automation activities using SQL.

Partner with Digital Production staff to customize data output as required for use in personalization, dynamic content, and reporting.

• Provide customer support on an as needed basis by investigating and addressing escalated incidents with data quality.
• Understand Salesforce Marketing Cloud (SFMC) data models, data extensions, and the core system data structure to successfully deliver segmented and tailored messaging to meet business needs.
• Facilitate and participate in detailed data analysis necessary to measure, identify and track the quality of data in an ongoing manner.
• Complete quality assurance of SQL code and data output to ensure business requirements and specs have been met.

Process and Project Management (20%) :

• Work closely with internal customers to ensure data requirements are clear and actionable.
• Ensure SLAs are met. Manage and escalate issues that arise through the data provisioning process.
• Leverage JIRA for collaboration and managing work.

Documentation (10%) :

Contribute to team resources by documenting common queries and unique processes that can be leveraged by other data analysts on the team.

Must have :

• A Bachelor’s degree, with additional post graduate degree, MS, or MBS preferred.
• Experience with standard business and project management processes.
• 3-6 years experience in managing and executing data management initiatives, including data management, warehousing, provisioning, and business intelligence.
• Advanced knowledge of SQL, with expertise in SQL standards and best practices.
• Practical knowledge of DBMS, ETL tools, reporting and analysis tools, and data mining tools.
• Experience in multiple areas of data standards, data management, data warehousing and business intelligence is essential.
• Demonstrated ability to complete projects on time and on budget.
• Strong analytical and data analysis experience with structured problem-solving ability.
• Experience with education related data is preferred.

Additionally, we prefer you have :

• Demonstrable experience in Salesforce Marketing Cloud or the ability and willingness to quickly learn Salesforce best practices and development.
• Experience with AWS, Postgres Database, DynamoDB or similar cloud technology.
• Demonstrated competency in strategic thinking with strong abilities in relationship management.
• Experience in business process analysis, design, and documentation.
• Execution and delivery focused mind set.
• Desire to learn, explore and be challenged.

Required Details

Experience : 5 Years Travel Required : No Clearance Required : No