Senior Postgres DBA Data Engineer

Job Description

Description

Nodal Exchange, the largest power futures exchange in North America, is a derivatives exchange providing price, credit and liquidity risk management to participants. Nodal Exchange is a leader in innovation, having introduced the world's largest sets of environmental and electric power futures and options contracts. All transactions on Nodal Exchange (power, environmental and natural gas) are cleared through its wholly owned subsidiary, Nodal Clear, using its award-winning portfolio margining methodology. As leaders in innovation, Nodal Exchange and Nodal Clear have built in-house most of the trading and clearing platforms that fuel our business. Nodal Exchange is part of the EEX Group which is in turn part of the Deutsche Börse Group.

We are now looking for talented, innovative individuals to join our team in Tyson’s Corner, VA (DC Metro area).

Key Responsibilities

Primary responsibilities include:

Postgres Data Engineer

The TechOps team scope at Nodal Exchange covers all data services within the organization including production database management, data transformation processes, reporting infrastructure, test data management, data modeling, and more. Across these areas, Nodal seeks to use a project delivery model in which the TechOps team takes responsibility for identifying needs and opportunities and designing solutions, then implementing and deploying them, following up with ongoing monitoring and continuous improvement.

Nodal seeks candidates who have significant experience with technology delivery and database administration but seek to advance their career by deepening their skills across infrastructure/networking and continuously improving Nodal’s data architecture.

This candidate will be responsible for providing Data support to teams across the company. The candidate is also expected to provide responsive database operational support and modernize data warehouse and reporting solutions. You will be part of a team with cross-divisional responsibility for Data Warehousing, Data Self Services, Big Data and Data Science within a regulated environment. The candidate is expected to be able to fully understand all components of data architecture (physical/logical replication, monitoring, provisioning, performance tuning at both SQL/system levels, etc.).

The candidate is willing to participate in on-call rotation in line with the industry practices. Note that this position is overtime-exempt position.

Skills, Knowledge and Expertise

Requirements:

Minimum 5-7 years’ experience with database administration including operation, administration (patching, backup/restore, replication), and SQL performance tuning

Expert understanding of how database internals function (Write-Ahead Logging, Point-in-time recovery, database optimizers, query planning and optimization, etc.)

Strong Linux experience

Excellent communication skills

Experience using JIRA, Confluence

Bachelor’s degree or higher in CS, MIS, Mathematics, or related field

Familiarity with cloud technologies like AWS’ data offerings

Up to date with latest developments in database technology (PostgreSQL or whichever RDBMS they work with most frequently)

Experience building ETL Pipelines

Capable of being part of a team with on-call responsibilities for after-hours emergencies

Preferred:

Experience with data obfuscation (masking)

Experience migrating data solutions from on-premises servers to Cloud

Experience using Python and/or R

Familiarity with Ansible and Terraform

Salary Range: $120,000 - $160,000 per year base salary, when annualized

Pay Transparency Notice: The salary range is based on the D.C. metro area, the successful candidate’s starting salary will vary depending on permissible, non-discriminatory factors including but not limited to qualifications, skills, and experience. Nodal also offers a wide range of benefits and perks for full-time employees, which may include target bonuses.

Benefits

Nodal Employee Benefits and Perks:

Nodal Exchange, LLC does not discriminate on the basis of race, color, religion, sex, gender, sexual orientation, gender identity or expression, pregnancy, parental status, marital status, citizenship, national origin, age, disability, genetic information, military status, veteran status, physical or mental health, hairstyle, or any other characteristic protected by federal, state or local law with respect to recruitment, hiring, training, promotion, or in any other terms and conditions of employment. Nodal Exchange is an E-verify participant.

Full-time