Sonoma Consulting Inc. Logo

Sonoma Consulting Inc.

MSBI Developer

Reposted 20 Days 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

4 Hours Ago
In-Office
Monroe, Chicago, IL, USA
185K-270K Annually
Senior level
185K-270K Annually
Senior level
Fintech • Information Technology • Financial Services
Lead partnership and platform strategy for BlackRock's US Direct channel, managing senior relationships with brokers, robo-advisors, and fintechs. Originate, structure, and execute strategic commercial deals, drive asset growth and product adoption, align cross-functional teams (product, marketing, Aladdin Wealth), translate market intelligence into strategy, and mentor a business development team to scale the channel.
Top Skills: Ai ToolsAladdin Wealth
5 Hours Ago
In-Office or Remote
United States
Entry level
Entry level
Digital Media • Fintech • Information Technology • Machine Learning • Financial Services • Cybersecurity • Automation
Handle inbound and outbound mortgage collections calls, review account status, collect payments, evaluate customer finances, negotiate repayment solutions, and document account actions. Ensure compliance with customer information security, debt collection, and mortgage regulations while meeting quality, productivity, and operational targets. The role includes extensive training and operates on a hybrid schedule with three days onsite and two days remote in Irving, Texas.
Top Skills: Ai SimulationsDigital Phone SystemsExcelMicrosoft WordMsp/Black Knight
6 Hours Ago
Remote or Hybrid
Hoffman Estates, IL, USA
179K-322K Annually
Senior level
179K-322K Annually
Senior level
Artificial Intelligence • Fintech • Insurance • Marketing Tech • Software • Analytics
Leads a specialized casualty claims team managing severe-exposure portfolios, complex litigation, coverage issues, reserves, settlements, vendors, and claim-handling protocols. Partners with legal, underwriting, actuarial, reinsurance, and other stakeholders to develop strategies, monitor litigation trends, address legal system abuse, manage financial outcomes, and improve operational performance. Coaches claims leaders, oversees staffing and portfolio capacity, and presents strategic recommendations to executives and business partners.
Top Skills: Guidewire Claims System

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