Job Description

Job LocationsUS-MI-Warren
Posted Date1 month ago(10/13/2020 11:42 AM)
ID
2020-6234
# of Openings
1
Category
Information Systems
Company
Flex-N-Gate Advanced Product Development, LLC (MTC)

Overview

Flex-N-Gate is a leading manufacturer and supplier of components for the automotive industry, recently ranked 10th of the 150 Top North American Suppliers in “Automotive News.” A growing and vital company, Flex-N-Gate provides a great opportunity for hard-working and skilled individuals.

Scope of the Position

The Data Warehouse Architect will support the Business Intelligence System and the Corporate Data Warehouse. They will be responsible for the development and maintenance of the Data Warehouse in order to meet the needs of Plant and Corporate Reports.


The candidate should have a strong working knowledge Business Intelligence Fundamentals; Designing Relational Databases, ETL processes, working with data schemas, etc. They will work collaboratively with Senior BI Team members to understand our data systems and ensure data integrity and reliability

Responsibilities

  • Design, create, maintain and deploy the Corporate Data Warehouse using IBM DataStage/QualityStage v11.7
  • Create and apply best practices for data loading and extraction.
  • Develop data architecture, data modeling and ETL mapping solutions within a structured data warehouse environment.
  • Manage the consolidation of data from multiple data sources such as DB2i, MSSQL, MYSQL, Web services, etc.
  • Act as Subject Matter Expert for the design and delivery of BI and reporting solutions using data from the data warehouse.
  • Facilitate requirements gathering and develop simple solutions to meet the immediate and long-term needs of the business customers.
  • Monitor the Data Warehouse and BI Systems performance and integrity. Provide corrective and preventative maintenance as required.
  • Other responsibilities as assigned by the IS Manager.
  • On call availability.

Qualifications

  • 5+ years’ experience in BI and Data Warehouse development
  • Bachelor’s Degree from an accredited college or university in Computer Science, Information Systems, MIS or other related field.
  • Proficient in SQL
  • Strong analytical and problem-solving skills are necessary
  • Working knowledge of ETL Processes and applications such as IBM InformationServer, DataStage
  • Exceptional SQL capabilities using SQL Developer tools
  • Experience with DB2i and other relational databases
  • Experience supporting data transfers between Web Based Applications
  • Proficiency in the following:
    • Dimensional and Relational modeling
    • Data warehousing concepts (DB Semantic modeling, Star/Snowflake schemas, data mining, etc.)
    • HADR concepts to support the synchronization and maintenance of Production, Development and Failover environments for the ETL system and data warehouse.
  • Strong analytical and good communications skills
  • Must be able to diagnose and solve the problems as well as guiding with best practices of trouble shooting methods
  • Understand Logical and Physical data modeling best practices and techniques
  • Experience in developing slowly changing dimensions, error handling and performance tuning.
  • Strong documentation skills using PowerPoint, Excel and/or Visio
  • Detail Oriented, self-motivated and team player
  • Strong Project Management and Application Management skills.

Preferred Skills:

  • DB2i, MSSQL, MYSQL
  • ETL software such as DataStage v11.x or SSIS
  • AS400 and iSeries
  • MS Windows Server 2012+
  • IBM Information Server
  • IBM WebSphere
  • ERP Systems such as Epicor CMS, SAP, JD Edwards, QAD
  • Automotive Industry experience
  • Hyper-V

Benefits

• Medical, dental, prescription, vision, life and disability insurance; and a flexible spending account
• 401(k) retirement savings plan with company match
• Extensive safety training, new hire orientation, continuous learning and development programs and tuition reimbursement
• Paid holidays and vacation time

What do our employees have to say?
“It engages you professionally, and provides learning opportunities.”
“Lots of growth opportunity.”
“The company’s young enough to be exciting, but old enough to be stable.”
Not just a job—a great place to work!

Flex-N-Gate is an equal opportunity employer. EOE/Minorities/Females/Veterans/Disabled.

Application Instructions

Please click on the link below to apply for this position. A new window will open and direct you to apply at our corporate careers page. We look forward to hearing from you!

Apply Online