Business Data Analyst

Role: Business Data Analyst (Market Regulation Technology) Location: Rockville, MD or Tysons, VA (3 Days onsite a week - Hybrid) Type: Contract on C2C/W2 Direct Client Opportunity We are seeking a highly analytical Business Analyst with 5+ years of experience in a financial regulatory environment to bridge business requirements and technical implementation within our compliance team. The role involves conducting complex surveillance analysis to identify potential market violations and supporting business investigations through advanced data insights. You will perform User Acceptance Testing (UAT), validate releases against production data, and package results for stakeholders .The ideal candidate will have strong SQL expertise, including window functions, to perform complex data analysis (20–30% of daily work). You will be responsible for requirement gathering, code gap analysis, and interpreting intricate surveillance rules. Experience in workflow automation and process optimization is essential .Additionally, you will leverage GenAI tools for documentation, prompt engineering, and accelerating analytical workflows. Strong technical literacy, attention to detail, and the ability to act as a data subject matter expert are key to success in this role .Must Haves • :Domain Expertise: 5+ years of experience in a financial regulatory environment • .Advanced SQL: Strong SQL skills, specifically the ability to use window functions for data analysis • .Technical Literacy: The ability to interpret complex code, as many surveillance rules are highly intricate • .Process Management: Experience with the UAT (User Acceptance Testing) process, requirement gathering, and code gap analysis • .GenAI Proficiency: Actively leveraging GenAI for documentation, data analysis, and prompt engineering • .Automation: Experience developing automation tools for workflow optimization . Interview Proces • s:Structure: There are two rounds of interviews. Round one has been expanded to one hour to better filter candidate • s.Technical Evaluation: The second round specifically focuses on analytical and SQL skills, testing your problem-solving abilities in a high-stakes regulatory environment. It concludes with a 30-minute behavioral assessmen • t.On-Site Requirement: While the role supports a drivable distance to Rockville, MD, Tysons, VA, or DC, the second round of interviews must be conducted on-site at the Rockville or Tysons offic e. SQL – Experti se The specific SQL requirements go beyond basic querying to include more advanced analytical capabiliti • es:Window Function Knowledge: The hiring manager emphasizes that the SQL required is "not straightforward" and specifically requires proficiency with window functio • ns.Complex Data Queries: The role involves performing complex data queries and analysis to support investigations for business use • rs.Interpreting Complex Code: Because the surveillance rules themselves are highly intricate, the candidate must have the ability to interpret complex co • de.Daily Application: Approximately 20% to 30% of the daily work is dedicated to data analysis using these SQL skills to answer specific questions from business stakeholders regarding surveillance outpu • ts.Technical Assessment: These skills will be a primary focus of the second-round technical interview, which evaluates a candidate's analytical and problem-solving abilities within a high-stakes regulatory environme nt.