Lead Data Warehouse Developer/Engineer - Washington, United States - Collaborate Solutions

Description

We are looking for a Lead Data Warehouse Engineer to join our team who can help our clients in their digital journey.

• Designing and developing architecture of our data warehouse, ensuring scalability, efficiency, and reliability.
• Designing, building, and maintaining ETL processes and integration pipelines to efficiently extract, transform, and load data from various sources into unified warehouse.
• Collaborate with cross-functional teams, including data scientists, analysts, and software engineers, and stakeholders to gather requirements and understand data needs.
• Optimize data models, schemas, and SQL queries to enhance the performance and speed of data retrieval and processing.
• Implement data quality checks, validation rules, and monitoring mechanisms to ensure the accuracy, consistency, and integrity of data stored in unified warehouse.
• Develop and maintain documentation, including data dictionaries, system diagrams, and technical specifications, to facilitate knowledge sharing and maintain data governance standards.
• Participate in code reviews, testing, and deployment activities to ensure high-quality and reliable data engineering solutions.

• Proven experience designing and implementing data warehouses including data modeling, schema design, and performance optimization. Strong Proficiency in relevant languages (SQL, SSIS, Data Factory and Databricks) for data manipulation and automation tasks.
• Solid understanding of ETL/ELT concepts and experience with ETL tools and frameworks using SSIS.
• Experience in implementing cloud-based infrastructure as code including version control and CI/CD with best practices.
• Strong analytical and problem-solving skills, with an attention to detail and a drive for delivering high-quality solutions with the most important features first
• Excellent communication and collaboration skills to work effectively with cross-functional teams and stakeholders.
• Understanding of business intelligence job roles and objectives, including tooling like PowerBI.
• Bachelor's degree and 5 years of experience required.

• SQL
• SSIS
• Data Factory
• Databricks
• JIRA.

• Insurance domain knowledge.
• Azure Cloud and DevOps Experience.