Data Warehouse & Data Integration at Finoit Inc

Technical Lead Data Warehouse & Data Integration Fulltime Chicago IL Hybrid (2 Days in a week) Salary $130-160K Base Overview Were looking for a strong Technical Lead who can guide our data engineering efforts while staying hands-on. This role is 60% leadership (managing a small onshore/offshore team) and 40% technical delivery. You will drive modernization across our data warehouse ETL pipelines and reporting platforms as we move from on-prem SQL/SSIS toward Azure Fabric and modern cloud data solutions. Key Responsibilities Data Engineering & Leadership Lead a distributed team focused on ETL development pipelines and DW loads. Build and maintain data workflows using SSIS SQL Azure Data Factory Fabric and Python/Databricks (nice to have). Support on-prem SQL Server/SSRS and cloud platforms like Redshift and Microsoft Fabric. Stay hands-on-coding debugging reviewing and contributing directly. Delivery Ownership Manage sprints backlog and progress using Scrum and JIRA. Own end-to-end delivery from requirements through deployment. Identify risks remove blockers and ensure quality and timelines. Data Quality & Architecture Define and enforce clean architecture and data standards. Lead efforts around data validation cleansing and transformation. Introduce frameworks or tooling to improve data quality and observability. Collaboration Work closely with Product Owners Architects Analysts and Business Leaders. Communicate roadmaps delivery plans and updates to stakeholders. Partner with BI and DBA teams to align reporting modeling and infrastructure. Modernization Drive the transition to modern cloud-first DW/ETL solutions. Support evaluation and implementation of tools such as Fabric Synapse Redshift Terraform. Explore automation/AI tooling to improve pipeline reliability and speed. Required Qualifications Bachelors degree in CS IS or equivalent work experience. 7 10 years in data warehousing; 3 years in technical leadership. Strong SQL ETL and data warehousing experience (SSIS ADF or similar). Experience with cloud data platforms (Azure AWS GCP) and Redshift or SQL Server. Hands-on experience with Python (plus) Power BI/SSRS and Agile/Scrum. Strong communication ownership and ability to lead delivery. Preferred Skills Experience with Fabric BigQuery Databricks or other modern data platforms. Familiarity with DevOps/CI-CD for data pipelines. Knowledge of data governance security and DataOps practices. Experience with retail or e-commerce analytics. Key Skills Apache Hive,S3,Hadoop,Redshift,Spark,AWS,Apache Pig,NoSQL,Big Data,Data Warehouse,Kafka,Scala Employment Type : Full Time Experience: years Vacancy: 1