Data Mart Architect (Remote)

Vaya Health

11d•Remote

About The Position

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.

Requirements

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.
High School Diploma/GED required. Bachelor’s degree in Computer Science, Computer Information Systems, Healthcare Information Systems or business-related degrees are preferred.
High School diploma or GED and 10+ years of relevant software development experience
Associates degree and 5+ years of relevant software development experience
Bachelor’s degree or higher and 2+ years of relevant development experience

Nice To Haves

Healthcare, Medicaid experience preferred.

Responsibilities

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

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume