Sonoma Consulting Inc. Logo

Sonoma Consulting Inc.

MSBI Developer

Posted Yesterday
Be an Early Applicant
In-Office
Chicago, IL, USA
Mid level
In-Office
Chicago, IL, USA
Mid level
Design, develop, and support MSBI solutions (SSIS/SSRS/SSAS/Power BI). Build cubes, write MDX, create SSRS reports, implement PowerPivot/SharePoint integration, design data warehouses and star schemas, perform production support and performance tuning, and coordinate with onshore/offshore teams and stakeholders.
The summary above was generated by AI
Company 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
• At least 3 years of experience in MSBI suite of products (SSIS/SSRS/SSAS/Power BI (Power View, Power Pivot, Power Query, Power Map)/ PerformancePoint (on SharePoint)/MDS/DQS/Data Mining).
• At least 3 years of experience in Software development life cycle.
• Good awareness on DW architecture and design using MSBI
• Strong knowledge of Dimension Modeling
• Good knowledge of MSBI suite of products (SSIS/SSRS/SSAS/Power BI (Power View, Power Pivot, Power Query, Power Map)/ PerformancePoint (on SharePoint)/MDS/DQS/Data Mining).
• Proficient in creating different types of cubes/schemas in Analysis Services
• Proficient in creating and testing new KPI's, perspectives and calculations
• Experience in creating SSRS reports from cubes
• Experience in PowerPivot and its Integration with SharePoint
• MDX Query writing experience
• Strong verbal and written communication skills as well as good time-management and organizational skills.
• Coordinate with customer, vendor and onsite/offshore folks
• Knowledge of Data Warehousing and Data Modeling concepts, specifically designing and populating normalized data warehouses and star schema based data marts
• Experience and understanding of in Production support and performance engineering
• Technical Skills
• Ability to work in team environment and client interfacing skills.
• Analytical skills
• Experience and desire to work in a Global delivery environment

Qualifications

• Bachelor’s degree or foreign equivalent required from an accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education.
• At least 4 years of experience with Information Technology.

Additional Information

** U.S. Citizens and those who are authorized to work independently in the United States are encouraged to apply. We are unable to sponsor at this time.
This is a Full-Time / Permanent job opportunity.
Only US Citizen, Green Card Holder, GC-EAD, H4-EAD & L2-EAD can apply.
** All your information will be kept confidential according to EEO guidelines.

Similar Jobs

41 Minutes Ago
Remote or Hybrid
United States
18-27 Hourly
Mid level
18-27 Hourly
Mid level
Artificial Intelligence • Automotive • Greentech • Information Technology • Machine Learning • Software • Cybersecurity
Support Managed Services Campaign Coordinators and SEO analysts by processing and executing campaign tasks, collaborating with cross-functional teams, participating in trainings, and assisting with client communications and special projects as assigned.
46 Minutes Ago
In-Office
Chicago, IL, USA
225K-325K Annually
Junior
225K-325K Annually
Junior
Artificial Intelligence • Legal Tech • Software
The Legal Engineer will help clients maximize the use of Legora's AI-powered platform, acting as a liaison between clients and product development, providing demos, and ensuring effective adoption across legal teams.
Top Skills: AILegal Technology
48 Minutes Ago
Hybrid
Deerfield, IL, USA
70K-120K Annually
Senior level
70K-120K Annually
Senior level
Manufacturing
The Senior RGM & Pricing Analyst drives profitable sales growth through analytics, providing strategic pricing and promotional insights while collaborating with cross-functional teams.
Top Skills: AlteryxExcelPower BITableauTalend

What you need to know about the Chicago Tech Scene

With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.

Key Facts About Chicago Tech

  • Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
  • Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
  • Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
  • Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account