Senior Analytics Engineer (100% Remote) (LATAM Only)

Allshore Talent; Oregon; Hybrid; USD 33,000 - 34,000; Full time

Job summary

AllShore Talent seeks a Senior Analytics Engineer to design scalable dimensional data models and lead DBT transformations using Databricks and cloud analytics tooling in a fully remote contractor role.

You will collaborate with stakeholders to translate business needs into reliable data solutions, maintain data quality and governance, support AI-enabled analytics, and build ELT pipelines with SQL, Python, and PySpark in enterprise environments. Full Mountain Time overlap is expected.

Qualifications

• Hands-on DBT work and dimensional data modeling expertise.
• Experience with Databricks, SQL, Python, PySpark for transformations.
• Proficiency with Terraform/IaC tooling and Microsoft Fabric.
• Experience enabling AI-enabled analytics and copilots.
• Strong communication and stakeholder management.
• Ability to work independently in a fast-paced remote environment.

Responsibilities

• Design scalable analytical data models using dimensional modeling.
• Build and maintain fact and dimension tables, star schemas.
• Develop DBT transformations and analytics workflows.
• Create scalable ELT pipelines using Databricks, SQL, Python.
• Collaborate with stakeholders to translate requirements.
• Ensure data quality, governance across analytics environments.
• Support analytics initiatives using Microsoft Fabric and SQL endpoints.
• Use Terraform/IaC to manage data platform resources.
• Contribute to AI-enabled analytics initiatives.

Skills

DBT

Dimensional modeling

Star schema

Kimball methodology

Databricks

SQL

Python

PySpark

Terraform / IaC

Microsoft Fabric

AI integrations

Stakeholder management

Independent work

Tools

Terraform

Microsoft Fabric

SQL Endpoints

Azure Data Factory

Power BI

Job description

About AllShore Talent

AllShore Talent is a leading remote staffing company, offering top-tier professionals working 100% remote to businesses worldwide. Specializing in IT and software development, design, administrative support, digital marketing, and more. AllShore connects organizations with skilled talent to meet diverse business needs.

About The Role

Senior Analytics Engineer

with strong expertise in analytics engineering, dimensional data modeling, DBT, and cloud-based data platforms. This role is heavily focused on designing and building scalable analytical data models that support reporting, business intelligence, and modern analytics initiatives across internal departments. Candidates should have strong hands-on experience with dimensional modeling concepts such as facts, dimensions, star schemas, and Kimball methodology, along with practical experience using Databricks and cloud analytics tooling.The ideal candidate is a strong SQL and analytics engineering professional who can work independently, communicate effectively with stakeholders, and deliver production-ready data solutions in enterprise environments.

Key Responsibilities

Analytics Engineering & Data Modeling (Primary Focus)

• Design and implement 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 business and reporting requirements into reliable data solutions
• Ensure data quality, consistency, and governance across analytics environments
• Support modern analytics initiatives using Microsoft Fabric, SQL endpoints, and related tooling
• Use Terraform or Infrastructure as Code (IaC) tooling to manage data platform resources
• Contribute to AI-enabled analytics initiatives, integrations, and modern data platform enhancements.

Secondary Responsibilities

• Provide light support for legacy Microsoft reporting environments (SSRS), on an as-needed basis only.

Required Qualifications (in priority order)

• Strong hands-on experience with DBT and analytics engineering workflows, including deep expertise in dimensional data modeling:Facts and dimensions
• Star schema design
• Kimball methodology
• Analytical warehouse modeling
• Hands-on experience with Databricks, including SQL, Python, and PySpark; advanced SQL skills for data transformation and analytics engineering
• Experience using Terraform or Infrastructure as Code (IaC) tooling
• Experience with Microsoft Fabric, especially SQL endpoints and analytics workloads
• Experience supporting AI-enabled analytics initiatives, copilots, agents, or modern AI integrations — candidates who can help teams adopt AI tooling are a strong differentiator for this client
• Strong communication and stakeholder-management skills
• Ability to work independently in a fast-paced remote environment

Nice-to-Have Skills

• Familiarity with Power BI or enterprise reporting environments
• Experience modernizing legacy BI/data environments
• Familiarity with Azure Data Factory, Synapse, or related Microsoft cloud analytics services
• Experience with data quality frameworks, monitoring, or testing practices

Who You Are

• You are an analytics-focused data professional with strong business and technical understanding
• You excel at translating reporting and analytics requirements into scalable data models
• You are comfortable working independently and collaborating across multiple teams
• You bring strong ownership, communication, and problem-solving skills
• You are confident explaining technical concepts to both technical and non-technical stakeholders

Non-Technical Requirements (weighted equally to technical skills)

• Strong spoken English
• Reliable home/office connectivity and consistent meeting/standup attendance
• Full Mountain Time working-hours overlap required

Engagement Details

• Independent contractor role
• Fully remote
• 32 - 40 hours per week
• Full-time, long-term commitment
• Hourly rate: $23.75–$25 USD depending on experience