Data Warehouse/Business Intelligence Specialist - (PF11251)

If you want a career that offers growth, opportunity and inspiration, consider what is waiting for you at Johns Manville. We've been developing leading edge commercial, industrial and residential building products for almost 150 years, and we're just getting started. Found in many of the world's largest commercial buildings and all around you, our innovative products insulate, shelter, strengthen and protect in order to make the world a better place. As a $2 billion member of the Berkshire Hathaway family of companies, Johns Manville has the resources and vision for extraordinary growth. We seek highly talented individuals to join our dynamic, financially stable company.

SUMMARY OF POSITION:

Johns Manville is currently seeking qualified applicants for the position of Data Warehouse / Business Intelligence Specialist to be located in our corporate offices in downtown Denver, CO. This position is best suited for someone possessing SAP BW experience or a background in Data Warehouse ETL and Business Intelligence Development and looking to grow their skill set to include SAP's Business Intelligence (BW 7) by actively participating in the Johns Manville SAP implementation.

KEY RESPONSIBILITIES:


Actively participate in the overall JM Data Warehouse/Business Intelligence Strategy

Develop Business Intelligence solutions within an SAP Business Intelligence environment

Design, implement and support security for worldwide information applications within SAP BI/BW

Design and execute data extracts from R/3

Create all objects and mappings from R/3 to BW

Create custom developed validation rules and generic extracts to support customization in ODS and InfoCube objects

Build/maintain process chains (workflow) to load the data

Monitor production loads and conduct root cause analysis for all load failures

Reviews and participates in data design, tool design, data loads, and presentation system design

Provides input, recommendations, and resolutions for technical issues

Work with customers, business analysts and technical staff to design, develop and enhance data warehouse components, business intelligence solutions, and procedures

Analyze and understand business requirements to produce development deliverables that support and comply with design and architectural specifications

Perform periodic maintenance on existing Data Warehouse implementation including, but not limited to, Informatica ETL, UNIX Shell Scripts and Autosys batch scheduling

Actively address business unit requests, clearly communicating commitments, issues, completion dates and status with the requestor and with management

Document and conduct unit and system testing as it pertains to new BI/BW development and maintenance

May review technical work of other team members for quality assurance

Develop and implement process improvements

Identification and resolution of data integrity issues

Definition of the design and functionality of analytical reporting front-ends

Development and execution of system test plans

Participate in project delivery and roadmap development

Coach/mentor team members on SAP Business Intelligence solutions

Additional responsibilities will include data cleansing, data quality analysis and business rules automation

Other duties as assigned by manager

MINIMUM QUALIFICATIONS:


At least four years working experience in a Data Warehouse development environment

Must possess a solid understanding of Data Warehouse concepts and strategies

Experience in report design and report development using enterprise Business Intelligence toolsets required (i.e. Hyperion/Brio, Cognos or Business Objects)

Experience in data integration methods from heterogeneous data sources, including legacy databases, employing data transformation standards and best practices

Strong SQL skills required

Must be self-motivated, have a strong team orientation, learn quickly and possess excellent communication and interpersonal skills.

Must be highly committed to data integrity

Solid analytical, problem identification and resolution skills

Internal consulting, presentations and recommendations, end user education

Proven track record for working effectively with technical and business functions

Experience working with multi divisional business communities to leverage information across the enterprise to improve business effectiveness

DESIRED QUALIFICATIONS:

Basic understanding of Informatica Powercenter 7.x

Basic understanding of Hyperion Business Performance Suite 8.x

Basic understanding of SAP BW 3.x

UNIX Schell Scripting

Experience using enterprise scheduling tools (i.e. Autosys, TidalSoft, etc.)


We are proud to be an EEO/AA employer M/F/D/V. We maintain a drug-free workplace and perform pre-employment substance abuse testing.

************************************************
TO APPLY FOR THIS JOB

Click (or copy and paste) the following Link/URL into your browser address bar to be redirected to our job posting website and our online Indication of Interest form. Please do not click on any buttons or other links displayed on this page. As an equal opportunity employer, Johns Manville strongly encourages qualified minority and female applicants to apply. JM offers a competitive salary and benefits package. Pre-employment drug testing and background check required.


See Job Description