Senior Data Solutions Architect

Krasan Consulting Services; United States; On-site; USD 80,000 - 100,000; Full time

Job summary

A consulting firm in the United States seeks a Data Systems Analyst to design, maintain, and optimize enterprise data systems. The ideal candidate will have strong analytical skills and proficiency in SQL and ETL tools such as Informatica. Responsibilities include developing data integration workflows and ensuring compliance with data standards. A Bachelor's degree and experience in data warehousing and database development are essential. Preferred qualifications include familiarity with healthcare provider enrollment data environments and modern cloud ETL tools.

Qualifications

• Hands-on experience in data integration, data warehousing, and database development.
• Proficiency in SQL with complex queries and optimization techniques.
• Strong understanding of data handling principles and metadata management.

Responsibilities

• Design and maintain data integration workflows using ETL tools.
• Collaborate with business and IT teams to define data requirements.
• Optimize SQL interface files and data validation scripts.

Skills

Data handling

SQL interfaces

ETL tools like Informatica

Analytical skills

Data quality standards

Database design

System integration

Education

Bachelor's degree in Computer Science or related field

Tools

Informatica PowerCenter

SQL Server

Job description

The Data Systems Analyst / Data Integration Specialist will play a key role in designing, maintaining, and optimizing enterprise-level data systems that support provider enrollment, third-party databases, and large-scale data warehousing environments. The ideal candidate will demonstrate strong analytical skills, proficiency in data handling, SQL interfaces, and ETL tools such as Informatica. Candidates with prior experience or foundational understanding of Third-Party Electronic Databases and Provider Enrollment Systems will be preferred.

This position requires technical depth in database design, data mapping, and system integration, along with the ability to work collaboratively across functional and technical teams to ensure data accuracy, integrity, and compliance within complex information systems.

Key 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.

Required Skills and Qualifications

• 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 Qualifications

• 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.