Lead Data Engineer

Your Role:

We are seeking a highly experienced Lead Data Engineer with a strong background in working with cross-functional teams, particularly Data Science, with expertise in Azure Modern Data Platform and knowledge in GCP. The ideal candidate will take ownership of solutioning and mentoring the team, ensuring a smooth transition from Jupyter notebooks to Azure Databricks. Expertise in writing ETL frameworks with PySpark and Python coding skills for Data Migration and Transformation (On-Premises or Cloud) is essential. This role requires a deep understanding of both traditional and NoSQL databases, distributed data processing, and data transformation techniques.

• Data Ingestion: Manage the ingestion of varied and unstructured data from REST APIs, as well as structured data from transactional databases. Experience in the design and development of Medallion architecture with Databricks and Unity Catalog governance principles is required.
• Data Analysis and Transformation: Demonstrate excellent data analysis skills with strong SQL knowledge, along with robust reporting and data transformation capabilities, especially using PySpark throughout the development.
• Validation and Verification: Perform thorough validation and verification using automation techniques by writing efficient unit test cases to ensure data quality.
• Project and Stage Planning: Develop specific, targeted, and well-detailed project and stage plans.
• Tool Proficiency: Utilize tools such as Jira, ADO, and Confluence effectively.
• Coordination and Communication: Exhibit strong coordination and communication skills, reporting back on progress and alignment with the implementation strategy for data pipelines and production deployments.
• Defect Management: Ensure transparency in defect management and work towards resolving them promptly, irrespective of the defect owner.
• Mentorship: Mentor and guide the team, ensuring they can hit the ground running and effectively collaborate with the Data Science and DevOps teams.

Your Profile:

• Proven experience with Azure Data Factory and Azure Databricks with Unity Catalog.
• Strong proficiency in PySpark and Python for data processing.
• Strong SQL knowledge.
• Good understanding of GCP cloud services such as GCP BigQuery and others.
• Good understanding of Airflow scheduling.
• Knowledge of Terraform for infrastructure management.
• Experience with CI/CD tools and practices.
• Understanding of data security, access controls, and compliance.
• Excellent problem-solving skills and attention to detail.
• Strong communication and collaboration skills, with leadership qualities to mentor and lead the team in providing data solutions.
• Ability to work independently and as part of a team.
• Experience with other cloud platforms and data engineering tools.
• Proven experience with data warehousing concepts and best practices.
• Certification in relevant technologies (e.g., Azure, GCP).