Director Business Intelligence

2 weeks ago

White Plains, United States Mavis Tire Full time

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.

Mavis is an Equal Opportunity Employer

  • Director Business Intelligence

    2 weeks ago

    White Plains, United States Mavis Tire Full time

    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...

  • Director Business Intelligence

    2 weeks ago

    White Plains, United States Mavis Tire Full time

    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...

  • Director Business Intelligence

    1 day ago

    White Plains, United States Mavis Tire Full time

    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...

  • Business Intelligence Intern

    2 weeks ago

    White Plains, United States Mast-Jägermeister US Full time

    Job DescriptionJob DescriptionMast-Jägermeister US is seeking highly motivated and detail-oriented Summer Business Intelligence Intern to join our team. As an Analyst Intern, you will assist the Business Intelligence team by strategically supporting the organization generating key insights and integrating data from a variety of sources: Power BI, VIP, Pro...

  • Business Intelligence Manager

    2 weeks ago

    White Plains, United States Mast-Jägermeister US, Inc. Full time

    Position Summary: As a Business Intelligence (BI) Manager you will lead a team that strategically supports the commercial organization by integrating data from a variety of sources, generating key insights.  You love large projects, working cross functionally and are always seeking to better understand the nuances of the business so you can improve process...

  • Business Intelligence Manager

    2 weeks ago

    White Plains, United States Mast-Jägermeister US Full time

    Job DescriptionJob DescriptionPosition Summary:As a Business Intelligence (BI) Manager you will lead a team that strategically supports the commercial organization by integrating data from a variety of sources, generating key insights. You love large projects, working cross functionally and are always seeking to better understand the nuances of the business...

  • Business Intelligence Intern

    4 weeks ago

    White Plains, New York, United States Mast-Jägermeister US Full time

    Mast-Jägermeister US is seeking highly motivated and detail-oriented Summer Business Intelligence Intern to join our team. As an Analyst Intern, you will assist the Business Intelligence team by strategically supporting the organization generating key insights and integrating data from a variety of sources: Power BI, VIP, Pro Diver, and IRI.   This...

  • Business Intelligence Manager

    3 weeks ago

    White Plains, New York, United States Mast-Jägermeister US Full time

    Position Summary: As a Business Intelligence (BI) Manager you will lead a team that strategically supports the commercial organization by integrating data from a variety of sources, generating key insights.  You love large projects, working cross functionally and are always seeking to better understand the nuances of the business so you can improve process...

  • Business Support Analyst

    7 days ago

    White Plains, United States iSoftStone Full time

    Formulate and apply mathematical modeling and other optimizing methods to develop and interpret information that assists management with decision making, policy formulation, or other managerial functions. Collect and analyze data and develop decision support software, service, or products. Develop and supply optimal time, cost, or logistics networks for...

  • Regional Director

    3 weeks ago

    White Plains, United States Pentegra Services, Inc. Full time

    Job DescriptionJob DescriptionThe base salary range for this role is $80,000 to $100,000. Base salaries are determined during our interview process, by assessing a candidate’s experience, skills against internal peers and against the scope and responsibilities of the position.Earnings potential, based on commissions, can total upwards of an additional...

  • Business Development and Marketing Manager

    3 weeks ago

    White Plains, United States Madison Approach Full time

    Job DescriptionJob Description Job Title – Business Development and Marketing Manager Basic Purpose:*#zrThe Business Development and Marketing Manager will develop and implement sales and marketing strategies that will target and grow company's programs and trainings. This is a customer facing role with a focus on building and maintaining relationships...

  • Director of Marketing

    2 days ago

    White Plains, United States Symphony Wireless Full time

    Symphony Wireless LLCJob Description – Director of MarketingReports to: SVPThe CompanySymphony Wireless acquires, manages, and leases rooftop, tower and other telecommunication cell sites interests in urban, suburban, and rural environments throughout the United States. Symphony operates as one of the largest privately held owners of these sites across the...

  • Tax Director

    3 weeks ago

    White Plains, United States UCare Staffing, LLC Full time

    Job Description Job Description JOB TITLE: Tax Director OFFICE LOCATION: White Plains, NY PLEASE NOTE: All interviews are kept confidential. SUMMARY/OBJECTIVE Our client, an outstanding and reputable Private Legal & Accounting Firm is seeking a tax leader. This candidate will be responsible for the firm’s tax compliance, tax planning and accounting for...

  • GUCCI Associate Store Director

    2 weeks ago

    White Plains, United States Aztec Full time

    Summary If you are a Dream-maker, this is the place for you. Together, we’ll create the real fabric of Gucci. A community of people united by the same passion: breaking new ground in the fashion world and beyond. Job Description Role Mission As a Gucci Associate Store Director, you will effectively lead and support all activities to achieve store business...

  • Tax Director

    6 days ago

    White Plains, United States UCare Staffing, LLC Full time

    Job DescriptionJob DescriptionJOB TITLE: Tax DirectorOFFICE LOCATION: White Plains, NYPLEASE NOTE: All interviews are kept confidential. SUMMARY/OBJECTIVEOur client, an outstanding and reputable Private Legal & Accounting Firm is seeking a tax leader. This candidate will be responsible for the firm’s tax compliance, tax planning and accounting for...

  • Tax Director

    1 month ago

    White Plains, United States UCare Staffing, LLC Full time

    Job DescriptionJob DescriptionJOB TITLE: Tax DirectorOFFICE LOCATION: White Plains, NYPLEASE NOTE: All interviews are kept confidential. SUMMARY/OBJECTIVEOur client, an outstanding and reputable Private Legal & Accounting Firm is seeking a tax leader. This candidate will be responsible for the firm’s tax compliance, tax planning and accounting for...

  • Senior Director, Finance

    4 days ago

    White Plains, United States Sabra Full time

    Sabra makes America's most iconic and beloved hummus and a delicious range of plant-based dips and spreads. We are dedicated to uniting and delighting the world around planet-positive food. Sabra was founded in 1986 in Astoria, Queens and is headquartered in White Plains, New York. Sabra's 500+ team members proudly produce hummus in Chesterfield County,...

  • Business Development Director

    7 days ago

    White City, United States Data Electronic Devices Full time

    Job Description Job Description Ascentron ( an Emerald Technologies company ) has an exciting opportunity for a Business Development Director to join their team remote from the Seattle Area! The Business Development Director will be responsible for the development and execution of the Target Account Strategy, the direction and coordination of customer...

  • Business Development Director

    3 days ago

    White City, United States Data Electronic Devices Full time

    Job Description Job Description Ascentron ( an Emerald Technologies company ) has an exciting opportunity for a Business Development Director to join their team remote from the Seattle Area! The Business Development Director will be responsible for the development and execution of the Target Account Strategy, the direction and coordination of customer...

  • Business Development Director

    3 weeks ago

    White City, United States Data Electronic Devices Full time

    Job DescriptionJob DescriptionAscentron (an Emerald Technologies company) has an exciting opportunity for a Business Development Director to join their team remote from the Seattle Area! The Business Development Director will be responsible for the development and execution of the Target Account Strategy, the direction and coordination of customer...