The Product and Portfolio Support Team provide around the clock coverage for the creation, deployment, and upkeep of enterprisewide Extract-Transform-Load (ETL) mappings. Key responsibilities include writing and maintaining Pythonbased Jupyter notebooks, designing workflows that ingest and transform incoming vendor and client files, and migrating legacy Excel logic into robust Python code.
This role involves transitioning legacy operations to more efficient and modern systems, while working with multiple business, technical and support teams for the development and maintenance of critical ETL mappings. They will use analytical skills to process and understand data, answer business questions, and be able to work independently and as part of a distributed global team.
The role offers the chance to author new guidelines, bestpractice playbooks, and rootcause analysis procedures whenever incidents arise. On top of the daytoday support tasks and ongoing long-term projects, team members will contribute to shortterm projects for internal initiatives or crossfunctional business units. The engineer will support process automation, data extraction, and customized solutions across various business units. Moreover, the candidate will be able to learn about the financial services/hedge fund industry.
Job Responsibilities
- ETL Development Design, build, test, and evolve ETL pipelines using Python and Jupyter notebooks.
- Data Transformation Convert raw data streams from multiple external sources into formats suitable for ingestion by proprietary applications.
- Documentation Produce and maintain clear, detailed documentation for both new and existing ETL processes.
- Support & Incident Response Deliver rapid, SLAcompliant assistance for tickets and incidents, with the ability to rapidly push fixes to production when needed.
- Continuous Improvement Keep up-to-date with industry best practices, tools, and emerging technologies relevant to ETL and data engineering, and apply them to the team's workflows.
- Communication - Translating complicated problems and processes into streamlined solutions for various internal audiences, including senior management.
Job Requirements
- Bachelor's degree in Computer Science, Information Systems, or equivalent professional experience.
- Strong proficiency in Python; experience with SQL and Bash is also required.
- Solid knowledge of datascience libraries such as Pandas, NumPy, and SciPy.
- Advanced Excel skills, including complex formula construction.
- Ability to read and interpret XML schemas and understand XMLbased workflows.
- Experience and knowledge using AWS technologies including Kibana and APM for troubleshooting.
- Deep grasp of objectoriented programming, design patterns, and core software engineering concepts.
- Experience in agile software development, release and change management, and frequent deployments into production environments.
- Experience in the financial services industry and some knowledge of financial products is a plus.
- Excellent written and verbal communication skills in English.
- All qualifications are equally important; the ideal candidate will blend technical expertise with a proactive, serviceoriented mindset.
Please note that this role requires working during U.S. business hours.
