Job Title: Sr. System Analyst
Job Duties: Prepare technical specification documents used by support team to maintain ETL
jobs in production. Design automated and self-service reporting solutions; develop data
visualizations for business users. Create specifications for reports and analysis based on business
needs; produce datasets and reports for analysis using system reporting tools. Interface between
business and divisional data teams to generate tools to be leveraged in building analysis and
reports which are actionable within the business environment. Analyze complex business
problems and issues using data from internal and external sources; identify and interpret trends
and patterns in datasets to locate influences. Design, develop and build DataStage parallel jobs
and job sequences using DataStage designer and director. Develop UNIX shell scripts to support
DataStage jobs. Test and debug issues with DataStage jobs and UNIX shell scripts. Work with
Business Analysts for data profiling and to make data mapping documents. Document DataStage
jobs and test cases. Populate Data Warehouse per business requirements using DataStage and
appropriate architecture/schema available. Use IBM Datastage, Quality Stage, MS SQL Server
Integration Service, Teradata , Oracle, MS SQL Server, IBMDB2, Hadoop, Spark, C, C++, SQL,
PL/SQL, SQL*Plus, SQL*Loader, TOAD, Oracle SQL Developer, Zena, AutoSys, Tivoli,
Serena, Dimensions CM, KORN, Bash.
​
Work Location: Various unanticipated work locations throughout the United States; relocation
may be required. Must be willing to relocate.
​
Minimum Requirements:
Education: Master – Computer Science
Experience: One (1) year