Senior DBA / Data Modeler / Data Engineer

PingWind; United States; On-site; USD 121,000 - 168,000; Full time

Benefits offered by this job

Eleven Federal Holidays

Paid Time Off

Parental Leave

Medical plan options

Dental Insurance

Vision Insurance

Disability Insurance

Life Insurance

401k matching

Education assistance

Flexible Spending Accounts

Employee Assistance Program

Wellness programs

College savings plan

Legal Insurance

Pet Insurance

Job summary

PingWind is seeking a DBA/Data Modeler/Data Engineer to design, manage, and optimize data activities supporting the FSA IAM systems in a remote, USA-based role. You will help transition legacy AIMS and PAS data to a modern cloud-centric IAM solution and oversee ongoing operations.

The role requires a Bachelor's degree, 10 years of experience, and Public Trust clearance. You will craft data models, mappings, dictionaries, and automated data-sharing processes while ensuring secure handling of PII

Qualifications

• Strong expertise in database administration, data modeling, and data engineering.
• Experience creating detailed data models, mappings, and dictionaries.
• Proficiency with data migration and transition planning in complex systems.
• Knowledge of secure data handling, encryption, and PII protection.
• Skills in performance tuning, monitoring, and capacity management for databases.
• Ability to design and implement automated data sharing and integration processes.
• Strong attention to detail and excellent documentation skills.
• Problem-solving abilities for troubleshooting data and database issues.
• Collaboration skills to work effectively with development, security, and operations teams.
• Familiarity with federal IT data standards and compliance requirements is preferred.

Responsibilities

• Develop a comprehensive data transition plan to move AIMS and PAS data and legacy functionality into the new cloud-centric architecture.
• Create and maintain data models, mappings, and dictionaries for intersystem connections, loads, and extracts.
• Design and enhance automated internal data sharing processes to support analytics for user accounts and fraud detection.
• Support network management tasks related to data flows, capture true user IP addresses, and implement edge protection.
• Maintain ASI documentation and support AIMS token management data processes.
• Provide environment support through database configurations, performance tuning, monitoring, backups, and capacity management.
• Ensure proper handling and encryption of key user data.

Skills

Database administration

Data modeling

Data engineering

Data migration planning

Secure data handling

Performance tuning

Monitoring & backups

Automated data sharing

Documentation

Troubleshooting

Team collaboration

Federal IT standards

Education

Bachelor's degree

Job description

Position Description

The DBA / Data Modeler / Data Engineer is responsible for designing, managing, and optimizing all data activities supporting the FSA IAM systems. This role ensures secure, accurate, and efficient data handling during the transition from the legacy AIMS and PAS systems to the new modern IAM solution and throughout ongoing operations.

Location:

Remote

Required Clearance:

Public Trust

Required Education:

Bachelors

Required Experience:

10 years

Responsibilities

The DBA / Data Modeler / Data Engineer develops a comprehensive data transition plan to move existing AIMS and PAS data and legacy functionality into the new cloud-centric architecture. They create and maintain detailed file layouts, source-to-target mappings, conceptual, logical, and physical data models, and data dictionaries for all intersystem connections, loads, and extracts. The role includes designing and enhancing automated internal data sharing processes to support analytics for user accounts and potential fraud detection. Additional responsibilities involve supporting network management tasks related to data flows, capturing true user IP addresses for each action, implementing network edge protection, enabling analytic tagging and dynamic error messaging, maintaining application-specific information (ASI) documentation, and supporting AIMS token management data processes. They also contribute to environment support through database configurations, performance tuning, monitoring, backups, and capacity management to ensure the IAM systems operate efficiently and reliably. The position ensures proper handling and encryption of key user data.

Required Qualifications

• Strong expertise in database administration, data modeling, and data engineering


• Experience creating detailed data models, mappings, and dictionaries


• Proficiency with data migration and transition planning in complex systems


• Knowledge of secure data handling, encryption, and PII protection


• Skills in performance tuning, monitoring, and capacity management for databases


• Ability to design and implement automated data sharing and integration processes


• Strong attention to detail and excellent documentation skills


• Problem-solving abilities for troubleshooting data and database issues


• Collaboration skills to work effectively with development, security, and operations teams


• Familiarity with federal IT data standards and compliance requirements is preferred

About PingWind

PingWind is focused on delivering outstanding services to the federal government. We have extensive experience in the fields of cybersecurity, development, IT infrastructure, supply chain management and other professional services such as system design and continuous improvement. PingWind is an SBA certified Service-Disabled Veteran-Owned Small Business (SDVOSB) with offices in Northern Virginia and Huntsville AL.

www.PingWind.com

Our benefits include:

• Eleven Federal Holidays


• Paid Time Off accrued each pay period


• Parental Leave


• Three medical plan choices with generous employer contribution


• Dental and Vision Insurance


• Company paid Short-Term and Long-Term Disability


• Company paid Life and AD&D Insurance


• 401k with competitive matching and vesting schedule


• Continuing education assistance


• Short Term / Long Term Disability & Life Insurance


• Medical, Dependent Care and Commuter Flexible Spending Accounts


• Employee Assistance Program


• Wellness benefits include Calm Health app and WellHub gym subsidy (formerly GymPass)


• 529 College Savings Plan


• Legal Insurance


• Pet Insurance

Salary Range

$121k-$168K

The pay range for this job is a general guideline only and not a guarantee of compensation or salary. Additional factors considered in extending an offer include (but are not limited to) job responsibilities, education, certifications, experience, as well as internal equity mapping and alignment with market data, or other applicable laws.

Veterans are encouraged to apply

Equal Opportunity Statement

PingWind, Inc. does not discriminate in employment opportunities, terms, and conditions of employment, or practices on the basis of race, age, gender, religious or political beliefs, national origin or heritage, disability, sexual orientation, or any characteristic protected by law.

We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses and identifying potential inconsistencies or verification signals in application materials based on available information. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us.