Overview

WHO are we looking for?

CAPTRUST is seeking an Analytics Engineer to design, build, and maintain analytics-ready data models that enable trusted reporting, self-service analytics, and downstream decision-making across the firm. This role owns the dbt analytics transformation layer and dbt project stewardship, and partners with Data Engineering on upstream pipelines and data shaping to ensure analytics-ready inputs. This role serves as the connective tissue between raw data engineering outputs and business-facing analytics by translating business concepts into well-modeled, well-documented dbt assets. This position is ideal for a data professional with deep dbt expertise, strong SQL skills, and a passion for data modeling who can partner closely with Data Engineers, Data Analysts, and business stakeholders to deliver reliable, scalable analytical data products.

Responsibilities

• 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
• Collaborate with Data Quality Analysts to embed data quality rules, validation logic, and testing directly into dbt models
• Apply dimensional and analytical modeling best practices (e.g., star schemas, facts and dimensions, grain alignment) to support reporting and metrics consistency
• Work 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
• Support the evolution of shared metric definitions in partnership with semantic and governance functions, ensuring consistency across analytics and reporting
• Participate in analytics development processes, including code reviews, testing, and deployment workflows

Qualifications

Minimum Qualifications:

• Bachelor's degree in data analytics, computer science, information systems, or a related field (or equivalent professional experience).
• 5+ years of experience in analytics engineering, business intelligence, data engineering, or a closely related role.
• 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.
• Ability to translate business concepts into structured, analytics-ready data models.
• Strong communication skills, with the ability to explain data logic in business terms.

Desired Qualifications/Skills:

• Experience working in a modern analytics stack (e.g., cloud data warehouse, dbt, BI tools).
• Familiarity with Microsoft Fabric, Power BI semantic models, or similar analytics platforms.
• Experience partnering closely with Data Engineers and Data Quality roles in a team-based analytics delivery model.
• 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.

WHAT can you expect from your career at CAPTRUST?

Our colleagues, like our clients, tend to stay with CAPTRUST for years. There's a reason for it; it's a great culture in which to work and grow. We all work together, each of us motivating those around us with our commitment to high standards. At CAPTRUST, expect a fully stocked break room, fun employee events, and a quality team surrounding you with opportunities for personal growth.

Our Employee Benefits Package shows how much we value our team. Some benefits include:

• Company discretionary bonus.
• Health, dental, and vision coverage, employer 401(k) plan and company match, health savings accounts, flexible spending accounts, and voluntary supplemental plans subject to plan terms
• Company-paid benefits such as life insurance, short-term disability, and long-term disability, subject to applicable waiting periods.
• Paid time off (PTO) or Paid Sick Leave (PSL)

WHERE will you be working?

4208 Six Forks Rd #1700 | Raleigh, NC 27609

Due to the nature of the role, this is not a remote or work from home position. #LI-Onsite

HOW do we build a world class organization one brick at a time?

We make it a priority to hire those who have a commitment to service, a real interest in other people, and a passion to continuously improve. Simply put: the difference at CAPTRUST is the quality of our people and depth of our bench. If you are ready to make your mark, we want to talk to you.

Are you the next brick?

To get it done the CAPTRUST Way, an individual should exhibit the following characteristics:

• Ability to build successful, collaborative, and trusting relationships
• Instinctive aptitude for consistently creating accurate, concise, respectful, and easy-to-understand verbal and written communications conveying complex information
• A strong sense of urgency about getting work done and solving problems to achieve results that benefit our clients and colleagues, even when faced with challenges
• Inherent desire to give back to our communities and enrich the lives of those around us
• An other-centered mindset
• Integrity through maintaining objectivity