Senior Data Engineer: Microsoft Fabric Lakehouse Architect

Cloud Analytics Technologies, LLC

Hartford (CT)

On-site

USD 82,000 - 117,000

Full time

4 hours ago

Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Cloud Analytics Technologies, LLC is seeking a senior Data Engineer to design and deliver data pipelines on Microsoft Fabric for a Hartford-based engagement. You will shape the solution, lead hands-on builds, mentor developers, and serve as the technical contact for business and IT stakeholders on site.

The role requires deep Fabric expertise, strong SQL and PySpark, and experience migrating workloads to Lakehouse architectures.

Qualifications

8+ years in data engineering with end-to-end Fabric delivery.
Expert-level SQL (T-SQL) and PySpark with Delta Lake mastery.
Strong dimensional modelling and medallion architecture experience.
Git-based version control and CI/CD for data assets.

Responsibilities

Lead design and build of ingestion and transformation pipelines using Fabric Data Factory and Spark notebooks.
Define Lakehouse vs Warehouse choices and medallion layering on One Lake with Delta tables.
Design and optimize Power BI models and guide report developers.
Lead migration of SSIS/ADF/Synapse workloads to Fabric and perform cutover.
Set up CI/CD using Fabric Git integration and deployment pipelines.
Define security/governance: workspace roles, row/column security, sensitivity labels.
Own performance, tuning of pipelines, Spark jobs, and queries.
Mentor junior/mid developers and conduct design/code reviews.
Run workshops, estimate work, and keep designs/runbooks current.