Data Warehouse Lead / SQL Server SpecialistMavens Guild • Chicago, IL, United States
[error_messages.no_longer_accepting]
Data Warehouse Lead / SQL Server Specialist
Mavens Guild • Chicago, IL, United States
[job_card.1_day_ago]
[job_preview.job_type]
- [job_card.full_time]
[job_card.job_description]Develop and lead development efforts of data integration (ETL) processes and BI reports Develop and lead development efforts of SQL queries for ad hoc data analysis, data integration processes, audit purposes and performance tuning of production SQL Develop and lead development efforts of database objects (tables, views, stored procedures, indexes, etc.,) Implement and administer (Level 1) SQL Server databases across various development and production environments Implement and administer standards for development and deployment of database objects Lead implementation efforts of database structures to support enterprise data warehousing activities Lead implementation efforts of high-availability and disaster recovery environments Assist data integration teams with data modeling tasks and maintain an inventory of data definitions Assist and advise in performance tuning of SQL queries Assist and advise in organization and standardization of existing database structures Assist and advise in data migration and test data creation Assist and advise in process automation and scheduling Assist in data integration activities and collaborate with cross functional teams 8+ years experience of working as a data warehouse developer Solid experience with data integration and reporting tools like SSIS, SSRS and procedural coding. Experience with creation of database structures and effective management of all database objects Experience with implementing database resource governance Experience with database standards and end user applications Experience with data backup, recovery, security, integrity and SQL Substantial experience with standing up development and testing database environments Good knowledge of database design, documentation and coding Good knowledge of data warehouse methodologies and best practices Strong problem solving skills, with an analytical mindset BS degree in Computer Science or relevant experience in lieu of a college degree for exceptional candidates Knowledge of working within Agile framework is desired Knowledge of other relational database systems like Oracle or MySQL is desired Complimentary skill sets like background in C++, Java, scripting languages, etc., will be a huge bonus
Data Warehouse Lead / SQL Server Specialist
This position demands a critical understanding of data warehousing concepts, advanced ETL and BI report development skills, and an in-depth knowledge of SQL Server database.
Primary responsibilities of this senior role include leading development efforts of ETL processes and BI reports using Microsoft BI stack (SSIS, SSRS, SSAS) and Tableau, designing relational database structures, prescribing and implementing database development standards, and some SQL server database administration. Ideal team member should be a self-starter, work with minimal supervision and seek-out opportunities to augment existing processes.
- All candidates will undergo stringent technical interview
A Typical Day As A Data Warehouse Lead / SQL Server Specialist :
What You Will Need To Bring To The Table :
[job_alerts.create_a_job]
Data Warehouse Lead SQL Server Specialist • Chicago, IL, United States
[internal_linking.similar_jobs]
Health Solutions Assistant Vice President – Data Warehouse Analytics.Join to apply for the Health Solutions Assistant Vice President – Data Warehouse Analytics role at Aon.As part of an industry‑le...[show_more]
A leading pediatric healthcare provider in Chicago seeks a Data Architect I to design and manage ETL jobs and custom data applications.
This Role involves integrating data from various repositories ...[show_more]
About Baird & Warner Real Estate.Over the last decade, Baird & Warner was named a Chicago Tribune Top Workplace ten times in a row.
But we didn’t get there by accident — behind every great c...[show_more]
A leading data solutions provider is seeking a Principal Enterprise Solutions Architect in Chicago, Illinois.The role involves driving the architecture of digital platforms that support comprehensi...[show_more]
A community-focused healthcare organization is hiring a Data Architect in Chicago to lead the design of its internal data infrastructure.
The role involves creating a modern Data Lakehouse architect...[show_more]
A consulting firm located in Chicago is seeking a Global Process Consultant / Lead to partner with business stakeholders.
Key responsibilities include defining data requirements, supporting global tem...[show_more]
A consulting firm is seeking a Senior Technical Business Analyst / Data Architect in Chicago, IL.This hybrid role requires experience in data architecture and business analysis.The ideal candidate ...[show_more]
Our VP Data Management / Information Owner professional is passionate about information security and risk / control solutions for computing environments.
Support business operations by partnering with t...[show_more]
The Index business is responsible for the creation and distribution of Morningstar’s Index intellectual property.The group administers an extensive range of existing indexes and develops new, innov...[show_more]
Novolex is a leading manufacturer of food, beverage, and specialty packaging that supports multiple industries including foodservice, restaurant delivery and carryout, food processing, grocery and ...[show_more]
A healthcare organization in Chicago is seeking a Data Architect to serve as the 'Data Owner.You will design scalable data pipelines, enforce data quality standards, and ensure compliance with priv...[show_more]
A leading data center solutions provider in Chicago is seeking a Development Director to oversee the full lifecycle of innovative data center projects.
This role includes providing guidance to proje...[show_more]
A career in IBM Consulting is rooted in long-term relationships and close collaboration with clients across the globe.You'll work with visionaries across multiple industries to improve the hybrid c...[show_more]
Our VP Data Management / Information Owner professional is passionate about information security and risk / control solutions for computing environments.
Support business operations by partnering with t...[show_more]
Location : North, NJ / Chicago, IL.Salary : $Market (Based on the Experience).Requires bachelor's degree or equivalent experience.
Expertise in technologies like Cognos / BO / HANA / Tableau.Firm underst...[show_more]
A Chicago-based financial services firm is seeking a Senior Data Engineer to enhance their Data team.The role requires a minimum of 5 years of experience in building and maintaining data pipelines,...[show_more]
Enjoy problem-solving, need a venue to display your creativity, and emerging technologies pique your interest; if so, Barrow Wise Consulting, LLC is for you.
As a multi-disciplined leader, you under...[show_more]%20AG)
A leading healthcare analytics firm is seeking a Director of Healthcare Analytics to transform large datasets and develop insightful Tableau dashboards in a hybrid work environment.Candidates must ...[show_more]
Health Solutions Assistant Vice President - Data Warehouse Analytics
Aon • Chicago, IL, United States
[job_card.full_time]
[last_updated.last_updated_30] • [promoted]
Healthcare Data Architect - ETL & Analytics
Children’s Research Fund • Chicago, IL, United States
[job_card.full_time]
[last_updated.last_updated_variable_days] • [promoted]
Data Warehouse & Business Intelligence Developer
Baird & Warner • Chicago, IL, US
[job_card.full_time]
[filters_job_card.quick_apply]
[last_updated.last_updated_variable_days]
Lead Enterprise Data & AI Solutions Architect
Vizient, Inc • Chicago, IL, United States
[job_card.full_time]
[last_updated.last_updated_variable_days] • [promoted]
Healthcare Data Architect - Lakehouse & HIPAA Expert
South Side Healthy Community Organization • Chicago, IL, United States
[job_card.full_time]
[last_updated.last_updated_1_day] • [promoted]
Global SAP Data & Process Lead
KellyMitchell Group • Chicago, IL, United States
[job_card.full_time]
[last_updated.last_updated_variable_days] • [promoted]
Senior Data Architect - Loyalty Platforms (Hybrid, Chicago)
Forbes Technical Consulting • Chicago, IL, United States
[job_card.full_time]
[last_updated.last_updated_variable_days] • [promoted]
Data Management Lead - Vice President
JPMorgan Chase & Co. • Chicago, IL, United States
[job_card.full_time]
[last_updated.last_updated_variable_days] • [promoted]
Index Data Sales Director
Morningstar • Chicago, IL, United States
[job_card.full_time]
[last_updated.last_updated_30] • [promoted]
Warehouse Lead I
Novolex • Chicago, IL, United States
[job_card.full_time]
[last_updated.last_updated_variable_days] • [promoted]
Senior Data Architect : GCP & Analytics Lead
EmergencyMD • Chicago, IL, United States
[job_card.full_time]
[last_updated.last_updated_variable_days] • [promoted]
Lead, Data Center Development & Delivery
T5 Data Centers • Chicago, IL, United States
[job_card.full_time]
[last_updated.last_updated_variable_days] • [promoted]
Senior Managing Consultant SAP Data Migration Lead
IBM • Chicago, IL, United States
[job_card.full_time]
[last_updated.last_updated_variable_days] • [promoted]
Data Management Lead - Vice President
JPMorgan Chase • Chicago, IL, United States
[job_card.full_time]
[last_updated.last_updated_variable_days] • [promoted]
Senior Data Architect (F500 Client) - North, NJ / Chicago, IL
Two95 International Inc. • Chicago, IL, US
[job_card.full_time]
[filters_job_card.quick_apply]
[last_updated.last_updated_30]
Senior Data Engineer, Azure Data Factory & Data Warehouse
Access Search, Inc. • Chicago, IL, United States
[job_card.permanent]
[last_updated.last_updated_variable_days] • [promoted]
SQL DBA
Barrow Wise Consulting • Chicago, IL, USA
[job_card.full_time]
[filters_job_card.quick_apply]
[last_updated.last_updated_30]
Healthcare Analytics Leader - SQL & Tableau Dashboards
CH01 CHE Fresenius Medical Care (Schweiz) AG • Chicago, IL, United States
[job_card.full_time]
[last_updated.last_updated_variable_days] • [promoted]