BI Data Engineer

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

Data Migration from various systems to SQL Server Database

What makes you stand out

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.