Note: The job is a remote job and is open to candidates in USA. Matrix is a global technology services and consulting company specializing in advanced technologies, software solutions, digital products, and technology delivery services. The role will design and maintain scalable data models, ELT pipelines, data marts, and semantic layers while supporting data quality, governance, business intelligence, predictive analytics, and AI initiatives across the organization.
Responsibilities
- Design, develop, and maintain scalable dbt models that power reporting and analytics across the organization
- Build and manage data marts that support business intelligence, self-service analytics, predictive analytics, and AI-driven insights
- Partner with analysts and business stakeholders to translate reporting and operational requirements into reliable, reusable data models
- Develop and maintain a consistent semantic layer that enables accurate reporting and decision-making
- Build, manage, and troubleshoot ELT pipelines and integrations using Airbyte and related technologies
- Collaborate with Data Engineering teams to maintain a reliable end-to-end data platform spanning data ingestion, warehousing, transformation, and reporting
- Support onboarding of new B2B clients by developing client-specific data models, transformations, and workflows
- Monitor and optimize warehouse performance, ensuring data processing efficiency and cost effectiveness
- Implement automated testing, data validation, and quality monitoring using dbt and related tools
- Maintain data documentation, lineage, metadata, and business definitions to promote data trust and transparency
- Contribute to data governance initiatives and help establish best practices for data management across the organization
- Design data structures optimized for AI and machine learning use cases
- Leverage AI-assisted development tools such as Cursor, Claude, and similar technologies to accelerate development, testing, and documentation
- Help champion AI-enabled workflows and best practices across the Data & Analytics organization
Skills
- * 2-4 years of experience in Analytics Engineering, Data Engineering, Business Intelligence Engineering, or a similar role
- * Strong experience with **dbt** for data modeling, transformation, testing, and documentation
- * Advanced SQL skills with experience developing complex analytical datasets
- * Experience with cloud data warehouses such as **Amazon Redshift**, Snowflake, BigQuery, or equivalent platforms
- * Working knowledge of Python for data processing, automation, or analytics workflows
- * Experience building and maintaining ELT/ETL pipelines using tools such as Airbyte, Fivetran, or similar platforms
- * Understanding of dimensional modeling, star schemas, and analytics-focused data architecture
- * Experience using Git and collaborative software development practices
- * Familiarity with business intelligence and visualization tools, preferably Tableau
- * Comfortable leveraging AI-powered development tools and assistants to improve productivity and workflow efficiency
- * Strong communication and stakeholder management skills
- * Must be based in the United States
- * Bachelor's degree in Computer Science, Information Systems, Statistics, Engineering, or a related field, or equivalent practical experience
- * Experience within healthcare, health technology, or other regulated industries
- * Experience working with HIPAA-, GDPR-, or other compliance-regulated data environments
- * Experience supporting client-facing data integrations and B2B customer onboarding
- * Experience in high-growth startup or fast-paced environments
- * Exposure to machine learning, predictive analytics, or AI-powered data applications
Benefits
- Remote work arrangement
Company Overview