Data Engineer at Green Key Resources Data Engineer at Green Key Resources in Purchase, New York Posted in 1 day ago.

Type:

full-time Overview 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. Key Responsibilities & Duties 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. Job Requirements 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.