Data Analyst (W2)

Job Title: Data AnalystLocation: Los Angeles CA / Orange County CA / Irvine, CA (ONSITE)Duration: 1+ Year Contract Key Responsibilities:·        Asset Management and Investment Operations: Leverage your expertise to support and enhance our operations.·        Data Requirements: Gather and analyze source and target data requirements, assessing datasets for suitability in data products.·        Data Analysis: Conduct in-depth analysis on large datasets to identify data gaps, trends, and improvement areas.·        Insight Generation: Develop points of view (POVs) through data analysis to inform product feature decisions.·        Product Support: Assist Data Product Managers in defining and prioritizing features based on analytical insights.·        Documentation: Create and maintain source-to-target mapping documents and other product-related documentation.·        Testing: Develop and execute test scripts for Functional Testing and User Acceptance Testing (UAT) of data products.·        Validation Controls: Document data validation controls and work with the engineering team to guide their implementation.·        Operational Readiness: Prepare comprehensive data product release notes.·        Agile Participation: Engage in Program Increment (PI) planning, daily stand-ups, sprint demos, and sprint retrospectives to foster transparency, feedback, and continuous improvement. Required Skills:·        Industry Experience: 6-8 years in the Financial Services industry with mandatory asset management experience.·        Operational Experience: Background in investment operations and data management is preferred.·        Data Analytics: Proficiency in advanced data analytics using Python and SQL.·        Data Management: Experience in handling functional and non-functional data requirements, including mapping, flows, data dictionaries, glossaries, lineage, and operational metadata.·        Capital Markets: Strong background and experience in the capital markets and investment management domain.·        SQL Proficiency: Skilled in writing intermediate to complex SQL queries, including advanced SQL scenarios such as JOINs and Rank functions.·        Python: Practical, hands-on experience with Python.·        Data Warehousing and Modelling: Experience in data warehousing and data modelling.Warm Regards,Balaji K E | Technical RecruiterCall: 609-732-3209 Email: balaji.ke@lorventech.com