Data Engineer - Corporate Technology Data Engineering & Analytics

Join our dynamic team as a Data Engineer - Corporate Technology Data Engineering & Analytics, where you'll play a pivotal role in driving the execution of our data and technology strategy. This role is crucial in driving digital transformation and operational efficiency across Investment Management. As part of this role, you will engage in building data solutions including streaming and batch pipelines, data marts & data warehouse. You will be responsible for establishing robust data collection and processing pipelines to fulfill Investment Management business requirements.

The Team

You’ll be an integral part of our esteemed Corporate Technology Team, focused on Data Engineering & Analytics. Our team operates on a global scale, driving innovation and excellence across diverse areas of expertise. As a Data Engineer, you'll play a critical role in high impact Corporate Technology Investment Initiatives, ensuring alignment with organizational objectives and driving impactful outcomes. This is an opportunity to collaborate closely with Corporate Technology Data and Analytics team and Investment management business stakeholders. Our team thrives on collaboration, innovation, and a shared commitment to excellence. Together, we're shaping the future of technology within our organization and making a lasting impact on a global scale. Join us and be part of a dynamic team where your contributions will be valued and your potential unleashed.

The Impact:

• 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.

• Bachelor’s degree in Computer Science, Engineering, Information Systems or related technical field.
• 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.

The Ideal Qualifications

• Knowledge of Informatica Power center and Informatica IDMC.
• Knowledge of distributed, column- orientated technology to create high-performant database technologies like - Vertica, Snowflake.
• 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.
• Experience with IBOR’s such as Blackrock Alladin, CRD, Eagle STAR (ABOR), Eagle Pace, and Eagle DataMart.
• Familiarity with investment data platforms such as GoldenSource, FINBOURNE, NeoXam, RIMES, and JPM Fusion.
• Strong analytical and problem-solving abilities.
• Exceptional communication and interpersonal skills.
• Ability to influence and motivate teams without direct authority.
• Excellent time management and organizational skills, with the ability to prioritize multiple initiatives.