View job on Handshake

Employer: Miami Dade College

Expires: 07/27/2021

All applications must be submitted online at 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 modelsMinimum Requirements: •Bachelor’s degree in Computer Science, MIS, Mathematics, Statistics, Finance, or otherclosely related field and seven (7) years of progressive experience in implementing andsupporting 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