Senior Business Analyst

Strategic Investment Group•Arlington, VA

1d•$120,000 - $130,000

About The Position

The Senior Business Analyst will join Strategic Investment Group’s Enterprise Solutions team, focusing on data analytics, data governance, and new software implementations. The role supports the quality, consistency, and accessibility of firm data used in investment operations and decision-making. Current priorities include a firm-wide data governance program, daily data analysis using SQL in Snowflake, maintenance and enhancement of Salesforce, and implementation of new software and system integrations as projects arise. The analyst collaborates with business users, internal teams, and external vendors to deliver and support solutions. The position calls for a self-motivated professional who owns issues from initial report through resolution, investigates details, advances work proactively, communicates clearly, and manages multiple priorities in a dynamic environment.

Requirements

Bachelor’s degree in Management Information Systems, Data Analytics, Business, Engineering, Economics, Finance, or a related discipline.
Six or more years of experience as a business analyst, data analyst, investment analyst, engineer, or consultant working through all phases of project delivery.
Strong SQL skills, including writing and troubleshooting complex queries against relational databases.
Demonstrated problem-solving ability, including breaking ambiguous issues into parts, tracing data discrepancies to root causes across systems, and proposing practical fixes.
Meticulous attention to detail, including identifying errors, inconsistencies, and edge cases in data, requirements, and testing, and validating one’s own work.
Self-motivation and accountability, including proactively identifying gaps, asking questions early, following open items through to closure, and delivering reliably with minimal supervision.
Excellent interpersonal and communication skills, including the ability to collaborate with business users to elicit and define functional requirements.
Advanced Microsoft Excel skills.
Authorization to work in the United States without requiring new employer-sponsored work authorization now or in the future.

Nice To Haves

Experience with Snowflake.
Experience in finance, investment management, or performance systems.
Familiarity with data governance concepts such as data quality, data lineage, master data management, and data cataloging.
Experience with Power BI or other business intelligence and visualization tools.
Experience using Python for data analysis, automation, or scripting.
Familiarity with AI tooling in a data context, such as AI-assisted querying, analysis, or documentation.
Exposure to Hex.
Familiarity with Salesforce from a business analyst perspective, including requirements, reports, dashboards, and light configuration; deep administration or development experience is not required.
Experience using Jira and Confluence to track and document projects.

Responsibilities

Support implementation of new software platforms and integrations, from requirements gathering through configuration review, testing, and user adoption.
Translate and supplement user requirements for external vendors and internal developers, breaking down requests and providing supporting calculations and examples.
Write and refine daily SQL queries in Snowflake to analyze, profile, and validate data across systems and ensure data integrity and reliable reporting.
Build and maintain queries, reports, and dashboards in tools such as Hex to make data accessible to business users.
Document implementation decisions, data flows, dependencies, and risks.
Verify that requirements are met at every project stage through hands-on testing and coordination of User Acceptance Testing.
Keep projects on schedule, communicate updates and blockers proactively, and manage scope expectations with internal stakeholders and vendors.
Manage tasks across multiple workstreams with varying priorities and oversight levels.
Support and enhance Salesforce by defining requirements with business users, performing light configuration of fields, reports, and dashboards, and coordinating vendors who handle development and updates.
Support legacy systems and internal tools, including responding to user inquiries and troubleshooting.
Support the design and rollout of a firm-wide data governance program, including data definitions, ownership, quality standards, and supporting documentation.
Gather requirements and develop understanding of the data warehouse and security master.
Perform other duties as assigned to support business initiatives.