Cognos BI Developer (Local to IL)
At a glance
Mid-level Data Analysis & BI role at Sonoma Consulting Inc. Glenview · full-time · no salary stated · we estimate $86,500–$135,038 across the United States.
Sonoma Consulting Inc. has not published a salary for this role. The figure below is our estimate, not theirs.
dataroles summary, based on the employer's posting.
What you'll do
- Build dashboards, scorecards, visual displays and analytics with Power Pivot, Power BI and SSRS
- Rework Tableau reporting logic into interactive reports using Power BI and SSRS
- Explore new tools and methods that could improve the reporting service
- Show IT staff and business users how to use the reporting tools effectively
- Gather user needs, manage delivery expectations and timelines, and document the work clearly
What you bring
- Strong SQL and stored procedure skills, plus advanced knowledge of Power Pivot, Power BI, SSRS and Tableau
- Experience with SSAS models and MDX, along with SQL Server, SharePoint and query tuning
- A computer science or information systems degree, or equivalent training and experience
Who this fits
This mid-level, hands-on role suits someone who can work independently with users and needs little supervision. The position is onsite in Glenview and is intended for someone local to Illinois.
From the employer
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.
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
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.
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