Analytics Engineer

Apex Companies, LLC

. Partner with business leaders, subject-matter experts, and end users to understand processes, challenges, goals, and reporting needs .

Posted 9/24/2026full-timeRemote • United StatesMid-LevelSenior💰 $120,000 - $150,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in developing scalable data solutions, including semantic models and Power BI reports, while effectively communicating with both technical and non-technical stakeholders. Proficient in SQL, Python, and Microsoft Fabric for data integration and analytics.

Highest-signal resume keywords

Power BI DeliverySQL SkillsData EngineeringSemantic ModelsMicrosoft Fabric

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data AnalyticsETL/ELT ProcessesDimensional ModelingDAXData Quality PracticesData IntegrationData WarehousingData TransformationAutomationKPI Design

Soft Skills

Effective CommunicationOwnershipIndependent WorkPrioritizationCollaboration

Tools & Technologies

Microsoft FabricPower BISQL ServerAzure DevOpsGitData FactoryLakehousePipelinesNotebooksAPIs

Industry Keywords

Business IntelligenceAnalytics EngineeringData GovernanceMetadata ManagementProject Management

Tech Stack

Tools & technologies

AzureCloudETLPySparkPythonSQL

About the role

Key responsibilities & impact

Partner with business leaders, subject-matter experts, and end users to understand processes, challenges, goals, and reporting needs
Lead discovery and requirements-gathering sessions; document business rules, data definitions, use cases, acceptance criteria, and success measures
Translate business needs into scalable data solutions, curated data products, semantic models, self-service datasets, dashboards, AI-ready data assets, and operational reporting
Advise stakeholders on KPI design, metric consistency, solution options, and appropriate reporting, self-service, automation, or AI-enabled experiences
Communicate solution options, tradeoffs, progress, and risks to technical and non-technical audiences
Design and build reusable data products and semantic models supporting Power BI reports, dashboards, scorecards, self-service analytics, and AI-enabled experiences
Develop and maintain semantic models, relationships, hierarchies, calculations, and DAX measures
Validate KPIs, reconcile results, and establish trusted analytics outputs
Enable governed self-service analytics and AI readiness through certified data assets, documentation, and user education
Design, build, and support Microsoft Fabric data pipelines, notebooks, lakehouses, warehouses, and related components
Develop ingestion and transformation processes using SQL, Python, Fabric Data Factory pipelines, and related tools
Build and maintain Bronze, Silver, and Gold data layers
Integrate data from enterprise applications, APIs, files, cloud platforms, and on-premises systems
Implement monitoring, validation, error handling, and performance improvements
Design dimensional models, star schemas, curated data marts, and analytical models
Profile and validate source data; identify and resolve data-quality issues
Document data lineage, transformation logic, KPI definitions, architecture, dependencies, support procedures, and intended consumption
Follow and strengthen standards for naming, security, access, testing, deployment, and lifecycle management
Own solutions through discovery, design, development, testing, deployment, adoption, and ongoing support
Work within source control and CI/CD practices
Troubleshoot data, model, refresh, and report issues and perform root-cause analysis
Identify opportunities to reduce manual reporting, retire duplicate solutions, expand self-service, and apply AI or automation
Share knowledge through documentation, demonstrations, and working sessions

Requirements

What you’ll need

Bachelor’s degree in Information Systems, Computer Science, Data Analytics, Engineering, Business Analytics, or a related field, or equivalent practical experience
Professional experience in analytics engineering, business intelligence, data engineering, or a similar field
Demonstrated ability to gather requirements, understand business processes, and translate needs into technical solutions
Strong experience developing enterprise data and analytics solutions, including semantic models, DAX, and Power BI delivery
Strong SQL skills and experience working with relational and analytical databases
Experience building or supporting ETL/ELT processes, data pipelines, and data integrations
Knowledge of dimensional modeling, star schemas, data warehousing, and data quality practices
Ability to communicate effectively with business stakeholders, technical teams, and vendors
Ability to manage multiple priorities, work independently, and take ownership of deliverables
Preferred: hands-on experience with Microsoft Fabric, including Data Factory pipelines, Lakehouse, Warehouse, notebooks, and semantic models
Preferred: experience developing data transformations or automation using Python or PySpark
Preferred: experience with Git, Azure DevOps, deployment pipelines, testing, and CI/CD practices
Preferred: experience integrating data from REST APIs, SaaS platforms, SQL Server, and cloud-based systems
Preferred: experience with data governance, lineage, metadata, access controls, KPI or data-dictionary management, and governed data for self-service or AI use cases
Preferred: experience supporting enterprise functions such as Finance, Sales, Project Management, Human Resources, Health & Safety, or Operations
Preferred: experience in architecture, engineering, construction, environmental, or professional-services organizations
Preferred: familiarity with project-based business metrics such as backlog, utilization, revenue, profitability, project performance, and resource planning
Technology environment includes Microsoft Fabric, Power BI, SQL, DAX, Fabric Data Factory, pipelines, notebooks, Lakehouse, Warehouse, semantic models, APIs, Git, and Azure DevOps

Benefits

Comp & perks

All Apex positions are eligible for annual bonus opportunities
Company-subsidized medical and dental
Company-paid life, short-term, and long-term disability coverage
401(k) match
Tuition assistance
Cross-training
Ability to work on a variety of projects
Performance-based bonuses or other incentives