Job Type

Full-Time

Career Level

Mid-Senior Level

Education

Bachelor's Degree

Travel

None

Security Clearance Required

Ability to obtain and maintain a U.S. Security Clearance

Job Description

At Lifescale Analytics, we help achieve data-driven decisions by leveraging strategic technologies to create innovative solutions that ultimately help our clients to navigate their ever-changing data landscape. We have an opportunity for a Performance Data Engineer, located in Raleigh, NC. Candidate must be able to be onsite and must be able to pass a government security clearance. Candidates will work full-time onsite for the first 2 months and then move to hybrid onsite for 2 days and remote 3 days.

Applicants responding to this position must be a US Citizen and will be subject to a government security investigation and must meet eligibility requirements by currently possessing the ability to view classified government information. The candidate must have lived in the United States for the past 5 years.

The Employer will not sponsor applicants for any employment visas, at hiring or in the future, including but not limited to H-1B visas. Corp-to-Corp or subcontract personnel will not be considered for this position.

Description:

• Under general supervision, responsible for product support and maintenance of the data warehouse.
• Performs data warehouse design and construction.
• Codes and documents scripts and stored procedures.
• Designs and implements data strategy methods.
• Develops appropriate programs and systems documentation.
• Assists with metadata repository management.
• Prepares and implements data verification and testing methods for the data warehouse.
• Creates index and view scripts.
• Performs all functional duties independently.
• Works on high-visibility programs, or mission critical aspects of assigned program(s).
• Oversees the efforts of direct reporting resources and/or is responsible for the efforts of all staff assigned to a specific job.

Job Requirements

Responsibilities/Skill Requirement:

• A minimum of ten (10) years’ experience in software development or related field, with at least 5 years in a data warehouse environment and/or related field
• Able to perform all functional duties independently on high-visibility programs, or mission critical aspects of a given program
• Able to oversee the efforts of direct reporting resources and/or be responsible for the efforts of all staff assigned to a specific job
• Experience training/mentoring less experienced personnel
• Extensive experience with data warehouse design, construction, and/or maintenance, to include design and implementation of data strategy methods, coding and documentation of scripts and stored procedures, and creation of index and view scripts
• Extensive experience with development of data warehouse program and system documentation
• Able to assist with metadata repository management
• Extensive experience preparing and implementing data verification and testing methods for data warehouses
• Able to obtain a government clearance
• Excellent communication skills

• Specific ability with the following languages, tools and utilities is required:
  • • • • Ab Initio ETL Coding in GDE
        • Ab Initio Metadata Hub Lineage
        • Ab Initio TRMC
        • ANSI SQL and Teradata SQL extensions
        • Teradata SQL Assistant (a.k.a. QueryMan) for EDS Support

• Teradata Utilities for EDS Support:
  • • • • BTEQ
        • FastLoad
        • MultiLoad
        • FastExport
        • TPump

• Azure/Databricks Support:
  • • • • Cloud operations
        • Cloud Governance
        • Data Engineering
        • Platform Engineering
        • Data Integration
        • Data Observability
        • AI/ML

• In addition, the following UNIX skills are required:
  • • • • UNIX commands and concepts in order to navigate source code directories, find error logs, perform impact analysis assessments, edit code, version files
        • Linux Shell scripting in order to read and create driver scripts

• In addition, the following Ab Initio skills are required:
  • A working knowledge of how Ab Initio conducts data extract, transformations, and loading – especially to and from Teradata
  • Development of graphs, plans, PSETs and how to develop tests and debug
  • PDL scripting

Education:

• A degree from an accredited College/University in Software Engineering, Computer Science, or related discipline is preferred.

Additional Provisions:

• Pass both a client mandated clearance process which includes drug screening, criminal history check and credit check.
• Candidate must have lived in the United States for the past 5 years.
• Cannot have more than 6 months’ travel outside the United States within the last five years. Military Service excluded. (Exception does not include military family members.)
• The enforced dress code is business casual, i.e., collared shirt with slacks for men, no skirts above the knee for women.

We are equal opportunity/affirmative action employers, committed to diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, gender identity, sexual orientation, national origin, disability, or protected veteran status, or any other protected characteristic under state or local law.