Microsoft BI Data Analysis
Salary: $65-85k, plus overtime/bonus
Location: Oakbrook, IL
Description
Company is a prominent, full service, IT consulting firm located in the Western suburbs of Chicago. We provide outsourced IT services including managed services, business software solutions, infrastructure and cloud support.
We are looking for a DATA ANALYTICS CONSULTANT. This position will work with clients to develop data-driven reporting and analytical solutions using primarily the Microsoft Business Intelligence stack. This includes working with end-users to collect and document business requirements, reverse engineering Legacy solutions, and developing new solutions. We are looking for someone with both solid business analytics skills as well as the technical acumen and passion for turning data into actionable insights.
Job Functions:
- Gather and document business requirements
- Develop data models and ERD diagrams
- Develop ETL packages with SSIS
- Develop new data warehouses/databases
- Create views and stored procedures to query data
- Create tabular models
- Install & configure SQL Server instances and data presentation applications
- Create data visualizations and reports to present data using Power BI and SSRS
- Performs other miscellaneous duties as assigned
Requirements
In order to be successful in this position, we are seeking the following experience:
- SQL Server (2008 R2 and higher)
- P-SQL knowledge a bonus
- Knowledge of data warehouse development and ER diagraming
- Experience with Microsoft's classic BI stack SSIS, SSAS (Tabular), SSRS
- Experience creating and mocking data visualizations using Power BI

Qualifications
Applicants must be eligible to work in the specified location