Sr. SQL Data Analyst (SQL Server Preferred!)

MMD Services

Gurnee (IL)

On-site

USD 100,000 - 115,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Sr. BI Developer - Finance & Accounting
Sr. BI Developer - Finance & Accounting

LJA, Inc. / LJA Services, Inc. • Houston (TX)

On-site
USD 120,000 - 150,000
Sr. Software Engineer - Analytics Engineering
Sr. Software Engineer - Analytics Engineering

SHI International • Somerset (NJ)

On-site
USD 125,000 - 140,000
Health, wellness, and financial ben­ef
Office or remote work options
Sr Data Specialist
Sr Data Specialist

ADP, Inc. • Niles (IL)

On-site
USD 44,000 - 52,000
Sr Data Specialist
Sr Data Specialist

SERENITY HOME HEALTH CARE • Niles (IL)

On-site
USD 44,000 - 52,000
Sr. Software Engineer - Analytics Engineering
Sr. Software Engineer - Analytics Engineering

SHI International • Austin (TX)

Hybrid
USD 125,000 - 140,000
Senior Data Analyst - Finance
Senior Data Analyst - Finance

HQ Business Support-GROUP • Minneapolis (MN)

On-site
USD 96,000 - 145,000
Medical and prescription drug plans
Dental plan
401k retirement plan with companymatch
+6
BI Data Analyst (Hybrid)
BI Data Analyst (Hybrid)

Rapid Finance • Bethesda (MD)

Hybrid
USD 75,000 - 95,000
Senior Business Intelligence Analyst
Senior Business Intelligence Analyst

ServiceLink • Plano (TX)

Hybrid
USD 95,000 - 125,000
Flexible hybrid work
Senior Business Intelligence Developer – Power BI, Data Modeling & Analytics Architecture 3654429
Senior Business Intelligence Developer – Power BI, Data Modeling & Analytics Architecture 3654429

Axiom Path • Charlotte (NC)

On-site
USD 110,000 - 170,000
Senior BI Data Engineer: Cloud Data & Power BI Lead
Senior BI Data Engineer: Cloud Data & Power BI Lead

Compunnel Inc. • New York (NY)

Hybrid
USD 120,000 - 150,000