Remote New

Data Mart Architect (Remote)

Vaya Health
92558.61 To 120326.20 (USD) Annually
United States, North Carolina
Mar 12, 2026
LOCATION: Remote - This is a home based, virtual position that operates Monday -Friday from 8:30am-5:00pm EST. Vaya Health welcomes applications from NC, SC, GA, TN, VA, MD, and FL. GENERAL STATEMENT OF JOB The Data Mart Architect works independently, and collaboratively, to architect, design, and maintain analytics-ready, reusable data models and enterprise analytical data marts that support both self-service analytics and non-self-servicing reporting solutions. This role serves as the foundation between raw source data and reporting platforms, ensuring business logic is centralized, consistent and reusable across Power BI, SSRS and other enterprise reporting tools. The Data Mart Architect partners with business intelligence developers, analysts, data subject matter experts (SMEs) and business stakeholders to enable scalable analytics delivery while reducing duplicated effort and improving trust in reported data. This role is also responsible for defining and implementing standardized data mart load and orchestration patterns to ensure analytical data assets are populated in a reliable, auditable, and repeatable manner. Note: This position requires access to and use of confidential healthcare information or protected health information (PHI) as described in laws addressing patient confidentiality, including, but not limited to, the federal HIPAA law, the Confidentiality of Alcohol and Substance Abuse Patient Records law, 42 CFR Part 2, and various state laws. As such, the individual filling this position shall be required to be trained regarding such laws and shall be required to observe those laws in his/her capacity as an employee of Vaya Health. The individual filling this position shall also sign a confidentiality statement as an employee of Vaya Health. ESSENTIAL JOB FUNCTIONS Analytics Data Modeling & Enterprise Data Mart Development: This position is responsible for architecture, design, and maintenance of analytics-ready, reusable data models and enterprise analytics data marts that support both self-service analytics and traditional reporting solutions. The Data Mart Architect translates business requirements and domain knowledge provided by data SMEs and business stakeholders into centralized modeling logic, ensuring business rules, calculations, and definitions are implemented once and reused consistently across multiple reporting and analytics platforms, including Power BI and SSRS. This role focuses on building analytical models and data marts optimized for performance, scalability, and long-term maintainability, with care given to defining and enforcing modeling standards related to grain, keys, measures, and reusable calculations. Certified analytical assets produced by this role serve as the trusted foundation for governed self-service analytics as well as scheduled, operational and regulatory reporting. The Data Mart Architect designs and builds the core data mart population logic, including incremental load strategies, transformation rules, and dependency sequencing, and implements these patterns to orchestrate and execute data mart loads. BI Planning, Design, and Implementation: This position collaborates closely with business intelligence developers, analyst and data SMEs to plan and design analytical solutions that align with enterprise reporting and analytics needs. The Data Mart Architect works with partners within the data life cycle to determine the appropriate placement of logic between source systems, data marts, semantic models and reporting layers, proactively identifying opportunities to reduce duplicated logic and improve reuse. This role defines standard pipeline patterns for analytics data mart population and provides guidance to BI developers on extending or maintaining these pipelines under established architectural standards. This role provides guidance and mentoring to BI Developers and analysts on proper consumption of analytical data marts and certified models, ensuring both self-service and traditional reporting solutions are built on consistent trusted data foundations. Modeling approaches are adapted as business needs evolve, with informed departures from traditional patterns when necessary to support performance, scalability, and usability. Analytics Model & Data Mart Administration and Documentation: This position is responsible for the administration, documentation and ongoing health of analytical data models and data marts. Responsibilities include maintaining clear documentation describing data mart purpose, grain, assumptions and key measures as well as monitoring performance, reliability and usage patterns. The Data Mart Architect also documents data mart load and orchestration logic, including pipeline design, dependencies, and failure-handling patterns, and participates in change control processes related to analytical data assets. The Data Mart Architect participates in establishing change control processes related to analytical assets and proactively identifies recurring issues or inefficiencies that indicate opportunities for structural, performance, or process improvements. Professional Development: This position is responsible for learning and improving upon the skills necessary to stay competitive in analytics data modeling, data mart design and reporting enablement practices. The Data Mart Architect actively pursues professional development through training, certifications, conferences, and self-directed learning to stay aligned with evolving Data Mart Architecting techniques, dimensional modeling approaches, and best practices across both self-service and traditional reporting BI platforms. Other Duties as Assigned KNOWLEDGE OF JOB Expert-level proficiency in SQL, including complex joins, aggregations, window functions, and performance optimization for analytical workloads Strong knowledge of analytics-focused data modeling concepts, including dimensional modeling, fact and dimension design, analytical grain, and measure behavior Proven ability to design and maintain enterprise analytical data marts that support both self-service analytics and traditional reporting solutions Demonstrated experience translating business requirements and domain knowledge from data SMEs and business stakeholders into centralized, reusable analytical models Strong understanding of how business logic should be abstracted and centralized to support reuse across multiple reports, dashboards, and analytics use cases Experience designing data models optimized for Power BI semantic models, including import-based datasets and shared models Working knowledge of supporting SSRS datasets and traditional reporting using shared analytical data foundations Hands-on experience designing and implementing data mart population and orchestration logic. Ability to design pipelines that support incremental load strategies, dependency sequencing and reliable refresh cycles for analytics data marts. Working knowledge of monitoring, troubleshooting, and failure-handling for analytics-based pipelines. Ability to determine appropriate placement of logic between source systems, data marts, semantic models, and reporting layers Prior experience designing and implementing ETL workflows in tools such as SSIS and Azure Data Factory (ADF) for analytics focused data marts or reporting solutions. Experience building reusable calculations and standardized metrics to reduce duplicated report-level logic Strong analytical skills with the ability to identify data quality, consistency, and performance issues and recommend structural improvements Experience documenting analytical models, including assumptions, grain, metric definitions, and intended use Familiarity with change control practices and disciplined promotion of analytical assets across environments Working knowledge of data security, privacy, and governance concepts as they relate to analytical data and reporting Experience collaborating effectively with business intelligence developers, analysts, data SMEs, and business users Strong ability to mentor and guide BI developers and analysts on proper use of analytical data marts and certified models Proven ability to interpret complex business processes and translate them into stable analytical structures Excellent problem-solving skills and ability to debug complex analytical logic across multiple layers Strong verbal and written communication skills with the ability to clearly articulate analytical concepts to technical and non-technical audiences Demonstrated ability to work independently while managing multiple analytical initiatives simultaneously Ability to operate effectively in environments without a dedicated data engineering team, balancing technical ownership with collaboration High level of integrity and sound judgment when working with confidential and sensitive information Commitment to continuous learning and improvement in Data Mart Architecting, data modeling, and reporting enablement practices Must have a high- level of computer literacy with desktop and cloud-based productivity software such as Office365, Microsoft Office desktop applications, Microsoft Teams, and SharePoint. Strong interpersonal skills including mentoring, coaching, collaborating, and team building Must be able to work independently and as a strong team player Ability to work in a fast-paced, deadline driven environment running multiple projects simultaneously Must possess the integrity and decision-making skills necessary to work with and protect confidential personal health information. EDUCATION & EXPERIENCE REQUIREMENTS High School Diploma/GED required. Bachelor's degree in Computer Science, Computer Information Systems, Healthcare Information Systems or business-related degrees are preferred. Must have: High School diploma or GED and 10+ years of relevant software development experience OR Associates degree and 5+ years of relevant software development experience OR Bachelor's degree or higher and 2+ years of relevant development experience Preferred work experience: Healthcare, Medicaid experience preferred. PHYSICAL REQUIREMENTS Close visual acuity to perform activities such as preparation and analysis of documents; viewing a computer terminal; and extensive reading. Physical activity in this position includes crouching, reaching, walking, talking, hearing and repetitive motion of hands, wrists and fingers. Sedentary work with lifting requirements up to 10 pounds, sitting for extended periods of time. Mental concentration is required in all aspects of work. RESIDENCY REQUIREMENT: The person in this position must live in NC, SC, GA, TN, VA, MD, or FL for this role. SALARY: Depending on qualifications & experience of candidate. This position is exempt and is not eligible for overtime compensation. DEADLINE FOR APPLICATION: Open until filled. APPLY: Vaya Health accepts online applications in our Career Center, please visit https://www.vayahealth.com/about/careers/. Vaya Health is an equal opportunity employer.