Data Engineering Consultant

Overview

WHO are we looking for?

CAPTRUST is seeking a Data Engineer to design, build, and maintain a scalable, high-quality data infrastructure enabling scalable analytics, self-service reporting, and AI-powered solutions across the firm. This role is ideal for an experienced professional with a passion for developing innovative data products, pipelines, and solutions. The Engineer will collaborate with stakeholders across departments to design scalable data solutions, enhance data quality, and optimize data-driven processes to support business objectives.

Responsibilities

• Design, build, and maintain scalable data products in Microsoft Fabric, including data pipelines, lakehouses, warehouses, and semantic models
• Support AI/ML workflows by delivering metadata-enriched, well-documented data products for feature engineering, integrating with machine learning pipelines, and enabling model monitoring
• Ensure data quality and consistency through profiling, validation rules, and integration of data quality standards into development workflows
• Optimize existing ETL processes for performance, reliability, and cost effectiveness
• Implement automated workflows and orchestration logic to ensure timely, repeatable, and cost-effective data delivery across the organization
• Integrate metadata management practices, supporting discovery, lineage, and cataloging
• Collaborate with data analysts, citizen developers, and key stakeholders to design data models and data products, championing data best practices and influencing CAPTRUST’s data culture

Qualifications

Minimum Qualifications:

• Bachelor’s degree in data analytics, computer science, information systems, or a related field (or equivalent work experience)
• 8 years of experience in data engineering, data science, or analytics role
• Advanced proficiency in SQL, Python, with hands-on experience with data modeling, ETL processes, and data pipeline development
• Experience with Microsoft Fabric or similar platforms, including dataflows, lakehouses, warehouses, and pipelines
• Understanding of metadata and governance frameworks to support secure, discoverable, and documented data assets
• Ability to manage multiple projects, prioritize tasks, and meet deadlines in a fast-paced environment
• Strong business acumen and problem-solving skills, with the ability to connect data products to business outcomes

Desired Qualifications/Skills:

• Strong problem-solving skills and attention to detail
• Excellent communication skills, with the ability to translate complex data insights into business-friendly recommendations
• Experience working with CRM systems (e.g., Microsoft Dynamics)
• Familiarity with semantic modeling for Power BI and other business intelligence tools
• Ability to work independently and proactively, while also being a strong team player
• Demonstrated ability to drive process improvements and enhance data-driven decision-making within an organization
• 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:

• Employee ownership opportunities
• Brick Bonus success sharing program
• Comprehensive health coverage Personify Health wellness platform
• 401(k) program with a 5% employer match financial planning for colleagues

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

EEO/Diversity Statement:

At CAPTRUST, we are committed to building and maintaining a diverse workforce and inclusive work environment where ALL colleagues feel authentically seen, respected, and supported.

CAPTRUST is committed to providing employment opportunities without regard to race, color, age, sex, sexual orientation, familial status, religious creed, national origin, ancestry, medical condition, marital status and registered domestic partner status, citizenship status, military and veteran status, disability, protected medical condition, genetic information, or any other status protected by law. CAPTRUST makes all employment decisions without regard to these protected statuses and does not tolerate harassment or discrimination. #mid-senior