JOB TITLE
Sr Analyst/Programmer
REQ NUMBER
292547
REQUIREMENTS

 

 

SPECIFIC SKILL SETS REQUIREMENTS:

  • 4+ years experience developing in a Microsoft SQL or Oracle based Business Intelligence environment.
  • 4+ years experience with one or more of the following toolsets
  1. Cognos including version 8 and/or 10 Framework Manager, Report Studio, Analysis Studio, PowerPlay Studio, Transformer and Administrator functions
  2. IBM Ascential DataStage 7.5 ETL components Designer, Director, Manager, Administrator
  3. Microsoft SQL Server Reporting Services (SSRS) 2008R2
  • UNIX experience with shell scripting
  • SQL syntax knowledge with the ability to create basic queries or stored procedures with dynamic SQL
  • Working knowledge of dimensional modeling, the Kimball Business Intelligence (Data

Warehouse)  methodologies and ETL best practices.

  • Experience researching data or report issues and reviewing detailed logic to identify and resolve issues.
  • Detailed and process oriented to follow development standards and enterprise change control requirements.
  • Team player with emphasis on knowledge sharing and demonstrated ability to manage

       multiple assignments simultaneously.

  • Excellent written and oral communication skills necessary to effectively define business and 

       technical requirements while working with Users, Management and Business Analysts.

SPECIFIC SKILL SETS DESIRED, BUT NOT NECESSARILY REQUIRED:

  • Strong business knowledge of Supply Chain data/processes, specifically related to the JD Edwards ERP system.
  • Experience with Cognos Insight, Business Insight Advanced, or mobile
  • Experience with other Microsoft BI tools such as SQL Server Integration Services (SSIS), Analysis Services (SSAS), PerformancePoint, SharePoint

 WHAT EXACTLY WILL THIS INDIVIDUAL BE WORKING ON?

The candidate will be involved with supporting and enhancing existing environments as well as participating in future rollouts for regional Supply Chain Systems BI and global Business Performance Management BI.  Responsibilities will include the following:

 Develop new or modified reports/cubes using Cognos or reports using SQL stored procedures and Reporting Services according to design specifications.

  • Develop new or modified table structures in Oracle and ETL jobs using IBM Ascential DataStage according to source to target documents.
  • Work with Business Analysts to clarify requirements, test report logic and troubleshoot issues during development process.
  • Perform Cognos and DataStage administrator functions as backup to primary.
  • Research user or BA identified report or data issues to troubleshoot and work toward a resolution.
  • Participate in daily/nightly on call support rotation for the Insight and SCS BI Oracle/UNIX/DataStage environments to address ETL job aborts ensuring data accuracy and timeliness.
  • Deploy approved report/ETL code through various environments as dictated by standards and Change Control processes.

 EDUCATION REQUIRED OR DESIRED:

  • Bachelor’s Degree or equivalent work experience

 CERTIFICATION(S) REQUIRED OR DESIRED:

  • Cognos or Microsoft BI certifications desired

FOREIGN LANGUAGE(S) REQUIRED OR DESIRED:

  • Ability to speak a foreign language such as Spanish, Portuguese, Chinese Mandarin or Russian may be helpful but not required.


TRAVEL:  

Potential travel to international subsidiaries depending on need of specific projects, but should not exceed 2 weeks per year.

LOCATION
16251 Dallas Parkway
Dallas TX, 75379-9045
E-MAIL
HRRecp@mkcorp.com
FAX NUMBER
(972) 687-1608