Microsoft BI Data Analyst

Oak Brook, IL

Prestigious Microsoft Gold Partner based in Oak Brook, IL is 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