Job: BI Cognos Support/Information Systems Analyst

This posting has expired and is no longer available.

Job Description

# of Openings
Job Locations
Posted Date
Information Systems
Flex-N-Gate Advanced Product Development LLC (MTC)


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.


  • 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


    • 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


    • 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


• 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.

Career Sites by