Develop and optimize a Snowflake-based Data Mart to support analytics, reporting, and data integration for counterparty-related workflows, ensuring compatibility with the Counterparty Mastering System.
Requirements
- 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)
- 3+ years of experience with cloud-based data platforms, preferably Snowflake
- Proven experience supporting data mastering systems, preferably for counterparty or financial data
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.
Other
- Stay updated on emerging technologies and propose improvements to enhance system functionality and performance.
- 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
- Bachelor’s degree (or 10 years equivalent experience)
- 7+ years of full stack development experience, with a focus on building data-driven applications and/or datamarts