Client Reporting Team Lead

Jobtailor; Illinois; On-site; USD 80,000 - 120,000; Full time

Job summary

Jobtailor in Illinois, United States, seeks a seasoned BI/Reporting Analyst to lead the lifecycle of reporting—from data acquisition to delivery—and to build automated BI solutions that support data-driven decisions.

The role requires SQL, SSMS/Oracle/Hadoop/Teradata experience, strong MS365 skills, and the ability to work with clients to understand needs and drive project outcomes while maintaining accuracy and timelines.

Qualifications

• 5+ years’ experience using database software and analytical tools to access large databases, including SQL
• Advanced proficiency in MS365 applications (Excel, PowerPoint, CoPilot)
• Strong analytical skills, investigative mindset, and ability to use data to enhance efficiency and develop reporting
• Strong analytical, risk management, organizational, and attention-to-detail skills
• Ability to think strategically across businesses to identify performance-efficiency opportunities
• Proactive and organized with strong time management and follow-through
• Excellent written and verbal communication skills
• Experience with SSMS, Oracle, Hadoop, and Teradata
• Prior experience managing multiple projects and adjusting to changing deadlines
• Experience with Python and statistical methods in understanding relationships in data (desired)

Responsibilities

• Lead reporting activities across the lifecycle from data acquisition through report development and delivery
• Engage clients to understand needs and contribute specialized reporting knowledge
• Lead small reporting projects or components of large projects
• Leverage tools and processes to build end-to-end reports
• Support delivery and maintenance of automated business intelligence solutions for data-driven decisions
• Contribute to complex technical projects and drive outcomes within initiative components
• Support design, development, and maintenance of automated ETL processes from various database platforms
• Store data in "Fit for Use" relational tables
• Provide technical solutions and learn new technology to fulfill project needs
• Keep current on the latest industry solutions
• Contribute to integration and adoption of business intelligence solutions

Skills

SQL

MS365

Data analysis

Project management

Python

Education

High School Diploma or equivalent

Tools

SSMS

Oracle

Hadoop

Teradata

Python

Job description

• Lead reporting activities across the lifecycle from data acquisition through report development and delivery
• Engage clients to understand needs and contribute specialized reporting knowledge
• Lead small reporting projects or components of large projects
• Leverage tools and processes to build end-to-end reports
• Support delivery and maintenance of automated business intelligence solutions for data-driven decisions
• Contribute to complex technical projects and drive outcomes within initiative components
• Support design, development, and maintenance of automated ETL processes from various database platforms
• Store data in "Fit for Use" relational tables
• Provide technical solutions and learn new technology to fulfill project needs
• Keep current on the latest industry solutions
• Contribute to integration and adoption of business intelligence solutions

Requirements

• Minimum Education Requirement: High School Diploma / GED / Secondary School or equivalent
• 5+ years’ experience using database software and analytical tools to access large databases, including SQL and/or coding experience
• Advanced proficiency in MS365 applications (Excel, PowerPoint, CoPilot)
• Strong analytical skills, investigative mindset, and ability to use data to enhance efficiency and develop reporting
• Strong analytical, risk management, organizational, and attention-to-detail skills
• Ability to think strategically across businesses to identify performance-efficiency opportunities
• Strong partnership and relationship-building skills
• Proactive and organized with strong time management and follow-through
• Excellent written and verbal communication skills
• Experience with SSMS, Oracle, Hadoop, and Teradata
• Prior experience managing multiple projects and adjusting to changing deadlines
• Experience with Python and statistical methods in understanding relationships in data (desired)

Core Competencies

Demonstrates expertise in leading reporting activities, utilizing SQL and analytical tools for data management, and developing automated business intelligence solutions. Strong ability to engage clients, manage projects, and leverage advanced MS365 applications for effective reporting.

Highest-signal resume keywords

• SQL Database Management
• Automated ETL Processes
• Business Intelligence Solutions
• Advanced MS365 Proficiency
• Project Management