Avatar for JMP
Sells and distributes commercial HVAC and plumbing equipment, offering design and operation training

Data & Analytics Engineer

Posted: 3 weeks ago
Job Location
Remote Work Policy

In office - WFH flexibility

Visa Sponsorship

Not Available

RelocationAllowed
Skills
Python
SQL
Git
Orchestration
T-SQL
ETL
Technical documentation
Data Pipelines
Transformation
Elt
Dimensional Modeling
Pyspark
Data Ingestion
Power BI
Report Design
Azure DevOps
Power Query
Keys
Access Management
Error Handling
Microsoft Fabric
Fact Tables
Dimension Tables
Slowly Changing Dimensions
Star Schemas
Semantic Models
Dependencies
Row-Level Security
Security Concepts
Grain
Report Publishing
Refresh Support
Governed Analytical Logic

About the job

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.

About the company

JMP company logo
Sells and distributes commercial HVAC and plumbing equipment, offering design and operation training51-200 Employees
Learn more about JMP image

Similar Jobs

Enigma Technologies company logo
Enigma Technologies
Authoritative answers for your agents and workflows
Forus company logo
Forus
Accelerate the future of medicine
Clipboard company logo
Clipboard
Flexibility and high pay for professionals. Top talent and fast fill for workplaces
Blue Ink Digital company logo
Blue Ink Digital
Automated Marketplace for real-time exclusive leads
AARATECH company logo
AARATECH
AaraTech Inc. empowers businesses by providing innovative and tailored IT solutions and services
EquityZen company logo
EquityZen
Private Markets for the Public // Pre-IPO Stock Marketplace
Iterative Health company logo
Iterative Health
Pioneering the use of artificial intelligence-based solutions for gastroenterology