Postgres DBA Data Engineer
Apply NowCompany: Nodal Exchange
Location: Dunn Loring, VA 22027
Description:
Postgres DBA Data Engineer
Department: Technology
Employment Type: Full Time
Location: Tysons Corner
Compensation: $110,000 - $150,000 / year
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 Brse 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.).
Skills, Knowledge & Expertise
Requirements:
Preferred:
Salary Range: $110,000 - $150,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.
Job Benefits
Nodal Employee Benefits and Perks: https://nodalexchange.pinpointhq.com
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.
Department: Technology
Employment Type: Full Time
Location: Tysons Corner
Compensation: $110,000 - $150,000 / year
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 Brse 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.).
Skills, Knowledge & Expertise
Requirements:
- Minimum 4+ 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: $110,000 - $150,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.
Job Benefits
Nodal Employee Benefits and Perks: https://nodalexchange.pinpointhq.com
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.