Analytics Engineer: dbt Data Modeling & Production

CAPTRUST; Raleigh (NC); On-site; USD 90,000 - 120,000; Full time

Benefits offered by this job

Company discretionary bonus

Health, dental, and vision coverage

401(k) plan and company match

Paid time off

Job summary

CAPTRUST in Raleigh, North Carolina is seeking an Analytics Engineer who will design, build, and maintain analytics-ready data models. This role involves partnering closely with Data Engineering to ensure data alignment for analytics products.

Ideal candidates should have extensive experience with dbt and SQL, and the ability to translate business needs into structured data models. The position includes a range of employee benefits and aims to foster an inclusive work environment.

Qualifications

• 5+ years of experience in analytics engineering, business intelligence, or related role.
• Ability to translate business concepts into structured, analytics-ready data models.
• Solid understanding of analytical data modeling concepts.

Responsibilities

• Owns end-to-end stewardship of the dbt project and its reliability.
• Design, build, and maintain analytics-ready data models in dbt.
• Collaborate with business stakeholders to understand reporting needs.

Skills

Advanced SQL proficiency

dbt expertise

Data modeling

Strong communication

Education

Bachelor’s degree in data analytics, computer science, or related field

Tools

Microsoft Fabric

Power BI

Job description

CAPTRUST in Raleigh, North Carolina is seeking an Analytics Engineer who will design, build, and maintain analytics-ready data models. This role involves partnering closely with Data Engineering to ensure data alignment for analytics products.

Ideal candidates should have extensive experience with dbt and SQL, and the ability to translate business needs into structured data models. The position includes a range of employee benefits and aims to foster an inclusive work environment.