Krasan Consulting Services · 19 hours ago
Senior Data Solutions Architect
United States
Full-time
Remote
Senior LevelKrasan Consulting Services is seeking a Senior Data Solutions Architect to design, maintain, and optimize enterprise-level data systems. The role involves collaborating with cross-functional teams to ensure data accuracy and compliance while developing data integration workflows and maintaining data warehouse structures.
Cloud ComputingConsultingInformation TechnologyIT ManagementManagement Consulting
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
Krasan Consulting Services
Krasan Consulting Services is a technology management consulting firm and solutions integrator.
Founded in 2019
51-200 employees
H1B Sponsorship
Krasan Consulting 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 (42)
2024 (21)
2023 (4)
Funding
Current Stage
Growth StageLeadership Team
Rick Pugh
Chief Operations Officer
Company data provided by crunchbase