Mavis is looking for a full-time, on-premise Business Intelligence Director who knows how to drive profits! The Director of Business Intelligence will have a proven track record of using the technical skills outlined below to drive business growth, and to lead a team of developers.
From a technical perspective, this role will require hands-on skills in the development and refinement of Multi-Dimensional Cubes (SSAS), ETL processes (SSIS), Data Visualization (PowerBI & SSRS), and overall business understanding. Primary development in the Microsoft-BI Stack. Architecting and tuning of production ETL processes and schedules will be a critical component of this job. This person is also responsible for designing, managing and updating the logical data models for the data warehouse and business intelligence solution. Will require the ability to follow and apply design standards to be used in creating data models in support of a multi-tiered data warehouse utilizing commercial data modeling tools. Ability to evaluate source systems data models, profile source system data content, and capture associated metadata as part of the design process will be crucial to this role.
Data Warehouse Essential Functions:
Code and test extraction, transformation, and load (ETL) processes to support a multi-layer data warehouse architecture (20%)
Lead and mentor developers in design best practices (15%)
Map source systems/file data to data warehouse data models (15%)
Work with business analysts, vendors, functional subject matter experts and systems documentation to understand source data systems and file structures for the purposes of designing and building acquisition code (ETL). (10%)
Work with business analysts and functional subject matter experts to understand data requirements for the ongoing development of the data warehouse solution. (10%)
Adapt ETL processes to accommodate changes in source systems and evolving business requirements (10%)
Create and maintain production ETL schedules and conduct on-going load performance management and tuning. (5%)
Define standards for modular and extensible ETL practices and oversee their use by other developers. (5%)
Designs conceptual and logical data models for the data warehouse and associated presentation layers. Communicate these designs to the technical team and work with the database administrator on the design and creation of the physical databases. (5%)
Evolve models to meet new and changing business requirements, maintaining the models to reflect current production reality at all times using version control and SDLC practices. (5%)
Work Experience:
Five years of experience in the analysis, design, documentation, build and maintenance of complex data models in a data warehouse environment required and
Seven years relevant experience required
Finance and/or Retail Industry experience desired
Knowledge, Skills and Abilities:
Excellent written and verbal communication skills
Understanding of basic Accounting and Finance concepts, including Profit & Loss statements, breakeven analyses, accruals, fixed vs variable costs, expenses vs capital expenditures, etc.
Understanding of web analytics and testing a +++
Expertise with ETL Design and Coding in Data Warehousing and Business Intelligence environments, including the ability to design and execute using industry best practice approaches to ETL with the Microsoft BI Stack (SSIS/SSAS) running on SQL Server 2008R2 and later versions.
Expertise in relational and dimensional data model design for Data Warehouse and Business Intelligence environments, including the ability to design and execute data models using industry best practice approaches for extensibility, ease of use, and performance in the Microsoft SQL Server / BI Stack environment.
Expertise in source systems data structures, change data capture practices, load architectures and target data structures, ETL processes and products.
Expertise in problem-solving with the ability to research, analyze and propose solutions to complex data related issues.
Ability to translate business needs into technical solutions. Expertise in communicating and collaborating on the design and physical implementation of data models with team members and stakeholders.
Other data warehousing and business intelligence skills include working knowledge of: SDLC practices, server and database environment management, data warehouse and BI architecture, data cleansing and data quality management, data governance, master data management.
Microsoft SQL Server, SSIS, SSRS, Data Modeling Software
Microsoft PowerBI and DAX a +++
Employee Benefits:
At Mavis, we understand that our people drive our success. We provide our team members with competitive weekly pay, a good working environment and an excellent combination of additional benefits like health and dental insurance, a 401(k) retirement savings plan with employer match, paid vacations, paid personal and sick time, paid holidays, on-the-job training, and opportunities for career growth and advancement.