Business Analyst with Capital Markets/SQL

Tech Business Analyst with Capital Markets/SQL

Charlotte, NC (Need Onsite day 1, hybrid 3 days from office).

Fulltime

Responsibilities:

• Lead and mentor a team of Business Analysts to meet compliance and risk management objectives across supported areas.
• Collaborate with stakeholders from small to large business units to implement key risk initiatives and technology solutions.
• Manage end-to-end technology delivery projects, ensuring they align with organizational standards, timelines, and quality benchmarks.
• Oversee data management activities, including data modeling, ensuring data integrity, and improving data quality standards.
• Translate complex business requirements into detailed data models (conceptual, logical, and physical) and functional specifications.
• Facilitate Agile practices such as Scrum, Product Ownership, User Story creation, and Sprint planning using tools like Jira.
• Drive all phases of the SDLC, including design, development, testing, and deployment of systems and tools.
• Partner with developers to implement new data pipelines and enhance existing data infrastructure.
• Develop and maintain comprehensive documentation including Functional Specifications Documents (FSDs), user stories, test cases, and technical specifications.
• Apply Governance, Risk, and Compliance (GRC) principles to ensure adherence to industry and regulatory standards.
• Utilize data analytics tools and languages such as Python, Dataframes, Excel/VBA, and SQL for analysis and reporting.
• Support Business Intelligence initiatives by leveraging platforms like Tableau and Dremio to deliver actionable insights.
• Engage in complex regulatory technology programs to ensure compliance with industry mandates.

Requirements:

• 5+ years experience leading Business Analyst team to ensure compliance and risk management requirements for supported area are met and work with other stakeholders to implement key risk initiatives.
• Technology delivery and relationship management experience with small and large business units in a large corporate environment.
• 3+ years experience in Data Management including data modeling, data integrity and data quality.
• BS/BA degree or higher in Information Technology 5+ years experience in Capital Markets.
• Agile Methodology including exposure to full-spectrum concepts. E.g. Scrum Master, Product Owner, User Story creation/composition, Jira.
• Deep understanding of SDLC processes and best practices.
• Strong proficiency in MS Office Suite and SQL.
• Business and functional requirements into conceptual, logical and physical data models.
• 3+ years experience prototyping/analysis experience using Python/Dataframe, Excel/VBA or other analytics functional language.
• 3+ years experience with Governance, Risk, and Compliance (GRC) concepts.
• 5+ years experience writing Functional Specifications Documents (FSD's).
• 5+ years experience with technical requirements, design, testing, and implementation of tools and technologies.
• 5+ years experience writing User Stories, test cases using BDD (Gherkin language).

Preferred, but not required:

• 5+ years experience working with developers to implement new data paths.
• 3+ years of participation in complex technology programs required for regulatory business requirements.
• Knowledge and understanding of data modeling tools, such as Power Designer 3+ years experience in BI solutions e.g