Senior Data Modeler & DW Architect

Sonoma Consulting Inc.; Kalamazoo (MI); On-site; USD 80,000 - 100,000; Full time

Job summary

A leading IT consultancy in Michigan is seeking a SQL Server Developer with solid database design and optimization experience. Key responsibilities include performance tuning, gathering requirements, and developing architectural specifications. Strong skills in SSIS, SSRS, and SSAS are crucial. The ideal candidate should possess a client-centric mentality and the ability to lead a team. This position provides an opportunity to work on diverse data solutions in a dynamic environment.

Qualifications

• Strong experience with SQL Server 2012-2014 and good knowledge of in-memory functions.
• Hands-on SQL Server development experience including DW schema design, implementation, and optimization.
• Ability to move between high-level design and actual project phases.

Responsibilities

• Responsible for performance tuning of database functions, SQL queries, and stored procedures.
• Gather and document functional and technical requirements for solutions.
• Develop solution patterns, data flow diagrams, and architectural specifications.

Skills

SQL Server Development

Data Modeling

Performance Tuning

SSIS

SSRS

SSAS

Big Data

Java

C++

Python

Tableau

Business Objects

Job description

A leading IT consultancy in Michigan is seeking a SQL Server Developer with solid database design and optimization experience. Key responsibilities include performance tuning, gathering requirements, and developing architectural specifications. Strong skills in SSIS, SSRS, and SSAS are crucial. The ideal candidate should possess a client-centric mentality and the ability to lead a team. This position provides an opportunity to work on diverse data solutions in a dynamic environment.