Data Architect

About the role:

Our ideal Advanced Data Engineer is a collaborative leader skilled in data analytics, data modeling, and database design. Youre also committed to data integrity, are highly analytical, and can work on multiple projects at once. You’ll use your skills to develop, monitor, and manage data systems across our platform. You will work on a variety of projects supporting the Corporate Finance, Investment Management or Enterprise Risk Management organizations.

Accountability:

• Design, build, and measure complex ELT jobs to process disparate data sources and form a high integrity, high quality, clean data asset.
• Working on a range of projects including batch pipelines, data modeling, and data mart solutions you’ll be part of collaborative project teams working to implement robust data collection and processing pipelines to meet specific business need.

Goals

• 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 data quality standards and tools for ensuring accuracy.
• Work across departments to understand new data patterns.
• Translate high-level business requirements into technical specs.

Skills Required

• Bachelor’s degree in computer science or engineering.
• 10+ years of experience with data analytics, data modeling, and database design.
• 10+ years of coding and scripting (Python, Java, Scala) and design experience.
• Having experience working on Clickstream data.
• Experience with ETL/ELT methodologies and tools.
• Experience with Vertica OR Teradata
• Expertise in tuning and troubleshooting SQL.
• Strong data integrity, analytical and multitasking skills.
• Excellent communication, problem solving, organizational and analytical skills.
• Able to work independently.