Data Analytics Team Lead

Team Lead | Data Analytics Exempt

The Team Lead – Data Analytics will oversee and guide a team of Data Analysts, including Data Analyst I, II, and Senior SQL Analysts. This leadership position is responsible for managing the team’s delivery of advanced SQL development, ETL design and maintenance, and data quality assurance to support business intelligence and strategic decision-making. The role combines technical expertise with team management, mentoring, and collaboration across departments to drive data-driven outcomes.

• Lead, mentor, and develop a team of data analysts, providing guidance on advanced SQL development, ETL processes, and best practices for data analysis.
• Coordinate and review complex SQL queries, stored procedures, and ETL workflows developed by team members to ensure quality and efficiency.
• Design and implement scalable ETL solutions in collaboration with data engineers and IT teams, maintaining high standards of data accuracy and system performance.
• Facilitate cross-functional communication with business analysts, data engineers, and stakeholders to align data requirements and analytics objectives.
• Oversee troubleshooting of ETL and SQL-related issues, ensuring rapid resolution to minimize impact on data availability and reporting.
• Establish and enforce team coding standards, documentation practices, and development methodologies.
• Promote continuous learning by encouraging adoption of emerging data technologies, SQL advancements, and cloud data services such as Microsoft Azure.
• Manage project priorities, resource allocation, and timelines within an Agile or Scrum framework to meet business goals effectively.
• Contribute to strategic planning for data infrastructure improvements and analytics capabilities.
• Perform other duties as assigned.

• Bachelor’s degree in computer science, Information Systems, Data Science, or related field, or equivalent experience.
• Minimum of 7 years of experience in SQL development, data analysis, and ETL process design and management.
• Proven leadership experience, mentoring and managing technical teams of data professionals.
• Expertise in writing and optimizing complex SQL queries, stored procedures, and database functions.
• Extensive experience with ETL tools such as SSIS, Informatica, or Talend and managing ETL workflows.
• Proficiency with relational database management systems (Microsoft SQL Server, Oracle, MySQL).
• Experience working with Microsoft Azure data services, including Azure SQL Database, Azure Data Factory, and Azure Data Lake.
• Strong analytical, problem-solving, communication, and interpersonal skills.

• Understanding of data warehousing principles and dimensional modeling.
• Exposure to cloud environments beyond Azure, such as AWS or Snowflake.
• Familiarity with scripting languages like Python or Power Shell.
• Experience with BI/reporting tools such as Power BI, Tableau, or Looker.
• Experience managing projects within Agile or Scrum methodologies.