Senior Business Data Analyst, New York

Lab49 was founded to bring cutting-edge solutions from Silicon Valley to Wall Street. Clients from various sectors within the financial industry rely on us to provide top-tier solutions to their most intricate challenges. When you join us, we'll encourage you to redefine industry standards with every project and support you in achieving excellence.

About the Role
As a Senior Business Data Analyst at Lab49, you will be a key contributor to data-intensive projects for top-tier financial services clients. This role requires a strong combination of business analysis and technical expertise, with hands-on experience in SQL, data profiling, and reporting. You will act as the bridge between business users, data, and development teams- ensuring accurate data flows, robust reporting, and effective issue resolution.

What You'll Be Doing:
• Investigate data and system-related issues across internal financial applications. Identify root causes, perform data analysis, and coordinate with teams or vendors to implement fixes.
• Write and execute SQL queries to extract, manipulate, and analyze data. Handle tasks such as finding duplicates, joining multiple datasets, and comparing data across systems.
• Perform data profiling, data mapping, and data quality checks to ensure consistency and integrity across upstream and downstream systems.
• Generate recurring and ad hoc reports for business stakeholders, providing actionable insights from complex datasets.
• Support testing efforts for bug fixes, new features, and platform upgrades. Document results, assist with UAT, and ensure data-driven validation.
• Translate business requirements into clear technical specifications, including data requirements and reporting logic. Collaborate with developers and product owners to refine user stories.
• Maintain and update documentation, including data dictionaries, implementation trackers, and training materials.
• Provide guidance and support to users on data-related questions, reporting tools, and system workflows.

What You’ll Bring:
• 8+ years of experience as a Business Analyst or Technical Analyst in financial services, preferably in capital markets, investment banking, or trading environments.
• Strong SQL skills: ability to write queries, handle joins/unions, find duplicates, and perform data validations.
• Hands-on experience with data analysis, data profiling, data mapping, and data warehouse/reporting projects.
• Experience with BI/reporting tools such as Power BI, Tableau, or similar.
• Solid understanding of data architecture, data governance, and application integration principles.
• Familiarity with object-oriented concepts, ERDs, and API-based data flows.
• Experience working in Agile delivery teams, including sprint planning, backlog grooming, and user story definition.
• Strong communication skills, with the ability to clearly articulate findings to technical and non-technical stakeholders.
• Attention to detail and problem-solving skills, particularly when working with large or complex datasets.
• Agile certifications or product management experience are a plus.

The base salary range is - $150,000-$185,000
Placement within the range provided above is based on the individual’s relevant experience and skills for the role and level.

Base salary is only one component of our total compensation package. Employees may be eligible for a discretionary bonus, which is determined upon company and individual performance.
Salary range disclosure as required by S9427A when hiring in New York.

Lab49/ION is committed to maintaining a supportive and inclusive environment for people with diverse backgrounds and experiences. We respect the varied identities, abilities, cultures, and traditions of the individuals who comprise our organization and recognize the value that different backgrounds and points of view bring to our business.

Lab49/ION adheres to an equal employment opportunity policy that prohibits discriminatory practices or harassment against applicants or employees based on any legally impermissible factor.