Senior DBA / Data Modeler / Data Engineer

Remote; San Francisco (CA); Remote; USD 121,000 - 168,000; Full time

Benefits offered by this job

Eleven Federal Holidays

Paid Time Off

Parental Leave

Medical Insurance

Dental Insurance

Vision Insurance

Disability Insurance

Life Insurance

401k with match

Education assistance

Wellness stipend

529 College Savings Plan

Pet Insurance

Job summary

PingWind is seeking a seasoned DBA/Data Modeler/Data Engineer to design and optimize data activities for the new IAM platform. The role supports legacy data migration, secure handling, and scalable data flows across the cloud architecture.

Responsibilities include data modeling, mappings, dictionaries, and automated sharing for analytics and fraud detection, plus database tuning and backups to ensure reliable IAM operations.

Qualifications

• DBA, data modeling, and data engineering expertise.
• Experience creating detailed data models, mappings, and dictionaries.
• Proficient in 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.
• Able to design automated data sharing and integration processes.
• Strong attention to detail and excellent documentation skills.

Responsibilities

• Develop a data transition plan moving legacy AIMS/PAS data to the new cloud IAM architecture.
• Create and maintain file layouts, mappings, and data dictionaries for intersystem connections.
• Design automated data sharing to support analytics and fraud detection.
• Support network tasks related to data flows and IP capture for actions.
• Maintain ASI docs and token management data processes.
• Contribute to environment support: DB configs, tuning, backups, capacity management.

Skills

DBA

Data modeling

Data engineering

Data migration

Secure data handling

Performance tuning

Automation

Documentation

Problem solving

Collaboration

Federal IT standards

Education

Bachelor's degree

Job description

Location: Remote
Required Clearance: Public Trust
Required Education: Bachelors
Required Experience: 10 years

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.

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

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.