Job description

Our client, a major bank in New York City, is looking for Senior Snowflake and BI Developer Treasury Finance. New York City Location This is hybrid commute, 5 days per 2 weeks in the office. Salary is up to 190K, plus around 15-20% bonus, plus great benefits package. Senior Snowflake & BI Developer – Treasury Finance! The Senior Snowflake & BI Developer designs, develops, and supports enterprise data, analytics, and reporting solutions across Treasury and Finance, partnering with business, Data Architecture, and Engineering teams to translate requirements into scalable, production-quality solutions. The role requires strong hands-on Snowflake, SQL, data engineering, data modeling, and Power BI expertise, with Treasury and Finance experience supporting areas such as Liquidity Management, Cash Positioning, Funding, Intraday Liquidity, Reconciliation, Bank Statements, and financial reporting, while ensuring appropriate data quality, lineage, performance, security, and governance. PRINCIPAL DUTIES AND RESPONSIBILITIES Stakeholder Management • Act as a technical liaison with Treasury, Finance, Data Architecture, Engineering, Operations, Risk, and dependent technology teams. • Partner directly with Treasury and Finance users to understand reporting requirements, financial calculations, business rules, and data dependencies. • Communicate development progress, data-quality issues, risks, dependencies, and technical recommendations. • Work collaboratively with Solution Architects, Data Architects, Business Analysts, and application teams. • Support analysis and resolution of data and reporting discrepancies. Snowflake Data Development • Design, develop, test, and maintain scalable Snowflake data solutions, including advanced SQL transformations, dimensional models, financial data marts, and reusable data components. • Build and maintain ETL/ELT pipelines to ingest, transform, aggregate, and publish Treasury and Finance data from multiple source systems. • Design and develop Power BI dashboards, semantic models, KPIs, calculations, and DAX measures supporting Treasury and Finance reporting and analytics. • Optimize Snowflake queries, data structures, and processing patterns for performance, scalability, and efficient resource utilization, while troubleshooting data issues across upstream and downstream layers. • Implement data-quality, reconciliation, and reporting controls to ensure Power BI outputs reconcile to approved source data and financial control totals. Requirements & Data Solution Design • Partner with Treasury and Finance users to translate business requirements into data requirements, reporting specifications, transformation rules, and source-to-target mappings. • Collaborate with Data and Solution Architects to design target-state data models and flows, maintaining traceability from source systems through Snowflake to Power BI. • Maintain required data models, mappings, and technical documentation. • Data Quality, Governance & Controls • Implement data-quality, validation, and reconciliation controls across source systems, Snowflake, and reporting layers. • Maintain data lineage, governance, security, and access controls for Treasury and Finance data. • Support the full development lifecycle, including testing, UAT, code review, deployment, and production support. ________________________________________ MINIMUM JOB REQUIREMENTS OR EXPERIENCE Business & Domain Experience • 5+ years of experience in data engineering, BI development, data warehousing, analytics engineering, or financial-services technology. • Hands-on expertise in Snowflake, advanced SQL development, and Power BI, supported by strong knowledge of dimensional data modeling, enterprise data warehousing, data marts, data aggregation and transformation, data-quality controls, and end-to-end data lineage. • Experience working directly with Finance/Treasury stakeholders to understand financial data and reporting requirements. • Experience working within Agile delivery environments. EDUCATION AND OTHER REQUIREMENTS • Bachelors in Engineering, Information Systems or equivalent practical experience. • Strong written and verbal communication skills. • Ability to translate business concepts into technical data solutions. • Ability to work independently and take ownership of development deliverables. • Comfortable working across business, technology, risk, operations, and data organizations. • Strong analytical and problem-solving skills. • High attention to data accuracy, reconciliation, and financial controls. Please email your resume or use this link to apply directly: brainsworkgroup.catsone.com Or email: igork@brainsworkgroup.com Check ALL our Jobs: brainsworkgroup.catsone.com Keywords: Snowflake power bi etl elt dax treasury finance banking kpi

Requirements

Must-haves

Our client, a major bank in New York City, is looking for Senior Snowflake and BI Developer Treasury Finance.
New York City Location
This is hybrid commute, 5 days per 2 weeks in the office.
Senior Snowflake & BI Developer – Treasury Finance!
Stakeholder Management
Act as a technical liaison with Treasury, Finance, Data Architecture, Engineering, Operations, Risk, and dependent technology teams.
Partner directly with Treasury and Finance users to understand reporting requirements, financial calculations, business rules, and data dependencies.
Communicate development progress, data-quality issues, risks, dependencies, and technical recommendations.
Work collaboratively with Solution Architects, Data Architects, Business Analysts, and application teams.
Support analysis and resolution of data and reporting discrepancies.
Snowflake Data Development
Design, develop, test, and maintain scalable Snowflake data solutions, including advanced SQL transformations, dimensional models, financial data marts, and reusable data components.
Build and maintain ETL/ELT pipelines to ingest, transform, aggregate, and publish Treasury and Finance data from multiple source systems.
Design and develop Power BI dashboards, semantic models, KPIs, calculations, and DAX measures supporting Treasury and Finance reporting and analytics.
Optimize Snowflake queries, data structures, and processing patterns for performance, scalability, and efficient resource utilization, while troubleshooting data issues across upstream and downstream layers.
Implement data-quality, reconciliation, and reporting controls to ensure Power BI outputs reconcile to approved source data and financial control totals.
Requirements & Data Solution Design
Partner with Treasury and Finance users to translate business requirements into data requirements, reporting specifications, transformation rules, and source-to-target mappings.
Collaborate with Data and Solution Architects to design target-state data models and flows, maintaining traceability from source systems through Snowflake to Power BI.
Maintain required data models, mappings, and technical documentation.
Data Quality, Governance & Controls
Implement data-quality, validation, and reconciliation controls across source systems, Snowflake, and reporting layers.
Maintain data lineage, governance, security, and access controls for Treasury and Finance data.

Nice-to-haves

Salary is up to 190K, plus around 15-20% bonus, plus great benefits package.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sqlagile

Platform: catsone
Effort: medium