Menu
Investment Data Tech Analyst
Full time @GRITalent posted 8 months ago in Data Science Engineering , in IT UI & Full Stack Developer , in Project Management & Business Analyst , in Quantitative Modeling & Financial Engineer Shortlist Email JobJob Description
Reporting to the Manager, Pension Investment Technology, the Analyst, Investment Data and Technology assists in designing, maintaining, and advancing the in-house IT structure of Pension Investment. The Analyst works with cross-functional teams, supporting the development and maintenance of data architecture, models, and integration services. The Analyst leverages their skills to transform key data from various business domains into insights. Utilizing their IT and finance experience, the Analyst enables efficient data management, insightful analytics, and provides robust support for issue resolution, facilitating informed decision making and ensuring no interruptions to workflow. The Analyst offers flexible IT support as the Pension Investment team grows, technology needs changing, and new needs arise.
Job Responsibilities
Below are the main job requirements and responsibilities for the Analyst, Investment Data and Technology:
- Develops scripts to automate reports for the Pension Investment team. Ensures reporting automation is meeting clients’ needs, correcting any reporting issues that arise. Thinks critically, does research, and analysis to provide resolutions for issues related to reporting, escalating to the Manager when necessary.
- Assists in the design and implementation of high-quality, well-tested data pipelines and systems using the latest technologies. Researches and recommends new technologies relevant to data warehousing, cloud computing, AI, etc.
- Utilizes Python programming and various data visualization tools for the development of automated solutions in data processing, analysis, and presentation.
- Integrates with internal and external investment systems, leveraging modern cloud technologies and tools on an event-driven architecture. Supports day-to-day issue resolution.
- Works closely with Investment and Risk teams and Data Management to assist in designing and strategizing reporting solutions. Helps build new trade feeds and portfolio hierarchies for Investment and Risk applications, adapt and adopt vendor-based solutions and APIs, and blend internal development with those vendor solutions. Coordinates with Pension Investment teams to ensure accuracy with daily trade movement and data management and reporting.
- Act as an IT support liaison for the Pension Investment department, handling a variety of IT-related issues, including hardware and software challenges. When necessary, coordinates interactions between users and IT support teams (submitting support tickets, setting up meetings) ensuring timely resolutions.
Job Responsibilities (continued)
- Manages smaller-scale IT projects, coordinating with stakeholders to determine the business needs. In consultation with the Manager, completes the applicable development and supports the project deployment.
- Interacts with clients to gather information, explore gaps in current services, gain new perspectives, consider best practices, and explore new strategies. Collaborates with management to communicate needs and findings, negotiate business cases, and to influence the best courses of action for reporting automation.
- Contributes to the development of new internal guides, documents, and information sources, and revises existing documents, based on team needs.
- Stays abreast with technological trends, continually enhancing technical skills through research and experimentation. Troubleshoot and resolve operational issues in both development and production environments.
- Networks with industry professionals from external pension plan groups to remain up to date on industry trends and maintain a network of other IT professionals.
Qualifications
Education
- A bachelor’s degree preferably in computer science or related subject OR a combination of equivalent professional experience and training.
Experience
- 1 to 3 years of relevant development experience, including experience with needs assessment, solution design, implementation, and ongoing support/evolution.
- Demonstrated experience with AWS, SnowFlake, or similar cloud platforms.
- Experience with technologies such as Jira, GitHub.
Other Candidate Requirements
- IT generalist knowledge of systems and programs.
- Working knowledge of trading lifecycle and investment workflow with experience in investment data flows, operational processing requirements, and management of data assets is an asset.
- Strong understanding of data management, integration, and warehousing concepts, with experience in relational and multi-dimensional database structures.
- Strong proficiency in Python is essential for developing automated data processing solutions and advanced data visualizations.
- Proficient in SQL with experience querying large datasets from multiple sources.
- Proficiency in data engineering tools and frameworks, including Airflow, Docker, Spark, PySpark, and ETL/ELT processes an asset.
- Exposure to various software development methodologies and practices like Test-Driven Development, Automation, Continuous Delivery, Containerization.
- Exemplary communication and coordination skills.
- Knowledge of general finance and pension investment applications, capital markets, and trading environment is considered an asset.