About AllShore TalentAllShore 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 RoleOur client is expanding its modern data and analytics capabilities and is seeking a 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.Job requirementsKey ResponsibilitiesAnalytics Engineering & Data Modeling (Primary Focus)Design and implement scalable analytical data models using dimensional modeling best practicesBuild and maintain fact tables, dimension tables, star schemas, and reporting datasetsDevelop and manage DBT transformations, models, and analytics workflowsCreate scalable ELT pipelines using Databricks, SQL, Python, and cloud-based technologiesCollaborate with stakeholders to translate business and reporting requirements into reliable data solutionsEnsure data quality, consistency, and governance across analytics environmentsSupport modern analytics initiatives using Microsoft Fabric, SQL endpoints, and related toolingUse Terraform or Infrastructure as Code (IaC) tooling to manage data platform resourcesContribute to AI-enabled analytics initiatives, integrations, and modern data platform enhancements.Secondary ResponsibilitiesProvide 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 dimensionsStar schema designKimball methodologyAnalytical warehouse modelingHands-on experience with Databricks, including SQL, Python, and PySpark; advanced SQL skills for data transformation and analytics engineeringExperience using Terraform or Infrastructure as Code (IaC) toolingExperience with Microsoft Fabric, especially SQL endpoints and analytics workloadsExperience 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 clientStrong communication and stakeholder-management skillsAbility to work independently in a fast-paced remote environmentNice-to-Have SkillsFamiliarity with Power BI or enterprise reporting environmentsExperience modernizing legacy BI/data environmentsFamiliarity with Azure Data Factory, Synapse, or related Microsoft cloud analytics servicesExperience with data quality frameworks, monitoring, or testing practicesWho You AreYou are an analytics-focused data professional with strong business and technical understandingYou excel at translating reporting and analytics requirements into scalable data modelsYou are comfortable working independently and collaborating across multiple teamsYou bring strong ownership, communication, and problem-solving skillsYou are confident explaining technical concepts to both technical and non-technical stakeholdersNon-Technical Requirements (weighted equally to technical skills)Strong spoken EnglishReliable home/office connectivity and consistent meeting/standup attendanceFull Mountain Time working-hours overlap requiredEngagement DetailsIndependent contractor roleFully remote32 - 40 hours per week Full-time, long-term commitmentHourly rate: $23.75–$25 USD depending on experience
3 days ago