Analytics Engineer II, Marketing Tech – Data Pipelines & BI

Digital Insurance LLC; United States; Remote; USD 95,000 - 130,000; Full time

Benefits offered by this job

Health

Wellbeing

Retirement

Other financial benefits

Paid time off

Overtime pay

Learning & development

Expense reimbursement

Job summary

OneDigital is hiring an Analytics Engineer II on the Marketing Technology team to build and optimize data solutions for marketing and growth reporting. You will merge data engineering, BI, and analytics development to deliver trusted datasets, maintain pipelines, and produce operational reporting.

You’ll work with AI-assisted tools while ensuring governance, data quality, and business context. You will partner with analytics leadership to transform requirements into technical solutions, create

Qualifications

• 2-4 years of experience in analytics engineering, business intelligence, or data engineering.
• Strong SQL skills and experience with cloud data warehouses (Snowflake preferred).
• Experience building ETL/ELT processes.
• Experience with Domo, Power BI, Tableau, or similar BI platforms.
• Understanding of dimensional modeling and relational databases.
• Experience with Git or version control.
• Working understanding of data security and privacy best practices.
• Strong written and verbal communication, including explaining findings to non-technical stakeholders.
• Strong prioritization skills and the ability to manage multiple requests with minimal supervision.

Responsibilities

• Data Engineering & Integration: Develop, maintain, and optimize SQL transformations in Snowflake for Marketing and Sales reporting.
• Build and support ETL/ELT pipelines and integrations across Salesforce, HubSpot, Microsoft Dynamics, Azure, and APIs.
• Follow CI/CD practices and execute tests to validate changes before production.
• Monitor scheduled jobs and troubleshoot production issues.
• Data Quality, Governance & Security: Monitor data quality, investigate discrepancies, and build automated validation and reconciliation processes.
• Maintain documentation for datasets, data flows, lineage, and transformation logic.
• Apply access controls and follow privacy requirements (PII/PHI) in accordance with policy.
• Business Intelligence Development: Build and maintain dashboards/reports in Domo and Power BI.
• Develop reusable datasets and semantic models for AI/ML; optimize dashboard performance.
• Analytics Partnership: Translate business requirements into technical solutions; treat datasets as products.

Skills

SQL

Snowflake

ETL/ELT

BI Platforms

Dimensional Modeling

Git

Data Security

Communication

Prioritization

Education

Bachelor's degree in CS/Data Science/IS

Tools

Domo

Power BI

Tableau

Azure Data Factory

Azure Blob Storage

Coalesce

API Integrations

Job description

OneDigital is hiring an Analytics Engineer II on the Marketing Technology team to build and optimize data solutions for marketing and growth reporting. You will merge data engineering, BI, and analytics development to deliver trusted datasets, maintain pipelines, and produce operational reporting.

You’ll work with AI-assisted tools while ensuring governance, data quality, and business context. You will partner with analytics leadership to transform requirements into technical solutions, create