Job Description
Overview
\n
This is a Data Engineer role focused on building and owning a cloud data platform, including ELT pipelines, data models, integrations, and reporting layers for financial data. The engineer will work heavily with Snowflake, SQL, and Python, while serving as a Snowflake SME and partnering with business and technology teams to ensure data is accurate, scalable, and reliable.
\n
\n
Key Responsibilities & Duties
\n
- \n
- Design and maintain scalable ELT pipelines for diverse data sources, ensuring data integrity and accessibility.
- Develop dimensional and semantic models to support portfolio reporting and analytics.
- Implement automated data validation and reconciliation tests with detailed exception reporting.
- Collaborate with stakeholders to gather requirements and write technical specifications for data solutions.
- Act as a subject-matter expert on Snowflake capabilities, advising on patterns and cost implications.
- Support analysts by exposing well-documented, performant reporting layers for downstream applications.
- Integrate Snowflake with operational systems through collaboration with platform engineers.
- Participate in design reviews, providing technical feasibility and cost input on new initiatives.
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
Job Requirements
\n
- \n
- Bachelor’s degree in Computer Science, Engineering, Information Systems, or related field.
- Minimum 3 years of data engineering experience, with 2 years focused on Snowflake.
- Proficiency in advanced SQL, Python, and Snowflake features like Streams, Tasks, and secure data sharing.
- Experience with data modeling methodologies and orchestration tools such as Airflow or Prefect.
- Familiarity with cloud infrastructure (AWS or Azure) and infrastructure-as-code tools like Terraform.
- Strong analytical and problem-solving skills with attention to detail and data accuracy.
- Preferred SnowPro Core or Advanced certification and experience with BI tools.
- Ability to work in a hybrid environment, balancing onsite and remote collaboration.
\n
\n
\n
\n
\n
\n
\n
\n
\n