Senior DBA / Data Modeler / Data Engineer
- Role
- Data Engineering
- Experience
- Senior
- Employment
- Full-time
The listing doesn't say where it hires from. It may hire in United States (90% confidence). This is an estimate, not an eligibility rule; verify before applying.Signals: employment terms and salary level.
No BS summary
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
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.
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.
\n
\n
What you'll do
- Develops a comprehensive data transition plan to move existing AIMS and PAS data and legacy functionality into the new cloud-centric architecture.
- 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.
- Design and enhance automated internal data sharing processes to support analytics for user accounts and potential fraud detection.
- Support 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.
- Contribute to environment support through database configurations, performance tuning, monitoring, backups, and capacity management to ensure the IAM systems operate efficiently and reliably.
What they require
- 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
- Preferred: Familiarity with federal IT data standards and compliance requirements
Benefits
- Eleven Federal Holidays
- Paid Time Off accrued each pay period
- Three medical plan choices with generous employer contribution
- 401k with competitive matching and vesting schedule
- Continuing education assistance