Talent.com
Data Warehouse Lead / SQL Server Specialist
Data Warehouse Lead / SQL Server SpecialistMavens Guild • Chicago, United States
Data Warehouse Lead / SQL Server Specialist

Data Warehouse Lead / SQL Server Specialist

Mavens Guild • Chicago, United States
Hace más de 30 días
Tipo de contrato
  • A tiempo completo
Descripción del trabajo

What we would like to see:

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:

  • 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


What you will need to bring to the table:

  • 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

Crear una alerta de empleo para esta búsqueda

Data Warehouse Lead / SQL Server Specialist • Chicago, United States

Ofertas similares

SAP Data and Analytics Lead

KomatsuChicago, Illinois, United States
A tiempo completo

Chicago, Illinois, USA, 60631 | Milwaukee, Wisconsin, USA, 53204-2941.Join Komatsu and Be Part of Something Big!.Komatsu is undergoing a major business transformation with the implementation of SAP...Mostrar más

 • Oferta promocionada

Enterprise Data Team Lead

RethinkFirstChicago, IL, US
A tiempo completo
Quick Apply

About RethinkFirst RethinkFirst is a leading behavioral health technology company working to make mental wellness, education, and support accessible and scalable.Through our suite of cloud-based pl...Mostrar más

Senior Cloud Data Engineer: BigQuery & Data Platform Leader

TeamtagChicago, IL, United States
A tiempo completo

A leading healthcare support organization is seeking a Principal Data Engineer in Chicago to architect and optimize scalable cloud-native data platforms.This role involves leading data engineering ...Mostrar más

 • Oferta promocionada • Nueva oferta

VP, Connected Commerce Data & Tech — Omni-Channel Leader

Publicis GroupeChicago, IL, United States
A tiempo completo

A global marketing agency is looking for a VP, Connected Commerce in Chicago to lead retail-specific activities for a major multi-brand client.The role requires over 10 years of experience in shopp...Mostrar más

 • Oferta promocionada • Nueva oferta

Databricks Technical Lead

Ender-ITChicago, IL, United States
A tiempo completo

We’re looking for a Databricks Technical Lead who can guide the design and build‑out of our data engineering and transformation platforms.This person will be the go‑to expert on Databricks, Delta L...Mostrar más

 • Oferta promocionada • Nueva oferta

Data QA Lead - SQL, BigQuery & ETL Validation

TechDigital GroupChicago, IL, United States
A tiempo completo

An innovative firm is seeking a detail-oriented SQL Specialist to enhance data validation processes.In this role, you will leverage your deep SQL knowledge to debug complex queries and ensure data ...Mostrar más

 • Oferta promocionada

Client Data Specialist I

PG ForstaChicago, Illinois, United States
A tiempo completo

Press Ganey is the leading experience measurement, data analytics, and insights provider for complex industries-a status we earned over decades of deep partnership with clients to help them underst...Mostrar más

 • Oferta promocionada

Lead Data Analyst (Hybrid)

American Medical AssociationChicago, Illinois, United States
A tiempo completo

The American Medical Association (AMA) is the nation's largest professional Association of physicians and a non-profit organization.We are a unifying voice and powerful ally for America's physician...Mostrar más

 • Oferta promocionada

Senior Azure Data Engineer

KenexaiChicago, IL, United States
A tiempo completo

Kenexai delivers smart, data-driven solutions that empower businesses across industries.Our mission is to combine deep, domain-specific expertise with cutting-edge technology to drive meaningful im...Mostrar más

 • Oferta promocionada

Data Architect Enterprise Data Warehouse EDW: Remote

Nexwave IncChicago, IL, United States
Teletrabajo
A tiempo completo

Job Title :Data Architect Enterprise Data Warehouse ( EDW ) Location :Remote Duration :12 Months Job Summary We are seeking an experienced Data Architect to provide architectural leadership and sup...Mostrar más

 • Oferta promocionada

SAP SCM Tech Lead

Chesapeake Utilities CorporationChicago, Illinois, United States
A tiempo completo

Hybrid - periodic travel to Newark, DE (2 weeks per month).Must reside or be willing to relocate to TX, IL, NJ, OH, DE, MD, PA, VA, NC, GA, FL.The SAP SCM Technical Lead is responsible for the tech...Mostrar más

 • Oferta promocionada

Vice President, Cloud Data Engineering

ConfidentialChicago, Illinois, United States
A tiempo completo

Vice President, Cloud Data Engineering.Top-tier organization in the consumer services industry.The Company is seeking a VP of Engineering to lead its dynamic and innovative engineering teams.The su...Mostrar más

 • Oferta promocionada • Nueva oferta

Warehouse Lead - 3rd Shift (Sun - Thurs)

CJ Logistics AmericaMatteson, IL, United States
A tiempo completo

Lift Your Career to New Heights with CJ Logistics!.Are you passionate about warehouse operations and ready to make a global impact? At CJ Logistics, we're on the hunt for exceptional talent to keep...Mostrar más

 • Oferta promocionada

AVP, Solutions Data Architecture

Vizient, Inc.Chicago, Illinois, United States
A tiempo completo

When you're the best, we're the best.We instill an environment where employees feel engaged, satisfied and able to contribute their unique skills and talents while living and working as their authe...Mostrar más

 • Oferta promocionada

Snowflake Data Architect

Compunnel, Inc.Chicago, IL, United States
A tiempo completo

We are seeking a highly experienced Snowflake Data Architect to lead the design and implementation of enterprise data management frameworks.This role involves defining strategic data architecture, ...Mostrar más

 • Oferta promocionada

Senior Data Solutions Architect - Financial Services

Databricks Inc.Chicago, IL, United States
A tiempo completo

A technology company specializing in data and AI seeks a Solutions Architect to lead growth for its analytics platform in Chicago.The ideal candidate will have over 8 years in customer-facing roles...Mostrar más

 • Oferta promocionada

Remote Data Analyst - SQL & Visualization Lead

JPS Tech SolutionsChicago, IL, United States
Teletrabajo
A tiempo completo

A leading IT consulting firm is seeking a skilled Data Analyst to join its Product Analytics team in Chicago.The role involves analyzing complex datasets, ensuring data integrity, and using data vi...Mostrar más

 • Oferta promocionada

Data Modeler - BI Analytics & Data Warehouse (Onsite)

The Dignify Solutions, LLCChicago, IL, United States
A tiempo completo

A technology solutions provider is seeking a Data Modeler specializing in BI Analytics for an onsite full-time position.The ideal candidate will have over 5 years of data modeling experience, exper...Mostrar más