Senior Data Analyst

About the position

If you're passionate about your craft and looking for an opportunity to make meaningful contributions toward our mission, we’d love to have you join us! As a Sr. Data Analyst, you’ll be joining a team of Data Operations Specialists and Engineers to review and enhance Altruist brokerage data to ensure accuracy and consistency. Additionally, you’ll support key operational responsibilities such as ensuring our data is compatible with our third party custodial integrations and handling data corrections, as needed. 

What you’ll do 

• Handle escalated data operations requests during US Exchange Market Hours
• Create and maintain data monitors, dashboards and internal tooling that enable automated and efficient reports and workflows for the Data Operations Team
• Update dimensional table mappings for vendor data transformed to the Altruist canonical model
• Perform root cause analysis and impact assessment for data issues, writing custom SQL scripts to provide corrections for all impacted accounts when necessary
• Investigate and correct issues identified through data operations monitors, tools and break reports
• Understand the Data Platform and all dependencies such that data processes can be rerun when necessary to apply data corrections
• Work with our Support Teams to troubleshoot and correct any data issues that impact the dependent components and/or teams. 
• Implement historic data corrections that are aligned with the intended actions taken in the books and records system and are compatible with performance reporting and billing
• Develop and maintain documentation on data operations processes

What you’ll bring

• 3+ years working in the financial industry in a data analyst role that utilizes intermediate to advanced SQL
• Experience troubleshooting investment returns (TWR/IRR), account reconciliation, cost basis issues, discrepancies with holdings, corporate action processing and security pricing issues
• Excellent data analysis and problem solving skills
• Keen eye for detail
• Effective collaboration and communication skills to work as part of a cross functional team

Bonus Points

• Experience building internal tools with applications such as Retool
• Experience working with Data Warehouses such as Snowflake
• Experience with one or more programming languages such as Javascript 
• Experience writing scripts or store procedures to automate workflows
• Experience with alerting and monitoring tools such as Monte Carlo and DataDog
• Prior experience working at a startup