Sr. Data Modeler with SQL

Sonoma Consulting Inc.

Kalamazoo (MI)

On-site

USD 80,000 - 100,000

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

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

Halo Group is a premier provider of IT talent. We place technology experts within the teams of the world’s leading companies to help them build innovative businesses that keep them one step closer to their customers and one step ahead of the competition. We offer a meaningful work environment for employees, attractive and interesting engagements for consultants, and cutting‑edge digital innovation for our customers.

We delight in helping our customers execute their digital vision. Big projects or small, Halo Group knows that by combining the highest quality talent with our unwavering support, we will become an invaluable extension of the team. Halo Group’s experienced consultants in Detroit, Atlanta and Dallas specialize in all areas of product/project governance, UX/UI, multi‑platform applications, quality assurance/testing, cloud computing, and data analytics.

Since its inception, Halo Group has been recognized for numerous awards, including:

INC 5000
Future 50
101 Best and Brightest
Michigan 50 Companies to Watch
Goldline Research - “Most Dependable Companies”
Ernst & Young - “Entrepreneur of the Year” Finalist

Job Description

Mandatory

Need to have experience with business Rules, Stored Procedures, and Optimizations.
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.
Strong experience with SQL Data modeling and designing the data marts for different sources of data.
Advanced Data Modeling skills with SQL databases, including good skills in designing complex queries and stored procedures.
Ability to move between high‑level architectural review/design and the ‘roll up the sleeves’ level of actually doing all phases of a solution delivery project.
Strong working experience with SSIS, SSRS and/or SSAS.
Experience with any of the following is a plus: Cloud IaaS/PaaS, Azure, Cloud Integration, etc.
Responsible for performance tuning of database functions, SQL queries, and stored procedures to ensure scalability demands are satisfied.
A deep understanding of, and experience using and explaining, all aspects of relational database design, multidimensional database design, OLTP, OLAP, KPIs, scorecards, and dashboards.
Experience leading technical discussions on data warehouse appliance technology (hardware, software, database, storage).
Gather and document functional and technical requirements, and translate requirements into reporting solutions, analytic tools, and dashboards.
Develop solution patterns, data flow diagrams, data models, and architectural specifications.
Integration experience with ETL (experience with SAP BODS is a plus).
Understanding of Big Data and Hadoop ecosystems is a plus.
Knowledge and work experience developing solutions using programming languages like Java, C++, Python is a plus.
Experience in integration with analytical tools such as Tableau/Business Objects is a plus.
Knowledge of the Data and Analytics and Agile Implementation lifecycle.
Client‑centric mentality: reliable, professional, and exceeds expectations.
Able to handle projects independently and manage client expectations and deliverables in a timely manner.
Ability to lead a team of 3‑5 consultants and mentor junior consultants.
Excellent organizational skills to work in a fast‑paced environment and manage and prioritize multiple tasks simultaneously.
Demonstrated skill at presenting complex development topics to technical and business users.