Responsibilities :
- Architect, build, and optimize scalable data pipelines using Azure Data Factory (ADF), PySpark, SQL, and related Azure services
- Design and implement robust ETL frameworks to ingest and transform data from multiple ERP systems into a centralized enterprise data warehouse (EDW)
- Build and maintain medallion-style architecture (Bronze / Silver / Gold) to support scalable and trusted analytics
- Support and enhance the corporate EDW to ensure consistent, reliable reporting across business units
- Implement automated data quality, validation, and lineage checks to ensure reliable ingestion from source systems
- Collaborate with business and IT stakeholders to define data requirements and deliver executive-ready datasets
- Develop semantic models and unified data layers to streamline and standardize reporting logic across teams
- Troubleshot performance issues, pipeline failures, and system bottlenecks
- Contribute to data governance, security, access control, and regulatory compliance efforts
- Mentor junior engineers and serve as technical lead on cross-functional data initiatives
- Maintain comprehensive documentation of technical architecture, data flows, and design decisions
- Perform other duties as assigned
Basic Qualifications :
BS / BA in Computer Science or a related field7+ years of proven experience as a data engineer preferredProven success with Azure-based data tools including Azure Data Factory, Data Lake Storage, Delta Lake, and Synapse or FabricAdvanced proficiency in T-SQL and PySpark for high-volume data processing and transformationExperience building and maintaining medallion architecture in enterprise environmentsAdvanced expertise in Azure Data Services, including Azure Data Factory (ADF), Data Lake, Synapse, and FabricStrong proficiency in SQL, PySpark, and database query languages such as SQL / PSMDeep understanding of ETL / ELT best practices and dimensional data modelingExperience integrating and harmonizing data from multiple ERP systemsProficiency in data automation using Python or other scripting languagesFamiliarity with CI / CD, DevOps, and infrastructure-as-code best practicesKnowledge of database design principles, structures and theoriesHands-on experience with Power BI and enterprise business intelligence environmentsStrong Understanding of data governance, privacy, and compliance standards (, GDPR, CCPA)Experience with data quality frameworks and observability tools (, Microsoft Purview, Azure Monitor)Strong analytical and problem-solving skillsProven ability to lead data projects and work independently in dynamic environmentsStrong written and verbal communication skills, including technical documentationFDH Aero is an Equal Opportunity Employer, and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability status, protected veteran status, or any other characteristic protected by law.