Data Quality AnalystCAPTRUST is seeking a Data Quality Analyst to lead the firm's data quality program. This Analyst will partner with teams across the firm to define, monitor, track, and enforce data quality rules that improve trust in reporting and analytics. This role is ideal for an experienced professional who combines strong SQL skills with cross-department collaboration to identify issues and drive remediation.ResponsibilitiesLead the firm's data quality program by identifying, defining, and prioritizing data quality rules in partnership with business owners and data stewardsDesign and maintain automated SQL based data quality tests via dbt and collaborate with data engineers to embed testing into the analytics warehouse build processDefine critical data elements (CDEs) and measurable quality standards (e.g., completeness, validity, accuracy, timeliness) and document acceptance criteriaMonitor data quality through reports and dashboards, implementing alerts, tracking trends, SLAs, and communicating status, risks, and progress to business ownersManage the data quality issue lifecycle from detection through remediation and verification, including triage, ownership, and root cause analysisPromote data quality best practices, support governance alignment (definitions, metadata, lineage), and maintain clear documentation of rules, exceptions, and coverageQualificationsMinimum Qualifications:Bachelor's degree in data analytics, computer science, information systems, or a related field (or equivalent work experience)6+ years of experience in a data quality, analytics, business intelligence, or data engineering-adjacent roleAdvanced proficiency in SQL, including complex queries for profiling, validation, reconciliation, and root cause analysisExperience defining and operationalizing data quality rules, thresholds, and automated checks, including monitoring and exception handlingUnderstanding of data governance concepts (definitions, metadata, lineage, stewardship) and how they support secure, discoverable, and documented data assetsAbility to manage multiple projects, prioritize tasks, and meet deadlines in a fast-paced environmentStrong business acumen and problem-solving skills, with the ability to explain data issues, impacts, and remediation options in business-friendly termsDesired Qualifications/Skills:Familiarity with dbt (tests, sources, models, documentation) or similar frameworks.Experience with Power BI or similar business intelligence platforms.Experience operating a data issue management process (ticketing, severity, SLAs) and coordinating remediation across teams.Comfort with data modeling and ETL concepts and partnering with Data Engineers to embed controls into pipelines and CI/CD.Experience working with CRM systems (e.g.
Microsoft Dynamics)Excellent communication and stakeholder management skills, with the ability to influence without authority and drive adoption of 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 bonusHealth, dental, and vision coverage, employer 401(k) plan and company match, health savings accounts, flexible spending accounts, and voluntary supplemental plans subject to plan termsCompany-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 27609Due to the nature of the role, this is not a remote or work from home position. #LI-OnsiteHOW 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 relationshipsInstinctive aptitude for consistently creating accurate, concise, respectful, and easy-to-understand verbal and written communications conveying complex informationA strong sense of urgency about getting work done and solving problems to achieve results that benefit our clients and colleagues, even when faced with challengesInherent desire to give back to our communities and enrich the lives of those around usAn other-centered mindsetIntegrity through maintaining objectivityEEO/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.It is our intent to maintain a work environment that is free of harassment, discrimination, or retaliation because of sex (including pregnancy, childbirth, or other related medical conditions), gender, race (including hair texture or hairstyles associated with race), religion, color, national origin, ancestry, physical or mental disability, genetic information, age, sexual orientation, gender identity, gender expression, protected veteran status, uniformed service, or any other status protected by federal, state, or local laws. #mid-seniorThis position will remain open until filled.