Data Analytics Supervisor (SQL & Power BI) - Remote

Allied Benefit Systems, LLC; Chicago, Northern (IL, KY); Hybrid; USD 60,000 - 65,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

Life & Disability Insurance

Generous PTO

Tuition Reimbursement

EAP

Technology stipend

Job summary

Allied Benefit Systems is seeking a Supervisor of Data Analytics and Reporting in Chicago to lead a team delivering high-quality data analysis, reporting, and data infrastructure support. You will modernize the reporting stack, define standards, mentor analysts, and collaborate with stakeholders to translate business questions into actionable insights.

The role offers a remote-friendly environment with a focus on governance, continuous improvement, and comprehensive benefits.

Qualifications

• Bachelor’s degree in IT, CS, or related field.
• Minimum 5 years in data analytics with leadership potential.
• Experience with data warehouses, SQL, and BI tools (Power BI/Tableau/Looker).
• Strong data modeling and ETL/ELT knowledge.
• Excellent communication with technical and non-technical stakeholders.

Responsibilities

• Review and approve reports, dashboards, and data outputs.
• Lead QA and validation for data accuracy.
• Manage analytics projects including data modeling and KPI development.
• Translate business questions into data-driven solutions.
• Mentor analysts and drive reporting standards and governance.
• Modernize the reporting stack and enable self-service.

Skills

Analytics leadership

SQL

Power BI

Tableau

Looker

Data modeling

ETL/ELT

Stakeholder communication

Mentoring

Education

Bachelor’s degree in IT/CS

Tools

Data warehouses

SQL

Power BI

Tableau

Looker

ETL tools

Job description

Job Details

Job Location: Allied Benefit Systems - CHICAGO, IL 60606

Position Type: Full Time

Salary Range: $60,000.00 - $65,000.00 Salary

Job Category: Medical Management

Position Summary

The Supervisor of Data Analytics and Reporting will oversee a team responsible for delivering high-quality data analysis, reporting, and data infrastructure support. In addition to managing the team’s day-to-day work, the Supervisor will own efforts to modernize the reporting stack, optimize processes, and help position the team for scalable, data-driven decision making.

Essential Functions

• Serve as the final reviewer and approver for all reports, dashboards, and data outputs before release.
• Perform detailed quality assurance and validation checks, ensuring accuracy, completeness, and alignment with business objectives.
• Take the lead on complex, high-impact analytics projects, including data modeling, exploratory analysis, and KPI development.
• Work with stakeholders to translate ambiguous business questions into clear, data-driven solutions.
• Help define and maintain standards for reporting accuracy, naming conventions, and documentation across the team.
• Recommend improvements in data processes, query efficiency, and dashboard usability.
• Provide guidance, technical mentorship, and informal training to analysts and the reporting coordinator.
• Share expertise in tools, SQL techniques, and best practices to elevate the team’s technical capability.
• Directly manage a team of analysts and reporting coordinators, including goal setting, coaching, and performance management.
• Serve as an escalation point and quality control checkpoint for complex data requests or reporting issues.
• Lead the effort to modernize the reporting stack, including evaluating tools, automating legacy reports, and introducing self-service capabilities where appropriate.
• Develop and maintain team operating procedures and documentation to improve transparency and continuity.
• Support a culture of data governance, accuracy, and continuous improvement.
• Lead, coach, motivate and develop. Responsible for one-on-one meetings, performance appraisals, growth opportunities and attracting new talent.
• Clearly communicate expectations, provide employees with the training, resources, and information needed to succeed.
• Actively engage, coach, counsel and provide timely, and constructive performance feedback.
• Other duties as assigned.

Education

Bachelor’s degree in information technology, Computer Science, or a related field or equivalent work experience required.

Experience and Skills

• At least 5 years of experience in data analytics with demonstrated leadership potential required.
• 1–2 years in a leadership or supervisory role preferred
• Proven experience working with data warehouses, SQL, and reporting tools (e.g., Power BI, Tableau, Looker, or similar).
• Strong understanding of data modeling, data transformation (ETL/ELT), and relational databases.
• Comfortable managing competing priorities and guiding others in a fast-paced environment.
• Demonstrated success managing or mentoring analytical teams with varied experience levels.
• Excellent interpersonal and communication skills; able to interface with both technical teams and non-technical business stakeholders.
• Background within a complex organization or regulated environment is a plus.

Position Competencies

• Accountability
• Coaching and Feedback
• Collaboration
• Customer Focus
• Decision Making
• Execution Management
• People Leadership

Physical Demands

This is a standard desk role requiring extended periods of sitting and working on a computer

Work Environment

Remote

Here at Allied, we believe that great talent can thrive from anywhere. Our remote friendly culture offers flexibility and the comfort of working from home, while also ensuring you are set up for success. To support a smooth and efficient remote work experience, the internet connection must be obtained through a cable broadband or fiber optic internet service provider with speeds of at least 100Mbps download/25Mbps upload. Reliable internet service is essential for staying connected and productive.

Compensation is not limited to base salary.

• Medical
• Dental
• Vision
• Life and Disability Insurance
• Generous Paid Time Off
• Tuition Reimbursement
• EAP
• Technology Stipend

Allied reserves the right to amend, change, alter, and revise, pay ranges and benefits offerings at any time. All applicants acknowledge that by applying to the position you understand that the specific pay range is contingent upon meeting the qualification and requirements of the role, and for the successful completion of the interview selection and process. It is at the Company's discretion to determine what pay is provided to a candidate within the range associated with the role.