Sonoma Consulting Inc. Logo

Sonoma Consulting Inc.

MSBI Developer

Reposted 2 Months Ago
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

3 Minutes Ago
In-Office or Remote
Chicago, IL, USA
88K-105K Annually
Junior
88K-105K Annually
Junior
Blockchain • Fintech • Payments • Financial Services • Cryptocurrency • Web3
Qualify inbound partner and prospect leads, conduct discovery conversations, assess business fit, route opportunities to appropriate business development or sales teams, and manage handoffs. Maintain CRM data hygiene, prioritize follow-up, resolve cases promptly, and use workflow tools to improve response times and prospect engagement. The role requires learning and communicating fintech, payments, blockchain, and digital asset concepts while collaborating with cross-functional teams.
Top Skills: Ai-Enabled Workflow ToolsCrm SystemsGoogle WorkspaceHubspotSalesforceSlack
3 Minutes Ago
In-Office or Remote
Chicago, IL, USA
65K-78K Annually
Junior
65K-78K Annually
Junior
Blockchain • Fintech • Payments • Financial Services • Cryptocurrency • Web3
Manages inbound partner and customer leads, responds within service-level agreements, conducts initial outreach, gathers qualification information, maintains accurate CRM records, routes leads to business development or sales teammates, and supports pipeline data hygiene. The role also uses CRM and AI-enabled tools for follow-up and prioritization and assists with qualified partner onboarding and activation.
Top Skills: Ai-Enabled Workflow ToolsBlockchainCRMDigital AssetsGoogle WorkspaceHubspotSalesforceSlackStablecoins
18 Minutes Ago
Remote or Hybrid
United States
100K-125K Annually
Senior level
100K-125K Annually
Senior level
Artificial Intelligence • Big Data • Cloud • Information Technology • Software • Big Data Analytics • Automation
Support 4–8 clients by analyzing digital experience data, connecting technical findings to business outcomes, identifying root causes, and expanding platform adoption. Manage complex engagements, present analyses and proof-of-concept results, coordinate with Support and account teams, create executive value reports, and mentor newer analysts. The role requires prioritization across multiple client teams and occasional travel for annual meetings or strategic client engagements.
Top Skills: Backend Trace DataBusiness EventsDynatraceInsights Tools

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