Business Intelligence & Analytics/Data Warehouse Manager

Jacobs Engineering Philadelphia , PA 19107

Posted 3 months ago

The Buildings & Infrastructure Line of Business is a global network of employees, which serves both the private and public sector. Our employees work to shape the communities we live in by creating world-class projects that transform the future development patterns of those communities. We provide our clients award-winning planning, engineering, architectural and interior design, construction and program management, and design-build project delivery. The Jacobs business model allows us to successfully service our clients, leverage our integrated services, and provide our employees with growth opportunities while delivering global solutions to our client's local programs.

We consistently receive high rankings from Engineering News-Record (ENR) in many classifications, including the categories of Top Design Firms, Top Contractors, Top Green Buildings Design Firms, and Top Transportation Companies.

The Business Intelligence & Analytics (BIA) Manager is responsible for managing the Data Warehouse and Business Intelligence systems at the Division of Aviation (DOA). The BIA Manager will design data models for the data warehouse and establish processes for introducing new datasets into the data warehouse.

The BI Architect will lead the DOA Business Intelligence team.

  • 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 for adding a new data source to the data warehouse based on best practices

  • Design templates for the 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 for 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


in Computer Science, Information Technology or a closely related field is preferred

  • Minimum of 5 years Data Warehouse/Business Intelligence Architect experience working on multiple, large, cross-functional teams or projects is required

  • 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 for building interactive dashboards connected to different data sources

  • Experience working in both Waterfall and Agile SDLC projects

  • Establish and maintain effective working relationships with associates, departmental officials, outside consultants and vendors.

  • 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

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Data Analytics Scientist

Axalta Coating Systems

Posted 5 days ago

VIEW JOBS 2/14/2020 12:00:00 AM 2020-05-14T00:00 Overview THE COMPANY Axalta Coating Systems Ltd. ("Axalta," or the "Company"), is a leading global manufacturer, marketer and distributor of high-performance coatings systems. With over a 150-year heritage in the coatings industry, Axalta is known for manufacturing high-quality products with well-recognized brands supported by market-leading technology and customer service. Over the course of the Company's history, Axalta has remained at the forefront of the industry by continually developing innovative coatings technologies designed to enhance the performance and appearance of customers' products, while improving the customer's productivity and profitability. Axalta's diverse global footprint of 50 manufacturing facilities, four technology centers, 47 customer training centers and more than 14,000 team members allows the Company to meet the needs of customers in over 130 countries. Axalta serves its customer base through an extensive sales force and technical support organization, as well as through approximately 4,000 independent, locally-based distributors. The Company's scale and strong local presence are critical to its success, allowing leverage of the technology portfolio and customer relationships globally while meeting customer demands locally. Axalta operates its business in two operating segments: Performance Coatings and Transportation Coatings, serving four end markets, including: Refinish, Industrial, Light Vehicle and Commercial Vehicle, across the following four regions: North America, EMEA, Latin America and Asia-Pacific. Primary Responsibilities Axalta Coating Systems is seeking an Data Analytics Scientist that develops and implements data collection, analysis, and modeling systems for the large databases supporting Color research and development, primarily for the Automotive OEM and Refinish businesses. A "Large Database" is defined as one with incomplete data, hundreds of variables and hundreds of thousands of data entries, beyond the data-analysis capabilities of routine tools or non-expert scientists. The Data Scientist also works closely with the Global Color Technology R&D group as well as other R&D groups, advising and consulting on technical programs where the complexity exceeds that which can be handled by commonly used analysis tools. Additionally, the scientist will be an analysis resource to marketing, manufacturing, business and information technology. Technology delivery of Color for internal uses is primarily done through the Axalta Color System software. This large and complex system interfaces with multiple data sources including Ingredient, Manufacturing, Refinish Formula and Customer Formula Delivery systems. This position will work closely with global users of these systems as well as resources in the Color Science group and Color System support team and software, instrument or imaging suppliers to ensure the data is analyzed to provide valid technical/business actions. Other responsibilities are to consult on key technical and business applications which involve large quantities of complex data; examples include: * Empirical modeling in applications such as color prediction modeling, property prediction modeling, and polymer structure property modeling. * Business modeling, e.g. customer demand forecasting for production and inventory planning. * R&D experiment design and analysis for complex projects. * Database mining to evaluate color or quality system performance.The successful candidate will join Axalta's Global Innovation Center (GIC) in Philadelphia, PA. The GIC group develops high performance coatings for the Transportation, Refinish, and General Industrial markets. Key Responsibilities: * Applies leading-edge data analysis methods to the development and use of color data systems as well as to manufacturing, research or product design projects. Applies quantitative color and appearance measurements to analyze and interpret results. * Develop physical and empirical property models of color and paint formulations. * Networks with global business, marketing, manufacturing, technology and information technology personnel and participates in working teams of Global Color management. * Consults on advanced analysis/statistics projects across the technical organization. * Consults as needed on business-driven data analysis. * Networks with external resources in academia, professional societies, suppliers and customers to gather and apply new data analysis methods which can be practically utilized in meeting technical and business objectives. #LI-GM1 Minimum Requirements * MS or PhD degree in Chemical Engineering, Physics, or related field with extensive research experience in application of data analytical methods to business and technical problems, including the practical ability to design data collection and apply data analysis tools. * Experience in theoretical and empirical modeling, statistics, analytics systems development and implementation. Experience with physical modeling in chemical formulation environment desired. * Experience with Color Technology data, systems and tools desired. * Expertise in commonly used programming and scripting languages for data analytics (Python, Matlab, R, etc.) and database querying (SQL). * Demonstrated ability to analyze large-scale databases leading to implemented actions for technical or business applications. * Effective written and oral communications. * Ability to work with cross-function teams as expert resource, developer or leader as needed. * Early career from 0 to 3+ years of experience. Key Behavioral Competencies: * Action and results oriented. * Strong business acumen * Ability to take complex, disparate information and translate into executive summaries. * Excellent organizational & relationship management skills * Ability to multitask and prioritize work in a self-directed capacity * Ability to balance the potentially competing needs of multiple customers in a matrix environment * Outstanding communication skills and ability to operate across countries, communicate and coordinate effectively across organizational boundaries * Ability to positively influence others, create a passion for excellence, and execute multiple projects while meeting customer expectations * Project Management knowledge and capability Axalta Coating Systems Philadelphia PA

Business Intelligence & Analytics/Data Warehouse Manager

Jacobs Engineering