[Remote] Analytics Engineer

Note: The job is a remote job and is open to candidates in USA. Apex Companies is a consulting and engineering firm seeking an Analytics Engineer to join its Corporate Data & Analytics team. The role combines business partnership, analytics development, and data engineering to build scalable, governed data solutions using Microsoft Fabric, Power BI, and related technologies. The position is responsible for translating business needs into trusted data products, semantic models, analytics experiences, and AI-ready data assets.

Responsibilities

• Partner with business leaders, subject-matter experts, and end users to understand business 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, including 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 when reporting, self-service, automation, or AI-enabled experience best fit the business need
• Communicate solution options, tradeoffs, progress, and risks clearly to both technical and non-technical
• Design and build reusable data products and semantic models that support Power BI reports, dashboards, scorecards, self-service analytics, and future AI-enabled experiences
• Develop and maintain reusable semantic models, relationships, hierarchies, calculations, and business
• Create and optimize DAX measures with a focus on accuracy, performance, consistency, and
• Partner with business owners to validate KPIs, reconcile results, and establish trusted
• Enable governed self-service analytics and AI readiness through certified data assets, business-friendly semantic models, clear documentation, and user education
• Design, build, and support data pipelines, notebooks, lakehouses, warehouses, and related components within Microsoft
• Develop ingestion and transformation processes using SQL, Python, Fabric Data Factory pipelines, and
• Build and maintain Bronze, Silver, and Gold data layers using reusable, domain-aligned patterns that support reporting, self-service analytics, and trusted AI consumption
• Integrate data from enterprise applications, APIs, files, cloud platforms, and on-premises
• Implement monitoring, validation, error handling, and performance improvements to support dependable production solutions
• Design dimensional models, star schemas, curated data marts, and analytical models that support scalable enterprise reporting
• Profile and validate source data; identify quality issues and work with business and system owners to resolve
• Document data lineage, transformation logic, KPI definitions, solution architecture, dependencies, support procedures, and intended consumption across reports, self-service, and AI-enabled solutions
• Follow and help strengthen standards for naming, security, access, testing, deployment, and lifecycle
• Promote reuse, consistency, business ownership, and responsible use of data across the
• Own solutions through discovery, design, development, testing, deployment, adoption, and ongoing
• Work within source control and CI/CD practices to deliver reliable, traceable changes across
• Troubleshoot data, model, refresh, and report issues and perform root-cause
• Identify opportunities to reduce manual reporting, retire duplicate solutions, expand self-service, and apply AI or automation where it provides practical business value
• Share knowledge with teammates and business users through documentation, demonstrations, and working

Skills

• 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
• Demonstrated ability to gather requirements, understand business processes, and translate needs into technical
• 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 data
• Experience building or supporting ETL/ELT processes, data pipelines, and data
• Knowledge of dimensional modeling, star schemas, data warehousing, and data quality
• Ability to communicate effectively with business stakeholders, technical teams, and
• Ability to manage multiple priorities, work independently, and take ownership of
• Hands-on experience with Microsoft Fabric, including Data Factory pipelines, Lakehouse, Warehouse, notebooks, and semantic models
• Experience developing data transformations or automation using Python or
• Experience with Git, Azure DevOps, deployment pipelines, testing, and CI/CD
• Experience integrating data from REST APIs, SaaS platforms, SQL Server, and cloud-based
• Experience with data governance, lineage, metadata, access controls, KPI or data-dictionary management, and preparing governed data for self-service or AI use cases
• Experience supporting enterprise functions such as Finance, Sales, Project Management, Human Resources, Health & Safety, or Operations
• Experience in the architecture, engineering, construction, environmental, or professional-services
• Familiarity with project-based business metrics such as backlog, utilization, revenue, profitability, project performance, and resource planning

Benefits

• All Apex positions are eligible for annual bonus opportunities
• Company-subsidized medical and
• Company-paid life, short- and long-term
• 401k match
• Tuition assistance
• Cross-training
• The ability to work on a variety of
• Performance-based bonuses or other

Company Overview

Company H1B Sponsorship