Company

Mavens GuildSee more

addressAddressChicago, IL
type Form of workFull-Time
CategoryInformation Technology

Job description

Job Description

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

Refer code: 7626882. Mavens Guild - The previous day - 2024-01-03 22:43

Mavens Guild

Chicago, IL
Popular Data Warehouse Lead jobs in top cities
Jobs feed

Registered Nurse III

Solomon Carter Fuller Mhc

Boston, MA

$83,491.20 - $139,317.88 a year

Registered Nurse- Full Time

Visiting Rehab And Nursing Services

Framingham, MA

$50 - $140 an hour

Registered Nurse (RN)

Cscm

Milford, MA

$34 - $38 an hour

Lead Toddler Teacher

Pincushion Hill Montessori School

Ashland, MA

$45,000 - $47,000 a year

Personal Lines Account Manager

Northstar Insurance Services Inc

Needham, MA

$75,000 - $90,000 a year

Registered Nurse

Harvard University

Cambridge, MA

Registered Nurse - Same Day Services

Optum

Natick, MA

$80.7K - $102K a year

Special Education Teacher- Specialized Programming- Ashland Preschool- Immediate 3/1/2024

Ashland Public Schools

Ashland, MA

$54.8K - $69.3K a year

Sales Executive

City Wide Of Boston

Worcester, MA

$60,000 - $125,000 a year

Preschool Teacher Assistant

Wayland Montessori Preschool

Wayland, MA

$20.00 - $23.50 an hour

Share jobs with friends

Related jobs

Data Warehouse Lead / Sql Server Specialist

Lead Data Warehouse Engineer (Hybrid)

Enova International

Chicago, IL

6 months ago - seen