Team Lead – Data Warehouse & Decision Support

Socket.dev; Dallas (TX); On-site; USD 140,000 - 210,000; Full time

Benefits offered by this job

Health insurance

Dental & Vision

Retirement match

Paid time off

Wellness program

Parking or transit support

Professional development

Job summary

ISN is seeking a Team Lead – Data Warehouse & Decision Support to guide technical direction and oversee the operation, reliability, and continuous improvement of the data warehouse, ETL, and data estate. This role combines leadership with hands-on data engineering using Microsoft Fabric, SQL Server, and Python.

You will lead a team 25% people leadership and 75% hands-on work, collaborating across architecture, governance, and security to ensure scalable, compliant pipelines and the adoption of

Qualifications

• 8+ years of data engineering and data warehousing experience.
• 3+ years of leadership or project leadership experience.
• Hands-on with Microsoft Fabric, SQL, ETL/ELT, and Python.
• Experience with Databricks and Fabric Lakehouse architectures.
• Proficient Python for data engineering and automation.

Responsibilities

• Lead day-to-day operation of the data warehouse, ETL environment, and semantic/reporting layers.
• Design and lead adoption of Microsoft Fabric, Databricks, and SQL Server for data workloads.
• Partner with architecture, operations, governance, security, and platform teams for compliance and cost control.
• Write and review complex SQL and pipeline code; review major data model changes.
• Evaluate applying AI/LLMs to data engineering workflows and guide team adoption.

Skills

Data engineering

Data warehousing

Leadership

SQL

Python

Databricks

Microsoft Fabric

Lakehouse

AI/LLMs in data eng

Tools

SQL Server

Job description

Our Company:

ISN was established in 2001 and is a global leader in contractor and supplier management. We work closely with a variety of household-name clients in the US, Canada, Europe, Australia, Latin America, and the Middle East to connect them with safe and reliable contractors and suppliers and incorporate a level of due diligence in the contractor management process.

The Position:

The Team Lead – Data Warehouse & Decision Support is responsible for guiding technical direction and overseeing the day-to-day operation, reliability, and continuous improvement of ISN’s data warehousing, ETL environment, and overall data estate. The position requires technical, analytical, and leadership skills with a strong background in data engineering, data modeling, and modern cloud and AI data platforms including Microsoft Fabric and SQL Server.

This position is approximately 25% people leadership and 75% hands-on technical work.

Who should apply?

• 8+ years of data engineering/data warehousing experience in a dynamic, data-rich, and fast-paced environment
• Strong hands-on experience with day-to-day data warehousing and ETL/ELT operations, including monitoring, troubleshooting, and performance tuning of production pipelines
• 3+ years of leadership/project leadership experience
• Strong hands-on expertise with: Microsoft Fabric, SQL, ETL and Python
• Hands-on experience with Databricks & Microsoft Fabric including Lakehouse architecture (Delta tables, OneLake, Apache Spark), Fabric Data Warehouse, and Fabric semantic models for downstream reporting
• Proficiency using Python (including PySpark and notebooks) for data engineering, transformation logic, and automation within Fabric and/or SQL Server

Responsibilities:

• Lead the day-to-day operation of the data warehouse, ETL environment, and semantic/reporting layers, ensuring pipelines run reliably, resilience, data is available on schedule, and incidents are resolved quickly
• Design and lead the team’s adoption and operational deployment of Microsoft Fabric, Databricks and SQL Server for data engineering, data pipeline modernization, and lakehouse/warehouse workloads
• Partner with data architecture, Technical Operations, data governance, security, and platform teams to ensure compliance, access controls, and cost management across cloud data environments.
• Write and review complex SQL and pipeline code; act as the final technical reviewer for major data model or pipeline changes
• Evaluate opportunities to apply AI and Large Language Models (LLMs) to data engineering workflows, such as pipeline development, code assistance, testing, and documentation, and guide the team through practical adoption

Onsite Requirements:

• Employees must be within a commutable distance to the Dallas, TX office. Relocation is required for candidates not already local to the DFW area.
• In-person attendance is required at minimum 2 days per week during the first 90 days of employment.
• After 90-day review, in-person attendance is required at minimum 1 day per month and required for certain meetings and tasks (collaboration with stakeholders and customers, team collaboration day, ISN events, team events, performance reviews, etc.).

ISN Benefits*

• 100% company-paid monthly insurance premiums for employees and dependents
• Medical, Dental, Vision, and Life Insurance
• Employee assistance program
• 4% retirement matching
• Long-Term & Short-Term Disability Coverage
• Paid time off
• 0-1 year – 15 day (pro-rated first year)
• 1-5 years – 20 days
• 5-10 years – 25 days
• 10+ years – 30 days
• Holidays – 13 paid holidays
• Monthly cell phone reimbursement
• Complimentary parking space or monthly reimbursement for DART public transportation
• Team-building activities and events, including quarterly kick-off meetings and community volunteer day
• Matching charitable gift program
• Professional development & training opportunities
• Wellness Program: Focuses on community, financial, mental, nutrition, physical and social health
• Business casual, jeans allowed

*All benefits are subject to change with notice to the employee

All job offers will be contingent on successful completion of a drug screen and background check.

ISN is an equal opportunity employer. All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran or disability status.