What are the responsibilities and job description for the Data Engineer Lead position at Bitwise?
Role - Data Engineer Lead
Location - Richmond, VA
Fulltime / Hybrid
Job Description Qualifications:
• 8-10 years of experience as a Lead Data Engineer with a strong focus on Databricks & Azure Data Factory.
• Strong experience leading the Data Engineering teams working on ADF & Databricks. Work with the teams providing technical approaches and solutions.
• Proven experience with data warehousing concepts and best practices.
• Strong SQL skills, ability to perform effective querying involving multiple tables and subqueries.
• Strong understanding of data modeling and data quality principles.
• Strong communication & collaboration skills, should be able to work closely with customer driving technical conversations.
• Experience with Agile development methodologies.
• Ability to work independently and as part of a team.
• Lead team and drive through technical challenges and solutions. Drive technical calls with customer
• Focus on continuous value additions and innovations
• Experience with any other ETL tool (Talend, Informatica or similar)
• Good to have Insurance domain knowledge
• Good to have exposure to Gen AI concepts
Databricks
• Hands-on experience with Databricks features such as delta lake, clusters, notebooks, jobs, and workspaces.
• Design, develop, and deploy data pipelines using Databricks, including data ingestion, transformation, and loading (ETL) processes.
• Develop and maintain high-quality, scalable, and maintainable Databricks notebooks using Python.
• Work with Delta Lake and other advanced features.
• Leverage Unity Catalog for data governance, access control, and data discovery.
• Experience working with Parquet files & Delta files for data storage and processing.
• Integrate with various data sources, including but not limited to databases and cloud storage (Azure Blob Storage, ADLS, Synapse), and APIs.
• Perform data quality checks and validation to ensure data accuracy and integrity.
ADF
• Strong working Knowledge and experience in Microsoft Azure, Azure Data Factory, Synapse Analytics, Azure SQL, Data Pipelining, Data Transformation, ETL, copy activity, custom Azure development.
• Develop and optimize data pipelines for performance and cost-effectiveness.
• Sound skills and hands on experience with Azure Data Lake, SQL Data Warehouse Azure Blob, Azure Storage Explorer • Sound knowledge on Azure DevOps, CICD Processes, Release Processes
• Sound Knowledge of Azure Data Catalog, Event Grid, Service Bus, SQL and Synapse
• Troubleshoot and resolve data pipeline issues effectively.