Ahava Services · 16 hours ago
Data Integration Specialist
United States
Full-time
Remote
Mid LevelAhava Services is seeking a Data Integration Specialist who will play a key role in designing, maintaining, and optimizing enterprise-level data systems. The role involves collaborating with business and IT teams to manage data integration workflows and ensure compliance with data governance standards.
Cloud ComputingEnterprise SoftwareConsultingSoftwareCloud Data ServicesCRM
Responsibilities
Design, develop, and maintain end-to-end data integration workflows using ETL tools such as Informatica to extract, transform, and load data between source and target systems
Collaborate with business and IT teams to analyze, define, and document data requirements within Third Party Electronic Database and Provider Enrollment frameworks
Develop and optimize SQL interface files , stored procedures, and data validation scripts to support system interoperability and data exchange between heterogeneous platforms
Perform detailed data profiling, cleansing, and validation to ensure compliance with federal and enterprise-level data governance and quality standards
Design and maintain data warehouse structures , ensuring efficient storage, retrieval, and reporting of mission-critical datasets
Work closely with architects, data stewards, and business analysts to develop data flow diagrams, metadata documentation , and post-migration validation reports
Support system migrations and modernization efforts , including post-migration verification and documentation of data lineage and reconciliation
Analyze data-related performance issues and implement corrective actions to optimize ETL job efficiency and system throughput
Ensure compliance with security, privacy, and regulatory frameworks , including HIPAA, NIST, and applicable state-level policies related to provider enrollment and healthcare data
Develop comprehensive technical and functional documentation , including data dictionaries, interface control documents (ICDs), and process flow diagrams
Qualification
Required
Bachelor's degree in Computer Science, Information Systems, Data Engineering, or a related field
Hands-on experience in data integration, data warehousing, and database development using tools such as Informatica PowerCenter or equivalent ETL solutions
Proficiency in SQL (Oracle, SQL Server, or similar RDBMS platforms), including writing complex queries, joins, and optimization techniques
Strong understanding of data handling principles, normalization, data lineage, and metadata management
Experience working with data warehouse architectures, including star and snowflake schema design
Exposure to or understanding of Third Party Electronic Databases and Provider Enrollment Systems, particularly in the healthcare or public sector domain
Familiarity with data migration and post-migration validation techniques, ensuring accuracy and consistency across systems
Strong analytical and troubleshooting skills for resolving data discrepancies and interface issues
Excellent communication, documentation, and cross-functional collaboration skills
Preferred
Experience in federally regulated data environments such as Medicaid, Medicare, or other healthcare provider enrollment platforms
Knowledge of Informatica Cloud, Azure Data Factory, or other modern cloud ETL tools
Familiarity with data governance frameworks, data quality tools, and compliance documentation
Certification in Informatica, SQL Development, or Data Warehousing preferred
Company
Ahava Services
Ahava Services is a salesforce consultancy that offers staff augmentation, cloud-based services, and CRM implementation for businesses.
Founded in 2010
11-50 employees
H1B Sponsorship
Ahava Services has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (2)
2024 (4)
2023 (1)
Funding
Current Stage
Early StageLeadership Team
Tharani Raj
CEO and Founder
Recent News
Company data provided by crunchbase