Driving the execution of our data and technology strategy, digital transformation, and operational efficiency across Investment Management by building data solutions including streaming and batch pipelines, data marts & data warehouse.
Requirements
- 8+ years of experience with data analytics, data modeling, and database design.
- 5+ years experience with ELT methodologies and tools.
- 5+ years experience in designing, developing, tuning and troubleshooting SQL.
- 3+ years of coding and scripting (Python, Java, Scala) and design experience.
- 2+ years of experience with Spark framework.
- Knowledge of Informatica Power center and Informatica IDMC.
- Knowledge of distributed, column-orientated technology to create high-performant database technologies like - Vertica, Snowflake.
Responsibilities
- Design, build, and measure complex ELT jobs to process disparate data sources and form a high integrity, high quality, clean data asset.
- Executes and provides feedback for data modeling policies, procedure, processes, and standards.
- Assists with capturing and documenting system flow and other pertinent technical information about data, database design, and systems.
- Develop comprehensive data quality standards and implement effective tools to ensure data accuracy and reliability.
- Collaborate with various Investment Management departments to gain a better understanding of new data patterns.
- Collaborate with Data Analysts, Data Architects, and BI developers to ensure design and development of scalable data solutions aligning with business goals.
- Translate high-level business requirements into detailed technical specs.
Other
- Bachelor’s degree in Computer Science, Engineering, Information Systems or related technical field.
- Strong data analysis skills for extracting insights from financial data
- Proficiency in reporting tools (e.g., Power BI, Tableau).
- Domain knowledge of Investment Management operations including Security Masters, Securities Trade and Recon Operations, Reference data management, Pricing.
- Familiarity with regulatory requirements and compliance standards in the investment management industry.
