Data & Analytics Engineer

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Information Systems Full Time Professional Greensboro, NC - 603 Diamond Hill Ct, Greensboro, NC, US

2 days ago Requisition

Position intent:
Hire a data-focused generalist who can build and support modern analytics solutions using Microsoft Fabric, Power BI, SQL, dimensional modeling, data pipelines, and governed semantic models.

Recommended Work Emphasis

Focus Area

Target Emphasis

Primary Outcomes

35%

Reliable ingestion, transformation, modeling, pipelines, quality controls, and reusable curated data.

Analytics & Power BI

45%

Trusted semantic models, dashboards, operational reporting, and decision support.

Business Analysis

15%

Well-defined requirements, metric definitions, validation, documentation, and user acceptance testing.

Supporting Automation / Code

5%

Light Python, Power Shell, APIs, or Power Automate used to extend and automate analytics workflows.

What This Role Is Not

• Not a full-stack software engineering position.
• Not primarily focused on mobile, web, or enterprise application development.
• Not limited to building report visuals without responsibility for the underlying data and business logic.
• Not a purely administrative Power BI role.

Core Responsibilities Responsibility Area Expected Contribution Fabric Data Engineering

Develop and support ingestion and transformation processes using Fabric pipelines, Dataflows Gen2, lake houses, warehouses, notebooks, or other appropriate Fabric components.

Data Modeling

Create and maintain dimensional models, curated analytical tables, relationships, conformed dimensions, and reusable business logic.

Semantic Models

Build and support governed Power BI semantic models, including measures, relationships, refresh design, security, naming standards, and documentation.

Power BI Analytics

Develop clear, useful, performant reports and dashboards that answer defined business questions and support operational and executive decision making.

Data Quality

Validate source-to-report results, identify data issues, document reconciliation logic, and implement repeatable data-quality checks.

Pipeline Operations

Monitor refreshes and pipelines, troubleshoot failures, improve reliability, and document support procedures.

Requirements & Metrics

Work with stakeholders to define requirements, business rules, KPIs, acceptance criteria, and authoritative metric definitions.

Governance & Deployment

Follow workspace, security, testing, change-control, release, lineage, and production-readiness standards.

Documentation & Enablement

Create technical documentation, data dictionaries, solution notes, lineage descriptions, user guidance, and knowledge-transfer materials.

Required Technical Skills

• Strong SQL/T-SQL skills, including joins, common table expressions, aggregations, window functions, data validation, and query troubleshooting.
• Python or PySpark for data preparation, validation, notebooks, or automation.
• Hands‑on Power BI development experience, including Power Query, semantic models, interactive report design, publishing, and refresh support.
• Understanding of dimensional modeling, including fact tables, dimension tables, star schemas, grain, keys, and slowly changing dimensions.
• Understanding of ETL and ELT concepts, data ingestion, transformation, orchestration, dependencies, and error handling.
• Ability to reconcile data from source systems through transformation layers to published reports.
• Experience creating clear technical documentation and translating business definitions into governed analytical logic.
• Working knowledge of security concepts that affect analytics, including access management and row‑level security.
• Basic Git or Azure Dev…