BTIG: Business Operations & Analytics, Associate

BTIG is seeking a Business Analyst with strong SQL skills to join our Business Operations and Analytics Team, where you will directly support firmwide operations by gathering and defining business requirements, analyzing complex data sets, and delivering clear, actionable reporting. The ideal candidate is technically fluent in data environments and deeply understands how information is sourced, transformed, maintained, and delivered to support business outcomes.

Responsibilities

Leverage demonstrated SQL proficiency to analyze large, complex datasets and extract meaningful insights; Design, develop, and maintain reports and dashboards using tools such as PowerBI and SSRS; Collaborate effectively with cross-functional teams to gather business requirements and deliver technical solutions; Follow existing processes and create new ones to enhance firm efficiency; Provide support to the firm through excellent data management and analysis; Adapt to evolving tools and technologies, proactively building proficiency in new platforms as business needs arise; Create and maintain positive relationships with other departments; Create and maintain technical documentation for reports, data flows, and business logic

Requirements

5+ years of experience in a Business Analyst or similar analytical role; Advanced SQL skills for data querying and manipulation; Proven ability to work with and manage large data sets; Comfortable and experienced with reporting tools such as PowerBI and SSRS; Demonstrate independence and initiative, with a strong track record of managing multiple priorities in a dynamic, team-oriented environment; Adept at diagnosing complex problems, developing practical solutions, and clearly communicating findings to stakeholders at all levels

Nice to have

Experience in financial services

Benefits

Healthcare (medical, dental, vision); Basic term and optional term life insurance; Short-term and long-term disability; Pregnancy disability and parental leave; 401(k) and employer-funded retirement plan; Paid vacation (from two to five weeks depending on salary grade and tenure); Up to 11 paid holiday opportunities; Adoption assistance; Sick and Safe Leave accruals of one hour for every 30 worked, up to 80 hours per calendar year unless otherwise provided by law