Cognos BI Developer (Local to IL)

Sonoma Consulting Inc.; Glenview (IL); On-site; USD 70,000 - 90,000; Full time

Job summary

A national IT Consulting firm located in Glenview, Illinois is seeking an innovative BI Developer to enhance their Power BI and SSRS environment. The successful candidate will focus on designing visualizations and dashboards while converting Tableau reports into Power BI solutions. Ideal applicants should have strong SQL skills, advanced knowledge of Power BI, and experience with SSAS. A Bachelor’s degree in Computer Science or a related field is required. Join a dynamic team pushing the boundaries of business intelligence.

Qualifications

• Strong SQL and Stored Procedure skills.
• Advanced knowledge of Power Pivot, Power BI, SSRS, and Tableau.
• Experience with SSAS multidimensional and tabular models.
• Experience with MS SQL Server and performance tuning.
• Good interpersonal and communication skills.
• Self-starter who can work independently.
• Completion of Bachelor's degree in related field.

Responsibilities

• Design and implement visualizations and dashboards using Power BI.
• Convert Tableau BI reporting logic to Power BI solutions.
• Research new tools and methodologies to improve services.
• Teach effective use of tools in IT and business.
• Work independently to elicit user requirements.
• Manage timelines and create clear documentation.

Skills

SQL

Power BI

SSRS

Stored Procedures

SharePoint

MDX

Education

Bachelor’s degree in Computer Science

Tools

SQL Server

Power Pivot

SSAS

Tableau

Job 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