Full-Time Analytics Engineer

Who We Are: We are a tech-enabled growth firm at the intersection of marketing, consulting & data intelligence, igniting revenue and brand recognition for leading and emerging companies. We value diversity. Our vision is to be the most valued private growth marketing firm. Our mission is to power relentless growth and redefine possibilities. We offer best-in-class services including SEO, Content Marketing, Paid Media, Social Media Marketing, and more. At Power Digital, we are focused on helping brands drive revenue growth and recognition. Our proprietary technology, nova, analyzes businesses through first-party data, simplifying investment planning and M&A.

A day in the life: As an Analytics Engineer, you'll maintain and improve our novaCloud data warehouse for performance marketing, e-commerce, and site activity. You'll work with cross-functional teams to gather data requirements, develop and monitor data pipelines, ensuring accuracy and reliability. You'll work on the enterprise warehouse, helping understand client revenue, manage churn, and forecasting. Your expertise in building ontologies between performance marketing and customer 360 data models is crucial for a robust data infrastructure.

Responsibilities:

• Assist in developing and maintaining analytics-ready data models (star, snowflake schemas).
• Write and optimize SQL queries and transformations for efficient and accurate data retrieval.
• Monitor and maintain data pipelines, debugging issues.
• Implement data quality checks and resolve flagged issues.
• Collaborate with stakeholders to translate data requirements into structured models.
• Support data marts and curated datasets for business users.
• Handle support tickets and escalate complex problems.
• Maintain documentation for data models and business definitions.
• Develop and maintain Looker dashboards and reports.
• Participate in identifying process improvements.
• Utilize AI technologies to optimize business processes.
• Leverage the Nova ecosystem.

Role Requirements:

• 1-3 years experience designing and implementing basic data models.
• 1-3 years experience in SQL-based data transformations (e.g., dbt).
• 1+ years experience with data warehousing principles and BI tools (e.g., Looker).
• Strong problem-solving and troubleshooting skills.
• Experience working with cross-functional teams.
• Experience documenting data models.
• Bachelor's degree (or equivalent experience).

What is the last date for applying to the job?

Which countries are accepted for this remote job?