BI Data Engineer

United Nations Federal Credit Union; New York (NY); Hybrid; USD 105,000 - 140,000; Full time

Job summary

A forward-thinking financial institution is seeking a skilled Data Engineer to join their innovative team. In this pivotal role, you will leverage your extensive experience in data migration, data warehousing, and business intelligence tools to develop and enhance data-driven applications. Collaborating closely with analysts and product managers, you will gather requirements, troubleshoot issues, and deliver exceptional BI solutions. This position offers a hybrid work environment, allowing you to balance your professional and personal life while contributing to a mission-driven organization dedicated to serving the UN community. If you are passionate about data and eager to make a meaningful impact, this opportunity is perfect for you.

Qualifications

• 6+ years of experience in building data intensive applications.
• Strong working knowledge with data migration and data warehousing.
• Experience in BI tools like Tableau, Power BI, and SQL Server.

Responsibilities

• Develop backend applications using TSQL/PLSQL in SQL Server and Oracle.
• Communicate with team members to gather requirements and enhance data assets.
• Design and maintain reports on SSRS and/or OBIEE.

Skills

Data Migration

Data Warehousing

TSQL

PLSQL

Business Intelligence Solutions

Analytical Skills

Communication Skills

Problem Solving

Multi-tasking

Education

Bachelor's degree in Engineering

Bachelor's degree in Computer Science

Tools

Microsoft SQL Server

Tableau

Power BI

SSRS

OBIEE

Microsoft SSIS

Job description

Why join this team

Data Engineer with 6+ years of experience in building data intensive applications, tackling challenging architectural and scalability problems with some exposure to gathering insights from data by leveraging various BI tools like Tableau, Power BI, MS SQL Server, and OBIEE (Oracle Business Intelligence Enterprise Edition). Demonstrate strong working knowledge with data migration and data warehouse and display excellent communication skills to be comfortable enough to interact with business areas to gather requirements and deliver BI solutions.

This position is expected to be hybrid.

NYC Salary Range - $105,000 - $140,000 annually; compensation is commensurate to geographic location.

What you'll do

• Regardless of seniority or role, 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.
• Communicate well and work closely with team members including Analysts, Product Managers, and business users to gather requirements, troubleshoot, modify, and enhance existing Data assets.
• Develop backend applications in Database using TSQL/PLSQL in Microsoft SQL Server and Oracle Database. Write complex code in stored procedures or PL SQL.
• Demonstrate strong exposure to relational databases technologies like Database, Data Warehouse, Data Lakes and Data Lake House.
• Troubleshoot to find root cause with data accuracy and/or performance related issues and find solutions to fix it by creating indexes, transaction isolation levels and optimizing code.
• Resolve database performance issues by looking at query plans, create appropriate indexes, resolve dead locks and create table hints.
• Design, develop, deploy, and maintain reports on SSRS and/or OBIEE.
• Evaluate, design, propose, and secure approval for all design and implementation.
• Work with multiple environments for development, testing, and deploying in production.
• Develop, implement, and maintain change control and testing processes for modifications to databases.
• Follow the organization’s data protection and network securities and antivirus policies.
• May need to demonstrate familiarity with dimensional models such as SSAS cube and tabular model.
• May need to demonstrate knowledge of some shell scripting language.
• Stay abreast of industry trends, and attend training, conferences and seminars according to organization’s business requirements.
• 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.

What we're seeking

• Bachelor’s degree in Engineering or Computer Science
• 6+ years of experience in Microsoft SQL Server
• 6+ years of experience in ETL tools like Microsoft SSIS
• 3 years software development experience on BI Platform like – SSRS, Power BI, Tableau
• Hands on experience using Microsoft SQL Server
• Data migration and Data warehousing with skills on issues that are complex and evaluative in nature where troubleshooting may call for referencing an advanced knowledge base
• Developing Business Intelligence Solutions by creating Dashboards and Reports
• Experience in the following areas:
  • Data Migration from various systems to SQL Server Database
  • Building Data Marts using dimensional models is a plus
  • Oracle PL/SQL
  • Maintaining code/scripts in TFS for multiple environments
  • DBA activities like database backup and restore
• Strong analytical ability/problem solving skills
• Ability to work independently and within a team environment to complete assigned projects in a timely manner
• Strong interpersonal, verbal and written communication skills
• Able to multi-task, taking on several initiatives at once

What makes you stand out

• Knowledge of financial/banking industry
• Experience in working in environments with in various firewall layers

Who we are

UNFCU is a global not-for-profit financial institution that serves the UN community. We are committed to providing peace of mind to our members and colleagues and strive to achieve service excellence in all that we do. The best part of UNFCU is the people. Those that choose to work with us often find personal fulfillment, professional growth and a purposeful culture.

UNFCU is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. UNFCU prohibits discrimination and harassment of any type. All applicants will be considered for employment without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by country, federal, state or local laws.