Data & Analytics Engineer

JMP USA; Greensboro, Winston-Salem, High Point (NC, NC, NC); On-site; USD 110,000 - 150,000; Full time

Benefits offered by this job

ESOP

401(k)

Job summary

JMP USA in Greensboro, NC seeks a Data & Analytics Engineer to design, build, and support data and reporting solutions using Microsoft Fabric, Power BI, and SQL. You will deliver trusted analytics, reliable data models, and actionable insights to inform business decisions.

The role emphasizes data modeling, ETL/ELT, documentation, and security controls, with opportunities to collaborate across the organization and occasional travel to the Greensboro home office.

Qualifications

• Strong SQL/T-SQL with joins, CTEs, aggregations, window functions, data validation, and query troubleshooting.
• Python or PySpark for data prep, validation, notebooks, or automation.
• Hands-on Power BI development: Power Query, semantic models, reports, publishing, refresh.
• Understanding of dimensional modeling: fact/dim tables, star schemas, grain, keys, SCDs.
• Understanding of ETL/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 analytics.
• Knowledge of security concepts affecting analytics, including access management and row-level security.
• Basic Git or Azure DevOps source-control practices.
• Strong communication with technical and non-technical audiences.

Responsibilities

• Design, build, and support data and reporting solutions to drive business decisions.
• Work with Microsoft Fabric, Power BI, SQL, and data pipelines to deliver trusted analytics.
• Create reliable data models and actionable insights for stakeholders.

Skills

SQL

Power BI

Python

Data modeling

ETL/ELT

Documentation

Security concepts

Git/Azure DevOps

Communication

Tools

Git/Azure DevOps

Job description

Are you looking for a full-time position that offers a great work-life balance, competitive salary, and company culture?

Do you favor a relaxed, collaborative office environment over corporate stuffiness?

At JMP, you’re more than an employee—you are an owner! By taking part in our employee-owned stock option plan (ESOP) and 401k you’ll be on the road to financial security and well-planned retirement.

JMP is one of the largest commercial HVAC sales reps in the Southeast, representing over 30 top brands of equipment, including Xylem, Lochinvar, Baltimore Aircoil Company, and ClimateMaster. We have an unprecedented 65-year reputation for engineered equipment sales & support and unparalleled client education programs.

We believe in doing right by our clients and our co-workers by being helpful, courteous, and honorable.

Role Summary

The Data & Analytics Engineer designs, builds, and supports data and reporting solutions that help drive business decisions across the organization. This role will be working with Microsoft Fabric, Power BI, SQL, and data pipelines to deliver trusted analytics, reliable data models, and actionable insights.

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 Technical Skills

• 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.
• 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.
• 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.

Requires periodic travel to the home office, located in Greensboro, NC.