Sr. Data Modeler with SQL
- Location
- Kalamazoo, MI · On-site
- Job type
- Contract
- Level
- Senior
- Listed
- Today
Skills & highlights for this role
- SQL Server
- data warehouse design
- ETL (SSIS)
- stored procedures
Also useful
- SAP BODS
- Hadoop
- Tableau
How well does your resume fit this job?
Upload your resume to see your score for this Sonoma Consulting Inc. role, what matches, what's missing, and your best other matches.
Scored on our server and not saved there. The file stays in this browser so you don't have to upload it again after you sign up.
About the role
Mandatory
- Need to have experience with business Rules, Stored Procedures and Optimizations
- Strong Experience with SQL Server 2012, 2014 and good knowledge on 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 source of data.
- Advanced Data Modeling Skills with SQL database including good skills in designing complex queries, 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 solutions patterns, data flow diagrams, data models and architectural specifications
- Integration experience with ETL (Working Experience with SAP BODS is a plus)
- Understanding of Big Data, Hadoop eco systems is a plus
- Knowledge and work experience developing solutions using Programming language like Java, C++, Python is a plus
- Experience in integration with Analytical Tool such as Tableau / Business Objects is a plus
- Knowledge of the Data and Analytics and Agile Implementation Lifecycle
- Client-centric mentality: reliable, professional, 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
Experience with any of the following is a plus
Cloud IaaS/PaaS, Azure, Cloud Integration etc.
Additional Information
All your information will be kept confidential according to EEO guidelines.
About the Company
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
From Sonoma Consulting Inc.'s careers page, first listed on Rolev.ai on November 19, 2026. Rolev.ai is not the employer.
How Rolev.ai helps with this application
Rolev.ai is a job search and application tool for US job seekers. For this Sr. Data Modeler with SQL role at Sonoma Consulting Inc., it shows how your resume fits, tailors your resume to the posting, and prepares the application for you to review.
See how you fit
Openings from employer career sites are ranked against your whole resume—and searchable inside Claude, ChatGPT, and Cursor via Rolev.ai MCP.
Tailor without inventing
Every change to your resume is checked against your original. New experience goes in only with your yes—zero fabricated claims.
Draft the full kit
Tailored and Full Match resumes, role-specific cover letters, and answers to employer screening questions are prepared in seconds.
1-Click Extension Autofill
The Chrome extension fills the employer's Greenhouse, Workday, Lever, or Ashby form in 1 click. You review it and press Submit.
Similar roles
- SAP HANA ConsultantMaania Consultancy Services · Dallas, TX
- Business Intelligence ArchitectAriston Tek Inc. · Stamford, CT
- Oracle Apps Technical LeadGeorgia IT Inc. · Somers, NY
- IBM Infosphere MDM(Physical MDM/Advance Edition experience is required)Ajna Infotech · Burlington, NC
- Senior Manager, Data EngineeringMDT Kangaroo · GA Johns Creek, GA
- Data ArchitectAmiga Informatics · Orlando, FL
Common questions
Where is the Sr. Data Modeler with SQL job at Sonoma Consulting Inc. located?
This Sr. Data Modeler with SQL position at Sonoma Consulting Inc. is located in Kalamazoo, MI (On-site). Always check Sonoma Consulting Inc.'s application page for specific state eligibility or relocation policies.
What qualifications are required for Sr. Data Modeler with SQL at Sonoma Consulting Inc.?
For the Sr. Data Modeler with SQL role, Sonoma Consulting Inc. highlights experience with SQL Server, data warehouse design, ETL (SSIS), stored procedures. Rolev.ai can score your existing resume against these requirements and show any skill gaps before you apply.
How do I apply for the Sr. Data Modeler with SQL position at Sonoma Consulting Inc.?
This listing links directly to Sonoma Consulting Inc.'s SmartRecruiters application page. You can apply directly on Sonoma Consulting Inc.'s site, or use Rolev.ai to check your resume fit, generate a zero-hallucination tailored resume and cover letter for this posting, and autofill the SmartRecruiters application form in 1 click with the Rolev.ai Chrome extension. You always review the form and press Submit yourself.