Job: BI Cognos Support/Information Systems Analyst

Click Here toApply Online

Posted: 03/23/2017

Job Reference #: 2596

Job Description

ID
2016-2596
# of Openings
1
Job Locations
US-MI-Warren
Posted Date
2/8/2017
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 BI Cognos Support Technician will assist in daily maintenance of the corporate Business Intelligence initiative. They will be responsible for development and maintenance and design of various BI reports, dashboards and scoreboards to meet business needs.

The candidate should have strong working knowledge business intelligence fundamentals; ETL processes, database schemas, development of reporting packages, and report writing. They will work collaboratively with Senior BI Team members to understand our data systems and ensure data integrity and reliability.

Responsibilities:

  • Develop Cognos Business Intelligence reporting, dashboards, analysis, and ad-hoc reports.
  • Design, develop, and unit test standard and ad-hoc reports.
  • Validate the data warehouse feeds into the reporting tools.
  • Work to enable business partners in the development of their own reports and dashboard
  • Monitors queries and report behavior to assure performance expectations are met.
  • Develops and/or implements Cognos BI report development best practice standards.
  • Assess existing Cognos code and determine refactoring
  • Develop and monitor ETL processes using IBM Data Stage 9.1
  • Develop and monitor IBM QReplications processes

Qualifications:

    • Working knowledge of Cognos 10 or similar Business Intelligence (BI) report writing tools
    • Understanding of Datastage 9.x or equivalent ETL software
    • Experience developing integration objects using ETL and/or ESB tools like: Mulesoft, Informatica, Tibco, Websphere MQ, IBM Integration Bus, Dell Boomi etc.
    • Experience with DB2 or other relational databases.
    • SQL capabilities using SQL Developer tools
    • Technical writing like Process Flow, Business Process, and Application Support documentation using PowerPoint, Excel and Visio
    • Proficiency in the following:
      • Analytical, process, and problem solving skills to help with tuning report visualizations
      • Dimensional and Relational modeling
      • Data warehousing concepts (DB Semantic modeling, Star/Snowflake schemas, data mining, etc.)
      • Creation of new/modifying report prototypes and building automated reporting solutions
    • Detail Oriented
    • Self-motivated
    • Good communications skills

    Qualifications

    • 2+ years’ experience in BI Reporting 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

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
 
Career Sites by Recruiting.com