Senior Analytics Engineer (Remote) – Dimensional Modeling & DBT

Allshore Talent; United States; Remote; USD 33,000 - 34,000; Full time

Job summary

AllShore Talent is seeking a Senior Analytics Engineer to design scalable data models and modern analytics pipelines for reporting and BI. The role focuses on dimensional modeling, DBT transformations, and cloud-based ELT pipelines using Databricks and SQL/Python in a remote environment.

You will collaborate with stakeholders to translate business requirements into reliable data solutions, ensure data quality and governance, and contribute to AI-enabled analytics initiatives.

Qualifications

• DBT and analytics engineering workflows with dimensional modeling.
• Experience with dimensional modeling concepts: facts, dimensions, star schemas, Kimball.

Responsibilities

• Design scalable analytical data models using dimensional modeling best practices.
• Build and maintain fact tables, dimension tables, star schemas, and reporting datasets.
• Develop and manage DBT transformations, models, and analytics workflows.
• Create scalable ELT pipelines using Databricks, SQL, Python, and cloud-based technologies.
• Collaborate with stakeholders to translate requirements into data solutions.
• Ensure data quality, governance, and consistency across environments.
• Support analytics initiatives using Microsoft Fabric, SQL endpoints, and IaC tooling.
• Contribute to AI-enabled analytics initiatives and integrations.

Skills

DBT analytics engineering

Dimensional data modeling

Databricks

SQL proficiency

Python / PySpark

AI tooling adoption

Stakeholder communication

Independent remote work

Tools

Terraform

Microsoft Fabric

Power BI

Azure Data Factory / Synapse

Job description

AllShore Talent is seeking a Senior Analytics Engineer to design scalable data models and modern analytics pipelines for reporting and BI. The role focuses on dimensional modeling, DBT transformations, and cloud-based ELT pipelines using Databricks and SQL/Python in a remote environment.

You will collaborate with stakeholders to translate business requirements into reliable data solutions, ensure data quality and governance, and contribute to AI-enabled analytics initiatives.