Analyze internally and externally sourced raw data to generate BI and advanced analytics datasets based on stakeholder requirements
Design data pipelines to curate sourced data into the in-house data warehouse
Develop data marts to facilitate dataset consumption from the in-house data warehouse by business and IT stakeholders
Design data model changes in alignment with in-house data warehouse standards
Define and plan migration execution activities to transition data from existing database solutions to the in-house data warehouse
Engineer
Perform regular housekeeping of raw data and data stored in the in-house data warehouse
Build and maintain data pipelines and data platforms
Develop data solution prototypes to support evolving business needs
Explore methods to enhance data quality and reliability
Identify and pursue opportunities to acquire higher-quality raw data
Develop analytical tools to support BI and advanced analytics activities
Execute data migration from existing databases to the in-house data warehouse
Promote and champion data engineering standards and best-in-class methodologies
Qualifications:
Bachelor's or Master's degree in Computer Science, Information Technology, Engineering, or a related quantitative discipline from a top-tier university
Certified in AWS Data Engineer Specialty or AWS Solutions Architect Associate
Snowflake SnowPro Core Certification
7+ years of experience in data engineering or a similar role, preferably in the financial industry
Strong understanding or hands-on experience with Enterprise Agile frameworks (e.g., Kanban, SAFe, SCRUM)
Solid understanding of ETL, data warehousing, BI (e.g., Qlik), and advanced data analytics concepts
Deep knowledge of cloud-enabled technologies such as AWS RDS, AWS Fargate, etc.
Experience with databases and data warehouses including Snowflake, PostgreSQL, and MS SQL
Strong programming skills with advanced knowledge of Java and/or Python
Practical experience with ETL tools such as AWS Glue
Excellent critical thinking, analytical, and problem-solving skills
Strong communication skills with a team-oriented mindset
