You are viewing a preview of this job. Log in or register to view more details about this job.

Lead Business Intelligence Developer

All applications must be submitted online at http://www.mdc.edu/jobs/
Job Opening ID: 1001348 
 
Job Description:
The Lead Business Intelligence Developer leads operational support activities for College’s enterprise decision support system. The Lead Developer will act as an engaged and effective partner to the key stakeholders in the stages of analysis, requirement development, design, documentation, implementation, and maintenance of data warehouse and business intelligence solutions.
 
Duties & Responsibilities:
•Acts as technical lead in the development and implementation of end-to-end Business Intelligence Solutions with Microsoft BI Stack
•Designs and implements complex data models (both relational and dimensional) and semantic layers using a variety of approaches
•Designs and implements complex, high volume data loading/transformation processes with Microsoft ETL tools such as SSIS, and the SQL Server platform
•Builds and organizes advanced DAX calculations both as part of Power BI reports and Tabular models

Minimum Requirements: 
•Bachelor's degree in Computer Science, MIS, Mathematics, Statistics, Finance, or other
closely related field and seven (7) years of progressive experience in implementing and
supporting business intelligence solutions
•Proven experience in Microsoft BI Solution stack including SSIS, SSAS (multi-dimensional and tabular) and SSRS
•Expert knowledge of SQL Server and SQL development as a whole
•Demonstrated knowledge and experience with ETL concepts and tools
•Demonstrated understanding of data warehousing, type II data warehouses, star schemas and snowflake schemas
•Experience in DAX development (tabular model)
•Experience developing visualizations, preferably using Microsoft Power BI