Sr. Data Engineer

The Senior Data Engineer with expertise in Azure Synapse Analytics and Microsoft Fabric will design, develop, and implement scalable data solutions to support analytics and reporting needs. The role involves creating, optimizing, and managing data pipelines to efficiently move and transform data across the Azure ecosystem. The candidate will be responsible for setting up and managing data lakes to store large volumes of structured and unstructured data, ensuring high availability and security. They will collaborate with crossfunctional teams to gather data requirements and create efficient, scalable architectures. Strong experience in ETL development, data modeling, and cloud technologies like Azure Data Factory, Azure Data Lake, and Synapse Analytics is essential. The candidate will also ensure data quality, security, and compliance with governance standards. 1. Create and optimize complex data pipelines using Azure Data Factory, Synapse Analytics, and other Azure tools to extract, transform, and load data efficiently. 2. Implement and maintain Azure Data Lake solutions to store large volumes of structured and unstructured data, ensuring scalability, performance, and security. 3. Integrate data from various sources, including relational databases, NoSQL databases, APIs, and flat files, into the Azure environment for analysis and reporting. 4. Design and develop robust data architectures, optimizing for performance and scalability in Azure Synapse Analytics and Azure Data Lake environments. 5. Develop efficient ETL/ELT processes using Azure Data Factory or other Azure tools to ensure timely and accurate data loading and transformation. 6. Ensure data pipelines run smoothly by monitoring, troubleshooting, and resolving issues to minimize downtime and data inconsistencies. 7. Continuously optimize data pipelines and query performance, especially within Azure Synapse to handle large data sets and complex transformations efficiently. 8. Work closely with data scientists, analysts, and business teams to understand data requirements and deliver scalable data solutions that support analytics needs. 9. Implement and enforce security best practices, ensuring data lakes, pipelines, and analytics solutions comply with Azure security standards and data governance policies. 10. Design and implement logical and physical data models that support highperformance querying and reporting within Azure Synapse. 11. Implement data quality checks, data validation processes, and error handling within data pipelines to ensure accuracy and consistency of data. 12. Ensure adherence to data governance frameworks, managing data lineage, metadata, and ensuring compliance with organizational and regulatory requirements. 13. Implement data partitioning and indexing strategies to improve query performance within data lakes and Synapse. 14. Automate data ingestion, transformation, and processing tasks to ensure efficient and scalable data workflows within the Azure environment. 15. Create and maintain detailed documentation for data architectures, pipelines, processes, and data models, ensuring transparency and ease of maintenance. 16. Provide technical guidance and mentorship to junior data engineers, sharing best practices and ensuring adherence to high-quality engineering standards. 17. Monitor resource utilization in Azure environments, planning for future data growth and ensuring efficient use of cloud resources. 18. Strong knowledge of Medallion architecture. 19. Experience in setting up parquet and delta file structures. 20. Experience in working with non-structured data sources. 21. Strong knowledge of consuming and exposing data from various data sources like XML, JSON etc. 22. Continuously stay informed on the latest features and best practices in Azure Synapse Analytics, Microsoft Fabric, and the Azure ecosystem, implementing improvements as needed. 23. Strong knowledge of python for creating and scheduling data pipelines. Job Types: Full-time, Contract Pay: $60.00 - $70.00 per hour Expected hours: 40 per week Schedule: 8 hour shift Monday to Friday Ability to Relocate: Laurel, MD 20707: Relocate before starting work (Required) Work Location: In person