Job Description

The Business Analytics (BA) team is a lean, cross-functional analytics team that serves 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 marketing analytics team is looking for a highly motivated digital analytics data engineer to join the team.

Responsibilities:
· Working on data from different Social media and Digital Media – Google, Facebook, ad servers and Websites
· Build and maintain marketing analytics platform, to ensure back-end analytics platform and infrastructure is highly performing and flexible for use by front-end data analysts/developers
· Build and maintain customized scripts and ETL jobs to reports, dashboards, predictive models, and adhoc analysis
· Develop standardized and scalable solutions using various back-end, database, and data transformation tools and technologies (SQL, Alteryx, Spark, etc.)
· 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

REQUIRED SKILLS/EXPERIENCE:
** Remote position, ideally would like someone local, but is open to non-local candidates who meet all the required skills **
** 8+ years of experience required
** Must have worked on data from different Social media and Digital Media – Google, Facebook, ad servers and Websites
** Need someone who is eager to learn and collaborative
** Must have cloud experience (GCP or AWS preferred)
** Intermediate experience with Adobe Analytics or Google Analytics
** Intermediate experience with Google Cloud Platform
** Has strong communication skills, able to work with technical and non-technical teams.

· 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+ years of experience in ETL tools like SSIS, Alteryx, and/or Informatica
· 3+ years of experience with cloud platforms like Google Cloud Platform or Amazon Web Services
· 3+ years of experience in data analysis and reporting in digital marketing
· Education: Bachelor’s Degree in Business, Marketing, Mathematics, Computer Science or Statistics, with significant quantitative course work is required

Calance Consultant Benefits Offerings:
- H1 Transfers/Green Card processing offered (NO C2C)
- EPO/PPO Medical Plan (Cigna)
- HMO/PPO Dental programs (Cigna)
- Vision - VSP (Vision Plan Summary)
- 401K VOYA Retirement vesting program