Systems Software Analyst / Engineer (ETL/Teradata)

comtecinfo; Raleigh (NC); On-site; Full time

Job summary

A data solutions company is seeking a Systems Analyst to support the end-to-end development of data warehouses. Responsibilities include requirements gathering, project documentation, and production support, alongside the need for strong analytical and communication skills. The role requires a Bachelor's Degree and at least 5 years of relevant experience, with knowledge of Teradata and SQL necessary. Candidates should be local to Raleigh, NC, and able to obtain public trust clearance. This is a full-time position with an M-F schedule and some on-call responsibilities.

Qualifications

• 5 years experience developing Data Warehouses, or equivalent experience.
• Strong knowledge of database analysis and SQL design for Teradata version 14 and above.
• Must be able to obtain Position of Public Trust clearance.

Responsibilities

• Requirements gathering for data warehouse projects.
• Document project lifecycles ensuring compliance.
• Provide production support for applications.

Skills

Data warehouse modeling and development experience

Strong analytical and problem solving skills

Excellent communication skills

Experience with performance tuning

Knowledge of AGILE methodology

Education

Bachelor's Degree

Tools

Teradata

SQL

UNIX

Windows

Linux

Ab Initio

Job description

• Full-time

Job Description

This position will support the data warehouse from end to end including requirements and design, specification review, development, deployment and documentation. Candidate will provide analysis, guidelines and assistance during requirements gathering, review final code before transitioning into production. The ideal candidate will have strong analysis and documentation skills as well as ability to interact with customers and other team members using AGILE methodology. This is a first shift M-F job with occasional on-call pager rotation.

Roles and Responsibilities

• Requirements gathering
• Systems Analyst and Design
• Strong analytical and problem solving skills
• Data warehouse modeling and development experience
• Create ETL Detail Design in Teradata environment
• Perform process and performance tuning
• Document project lifecycles and ensure SOX compliance
• Provide production support for applications.

Basic Qualifications

• Bachelor's Degree and 5 years experience developing Data Warehouses. Additional experience in lieu of a degree will be considered.
• Strong knowledge of database analysis and SQL design for Teradata version 14 and above.
• Strong knowledge of Teradata utilities including MLOAD, Fastload and TPUMP and new features.
• Strong Data Warehouse and Data Modeling experience.
• Strong UNIX experience.
• Knowledge of Windows, and Linux operating systems.
• Excellent communication skills as position require interaction with customer.
• Research, troubleshooting and problem solving skills.
• Experience with performance tuning and space reclamation.
• Must be able to obtain Position of Public Trust clearance.

Preferred Qualifications

• Teradata Certification.
• Knowledge of Ab Initio.
• UNIX Shell Scripting.
• Test script creation and documentation.
• Experience or knowledge of AGILE methodology.
• Local to the Raleigh, NC area.

Qualifications

Bachelor's Degree and 5 years experience developing Data Warehouses. Additional experience in lieu of a degree will be considered.

Additional Information

All your information will be kept confidential according to EEO guidelines.

Job Location