Marketing Automation Data Analyst

Our Customer is a mission-driven not-for-profit organization that connects students to college success and opportunity. Founded in 1900, they were created to expand access to higher education. Today, the membership association is made up of over 6,000 of the world’s leading educational institutions and is dedicated to promoting excellence and equity in education. Each year, our Customer helps more than seven million students prepare for a successful transition to college through programs and services in college readiness and college success—including the SAT, the Advanced Placement Program, and BigFuture. The organization also serves the education community through research and advocacy on behalf of students, educators, and schools.

We are seeking a Marketing Automation Data Analyst on a contract basis to help support our Customer’s business needs. This role is 100% remote.

This role will be a member of a cross-functional digital campaign team, tasked with accurately provisioning for the purpose of outbound digital communications including email and SMS campaigns. Working remotely, you will also plan, analyze, develop, test, deliver and complete quality assurance of data you and other team members provision to support these external communications.

What You’ll Do:

• 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 College Board 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 working with sensitive PII data
• 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

???????
Please note: In order to create a safe, productive work environment, our client is requiring all contractors who plan to be onsite to be fully vaccinated according to the CDC guidelines. Prior to coming into our offices, contractors will be required to attest that they are fully vaccinated.

An Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, or protected veteran status and will not be discriminated against on the basis of disability.