01 Dec
Sr. Data Engineer (Marketing Analytics Platform)
Vacancy expired!
The Business Analytics (BA) team is a lean, cross-functional analytics team that serves clients in sales & Marketing organizations. The Marketing Analytics team, a subset of Business Analytics, enables data-driven business decisions across advertising, marketing, and digital domains across the customer journey, by delivering insights and analytics solutions that provide centralized access to data stitched together from disparate sources. The team is looking for a seasoned data engineer to help build and maintain our Marketing Analytics Platform (MAP).
Responsibilities:- Responsible to build and maintain marketing analytics platform, to ensure back-end analytics platform and infrastructure is highly performant and flexible for use by front-end data analysts/developers
- Build and maintain customized scripts and ETL jobs to reports, dashboards, predictive models, and ad hoc analysis
- Develop standardized and scalable solutions using various back-end, database, and data transformation tools and technologies (SQL, Alteryx, Spark, etc.) in accordance with best practices
- Deep expertise in writing SQL joins, stored procedures, scripts, functions, views, indexing and execution plans.
- Define data flow design and appropriate data models to support ad-hoc analytics needs and assist in interpretation of data
- Partner with marketing analyst and others to identify requirements, and transform data for digital analytics and reporting
- Monitor analytics platform and infrastructure performance, and escalate issues with front-end teams and IT as needed
- Ensure data accuracy and completeness across the data landscape
- Communicate project status, risks, dependencies and roadblocks for technical and business audiences
- Bachelor’s Degree in Business, Marketing, Mathematics, Computer Science or Statistics, with significant quantitative course work is required.
- Experience with media analytics platforms such as Google Marketing Platform, Google Campaign Manager, Facebook and Adobe.
- Strong technical experience regarding data models, databases, data mining, and querying techniques.
- Strong analytical skills with the ability to collect, organize, analyze and disseminate significant amounts of information with attention to detail and accuracy.
- 5 - 8 years of experience in SQL and ETL tools like SSIS, Alteryx, Talend, and/or Informatica.
- 3 – 5 years of experience in data analysis and reporting in the digital marketing domain.
- Master’s degree
- Participate in OrangePeople monthly team meetings, and participate in team-building efforts.
- Contribute to OrangePeople technical discussions, peer reviews, etc.
- Contribute content and collaborate via the OP-Wiki/Knowledge Base.
- Provide status reports to OP Account Management as requested
Vacancy expired!