Analytics Engineer II, Marketing Technology - Remote

OneDigital Investment Advisors LLC; Northern (KY); Remote; USD 95,000 - 130,000; Full time

Benefits offered by this job

Health benefits

Retirement plan

Paid time off

Job summary

OneDigital Investment Advisors LLC is seeking an Analytics Engineer II for the Marketing Technology team, focused on data pipelines, dashboards, and analytics. You will collaborate with stakeholders to translate requirements into scalable data products and trusted datasets.

The role emphasizes governance, testing, and AI-assisted tooling to accelerate delivery. The position offers a remote, full-time arrangement with competitive compensation and benefits.

Qualifications

• 2-4 years in analytics engineering, BI, or data engineering.
• Strong SQL and cloud data warehouse experience.
• Experience building ETL/ELT processes and BI dashboards.

Responsibilities

• Develop, maintain, and optimize SQL transformations for Marketing and Sales reporting.
• Build and support ETL/ELT pipelines across Salesforce, HubSpot, Microsoft Dynamics, Azure, and APIs.
• Create dashboards and reports in Domo and Power BI based on business requirements.
• Translate business requirements into technical solutions and data models.
• Ensure data governance, security, and data quality across datasets.

Skills

SQL

Snowflake

BI Tools

Data Modeling

Git

Education

Bachelor's degree in CS/DS/IS

Tools

Domo

Power BI

Tableau

Azure Data Factory

Git

Job description

## Analytics Engineer II, Marketing Technology - RemoteApply: Remote: Full time: Posted Today: R9475*Are you looking to accelerate your career without having to hide your authentic self - a place where you can be you? A career that’s making a bigger impact on the world? At OneDigital, we are on a mission to help people do their best work and live their best lives. From the services we offer to the way we show up for each other each day, we are fueling dreams, achieving big goals, and embracing each other’s truest selves.* *We understand that pursuing a new job is a big deal. Maybe you’re afraid you won’t fit in. Well, here’s the good news. For us, the days of “fit in to get in” are over and being different is not a barrier to getting ahead. Greatness comes in all shapes, sizes, colors, and experience levels. If you are looking for a people-first culture that is wired for growth, driven to serve, and totally committed to having your back, give us a shot. Your best life awaits.* Must be eligible to work in the United States without the need for work visa or residency sponsorship. We kindly ask that external recruiters, agencies, and search firms do not contact our hiring managers or employees directly regarding open positions. All candidate submissions must go through our official application process and must be made aware to our internal Talent Acquisition team to verify candidate ownership.Unsolicited resumes or candidate profiles sent to OneDigital without a prior signed agreement will be considered the property of OneDigital. In such cases, OneDigital reserves the right to pursue and hire those candidates without any financial obligation to the agency or recruiter. **Our Newest Opportunity:**The Analytics Engineer II sits on the Marketing Technology team and develops, maintains, and improves the data solutions that support Marketing and growth reporting. The role combines data engineering, business intelligence, and analytics development to create trusted datasets, maintain reliable pipelines, and deliver operational reporting. Working closely with the Sr. Growth Analytics Manager, you will build a strong understanding of OneDigital's data ecosystem and help improve our data products over time. You will use AI-assisted tools to accelerate pipeline development, testing, and documentation, while retaining accountability for governance decisions, data quality judgment, and business context. **Essential Duties and 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 established CI/CD practices and execute test cases 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 and handling requirements (PII/PHI) in accordance with company policy, escalating gaps or exceptions to the Sr. Growth Analytics Manager*Business Intelligence Development** Build and maintain dashboards and reports in Domo and Power BI based on business requirements* Develop reusable datasets and semantic models, including clean, structured datasets that support AI and predictive modeling* Optimize dashboard performance and usability*Analytics Partnership** Partner with the Sr. Growth Analytics Manager to translate business requirements into technical solutions* Treat recurring datasets and dashboards as products: gather feedback, prioritize enhancements, and document intended use* Coordinate with cross-functional data owners when upstream changes could affect Marketing reporting* Support ad hoc analytical requests **Required 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 **Preferred Qualifications*** Marketing or sales analytics experience* Salesforce, HubSpot, Microsoft Dynamics, and API integrations* Azure Data Factory or Azure Blob Storage; Coalesce or similar tools* CI/CD and automated testing for data pipelines* Exposure to preparing datasets for ML/AI; familiarity with data governance frameworks* Bachelor's degree in computer science, data science, information systems, or a related field (equivalent experience considered) **Desired Characteristics** Curious about how data supports business decisions, takes initiative, troubleshoots methodically, values documentation and responsible data handling, and is eager to grow technical, business, and AI/ML knowledge.The typical base pay range for this role nationwide is $95,000 to $130,000 per year. Your base pay is dependent upon your skills, education, qualifications, professional experience, and location. In addition to base pay, some roles are eligible for variable compensation, commission, and/or annual bonus based on your individual performance and/or the company’s performance. We also offer eligible employees health, wellbeing, retirement, and other financial benefits, paid time off, overtime pay for non-exempt employees, and robust learning and development programs. You will receive reimbursement of job-related expenses per the company policy and may receive employee perks and discounts.