Job Posting ExternalPrimary Responsibilities:Design, develop, and support scalable enterprise data solutions on the Microsoft Fabric platform, leveraging Lakehouse, Data Warehouse, OneLake, Data Factory, Real-Time Analytics, and Power BI.
Develop and optimize ETL/ELT data pipelines using Microsoft Fabric Data Factory, Notebooks, Dataflows Gen2, Pipelines, Event Streams, and streaming ingestion frameworks.
Build high-performance data transformation frameworks using PySpark and Spark SQL within Fabric Notebooks to process large-scale structured and unstructured datasets.
Design, develop, and maintain Lakehouse architectures, medallion data models (Bronze, Silver, Gold), and enterprise data products that support analytics, reporting, and AI use cases.
Develop and optimize complex SQL queries, stored procedures, views, and data models within Fabric Data Warehouse and Lakehouse environments.
Design and implement semantic models in Power BI, ensuring efficient data modeling, performance optimization, governance, and reusability across business domains.
Develop enterprise-grade Power BI solutions, including DAX measures, calculated columns, Power Query (M) transformations, row-level security (RLS), and advanced dashboard visualizations.
Collaborate with Business Analysts, Data Analysts, and stakeholders to gather requirements and translate business needs into scalable Fabric-based data solutions.
Implement and support CI/CD, DevOps, and deployment automation using Git integration, deployment pipelines, source control, and environment promotion strategies.
Establish data quality, data governance, lineage, security, and monitoring standards across Fabric workloads to ensure reliable and trusted data assets.
Optimize Spark jobs, semantic models, and Power BI datasets for performance, scalability, and cost efficiency.
Perform peer code reviews and enforce best practices for PySpark, SQL, Power BI, and Fabric development standards.
Develop and maintain technical documentation, architecture diagrams, data flow mappings, and operational procedures in alignment with enterprise standards.
Support real-time and near real-time data integration using technologies such as CDC, Kafka, Event Streams, APIs, and Fabric Real-Time Analytics.
Work closely with QA and testing teams to develop unit tests, integration tests, and data reconciliation processes, ensuring solution quality and reliability.
Provide production support, root cause analysis, performance tuning, and troubleshooting of Fabric pipelines, notebooks, semantic models, and reporting solutions.
Minimum QualificationsBachelor's degree in Computer Science, Information Systems, Data Engineering, Information Technology, Engineering, Mathematics, or a related technical field.
Strong expertise in PySpark and Spark SQL for large-scale data processing, transformation, and optimization.
Strong experience developing enterprise-grade Power BI solutions including:
- Semantic Models
- DAX Measures
- Power Query (M)
- Row-Level Security (RLS)
- Performance Optimization
- Interactive Dashboards and Reports
Preferred QualificationsMicrosoft Certified: Fabric Analytics Engineer Associate (DP-600).
Microsoft Certified: Azure Data Engineer Associate (DP-203).
Experience with Real-Time Analytics, Eventhouse, KQL, and streaming data architectures.
Experience integrating SAP, Quipware, IFS, WMS, Manufacturing, Finance, or Supply Chain data into modern analytics platforms.
This position is on-site four days/week at the New Bremen, OH location.
Work Authorization:Crown will only employ those who are legally authorized to work in the United States. This is not a position for which sponsorship will be provided. Individuals with temporary visas or who need sponsorship for work authorization now or in the future, are not eligible for hire.
No agency calls please.
Compensation and Benefits:Crown offers an excellent wage and benefits package for full-time employees including Health/Dental/Vision/Prescription Drug Plan, Flexible Benefits Plan, 401K Retirement Savings Plan, Life and Disability Benefits, Paid Parental Leave, Paid Holidays, Paid Vacation, Tuition Reimbursement, and much more.
