Hiring: Analytics Engineer Company: CAPTRUST Location: Raleigh, NC Job Posted Time: 2026-09-10 13:46:48 Employment Type: Remote Target Skills & Keywords : Data Warehouse, SQL, dbt About the job Experience: •5+ years of experience in analytics engineering, business intelligence, data engineering, or a closely related role. Required Skills: •Owns end-to-end stewardship of the dbt project, including model organization, naming conventions, testing strategy, documentation standards, and ongoing refactoring to keep the project healthy and scalable •Owns the analytics transformation layer and its production reliability, including build/deploy routines, dependency management, and monitoring/triage of model and test failures in partnership with Data Engineering •Owns the definition and implementation of analytics-ready business logic (e.g., conformed dimensions, facts, and shared metrics) and drives upstream data shaping requirements with Data Engineers to ensure source data supports agreed analytical needs •Design, build, and maintain analytics-ready data models in dbt that translate business requirements into clear, performant, and trusted analytical structures •Partner cross-functionally with Data Quality Analysts to embed data quality rules, validation logic, and testing directly into dbt models •Interface directly with business stakeholders and data analysts to understand reporting needs and codify logic in reusable models •Own dbt documentation quality and completeness, including model descriptions, lineage, business context, and assumptions, to support discovery and trust •Actively facilitate and support evolution of shared metric definitions in partnership with semantic and governance functions, ensuring consistency across analytics and reporting Qualifications: •Bachelor’s degree in data analytics, computer science, information systems, or a related field (or equivalent professional experience). •Advanced proficiency in SQL, including complex transformations, aggregations, and windowing logic. •Strong hands-on experience with dbt, including model development, refactoring, documentation, sources, and tests. •Solid understanding of analytical data modeling concepts and best practices. •Demonstrated capacity to translate business concepts into structured, analytics-ready data models. •Strong communication skills, with the ability to explain data logic in business terms. •Operational familiarity with Microsoft Fabric, Power BI semantic models, or similar analytics platforms. •Exposure to data governance concepts such as definitions, lineage, stewardship, and certified metrics. •Comfort operating in environments with evolving requirements and helping bring clarity through modeling standards •High standard of professionalism, integrity, and accountability. Compensation: •Flexible work environment (work from home / hybrid options) Interested candidates, please apply directly through the job posting on company's career page or try via AI auto apply on this platform. Don't miss this opportunity to join a forward-thinking team!