Senior Data Warehousing Specialist

The Senior Data Warehousing Specialist manages the design, implementation, and optimization of data warehousing solutions supporting the VA EHRM program. This role ensures that stakeholders have timely, accurate, and actionable access to enterprise healthcare data.

About iCallidus

Tech

Description

At iCallidus, we are innovators harnessing the power of creative thinkers to develop, execute, and manage groundbreaking IT solutions. Our multidisciplinary team excels in cybersecurity, digital modernization, transformation, and strategic management, ensuring our clients stay ahead in a dynamic tech landscape. We prioritize user-centric designs, building secure, scalable, and efficient systems tailored to meet specific business needs. Our commitment to cost-effective solutions enables clients to achieve more without significant cost escalations. With a robust portfolio of successful projects across various sectors and a proven track record, we consistently deliver high-quality results, helping organizations enhance performance and security while embracing the future of technology.

Location: Washington, D.C., Kansas Or Remote

Contingent Upon Award

Key Responsibilities:

• Design and implement enterprise data warehouse solutions to consolidate clinical, administrative, and operational data.
• Develop Extract, Transform, Load (ETL) processes to migrate and integrate data from legacy systems into the EHRM solution.
• Ensure data accuracy, consistency, and compliance with VA and federal standards.
• Build reporting and analytics capabilities to support program performance assessment, clinical outcome tracking, and executive dashboards.
• Collaborate with database architects, data analysts, and business intelligence teams to align warehousing solutions with VA mission needs.
• Provide technical leadership in resolving complex data integration and transformation challenges.
• Ensure security and privacy controls are applied to all data environments.

Qualifications and Requirements:

• Bachelor’s or Master’s degree in Data Management, Computer Science, or related field.
• 8+ years of experience in data warehousing, ETL development, and enterprise reporting.
• Proficiency with tools such as Informatica, Talend, or SSIS, and experience with Oracle/SQL Server environments.
• Strong background in healthcare data structures, interoperability (HL7/FHIR), and federal data compliance.
• Demonstrated ability to translate clinical/operational requirements into data solutions.
• Experience working with Cerner (Oracle Health) electronic health record solutions and prior involvement with the VA Electronic Health Record Modernization (EHRM) program is strongly preferred.

Deliverables:

• The Senior Data Warehousing Specialist shall deliver data warehousing strategy and architecture documentation defining schemas, data marts, and cubes.
• The Senior Data Warehousing Specialist shall deliver ETL process documentation including scripts and workflows for data integration.
• The Senior Data Warehousing Specialist shall deliver reporting and analytics dashboards for clinical and executive users.
• The Senior Data Warehousing Specialist shall deliver data quality and validation reports demonstrating accuracy and compliance with VA standards.
• The Senior Data Warehousing Specialist shall deliver inputs to the Annual Performance Baseline Report by submitting warehouse performance metrics.
• The Senior Data Warehousing Specialist shall deliver training and knowledge transfer materials to support VA analysts and end users.

Clearance Requirement:

Must be able to obtain and maintain a Public Trust / Moderate Risk clearance.

Benefits:

Medical, Vision, Dental, 401(K), Short Term Disability, Standard Basic Life Insurance and PTO.

EEO Statement

iCallidus is an Equal Opportunity/Affirmative Action Employer. We do not unlawfully discriminate because of race, color, religion, age, sex, creed, national origin, ancestry, citizenship status, marital or domestic or civil union status, familial status, affectional or sexual orientation, gender identity or expression, genetics, disability, military eligibility or veteran status, or any other protected status.

Salary

$116,000 - $151,000 per year