Remote IAM Data Architect & Modeler

PingWind; United States; On-site; USD 93,000 - 128,000; Full time

Benefits offered by this job

Eleven Federal Holidays

Paid Time Off

Parental Leave

Medical plan with employer contrib.

Dental and Vision Insurance

Disability Insurance

Life and AD&D Insurance

401k with matching

Education assistance

Wellness benefits

Flexible Spending Accounts

Employee Assistance Program

Pet Insurance

Job summary

PingWind is seeking a DBA / Data Modeler / Data Engineer to manage, design, and optimize data activities for FSA IAM systems, enabling secure sharing and analytics. This role supports identity management, fraud analysis, and system integrations in a remote setting.

Required are a Bachelor's degree and 8 years of experience, with a Public Trust clearance preferred. Responsibilities include data modeling, mappings, dictionaries, and data dictionaries, plus system performance tuning and backups.

Qualifications

• Requires strong expertise in database administration, data modeling, and data engineering.
• Proficiency with relational databases, data modeling tools, and ETL processes.
• Ability to create and maintain clear data models, mappings, and dictionaries.
• Experience with secure handling of sensitive identity and PII data.
• Knowledge of performance tuning, monitoring, and capacity planning for databases.
• Good understanding of data integration, sharing, and analytics support.
• Attention to detail and strong documentation skills.
• Ability to collaborate with development, security, and operations teams.
• Problem-solving skills for troubleshooting data and database issues.
• Familiarity with federal IT environments and compliance requirements is preferred.

Responsibilities

• Provide detailed file layouts, source-to-target mappings, and data models.
• Design, support, and enhance automated data-sharing processes for IAM systems.
• Support network management tasks related to data flows and IP capture.
• Implement analytic tagging and dynamic error messaging; maintain ASI documentation.
• Support AIMS token management data processes and environment configurations.
• Handle database configurations, performance tuning, backups, monitoring, and capacity management.

Skills

Database administration

Data modeling

Data engineering

Relational databases

ETL processes

Data mappings

Data dictionaries

PII data handling

Performance tuning

Monitoring

Capacity planning

Data integration

Analytics support

Documentation

Cross-team collaboration

Troubleshooting data issues

Federal IT compliance

Education

Bachelor's degree

Job description

Position Description

The DBA / Data Modeler / Data Engineer is responsible for managing, designing, and optimizing all data-related activities for the FSA IAM systems. This role ensures data is accurate, secure, well-organized, and efficiently shared to support identity management, reporting, fraud analysis, and system integrations.

Location: Remote

Required Clearance: Public Trust

Required Education: Bachelors

Required Experience: 8 years

Position Description

The DBA / Data Modeler / Data Engineer is responsible for managing, designing, and optimizing all data-related activities for the FSA IAM systems. This role ensures data is accurate, secure, well-organized, and efficiently shared to support identity management, reporting, fraud analysis, and system integrations.

Responsibilities

The DBA / Data Modeler / Data Engineer provides detailed file layouts, source-to-target mappings, conceptual, logical, and physical data models, and data dictionaries for all intersystem connections, loads, and extracts. They design, support, and enhance automated processes for internal data sharing with authorized FSA applications, including analytics support for user account analysis and fraud detection. Additional responsibilities include supporting network management tasks related to data flows, capturing true user IP addresses, implementing network edge protection measures, 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 by handling database configurations, performance tuning, backups, monitoring, and capacity management to keep IAM systems running efficiently."

Required Qualifications

• Strong expertise in database administration, data modeling, and data engineering
• Proficiency with relational databases, data modeling tools, and ETL processes
• Ability to create and maintain clear data models, mappings, and dictionaries
• Experience with secure handling of sensitive identity and PII data
• Knowledge of performance tuning, monitoring, and capacity planning for databases
• Good understanding of data integration, sharing, and analytics support
• Attention to detail and strong documentation skills
• Ability to collaborate with development, security, and operations teams
• Problem-solving skills for troubleshooting data and database issues
• Familiarity with federal IT environments 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
  
  
  

Veterans are encouraged to apply

Salary Range

$93k-$128K

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.

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.