Snowflake and BI Developer Treasury Finance

#### 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:

https://brainsworkgroup.catsone.com/careers/index.php?m=portal&a=details&jobOrderID=16866063
Or email: [email protected] (https://brainsworkgroup.catsone.com/careers/index.php?m=portal&a=apply&jobOrderID=16866063&portalID=9549)
Check ALL our Jobs: http://brainsworkgroup.catsone.com/careers

Keywords: Snowflake power bi etl elt dax treasury finance banking kpi