Senior Data Architect, Analytics COE

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

Job summary

United Nations Federal Credit Union is seeking a Data Architect to establish and build our long-term data strategy and architecture within the Data & Analytics Center of Excellence. Hybrid work model.

You will architect data warehouse and data lake solutions, expand data dictionaries, and promote best practices across IT and business units. Responsibilities include delivering high-quality data solutions, collaborating with BI, analytics, and leadership, and ensuring compliance with policies and

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, or related field.
• 3 years of experience in Data Architect Role.
• 5 years of working knowledge in Datawarehouse.
• 5 years of data engineering experience in MS SQL, Fabric, Snowflake or other equivalent data platforms.
• Experience in ETL development using Microsoft SQL Server Platform and Oracle DBMS.
• Proficiency in SQL, including query performance tuning, index maintenance, and understanding of database structures.
• Experience creating reports in Tableau, Power BI, or Qlik.
• Experience using cloud technologies like Microsoft Fabric, Snowflake, or Databricks.
• Knowledge of various SQL data storage mechanisms and Big Data technologies.
• Experience in warehousing architecture techniques, including MOLAP, ROLAP, ODS, Data Marts, and Enterprise Data Warehouse.

Responsibilities

• Uphold UNFCU’s mission and service excellence in all activities and interactions.
• Collaborate with data management teams to understand enterprise data requirements and contribute to data solution design.
• Partner with BI and analytics teams, product managers, and leadership to deliver high-quality data solutions.
• Ensure data platforms meet IT standards and design requirements across teams.
• Expand and maintain data dictionaries, architecture documents, and standards documentation.
• Develop data objects and processes (marts, tables, ETL components) within data warehousing and data lake ecosystems.
• Provide data architecture and analysis support to business units for active projects.
• Troubleshoot data platform, pipeline, and architecture issues and provide maintenance.
• Stay informed of industry trends and participate in relevant training and seminars.
• Participate in Credit Union training and development programs.
• Perform additional responsibilities and ensure compliance with laws and UNFCU’s Code of Ethics.

Skills

SQL proficiency

Data reporting

ETL development

Cloud data platforms

Data warehousing

Data architecture

Education

Bachelor’s degree in Computer Science, Information Systems, or related field

Tools

Tableau

Power BI

Qlik

Snowflake

Databricks

Microsoft Fabric

Job description

United Nations Federal Credit Union is seeking a Data Architect to establish and build our long-term data strategy and architecture within the Data & Analytics Center of Excellence. Hybrid work model.

You will architect data warehouse and data lake solutions, expand data dictionaries, and promote best practices across IT and business units. Responsibilities include delivering high-quality data solutions, collaborating with BI, analytics, and leadership, and ensuring compliance with policies and