Sr. SQL Data Analyst (SQL Server Preferred!)

MMD Services; Gurnee (IL); On-site; USD 100,000 - 115,000; Full time

Job summary

A rapidly growing company in Gurnee, Illinois, is looking for a Sr. SQL Admin to design, build, and maintain a unified data architecture while effectively utilizing Power BI for data reporting and analytics. This role requires a bachelor's degree in a relevant field and proficiency in SQL as well as demonstrated experience in data modeling, ETL pipelines, and collaboration with finance and business stakeholders for delivering insights. Join a culture that thrives on innovation and transformation.

Qualifications

• Bachelor’s degree in a relevant field is required.
• Proficiency in SQL and Power BI is essential.
• Experience with data modeling and ETL processes is a must.

Responsibilities

• Design and maintain a unified data architecture.
• Build ETL pipelines and optimize data sources.
• Develop and maintain Power BI datasets and reports.

Skills

SQL development

Power BI

Data modeling

ETL pipelines

Data analysis

Education

Bachelor’s degree in Data Science, Analytics, IT, or a related field

Master’s or MBA

Power BI certification

Microsoft Fabric certification

Job description

Base Pay Range

$100,000.00/yr - $115,000.00/yr

Our client is a fast‑growing leader recognized by both consumers and industry professionals. They foster a dynamic, collaborative culture where high performers thrive in a fast‑paced, hands‑on environment. Although the company has over 60 years of history, they are entering a powerful new chapter of expansion, innovation, and transformation. Their people are their greatest asset—driven, engaged, and motivated by purposeful work.

Our client is seeking a Sr. SQL Admin to design, build, and maintain a unified data architecture to support enterprise‑wide reporting and analytics. This role blends SQL development, and Power BI expertise to integrate multiple data sources into a single, trusted reporting layer. The ideal candidate will build ETL pipelines, optimize semantic models, and partner closely with finance and business stakeholders to deliver scalable, accurate, decision‑driving insights.

What You Will Do

Data & Reporting Support

• Help organize and improve data models used for reporting in Microsoft Fabric and Power BI.
• Assist with reviewing existing data and supporting data migration efforts.
• Create and update tables, metrics, and documentation used in reports.
• Support data refresh schedules and basic performance improvements.
• Help build and maintain data pipelines using SSIS and Microsoft Fabric Dataflows.
• Troubleshoot data issues with guidance from senior team members.
• Learn when data should be stored in the warehouse versus accessed through views.

SQL Development

• Write and update SQL queries to support reports and dashboards.
• Maintain SQL views used by Power BI and other reporting tools.
• Learn how to optimize queries and work with stored procedures.
• Work with finance, operations, and analytics teams to understand reporting needs.
• Help translate business questions into data and reporting solutions.
• Participate in team discussions about improving data and reporting processes.

Power BI & Semantic Models

• Build and maintain Power BI datasets and reports with support from senior analysts.
• Assist with Power BI deployments and basic version control processes.
• Learn DAX calculations and support paginated reports as skills grow.

Education & Qualifications

• Bachelor’s degree in Data Science, Analytics, IT, or a related field; finance or accounting knowledge is strongly preferred.
• Master’s or MBA is a plus.
• Power BI certification preferred.
• Microsoft Fabric certification preferred.
• Proven ability to collaborate with senior finance and business leaders.

MMD Services Inc. is an equal opportunity employer. All applicants are considered for all positions without regard to race, religion, color, sex, gender, sexual orientation, pregnancy, age, national origin, ancestry, physical/mental disability, medical condition, military/veteran status, genetic information, marital status, ethnicity, alienage or any other protected classification, in accordance with applicable federal, state, and local laws.