Sr Agile Developer - Datamart

Huntington National Bank • Dallas, TX

7h • Hybrid

About The Position

Description Key Responsibilities: Snowflake Data Mart: develop, and optimize a Snowflake-based Data Mart to support analytics, reporting, and data integration for counterparty-related workflows. Data Integration: Develop ETL/ELT pipelines to integrate data from various sources into the Snowflake Data Mart, ensuring compatibility with the Counterparty Mastering System. Performance Optimization: Optimize application performance, database queries, and Snowflake data models for scalability and efficiency. Security & Compliance: Ensure the datamart adheres to data security standards, regulatory requirements (e.g., GDPR, CCPA), and financial industry best practices. Collaboration: Work closely with data engineers, analysts, and business stakeholders to gather requirements, define system specifications, and deliver solutions. Testing & Maintenance: Write unit tests, perform integration testing, and maintain codebases to ensure reliability and robustness of the systems. Documentation: Create and maintain technical documentation for system architecture, data models, and workflows. Innovation: Stay updated on emerging technologies and propose improvements to enhance system functionality and performance. Technical Skills: Back-End: Expertise in server-side languages such as Python, Java, Node.js, or C#. Database: Strong knowledge of SQL, Snowflake (SnowSQL, stored procedures, data modeling), and relational databases (e.g., PostgreSQL, MySQL) ETL/ELT: Experience with data integration tools (e.g., Apache Airflow, dbt, Profisee) and building data pipelines Cloud: Familiarity with cloud platforms (AWS, Azure, or GCP) and Snowflake integration DevOps: Experience with CI/CD pipelines, Docker, Kubernetes, and version control (Git) Domain Knowledge: Understanding of counterparty data (e.g., KYC, credit risk) and financial services workflows is a plus Soft Skills: Strong problem-solving skills, attention to detail, and ability to collaborate with cross-functional teams Basic Qualifications: Bachelor’s degree 7+ years of full stack development experience, with a focus on building data-driven applications and/or datamarts 3+ years of experience with cloud-based data platforms, preferably Snowflake (including experience supporting data mastering systems, preferably for counterparty or financial data) 5+ years of Back-End: Expertise in server-side languages such as Python, Java, (Git). Preferred Qualifications: Node.js, or C#. Database: Strong knowledge of SQL, Snowflake (SnowSQL, stored procedures, data modeling), and relational databases (e.g., PostgreSQL, MySQL). ETL/ELT: Experience with data integration tools (e.g., Apache Airflow, dbt, Profisee) and building data pipelines Cloud: Familiarity with cloud platforms (AWS, Azure, or GCP) and Snowflake integration DevOps: Experience with CI/CD pipelines, Docker, Kubernetes, and version control for counterparty or financial data Domain Knowledge: Understanding of counterparty data (e.g., KYC, credit risk) and financial services workflows is a plus. Soft Skills: Strong problem-solving skills, attention to detail, and ability to collaborate with cross-functional teams

Requirements

• Bachelor’s degree
• 7+ years of full stack development experience, with a focus on building data-driven applications and/or datamarts
• 3+ years of experience with cloud-based data platforms, preferably Snowflake (including experience supporting data mastering systems, preferably for counterparty or financial data)
• 5+ years of Back-End: Expertise in server-side languages such as Python, Java, (Git).
• Expertise in server-side languages such as Python, Java, Node.js, or C#.
• Strong knowledge of SQL, Snowflake (SnowSQL, stored procedures, data modeling), and relational databases (e.g., PostgreSQL, MySQL).
• Experience with data integration tools (e.g., Apache Airflow, dbt, Profisee) and building data pipelines
• Familiarity with cloud platforms (AWS, Azure, or GCP) and Snowflake integration
• Experience with CI/CD pipelines, Docker, Kubernetes, and version control (Git)
• Strong problem-solving skills, attention to detail, and ability to collaborate with cross-functional teams

Nice To Haves

• Node.js, or C#.
• Strong knowledge of SQL, Snowflake (SnowSQL, stored procedures, data modeling), and relational databases (e.g., PostgreSQL, MySQL).
• Experience with data integration tools (e.g., Apache Airflow, dbt, Profisee) and building data pipelines
• Familiarity with cloud platforms (AWS, Azure, or GCP) and Snowflake integration
• Experience with CI/CD pipelines, Docker, Kubernetes, and version control
• Proven experience supporting data mastering systems, preferably for counterparty or financial data
• Domain Knowledge: Understanding of counterparty data (e.g., KYC, credit risk) and financial services workflows is a plus.
• Strong problem-solving skills, attention to detail, and ability to collaborate with cross-functional teams

Responsibilities

• Snowflake Data Mart: develop, and optimize a Snowflake-based Data Mart to support analytics, reporting, and data integration for counterparty-related workflows.
• Data Integration: Develop ETL/ELT pipelines to integrate data from various sources into the Snowflake Data Mart, ensuring compatibility with the Counterparty Mastering System.
• Performance Optimization: Optimize application performance, database queries, and Snowflake data models for scalability and efficiency.
• Security & Compliance: Ensure the datamart adheres to data security standards, regulatory requirements (e.g., GDPR, CCPA), and financial industry best practices.
• Collaboration: Work closely with data engineers, analysts, and business stakeholders to gather requirements, define system specifications, and deliver solutions.
• Testing & Maintenance: Write unit tests, perform integration testing, and maintain codebases to ensure reliability and robustness of the systems.
• Documentation: Create and maintain technical documentation for system architecture, data models, and workflows.
• Innovation: Stay updated on emerging technologies and propose improvements to enhance system functionality and performance.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level