Data & Analytics Engineer

Automatic Data Processing, Inc.; Greensboro (NC); On-site; USD 90,000 - 120,000; Full time

Job summary

Automatic Data Processing, Inc. in Greensboro, NC is seeking an Information Systems professional to design and support modern analytics solutions. You will build ingestion pipelines, data models, and governance for trusted BI insights.

The role emphasizes Power BI development, dimensional modeling, and data quality, with collaboration across business and IT teams. This is a full-time on-site position in Greensboro, NC.

Qualifications

• Two or more years of relevant experience in data analytics, BI, data engineering, or data warehousing.
• Experience delivering analytics solutions from data to reports using Power BI.
• Ability to translate business requirements into governed analytical logic and data models.

Responsibilities

• Develop and support data ingestion and transformation pipelines using Fabric or equivalent components.
• Create and maintain dimensional models, curated analytical tables, and reusable business logic.
• Build and support governed Power BI semantic models, measures, security, and documentation.
• Develop clear, useful Power BI reports and dashboards to support operations and executive decision making.
• Validate data quality, document reconciliation logic, and implement repeatable checks.
• Monitor data pipelines and refreshes, troubleshoot failures, and document support procedures.
• Define requirements, metrics, KPIs, and authoritative metric definitions with stakeholders.
• Follow governance, security, change-control, release, lineage, and production-readiness standards.
• Create technical documentation, data dictionaries, and knowledge-transfer materials.

Skills

SQL/T-SQL

Python or PySpark

Power BI development

Dimensional modeling

ETL/ELT concepts

Data reconciliation

Technical documentation

Security concepts

Git / Azure DevOps

Communication skills

Tools

Git

Azure DevOps

Job description

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 ID: 1044

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, PowerShell, 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, lakehouses, 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 DevOps source‑control practices.
• Strong communication with technical and non‑technical audiences.

Preferred Microsoft Fabric Experience

• Fabric workspaces, capacities, items, and deployment concepts.
• Lakehouse and Warehouse design and support.
• Data Factory pipelines and Dataflows Gen2.
• Fabric notebooks and Spark or Python for data engineering tasks.
• OneLake concepts, shortcuts, and medallion‑style data organization.
• Direct Lake and Import semantic‑model considerations.
• Monitoring Hub, refresh troubleshooting, lineage, and operational support.
• Deployment pipelines, source control, or structured development and release practices.

Preferred Power BI Experience

• Advanced calculation patterns.
• Power Query and reusable transformation logic.
• Semantic‑model performance optimization and model simplification.
• Row‑level security and testing across business entities or user groups.
• Workspace organization, Power BI apps, deployment, and access management.
• Report usability, accessibility, visual consistency, and performance optimization.
• Shared semantic models and thin‑report development patterns.

Supporting Coding Skills

Not necessary, but nice to have. Will use these skills but I can teach them if not known already.

• PowerShell for administration or repeatable support tasks.
• Ability to work with REST APIs, JSON, authentication concepts, and configuration values.
• Ability to read, troubleshoot, and adapt existing code without needing to be a full‑stack developer.

Business and Professional Skills

• Ability to translate a business problem into data requirements, model requirements, metrics, and reporting outcomes.
• Detail‑oriented approach to data reconciliation, testing, and quality assurance.
• Ability to challenge unclear requirements and ask effective follow‑up questions.
• Comfort managing several priorities across development, troubleshooting, stakeholder support, and documentation.
• Curiosity, adaptability, and willingness to learn as the Fabric environment and analytics program mature.

Experience Profile

Level

Desired Background

Minimum

Two or more years of relevant experience in data analytics, business intelligence, data engineering, data warehousing, or a closely related field; practical Power BI and SQL experience.

Strong Candidate

Demonstrated experience building complete analytics solutions from source data through transformation, modeling, semantic models, and Power BI delivery.

Ideal Candidate

Hands‑on Microsoft Fabric experience, enterprise Power BI support, dimensional modeling, pipeline troubleshooting, governance, security, and stakeholder‑facing requirements work.