Sr. Software Engineer- Data & Integration

About the role

The Senior Data Integration Engineer plays a crucial role in building and maintaining scalable ETL/ELT pipelines that support analytics and reporting across various domains including asset management, investment accounting, and investment operations.

Responsibilities

• Design, develop, optimize, and support scalable ETL/ELT data pipelines using SQL, Informatica, Oracle, and cloud-based technologies.
• Partner with developers, architects, analysts, and business stakeholders to define integration solutions and ensure data accuracy and usability.
• Lead technical design discussions and provide guidance to junior team members on data integration best practices.
• Contribute to data architecture and modernization initiatives, including migration of legacy solutions to cloud-based platforms, data warehouse design, and enterprise integration strategies.
• Participate in the software development lifecycle, including CI/CD practices and infrastructure automation using Azure Pipeline.

Requirements

• Proficiency in SQL and hands-on experience with ETL/ELT tools (Informatica preferred).
• Advanced knowledge of Oracle SQL and PL/SQL for data transformation, performance tuning, and data integration.
• Experience with cloud-based data platforms such as Snowflake.
• Understanding data warehousing concepts, dimensional modeling, and data integration patterns.
• Experience designing data warehouse and dimensional models to support reporting and analytics.
• Experience integrating data from APIs, files, databases, and cloud platforms.
• Working knowledge of Python and experience developing data processing scripts and automation.
• Exposure to version control and DevOps tools such as Git and Azure Pipelines.
• Ability to work collaboratively in an agile, team-oriented environment.
• Strong communication skills and a willingness to learn and grow.

Qualifications

• 8+ years of experience designing, developing, and supporting enterprise ETL/ELT and data integration solutions.
• BS Degree: IT, CS, Data Science or Statistics or equivalent experience.
• Strong expertise in SQL, Oracle, and data integration development.
• Experience with ETL/ELT frameworks, data warehousing, and dimensional modeling.
• Experience with Python for automation, scripting, and data processing preferred.
• Experience supporting cloud-based data platforms such as Snowflake preferred.

Skills

• Experience implementing modern ELT frameworks such as DBT and Matillion within Snowflake environments.
• Exposure to enterprise scheduling and orchestration tools such as Control-M.
• Experience working with investment management platforms, investment accounting systems, or financial market data.
• Knowledge of cloud-native architecture and data modernization initiatives.
• A proactive mindset with a passion for continuous learning, automation, and technology transformation.

Benefits

• Prioritization of your health and well-being including Medical, Dental, Vision, and Wellbeing Reimbursement Account that can be used on yourself or your eligible dependents.
• Generous paid time off options including: Paid Time Off, Holiday Schedules, and Financial Planning Time Off.
• Paid Parental Leave as well as an Adoption Assistance Program.
• Competitive 401k savings plan with company match and an additional contribution regardless of participation.