Sr. Data Engineer

Imperial Brady; Jersey City (NJ); On-site; USD 130,000 - 150,000; Full time

Benefits offered by this job

Medical benefits

Dental & Vision

401(k) with company match

Life insurance

Paid time off

Educational reimbursement

Paid family leave

Adoption assistance

Job summary

Imperial Brady is seeking a Senior Data Engineer to design, build, and maintain scalable data solutions on the Microsoft Fabric stack. You will own end-to-end data pipelines, data modeling across lakehouse layers, and governance to support reporting and analytics.

Join a modern data platform with a three-week sprint cadence, where you will collaborate with analytics and business stakeholders to ensure data freshness and reliability across BI workloads.

Qualifications

• 5+ years in data engineering with ownership of production data pipelines.
• Hands-on Microsoft Fabric experience, or equivalent Azure Synapse or Databricks experience.
• Proficiency in SQL, PySpark, and Spark SQL for data transformation.
• Solid understanding of dimensional modeling and of Delta Lake and medallion architecture patterns.
• Strong source control (Git) and CI/CD experience for data pipelines.
• Strong understanding of data quality, governance, and security practices, especially around PII, financial, and HR data.
• Ability to communicate technical trade-offs clearly to non-technical business stakeholders.

Responsibilities

• Design and build robust ETL/ELT pipelines ingesting data from diverse source systems.
• Own data modeling across bronze, silver, and gold layers including star schemas and SCD handling.
• Optimize pipeline and query performance with partitioning, indexing, and Delta/Parquet strategies.
• Enforce data governance and security practices for sensitive data (PII, financial, HR).
• Collaborate with analytics and BI to ensure data is reliable, well-modeled, and timely.
• Deploy Fabric artifacts through source control and CI/CD, maintaining parity across environments.
• Ensure gold/silver layers meet BI needs and assist with report requests.

Skills

SQL

PySpark

Spark SQL

Dimensional modeling

Data governance

Data quality

Communication

Tools

Microsoft Fabric

Azure Synapse

Databricks

Git

CI/CD

Job description

Imperial Brady is a leading North American distributor and solutions provider for cleaning and facility care, foodservice, and packaging. With more than 13,000 employees and a broad supply chain network, we deliver national scale with local expertise. Built on strong customer relationships and deep industry knowledge, we go beyond distribution—delivering Supplies + Support through expertise, service, and a commitment to making every customer touchpoint a plus. #imperialbradyjobs

• All correspondence will come directly from Imperial Brady and not a personal email address.**

Senior Data Engineer

We are looking for a Senior Data Engineer to design, build, and maintain scalable data solutions across our modern data platform. This role is grounded in core data engineering discipline, including data modeling, pipeline architecture, performance optimization, and data quality, with hands‑on ownership across the full Microsoft Fabric stack: pipelines, lakehouses, notebooks, semantic models, and Fabric‑native applications.

You will work closely with analytics, BI, and business stakeholders to ensure data is reliable, well modeled, and delivered at the right grain and freshness to support reporting, analytics, and downstream applications. The EDW team delivers on a three week sprint cadence: two weeks of development, followed by one week of UAT, reconciliation, retrospective, and grooming. You will own your work end to end inside that cadence, from refinement and estimation through the production deploy.

Compensation Range: $130,000 to $150,000 + Bonus
Salary range reflects the Jersey City, NJ market & compensation may vary based on geographic location.

You Will

• Design and build robust, scalable ETL and ELT pipelines that ingest, transform, and curate data from diverse source systems.
• Own data modeling across bronze, silver, and gold layers, including dimensional modeling (star schema), surrogate key strategy, and slowly changing dimension (SCD) handling.
• Optimize pipeline and query performance, including partitioning, indexing, and file format strategy (for example Delta and Parquet).
• Enforce data governance practices, including handling of sensitive data (PII, financial, HR) and access control patterns.
• Drive data defects to their true origin. Where records are wrong in a source system, partner with the owning team to fix them at the source rather than filtering them downstream, and document any interim handling for audit purposes.
• Deploy Fabric artifacts through source control and CI/CD, keeping Dev, UAT, and Production in parity. Direct changes to Production outside the release process are not acceptable practice.
• Ensure curated gold and silver layers meet the grain, freshness, and structure the BI team needs, and help triage whether a report request requires new engineering work or can be served from existing structures.

You Have

• 5 or more years in data engineering with demonstrated ownership of production data pipelines.
• Strong hands‑on Microsoft Fabric experience, or equivalent Azure Synapse or Databricks experience with a willingness to specialize in Fabric.
• Proficiency in SQL, PySpark, and Spark SQL for data transformation.
• Solid understanding of dimensional modeling and of Delta Lake and medallion architecture patterns.
• Strong source control (Git) and CI/CD experience for data pipelines, including branching strategy, pull request discipline, and automated promotion across environments.
• Strong understanding of data quality, governance, and security practices, especially around PII, financial, and HR data.
• Ability to communicate technical trade‑offs clearly to non‑technical business stakeholders.

We offer a dynamic environment for our more than 13,000 employees to work, learn, and grow professionally. We value our people and strive to create rewarding career opportunities by offering competitive salaries and benefits (medical, dental, vision), a 401(k) program with company match, life insurance, a generous paid time off package, educational reimbursement, paid family leave, and adoption assistance. We are excited to invite talented individuals with a passion for excellence to join our team.

Imperial Brady is an EEO Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, gender identity, sexual orientation, pregnancy, status as a parent, national origin, age, disability (physical or mental), family medical history, or genetic information, political affiliation, military service, or other non‑merit‑based factors.

Our company is a Fair Chance employer, committed to providing opportunities for qualified individuals with past justice system involvement. We believe in assessing candidates based on their skills and experience. A conditional offer of employment will be contingent upon the successful completion of a background check, consistent with applicable federal, state, and local laws.

Massachusetts Applicants

It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.