Sr. Associate, BI & Analytics

Sr. Associate, BI & Analytics Employment Type:Full-Time/Direct Hire Workplace Type:Onsite/Hybrid (3-4 days a week onsite) Location:Santa Monica, CA Industry:Investment/Asset Management Compensation: $125,000-$160,000. Eligible for an annual bonus after completing 1st year. Benefits/Perks:Healthcare Insurance (Medical, Dental, Vision), PTO, 401k, fully catered snack lounge, from lunch Monday-Thursday every week. JOB SUMMARY: The Sr. Associate, BI & Analytics will oversee the maintenance and enhancement of the firm's security master database, conduct data validation checks, and resolve discrepancies. This individual will drive the creation and automation of reports that inform decision-making within the firm and support ongoing trading activities. They will also develop SQL queries for data extraction and champion the development of innovative automated solutions to streamline data workflows and reporting processes. This role will be pivotal in integrating data from various internal and external sources into the firm's security master and other relevant databases, ensuring seamless data flow and system interoperability. They will continuously identify opportunities to improve data management processes by implementing best practices to enhance operational efficiency and accuracy. Collaborating closely with cross-functional teams, the Assistant Vice President will drive data management initiatives and ensure alignment with organizational goals. KEY RESPONSIBILITIES: • Strategic Data Management: Oversee the maintenance and continuous improvement of the firm's security master database, ensuring accurate and up-to-date information for all securities. • Quality Assurance: Lead comprehensive data validation checks to ensure the accuracy, consistency, and completeness of data from various sources. Address and resolve any discrepancies identified. • Reporting & Automation:Direct the creation and automation of reports related to security attributes, trading activity, and data quality metrics. • SQL Query Development:Develop and manage SQL queries for robust data extraction, aggregation, and reporting. Support and lead the development of innovative automated solutions that streamline data workflows and reporting processes. • Data Integration:Oversee the integration of data from internal and external sources into the security master and other relevant databases. • Process Optimization:Identify and implement best practices and process improvements in data management, enhancing operational efficiency and accuracy. • Collaboration:Work closely with cross-functional teams to support data management initiatives and ensure alignment with organizational goals. REQUIRED QUALIFICATIONS & SKILLS: • BS/BA Degree in Finance, Economics, Computer Science, Engineering, or a related field. • Extensive experience in data management, preferably within the financial services or investment industry, with a proven track record of leading data initiatives and projects at a senior level. • In-depth familiarity with data management/governance concepts, including data integrity, Data Validation, Data Stewardship, Data Automation, and Data Visualization/Reporting. • Prior or current expeirnece working in the financial services industry in a data focused role, expeirnece with Investment & Asset Management securities, including Fixed Income (required), Derivatives, Auctions, High Yield Bonds, Loans, Direct Lending, Structured Credit, and Private & Illiquid Credit product knowledge is highly desired. • Expert proficiency in SQL and Excel. Advanced SQL skills, including stored procedures, joined tables, query optimization, etc. • Strong background and skill with data visualization & reporting tools such as Tableau (strongly referred), PowerBI, or related solutions • Knowledge, expeirnece, and passion for data automation. Experience with SQL & Python programming for data automation is highly desired. • Strong knowledge of financial markets and fixed income instruments • Ability to identify and resolve discrepancies in large data sets. • Problem-solving and analytical abilities. • Excellent verbal and written communication skills, with the ability to clearly convey complex data concepts to non-technical stakeholders. • Demonstrate ability to lead data management initiatives and collaborate effectively with cross-functional teams. DESIRED QUALIFICATIONS & SKILLS: • Advanced Degree in Degree in Finance, Economics, Computer Science, Engineering, or a related field • Experience with Python & SQL for data automation • Knowledge of ETL and Data Pipelines • Expeirnece with Investment Management systems & applications (i.e., Trading Platforms, Accounting Software, Financial Systems, etc.) All qualified applicants will receive consideration for employment without regard to race, color, national origin, age, ancestry, religion, sex, sexual orientation, gender identity, gender expression, marital status, disability, medical condition, genetic information, pregnancy, or military or veteran status. We consider all qualified applicants, including those with criminal histories, in a manner consistent with state and local laws, including the California Fair Chance Act, City of Los Angeles' Fair Chance Initiative for Hiring Ordinance, and Los Angeles County Fair Chance Ordinance. For unincorporated Los Angeles county, to the extent our customers require a background check for certain positions, the Company faces a significant risk to its business operations and business reputation unless a review of criminal history is conducted for those specific job positions.