Data Analytics Supervisor (SQL & Power BI) - Remote

Job Details: Job Location: Allied Benefit Systems - CHICAGO, IL, Position Type: Full Time, Salary Range: $60000.00 - $65000.00Salary, 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.

The company has reviewed this job description to ensure that essential functions and basic duties have been included. It is not intended to be construed as an exhaustive list of all functions, responsibilities, skills, and abilities. Additional functions and requirements may be assigned by supervisors as deemed appropriate.

Compensation is not limited to base salary.  Allied values our Total Rewards, and offers a competitive Benefit Package including, but not limited to, Medical, Dental, Vision, Life and Disability Insurance, Generous Paid Time Off, Tuition Reimbursement, EAP, and a 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.Qualifications: