Full Job Description
We seek a highly motivated and driven individual with a passion for data development to support our Marketing Operations team.
Partner with internal teams to develop detailed documentation and governance to ensure our analytics platform contains high quality, managed data that is easy to consume
Partner with the IT organization, and marketing analysts to map new and existing marketing data sources
Validate data and document gaps between available data points and requested requirements from marketing analysts
Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
Help craft, build and maintenance of the marketing data mart
Build and maintain customized scripts and ETL jobs to power reports, dashboards, predictive models, and ad hoc analysis
Partner with marketing analyst and others to identify, access, and transform data for marketing analytics and reporting
Assist in the development and build of complex dashboards in partnership with marketing analysts
Experience with Marketing Automation tools including Salesforce Marketing Cloud, Pardot, Interaction Studio, etc.
Experience with clickstream web analytics tools such as Adobe Analytics and Google Analytics
Familiarity with Salesforce CRM campaigns
Working knowledge of a scripting language such as R or Python
Advanced knowledge of SQL as well as ETL tools and techniques
Comfortable working with relational database systems such as Redshift, Oracle, and Postgres
Strong written and verbal communication skills
Excellent social skills, a collaborative spirit, and relationship-builder both internally and externally.
Familiarity with AWS Cloud platform and services
Knowledge of the financial services industry
Experience with MuleSoft or other API orchestration tools
Demonstrated ability working with structured and unstructured data
Education and Experience
Bachelor’s degree in Computer Science, Information Systems, Data Science or other analytically related field
3+ years’ experience in manipulating data and investigating data problems preferably related to marketing
3+ years’ experience working with marketing data and marketing technologies