Current Job Opportunity

Business Intelligence & Analytics Manager

Location
Philadelphia, PA
Category
Consulting - Engineering
Career Level
Manager
Type
Full-time
Delon Hampton & Associates, Chartered a minority-owned, professional consulting engineering services firm, currently has an excellent opportunity for a talented and energetic, Business Intelligence & Analytics Manager (BIA).

Responsibilities

Candidate will be responsible for managing the Data Warehouse and Business Intelligence systems for one of our clients. The BIA Manager will design data models for the data warehouse and establish processes for introducing new data-sets into the data warehouse.

  • Improve and maintain data warehouse and business intelligence solution
  • Participate in design sessions with System Architects to determine appropriate schema designs for business systems
  • Establish the use of master data records by enterprise systems to prevent data inconsistencies
  • Analyze enterprise data use cases and design data warehouse data models based on determined data needs
  • Identify and appropriately handle confidential data in compliance with organizational policies
  • Design and document a standard end-to-end process of data source identification through to loading data into the data warehouse
  • Develop and document source-to-target mapping for various data sources
  • Design standardized tests to analyze and validate incoming data from various data sources
  • Manage the enterprise data catalog
  • Lead the design of scalable Data Models for applications based on business requirements
  • Lead the Data Warehouse team in consolidation of data from different data sources and business systems
  • Establish and maintain effective working relationships with associates, departmental officials, outside consultants and vendors

Qualifications

  • Completion of a Bachelor's degree program at an accredited college or university with a major course work in Computer Science, Information Technology or a closely related field
  • Minimum of 5 - 7 years Data Warehouse/Business Intelligence Architect experience working on multiple large, cross-functional teams or projects
  • 5 - 8 years of applicable business experience
  • Knowledge of Azure cloud technologies such as Data Factory, MS SQL service, Web Apps, Data Warehouse
  • Knowledge of data integration using APIs, Web Services, and other methodologies
  • Experience using Azure functions to automate data integrations
  • Experience working with Power BI or building interactive dashboards connected to different data sources
  • Experience working in both Waterfall and Agile SDLC projects
  • Prior experience working on Data Warehouse and Business Intelligence projects
  • Ability to write SQL stored procedures, write ETL scripts, and perform other hands-on tasks when necessary is a plus

Special Instructions

When applying, please reference position title in email subject line. Send all resumes to: hr@delonhampton.com

Delon Hampton & Associates is an Equal Opportunity Employer for VEVRAA protected veterans and all other protected classes. DHA is an equal opportunity/affirmative action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability, protected veteran status, gender identity or sexual orientation. We encourage minorities, women, protected veterans and disabled individuals to apply. Click here for EEO law and policy.

Questions about working at our firm?
contact us