Sonoma Consulting Inc. Jobs

Cognos BI Developer (Local to IL)

Sonoma Consulting Inc.

Cognos BI Developer (Local to IL)

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

Flex

Operations Director

An Hour Ago

In-Office

Libertyville, IL, USA

145K-199K Annually

Expert/Leader

145K-199K Annually

Expert/Leader

Hardware • Other • Appliances

Leads operations for a highly technical, regulated manufacturing site, overseeing production, planning, engineering, maintenance, logistics, purchasing, and production control. Owns staffing, P&L, productivity, profitability, quality, customer delivery, and operational performance. Drives Lean transformation through 5S, Kaizen, Kanban, value stream optimization, and continuous improvement. Develops teams, manages organizational change, partners with executives and customers, and ensures compliance and business growth.

Top Skills: 5SAutomation EquipmentHigh-Tech MoldingKaizenKanbanLean Daily ManagementLean ManufacturingPrecision ManufacturingStandard WorkValue Stream MappingVisual Management

CrowdStrike

Principal Engineer

2 Hours Ago

Remote or Hybrid

USA

195K-290K Annually

Expert/Leader

195K-290K Annually

Expert/Leader

Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity

Own the architecture and multi-year roadmap for CrowdStrike’s global IP and optical backbone. Lead traffic engineering, capacity planning, demand forecasting, hardware and vendor strategy, cloud connectivity, automation, infrastructure-as-code, telemetry, and AI-assisted network operations. Drive initiatives from funding through implementation and operational stewardship, serve as a senior incident escalation resource, influence executive stakeholders and vendor roadmaps, and mentor senior engineers. The role requires large-scale backbone expertise, optical transport knowledge, cloud networking experience, FedRAMP exposure, and U.S. citizenship or Green Card status.

Top Skills: 400G800GAi ModelsAlien WavelengthsAnsibleAristaAWSAzureCdnCerebrasCi/CdCiscoCoherent OpticsContainersCoreweaveDatabasesDdos MitigationDispersion ManagementDwdmEdfaFedrampGCPGitopsInfineraIp/MplsIs-IsJuniperMessage QueuingMp-BgpMpls-TeNokiaOciPe/P ArchitecturesRaman AmplificationRoadmSegment RoutingSr-MplsSrv6Telemetry AnalyticsTerraformVirtualizationVrfs

CrowdStrike

Security Advisor II, Falcon Complete (Remote)

4 Hours Ago

Remote or Hybrid

USA

100K-155K Annually

Mid level

100K-155K Annually

Mid level

Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity

Assess customers’ Falcon environments, identify security-posture gaps, recommend remediation, and contact customers regarding standards misalignment. Document and resolve issues within SLAs, produce service reports, coordinate troubleshooting with support and internal teams, and promote customer satisfaction. The role requires cybersecurity experience, threat detection and incident response knowledge, operating-system proficiency, strong customer communication, and the ability to use AI technologies to improve workflows and decisions.

Top Skills: Ai TechnologiesCis Critical Security ControlsCloud Controls MatrixCrowdstrike Falcon CompleteIso 27001/2LinuxmacOSMdr/XdrMitre Att&CkNist Cybersecurity FrameworkPci DssSIEMUebaWindows

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