Sonoma Consulting Inc. Jobs

Cognos BI Developer (Local to IL)

Sonoma Consulting Inc.

Cognos BI Developer (Local to IL)

Posted 6 Hours 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

Grow Therapy

Accountant

40 Minutes Ago

Remote or Hybrid

USA

76K-85K Annually

Junior

76K-85K Annually

Junior

Healthtech • Social Impact • Software

Own end-to-end accounts payable operations using NetSuite and Ramp, handle invoice intake, GL coding, approvals, and payments; manage month-end AP close, reconciliations (prepaids, accruals, corporate cards), vendor communications, and drive automation/AI process improvements to scale AP.

Top Skills: NetSuiteRamp

Apex Fintech Solutions

Revenue Strategy Analyst

51 Minutes Ago

Hybrid

Chicago, IL, USA

78K-98K Annually

Junior

78K-98K Annually

Junior

Fintech • Software • Financial Services

Produce regular reports and analyses to inform strategic decisions across Sales, Partnerships, Finance, and Product. Ensure data integrity, present insights to senior leadership, solve complex business problems, and improve analytical capabilities and processes.

Top Skills: DealhubExcelHubspotLookerPower BISalesforceTableau

Enova

Marketing Specialist - Direct Mail (Hybrid)

An Hour Ago

Easy Apply

Hybrid

Chicago, IL, USA

Easy Apply

60K-83K Annually

Mid level

60K-83K Annually

Mid level

Fintech • Information Technology • Machine Learning • Software • Analytics • Financial Services

Manage day-to-day execution of consumer acquisition and portfolio Direct Mail programs: data flows, campaign scheduling, cost tracking, performance reporting and optimization. Run A/B and creative/targeting tests, partner with vendors, and collaborate with BI, Data Science, and Analytics to improve reporting and drive program growth.

Top Skills: A/B TestingExcelMicrostrategyTableau

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