Data Engineering

Captrust•Raleigh, NC

12d•Onsite

About The Position

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.

Requirements

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

Nice To Haves

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

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