ETL Datawarehouse Architect/Lead

Title: ETL Datawarehouse Architect/Lead Location: Hartford, CT (Onsite)
Duration: Long Term Contract

Key Responsibilities ::

• Data Warehouse Management: Maintain and optimize the SQL Server data warehouse, ensuring performance, reliability, and data integrity.
• Process Optimization: Identify and implement enhancements to ETL processes, data pipelines, and operational workflows.
• Technical Leadership: Serve as the technical lead for data engineering initiatives, collaborating with Product Owners, Managers, and agile teams to deliver on sprint and program objectives.
• Project Delivery: Oversee all aspects of data engineering activities, including design, development, testing, documentation, deployment, and production support.
• Stakeholder Collaboration: Work closely with business and technology teams to understand requirements and deliver effective data solutions.
• Standards & Compliance: Ensure adherence to data governance, security policies, and best practices across all data engineering activities.
• Continuous Improvement: Stay up to date with technology changes, particularly in cloud platforms and data privacy.

Professional Experience / Qualifications:

Experience: 15+ years of IT experience with a focus on hands-on development and data architecture.
Technical Skills: Proficient in data modelling, pipeline creation, and merging datasets.
Client-Facing: Experienced in leading client engagements and translating technical concepts to non-technical stakeholders.
Data Warehousing: 10+ years of real-world data warehousing project experience, with a deep understanding of architectural principles and design patterns.
Snowflake & Spark: Strong hands-on experience with Snowflake for data warehousing and Spark for data processing.
ETL/ELT Workflow Design: Proven experience in designing efficient and robust ETL/ELT workflows and job scheduling.
Performance Tuning: Expertise in performance tuning of SQL queries and Spark jobs.
Tool Proficiency: Experience with Git, Jira, and Agile methodologies.
Communication Skills: Strong written and verbal communication skills, with the ability to convey complex technical concepts to non-technical stakeholders.
Analytical Skills: Excellent analytical and problem-solving abilities, with a self-driven attitude and the capability to work both independently and as part of a team.
Soft Skills: Strong attention to detail, collaborative mindset, and curiosity.