Lead Data warehouse Engineer
📋 Role Overview & Responsibilities
Note: *Data warehouse Engineer are needed, DO NOT SEND DATA ENGINEER PROFILES*Minimum years of experience: 11+
Title: Lead Data warehouse EngineerLocation: Columbia, TN Hybrid ( 3days onsite)Contract: Long term ( W2)
We are looking for a Lead Data warehouse Engineer to join our team who can help our clients in their digital journey.
Roles and Responsibilities:• 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.Qualifications:• 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[1]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.
Tools and technologies skills needed:• SQL• SSIS• Data Factory• Databricks• JIRA.
Nice to have:• Insurance domain knowledge.• Azure Cloud and DevOps Experience.
Frequently Asked Questions
How do I apply for the Lead Data warehouse Engineer position at Collaborate Solutions, Inc? ▼
Click the “Apply for this Position” button on this page to submit your application directly to Collaborate Solutions, Inc without recruitment intermediary fees.
Is this position eligible for remote work or visa sponsorship? ▼
This position is located in Columbia, TN with potential relocation and sponsorship assistance depending on candidate qualifications.
Are there any candidate fees on Hirely? ▼
No. Hirely is completely free for candidates. We never charge registration fees or placement fees.
Legitimate employers will never ask you to transfer funds, purchase equipment from unauthorized vendors, or pay application/visa fees. Hirely rigorously monitors listings, but always verify communication is from official corporate email domains.
Learn how to protect yourself against employment fraud →