Sonoma Consulting Inc. Jobs

Cognos BI Developer (Local to IL)

Sonoma Consulting Inc.

Cognos BI Developer (Local to IL)

Reposted 20 Days Ago

Be an Early Applicant

In-Office

Glenview, IL, USA

Mid level

In-Office

Glenview, IL, USA

Mid level

Design and implement dashboards, visualizations, and analytic solutions using Power BI, Power Pivot and SSRS. Convert Tableau reports to Power BI/SSRS, work with SSAS (multidimensional/tabular) and MDX, perform SQL development and tuning, document solutions, elicit user requirements, teach colleagues, and research new BI tools and methodologies.

The summary above was generated by AI

Company Description

Sonoma Consulting is one of the fastest growing national IT Consulting and Executive Search company in the United States, which was founded in 2011 by Mark McGee, the President and CEO. Sonoma Consulting has two business divisions - IT Consulting Services & Executive Search to serve its 150 national clients which range from entrepreneurial start-ups to Global Fortune 500.

Job Description

Description:
Our client is expanding its use of Power BI and SSRS, and needs an innovative individual to join its IT Department help grow our established Power BI for Excel / SSRS environment.

The successful candidate will:
be responsible for designing and implementing visualizations, dashboards, scorecards, and analytic solutions using Power Pivot, Power BI and SSRS
help convert Tableau BI reporting logic to a Power BI/SSRS interactive reporting solution
research new technologies, tools and methodologies as they emerge that may improve the overall service offering.
teach others in IT and the business how to use these tools effectively.
work independently with users to elicit requirements
manage timelines and expectations, and create clear documentation

Qualifications

Our ideal candidate will have these qualifications:
Strong SQL and Stored Procedure skills
Advanced knowledge of Power Pivot, Power BI, SSRS and Tableau
Experience with SSAS multidimensional and tabular models and querying the same with MDX
Experience with MS SQL Server, SharePoint, and with SQL Query performance tuning
Good interpersonal, written and oral communications skills.
Be a self-starter who can work with minimal supervision.
Completion of a Bachelor’s degree in Computer Science, Information Systems or an equivalent combination of training and experience.

Additional Information

Titles: BI Developer, Business Intelligence Developer, BI Datawarehouse Developer, BI/DW, BIDW Lead Developer

Skills : SQL Server, Stored Procedure, SSRS, SSAS, Power BI, MDX, Sharepoint

Similar Jobs

BlackRock

Director, Business & Platform Development, US Direct

2 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

Citizens

Consumer Counselor - Mortgage Collections

4 Hours Ago

In-Office or Remote

United States

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

Liberty Mutual Insurance

Casualty Senior Claims Manager — Casualty Specialized Claims

5 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