Senior Data Warehouse Developer Job at Mavens Guild, Chicago, IL

SktkK05JMmJXQlkzU0llaFZMV09DU1psTlE9PQ==
  • Mavens Guild
  • Chicago, IL

Job Description

What we would like to see:

Ideal candidate for this role will not only help us procure, curate and model various transactional data but also turn it into information, generating insights and aid in business decisions based on the analytical results. Incumbent's responsibilities will include conducting full development lifecycle — requirements, analysis, development, testing and production deployment whilst managing various everyday data warehouse related processes (SSIS, SSRS, SSAS) and MS SQL Server performance.

We expect you to possess analytical mindset with creative approach to tasks and experience in working with entire Microsoft BI stack with sound understanding of SQL Server and advanced SQL tuning for performance.

 

A typical day as a senior data warehouse developer:

  • Design and develop ETL and reporting processes using SSIS/SSRS tools based on established enterprise standards 

  • Engage with business units to gather requirements and perform iterative data analysis in a fast paced agile environment

  • Architect SQL Server database structures and objects, fine tune SQL queries for performance and monitor latencies during batch processes

  • Identify, analyze, and interpret trends or patterns in complex data sets

  • Design and develop reports, and flat file extracts for consumption by business users and external vendors

  • Collaborate with management to prioritize business and information needs

  • Find and evaluate new process improvement opportunities

What you will need to bring to the table:

8+ years' experience of working as a data warehouse developer or ETL specialist with a deep understanding of relational databasesSolid experience of working with data models, database design development, performance tuning techniques


Solid experience in working with voluminous databases, creating database objects and tuning complex SQL queries for performance


Solid experience using ETL and reporting tools like SSIS, SSRS, SSAS, Informatica and Business Objects


Strong analytical thinking is vital to succeed in this role. You will be constantly asked to understand the business premise before employing your technical skills


Ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy


Good knowledge of documentation and code versioning


Good knowledge of working with enterprise automation tools


BS degree in Computer Science or relevant experience in lieu of a college degree for exceptional candidates


Complimentary skills sets like background in Java programming, Python and/or experience in other databases like Oracle, Netezza, Mongo DB, Teradata is a huge plus!

Job Tags

Full time,

Similar Jobs

Northeast Healthcare Recruitment, Inc.

Medical Assistant - Pediatrics Job at Northeast Healthcare Recruitment, Inc.

Weare seeking a high-performing Medical Assistant with at least 1 year ofexperience to join our dedicated pediatric team. If you are compassionate,detail-oriented, and thrive in a fast-paced environment, we encourage you toapply!Location: Spokane, WAJobType... 

United Supermarkets

Service Center Clerk Job at United Supermarkets

 ...standing in place, lifting, walking, squatting, climbing and at times running Ability to operate all checker equipment, office equipment, Post Office equipment, and count money and make change Ability to accept supervisory coaching related to performance, work habits... 

Dynamics ATS

CT Technologist Job at Dynamics ATS

 ...comprehensive care, addressing the physiological, and socio-cultural needs of patients and their families and acts as a resource to other radiology employees in managing complex issues. Assured equipment is present and accounted for at the beginning and end of each shift.... 

Infrahire

Immigration Attorney Job at Infrahire

 ...InfraHire is looking for Immigration Attorney in Kenner, LA. Job Description: We are seeking an experienced Immigration Attorney to provide legal counsel, conduct in-depth legal research, and represent clients in Immigration Court proceedings.... 

Sidney Health Center

Social Worker ~ Social Services Job at Sidney Health Center

Text to apply: (***) ***-**** using the code: Social