Performance Data Engineer

Job Title: Performance Data Engineer
Job Location: Raleigh, NC – preferred; Remote – Open
Eligibility/Clearance: Must be authorized to work in the US

Job Description: The Data Asset Services organization is responsible for
the full lifecycle of ETL (extract, transform, load) application
development, enhancement, and maintenance. This includes system and
problem analysis, coding and system modifications, configuration
management and change control, test script development, validation of
program changes, application documentation, and implementation of
security safeguards in accordance with government standards.

HOW A PERFORMANCE DATA ENGINEER WILL MAKE AN IMPACT

-Provides data modeling expertise and performance-tuning guidance to
optimize ETL workloads and database queries, including those supporting
MicroStrategy reporting within the EDS Application.

-Lead the engineering of a scalable, cloud-based Data Lakehouse
platform, known internally as the Unified Analytics Platform (UAP),
powered by Databricks and hosted in Microsoft Azure to enhance
enterprise data governance, observability, and operational value.

-Application development and maintenance efforts that provide direct
technical assistance.

-Provide remote support on a 24×7 on-call basis. This will provide
support for production server applications, installation and upkeep of
ETL solutions, and the delivery of complementary services required to
meet customer and business needs.

WHAT YOU’LL NEED TO SUCCEED:

Education:

-Bachelor’s degree in Computer Science, or a related field is highly
preferred.

Experience:

-15+ years of hands-on data modeling and querying experience

Required Skills and Abilities:

-Focus on development and maintenance of applications providing ETL
services in support of the Postal Data Asset Services group.   

-Significant experience with the Teradata optimizer is required

-The ability to read SQL “explain” plans and take action to effectively
utilize the massive parallel nature of the database engine.

-Must have Teradata SQL, due to business logic embedded in the queries.

-Must have a thorough understanding of the internal “DBC Accounting”
information to effectively measure the performance of application code.

Desired Skills and Abilities:

-A working knowledge of how MicroStrategy and other OLAP tools interact
with Teradata.

-Knowledge of Ab Initio tools, architecture, process and analytics

-A working knowledge of the major competing Data Warehouse modeling
techniques (Third-Normal-Form and Dimensional modeling) and how data
modeling decisions affect the performance of ETL, structured report
queried, and unstructured data analysis.

-A working knowledge of GDE (Graphical Development Environment - used by
Ab Initio)

-A working knowledge of Web API development.

-A working knowledge of storing, reading and analyzing streaming data –
i.e., Kafka, MQSeries, or similar technologies, such as JMS.

-A working knowledge of Cloud technology - developing and architecting.

Location:

-Raleigh, NC (Preferred)

-Remote Considered

Arena Technical Resources, LLC, (ATR) is an Equal Opportunity Employer
(EOE) who will provide equal employment opportunity to employees and
applicants for employment without regard to race, ethnicity, religion,
color, sex, pregnancy, national origin, age, veteran status, ancestry,
sexual orientation, gender identity or expression, marital status,
family structure, genetic information, or mental or physical disability.