Data Platform Engineer

JFC Staffing Companies; Lancaster (Lancaster County); On-site; USD 120,000 - 160,000; Full time

Job summary

JFC Staffing Companies seeks a Data Platform Engineer to shape enterprise data solutions. You will leverage advanced SQL, Azure data services, and Microsoft Fabric, Synapse, and Dataverse to build scalable data pipelines and analytics that drive business success.

Collaborate across teams, optimize ETL/ELT workflows, support Power BI datasets, ensure data governance, security, and reliability, and continuously modernize the data platform to meet evolving needs.

Qualifications

• Extensive experience with advanced SQL, including optimization & tuning
• Strong relational data modeling and database design knowledge
• Hands-on experience with Microsoft Azure data services and Synapse

Responsibilities

• Design, develop, and maintain scalable data solutions using Azure, Fabric, Synapse and Dataverse
• Create and optimize complex SQL queries, stored procedures and data models for reporting and operations
• Build and manage robust data pipelines and ETL/ELT workflows
• Monitor and troubleshoot database performance and apply tuning techniques
• Support data integration across ERP/CRM systems and ensure security and governance

Skills

Advanced SQL

Azure Data Services

Azure Synapse

Dataverse

ETL/ELT

Power BI

Data Modeling

Performance Tuning

Tools

Microsoft Fabric

Azure Data Factory

Job description

Are you a passionate Data Platform Engineer looking to play a vital role in shaping cutting-edge enterprise data solutions? This opportunity is tailored for professionals with robust SQL expertise and a strong background in Microsoft’s data ecosystem. If you thrive working with cloud-based data architectures, enjoy collaborating across teams, and have experience with tools like Azure, Microsoft Fabric, Synapse, and Dataverse, this role could be the perfect next step. With potential exposure to D365, you'll contribute to innovative data integrations and analytics that drive business success. Join a dynamic environment where your technical skills will directly impact organizational growth, all while expanding your expertise in modern cloud data platforms.

Key Requirements:

• Extensive experience with advanced SQL, including query optimization, stored procedures, and performance tuning
• Solid understanding of relational database design and data modeling principles
• Proven hands-on experience with Microsoft Azure data services
• Familiarity with Microsoft Fabric, Azure Synapse Analytics, and Dataverse
• Knowledge of data integration, ETL/ELT processes, and enterprise data architecture
• Experience supporting Power BI datasets and reporting environments
• Strong grasp of database administration tasks like security, backups, and performance monitoring
• Excellent problem-solving abilities with effective communication skills, capable of working with both technical and non-technical stakeholders
• Ability to manage multiple projects simultaneously while maintaining high-quality deliverables

Preferred Qualifications:

• Experience with Microsoft Dynamics 365 (D365) and its data structures
• Knowledge of Azure Data Factory or similar data integration tools
• Familiarity with data governance, master data management, and data quality practices
• Certifications in Microsoft Azure, Fabric, or SQL are advantageous

Position Highlights:

• Design, develop, and maintain scalable data solutions leveraging Microsoft Azure, Fabric, Synapse, and Dataverse
• Create and optimize complex SQL queries, stored procedures, and data models to enhance reporting and operational systems
• Build and manage robust data pipelines and ETL/ELT workflows
• Monitor and troubleshoot database performance issues, applying tuning techniques
• Support data integration efforts across enterprise applications, including ERP and CRM systems
• Develop datasets and data models to empower Power BI reporting
• Continually seek opportunities to modernize and improve existing data infrastructure
• Ensure all data practices align with organizational security, governance, and compliance standards
• Document data architectures, processes, and technical specifications
• Collaborate with cross-departmental teams to deliver scalable analytical solutions that support business objectives

W2 only. Equal Opportunity Employer (EOE). Sorry, no sponsorship, C2C, subcontract, or 1099 opportunities.