Sr. Data Modeler with SQL
At a glance
Senior Data Architecture & Governance role at Sonoma Consulting Inc. Kalamazoo · contract.
Pay not stated Data Architecture & Governance salary
dataroles summary, based on the employer's posting.
What you'll do
- Design SQL data models and marts that combine information from different source systems
- Build and tune SQL Server warehouse schemas, queries, stored procedures and database functions
- Turn functional and technical requirements into reporting solutions, analytics tools and dashboards
- Create data-flow diagrams, solution patterns, models and architecture specifications
- Guide technical discussions on warehouse appliance design and explain complex topics to business and technical users
What you bring
- You have hands-on SQL Server development experience, including warehouse schema design and optimization
- You bring strong SQL data-modeling skills and can design complex queries and stored procedures
- You have worked with SSIS, SSRS or SSAS, and know SQL Server versions 2012 or 2014
- You can move from architectural design into delivery work, manage projects independently and lead or mentor consultants
Who this fits
This senior contractor role suits someone who can combine database architecture with hands-on SQL development and client-facing project delivery. The position is onsite in Kalamazoo.
From the employer
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
Mandatory
1. Need to have experience with business Rules, Stored Procedures and Optimizations
2. Strong Experience with SQL Server 2012, 2014 and good knowledge on in-memory functions.
3. Hands-on SQL Server development experience including DW schema design, implementation and optimization
4. Strong experience with SQL Data modeling and designing the data marts for different source of data.
5. Advanced Data Modeling Skills with SQL database including good skills in designing complex queries, stored procedures
6. 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
7. Strong working experience with SSIS, SSRS and/or SSAS
8. Experience with any of the following is a plus: Cloud IaaS/PaaS, Azure, Cloud Integration etc.
9. Responsible for performance tuning of database functions, SQL queries, and stored procedures to ensure scalability demands are satisfied.
10. A deep understanding of, and experience using and explaining all aspects of, relational database design, multidimensional database design, OLTP, OLAP, KPIs, Scorecards, and Dashboards
11. Experience leading technical discussions on data warehouse appliance technology (hardware, software, database, storage).
12. Gather and document functional and technical requirements, and translate requirements into reporting solutions, analytic tools and dashboards
13. Develop solutions patterns, data flow diagrams, data models and architectural specifications
14. Integration experience with ETL (Working Experience with SAP BODS is a plus)
15. Understanding of Big Data, Hadoop eco systems is a plus
16. Knowledge and work experience developing solutions using Programming language like Java, C++, Python is a plus
17. Experience in integration with Analytical Tool such as Tableau / Business Objects is a plus
18. Knowledge of the Data and Analytics and Agile Implementation Lifecycle
19. Client-centric mentality: reliable, professional, exceeds expectations
20. Able to handle projects independently and manage client expectations and deliverables in a timely manner
21. Ability to lead a team of 3 - 5 consultants and mentor junior consultants
22. Excellent organizational skills to work in a fast-paced environment and manage and prioritize multiple tasks simultaneously
23. Demonstrated skill at presenting complex development topics to technical and business users
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.
All your information will be kept confidential according to EEO guidelines.
Data Architecture & Governance work from LinkedIn, X, Reddit and Upwork, in one list.
Each morning you get everything that fits, strongest first.
Data Architecture & Governance
Find me workBy the team behind dataroles.