Top 16 Sql server/ssas Jobs in Rolling Meadows, Il

Senior Data Engineer
PremiStar —Deerfield, IL
- Hybrid work
- Computer Science
- Mid-level
- Office
Quick Apply
BI Developer - Temp to hire
Gallagher —Rolling Meadows, IL
- $137,500 - $268,000 a year
- Full-time
- Remote
- 5 years
- Bachelor of Science
- Mid-level
- Paid parental leave
- Health savings account
.NET Developer (FT and/or Contract to Hire)
Discharge 1-2-3 —Schaumburg, IL
- Full-time
- Computer Science
- Mid-level
- 3 years
- Profit sharing
- Paid holidays
Programmer Analyst1
Vistal Tech —Buffalo Grove, IL
- From $118,000 a year
- Full-time
- Azure
- 5 years
- Salesforce
Programmer Analyst
Vistal Tech —Buffalo Grove, IL
- $118,000 a year
- Full-time
- Azure
- Bachelor of Science
- Salesforce
Data Analyst
Lawndale Christian Health Center —Chicago, IL
- $53,000 - $60,000 a year
- Full-time
- Mid-level
- SQL
- SharePoint
- Paid holidays
- Health insurance
Azure Data Architect
Anblicks —Addison, IL
- Full-time
- Analysis skills
- 1 year
- Senior level
Business Analytics Analyst
Roadrunner Transportation Services, Inc. —Downers Grove, IL
- $70,000 - $110,000 a year
- Full-time
- Hybrid work
- Computer science
- Azure
- Computer Science
- Paid holidays
- Health insurance
Quick Apply
4d
Senior Data Warehouse Developer
Mavens Guild —Chicago, IL
- Full-time
- Computer science
- Computer Science
- Bachelor of Science
Quick Apply
Software Development Technical Architect
BDO —Oak Brook, IL
- $135,000 - $165,000 a year
- Full-time
- Computer science
- Azure
- Computer Science
- Employee stock ownership plan
- Opportunities for advancement
Lead BI Engineer
Follett Higher Ed Group, LLC —Westchester, IL
- $40,000 - $141,700 a year
- 7 years
- SQL
- Analysis skills
- Paid holidays
- Health insurance
Data Warehouse Lead / SQL Server Specialist
Mavens Guild —Chicago, IL
- Full-time
- Computer science
- Computer Science
- Bachelor of Science
Quick Apply
Senior Full Stack Developer (.NET/C#/Angular)
BDO —Oak Brook, IL
- $75,000 - $150,000 a year
- Full-time
- Computer science
- Azure
- Computer Science
- Employee stock ownership plan
- Opportunities for advancement
Software Solution Architect
BDO —Oak Brook, IL
- $150,000 - $180,000 a year
- Full-time
- Azure
- Computer Science
- Java
- Employee stock ownership plan
- Opportunities for advancement
SENIOR DIRECTOR OF ADVANCEMENT INFORMATION SERVICES & REPORTING
Loyola University Chicago —Chicago, IL
- $140,000 - $155,000 a year
- Full-time
- Microsoft Access
- 5 years
- Computer literacy

More jobs to discover

Find similar jobs that you might be interested in.

BI Developer - Temp to hire
Gallagher —Rolling Meadows, IL
Experience performing root cause analysis on data and processes to answer specific business questions, and identify opportunities for improvement.
$137,500 - $268,000 a year

Explore jobs in cities nearby

Check out jobs in cities near your current location, Columbus

Analyst - Business Data Services 5B
Genpact US Services, LLC. —Alexandria, OH
Learns analytics tools and delivery processes. Assists in report preparation and formatting. Collaborates with team for task execution.
$45,000 - $56,500 a year
Quick Apply
5d

I want to receive the latest job alert for sql server/ssas in rolling meadows, il

By signing in to your account, you agree to SimplyHired's Terms of Service and consent to our Cookie and Privacy Policy.

Senior Data Engineer

PremiStar -
Deerfield, IL

Quick Apply

Job Details

Qualifications

Data integrity assurance
Data model design
Commercial use (data warehousing systems)
Performance tuning
Performance dashboards
Cloud analytics services
Data visualization software proficiency
Cloud data warehouses
Data validation techniques
System performance optimization
Business intelligence report generation
Schema design
Stored procedures
ETL process automation
Business intelligence tools
Data integrity process (data warehousing)
Data analytics tools
System tuning
Data performance optimization

Full Job Description

The Sr. Data Engineer at PremiStar is responsible for building and optimizing the company’s data infrastructure in support of Project Mosaic and the Enterprise Data Unification initiatives. Project Mosaic is PremiStar’s enterprise-wide ERP transformation built on Microsoft Dynamics 365 – aimed at unifying systems, standardizing processes, and improving real-time data visibility across all business units.

In this role, The Sr. Data Engineer will develop and maintain robust data pipelines and unified data repositories (data lake and data warehouse) that consolidate information from Dynamics 365 and various legacy systems into a single source of truth.

RESPONSIBILITIES

Design, build, and maintain ETL/ELT processes that ingest and transform data from multiple sources (including D365 (Mosaic ERP) and legacy systems) into PremiStar’s Azure Synapse data lake and data warehouse.
Implement data cleansing, validation rules, and quality checks so that disparate data (from various business units and systems) is accurate, consistent, and ready for unified analysis.
Contribute to the design and expansion of enterprise data models and schema (e.g. star schema in the enterprise data warehouse) to support new reporting needs and Mosaic’s unified process definitions.
Work closely with the Analytics and BI consulting partners to enable self-service reporting and advanced analytics.
Prepare curated data sets for Power BI dashboards by writing efficient SQL queries or creating new pipeline components as needed.
Collaborate with cross-functional teams – including business analysts, data scientists, and ERP specialists – to understand data requirements arising from Project Mosaic deployments and other business initiatives.
Follow and promote software development best practices in analytics projects (version control, code review, documentation, etc.) and optimize existing data processes.

EDUCATION

Undergraduate degree or equivalent in Computer Science, Information Systems, or a related field required.

EXPERIENCE

3–5 years of hands-on experience in the design, development, and support of data pipelines (ETL/ELT processes)
3–5 years of experience writing and optimizing SQL (T-SQL) queries and working with Microsoft SQL Server or similar relational databases
1–3 years of experience in data modeling and database design
Prior experience in private equity backed industrial or multi-business-unit companies is a plus

SKILL REQUIREMENTS

Strong SQL programming skills, particularly with Microsoft SQL Server, including the ability to write efficient T-SQL queries, create stored procedures, and perform performance tuning on database operations.
Hands-on experience with Azure Synapse Analytics or similar cloud data warehousing technologies, including using Synapse (or Azure Data Factory) to create and orchestrate data pipelines, transform data at scale, and manage data lakes/warehouses.
Familiarity with Microsoft D365 (Dynamics 365 Finance & Operations, and/or Customer Engagement) – or similar ERP/CRM systems.
Proficient in Microsoft Power BI or comparable BI visualization tools, including an understanding how Power BI datasets and dataflows work.
Knowledge of DAX and Power BI performance tuning is a plus, as is experience with SSRS or other Microsoft BI stack components (e.g. SSIS/SSAS).
Strong understanding of data modeling concepts and tools.
Experience with master data management or data cataloging in a unified data environment.
Familiarity with data quality and profiling tools (i.e. using SQL or Python to implement data validation).
Comfort with a programming or scripting language (e.g., Python, PySpark, or SQL scripts) to transform and manipulate data within pipelines.

PHYSICAL DEMANDS

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job.

WORK ENVIRONMENT:

This job operates in both an office and a field environment. Must be able to sit and/or stand for extended periods of time.

REASONABLE ACCOMODATION:

Reasonable accommodation will be made to enable individuals with disabilities to perform the essential job functions unless doing so presents an undue hardship on the Company’s business operations.

OTHER DUTIES:

Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice. Employees understand the above job description and agree to comply with and be subject to its conditions. Employee further agrees this job description does not alter his/her at-will employment status. Employees understand the Company reserves the right to delegate, remove, expand or change all responsibilities. Employees acknowledge that he/she can fulfill the above duties with or without reasonable accommodation.

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights (https://www.eeoc.gov/poster) notice from the Department of Labor.

Quick Apply

Refine Your Search

sql server/ssas jobs in rolling meadows, il

Senior Data Engineer

BI Developer - Temp to hire

.NET Developer (FT and/or Contract to Hire)

Programmer Analyst1

Programmer Analyst

Data Analyst

Azure Data Architect

Business Analytics Analyst

Senior Data Warehouse Developer

Software Development Technical Architect

Lead BI Engineer

Data Warehouse Lead / SQL Server Specialist

Senior Full Stack Developer (.NET/C#/Angular)

Software Solution Architect

SENIOR DIRECTOR OF ADVANCEMENT INFORMATION SERVICES & REPORTING

More jobs to discover

Explore jobs in cities nearby

I want to receive the latest job alert for sql server/ssas in rolling meadows, il

Explore jobs in more locations

Job Seeker Tools

Employer Tools

Browse

Stay Connected