Apply on Employer Site

UNFCU · 2 weeks ago

Senior Data Engineer, BI

Queens, NY

Full-time

Hybrid

Senior Level

$105K/yr - $130K/yr

6+ years exp

UNFCU is a global not-for-profit financial institution that serves the UN community. They are seeking a Senior Data Engineer to design and deliver scalable OLTP, Business Intelligence, and Data Warehouse solutions while maintaining data quality and integrity across systems.

AccountingFinanceFinancial ExchangesFinancial ServicesMobile AppsPayments

Responsibilities

Uphold UNFCU’s mission, core values, and guiding principles by providing an exceptional service experience to colleagues and members alike through consistent demonstration of our service excellence behaviors

Develop and maintain ETL/ELT processes using SSIS, Fabric Pipelines, and/or Azure Data Factory, including advanced Script Tasks (C# or VB.NET) to automate file operations and apply custom business logic

Develop and implement solutions in Microsoft PowerBI and Microsoft Fabric, including Lakehouse/Warehouse modeling, Dataflows Gen2, Pipelines, and Semantic Models; support the modernization of existing ETL and reporting assets into Fabric and Azure cloud-based frameworks

Design, develop, and optimize complex T-SQL stored procedures, functions, and database objects for high-volume OLTP and Data Warehouse environments, with expertise in transaction isolation levels, table hints, deadlocks, linked servers, OPENQUERY, triggers, and column-level encryption

Perform advanced database performance tuning, including execution plan analysis, indexing strategies, partitioning, and transaction optimization

Contribute to the design and enhancement of OLTP and OLAP data models, ensuring alignment with business, analytical, and performance requirements

Build and support integrations that consume or expose REST APIs, including testing, validation, and troubleshooting using Postman and related API tools

Create and govern dashboards and visual analytics in Power BI or Tableau, ensuring accuracy, compliance with governance standards, and proper alignment with semantic models

Verify and maintain data quality and integrity across the data warehouse, semantic models, dashboards, reports, and data extracts

Troubleshoot and resolve database, ETL, reporting, data quality, performance, capacity, replication, and distributed data issues; participate in incident resolution and root-cause remediation

Maintain thorough documentation, adhere to change control processes, and support regulatory, cybersecurity, and data protection compliance

Collaborate with Product Managers, Analysts, Engineers, and cross-functional teams to enhance BI and data platform capabilities

Stay current with industry trends and participate in relevant training, conferences, and professional development programs. Participate in Credit Union training and development programs

Perform additional responsibilities as assigned

Ensure compliance with federal and state laws and regulations and UNFCU’s Code of Ethics & Business Conduct

Qualification

Microsoft FabricSSISSQL ServerPower BIETL/ELT processesT-SQLData WarehouseData MartsAPI integrationC#VB.NETTableauOracleXMLDocumentationCollaboration

Required

Bachelor's degree in Engineering or Computer Science

6 years of experience in reports and data warehouse development

5 years software development experience on Microsoft BI Platform including, MS SQL Server

4 years of experience in DB Development (OLTP) using MS SQL

2 years of experience in building Data Marts using dimensional models

2 years of experience in building Dashboards and KPI visualization on Power BI and/or Tableau

Strong reporting and data warehouse development skills on issues that are complex and evaluative in nature where troubleshooting may call for referencing an advanced knowledge base

Large data migration experience

Hands on experience using Oracle