Snowflake and BI Developer Treasury Finance

BRAINS WORKGROUP, INC.; New York (NY); Hybrid; USD 170,000 - 210,000; Full time

Job summary

BRAINS WORKGROUP, INC. seeks a Senior Snowflake & BI Developer for Treasury Finance in New York. The role designs, builds, and supports enterprise data, analytics, and reporting solutions across Treasury and Finance with strong Snowflake, SQL, data modeling, and Power BI expertise.

You will partner with business and technology teams to translate requirements into scalable, production-quality data solutions, ensuring data quality, governance, and timely delivery in a hybrid work setting.

Qualifications

• 5+ years of experience in data engineering, BI development, data warehousing, analytics engineering, or financial-services technology.
• Hands-on Snowflake, SQL, and Power BI development.
• Experience working with Finance/Treasury stakeholders to understand data and reporting requirements.
• Experience working in Agile delivery environments.

Responsibilities

• Design, develop, and maintain Snowflake data solutions for Treasury and Finance across data sources and downstream reporting.
• Build and maintain ETL/ELT pipelines to ingest and transform data.
• Design and develop Power BI dashboards and semantic models to support treasury reporting and analytics.
• Optimize Snowflake queries and data structures for performance and governance; ensure data quality and lineage.
• Collaborate with stakeholders and architects to translate requirements into data models and data flows; support testing and production deployment.

Skills

Snowflake

SQL

Power BI

Data modeling

ETL/ELT

Data governance

Analytics engineering

Agile

Education

Bachelor's degree in Engineering/Information Systems

Tools

Snowflake

Power BI

DAX

Job description

Snowflake and BI Developer Treasury Finance

• New York, NY
• Information Technology

Our client, a major bank in New York City, is looking forSenior 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.