Analytics Engineer

Job not on LinkedIn

🔥 1 minute ago

🇺🇸 United States – Remote

💵 $120k - $150k / year

⏰ Full Time

🟡 Mid-level

🟠 Senior

📊 Analytics Engineer

👻 Ghost score 0%

What it means: how likely this posting is sitting open without active hiring.How to read it: 60% or higher means we think this is a ghost. Lower scores are less of a worry.How we score it: age, reposts, open roles vs team size, how fast jobs close, and whether pay is listed.Fine print: an estimate from public data, not a judgment of the company. Real jobs can score high, so treat it as a hint, not a fact.

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Apex Companies, LLC

WebsiteLinkedInAll Job Openings

1001 - 5000 employees

💼 Consulting

🏥 Healthcare

📦 Logistics

💰 Funding Round on 2019-01

Consulting • Healthcare • Logistics

Apex Companies, LLC is an award-winning consulting and engineering firm that provides a comprehensive range of services related to water resources, environmental solutions, and infrastructure development. Their expertise spans across various sectors including health and safety compliance, environmental assessment, civil engineering, and sustainable infrastructure management. With a commitment to delivering high-impact results, Apex is dedicated to fostering a safe, sustainable, and equitable future for their clients and communities.

📋 Description

• 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

• 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

• 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