Snowflake and BI Developer Treasury Finance

Brains Workgroup
  • New York
    8 days ago

    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 usethis link to apply directly:
    https://brainsworkgroup.catsone.com/careers/index.php?m=portal&a=details&jobOrderID=16866063
    Or email: igork@brainsworkgroup.com
    Check ALL our Jobs: http://brainsworkgroup.catsone.com/careers





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

    Numbers & Facts

    LocationNew York
    Websitehttp://www.brainsworkgroup.com

    Skills

    • Acceptance Testingunmatched
    • Access Controlunmatched
    • Agile Programming Methodologiesunmatched
    • Analysis Skillsunmatched
    • Architectural Analysisunmatched
    • Architectural Designunmatched
    • Business Analysisunmatched
    • Business Architectureunmatched
    • Business Intelligenceunmatched
    • Business Skillsunmatched
    • Code Reviewsunmatched
    • Communication Skillsunmatched
    • Data Analysisunmatched
    • Data Collectionunmatched
    • Data Martunmatched
    • Data Modelingunmatched
    • Data Qualityunmatched
    • Data Structuresunmatched
    • Data Warehousingunmatched
    • Database Extract Transform and Load (ETL)unmatched
    • Dimensional Modelingunmatched
    • Financeunmatched
    • Financial Analysisunmatched
    • Financial Controlunmatched
    • Financial Modelingunmatched
    • Financial Reportingunmatched
    • Financial Servicesunmatched
    • Financial Statementsunmatched
    • Fundingunmatched
    • Identify Issuesunmatched
    • Information Technology & Information Systemsunmatched
    • Liquidityunmatched
    • Performance Metricsunmatched
    • Power BIunmatched
    • Presentation/Verbal Skillsunmatched
    • Problem Solving Skillsunmatched
    • Product Lifecycleunmatched
    • Production Supportunmatched
    • Query Optimizationunmatched
    • Reconciliationunmatched
    • Reporting Dashboardsunmatched
    • Requirements Managementunmatched
    • Resource Utilizationunmatched
    • Riskunmatched
    • SQL (Structured Query Language)unmatched
    • Snowflake Schemaunmatched
    • Source Code Control System (SCCS)unmatched
    • Technical Writingunmatched
    • Test Plan/Scheduleunmatched
    • Testingunmatched
    • Traceabilityunmatched
    • Treasuryunmatched
    • Writing Skillsunmatched

    Be found by employers

    5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

    Level up your application

    Professional resume templates

    Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

    Free resume templates

    Resume Builder

    Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

    Resume Builder