Sql Data Engineer

Job Description

You will work with IT and business stakeholders to build and operationalize data pipelines necessary for the enterprise data and analytics initiatives, following industry standard practices and tools. This includes user requirements gathering and feedback from business leads in both formal and informal settings.

You will be designing and documenting data architecture at multiple levels (high-level to detailed) and across multiple views (conceptual, logical, physical, data flow and sequence diagrams)

In this role, you will be highly collaborative – with our Digital Information Systems Team and Business Teams. Interpersonal skills and the ability to learn and act quickly are crucial to succeeding in this role.

Responsibilities:

• Deploy and manage data platforms and data movement solutions both in the cloud and on-premise
• Build scalability and performance into data platforms to meet the growing needs of our users
• Partner with Information Security professionals to ensure data is secure both at-rest and in-flight
• Develop, test, deploy and maintain efficient reusable patterns of streaming and batch data ingestion pipeline architectures
• Integrate data platforms to leverage efficiencies and automation within the stack
• Document and maintain key architecture and coding standards for supported platforms
• Ensure data platforms remain current to take advantage of the latest features and support
• Construct comprehensive dashboards and KPI’s
• Coach and mentor other team members on data architecture practices and tool
• Be open to learn, train and develop as a team

Qualifications:

• Minimum of 10 years of experience with Data warehousing methodologies and modeling techniques
• Snowflake development experience while desired is not required
• Minimum of 2 years of hands-on experience in any cloud technologies such as AWS, MS Azure or GCP
• Minimum of 3-5 years of experience with any one of the ETL/ELT tools (Informatica) along with experience in orchestration tools like Autosys, Active Batch etc.
• Experience in integration with other applications/front office systems using API’s or microservices
• Must have Investment Management data domains knowledge (Security Master, Index, Holdings, ESG)
• Experience in migration to new technology and retirement of legacy platforms is a plus
• Strong communication skills and ability to articulate system designs and patterns to varying levels of leadership