Senior Architect - Data & 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

Why join this team

Establish and build out our long-term data strategy and architecture for the Data & Analytics Center of Excellence. Collaborate with various data management teams and business units in architecting and enhancing data warehouse & data lake solutions, ETL processes, and reports. Expand and maintain our data dictionaries, architecture design documents, and standards documentation and promote adherence to policy and best practices

This position is expected to be hybrid.

$140,000-$155,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.
• Collaborate with data management teams to understand enterprise data requirements and contribute to data solution and architecture design.
• Partner closely with business intelligence and analytics teams, product managers, and leadership to understand data needs, deliver precise and high-quality data solutions, and promote adherence to data policies and best practices.
• Partner with other IT teams to ensure data platforms, architecture, and development practices meet IT standards and design requirements.
• Expand and maintain data dictionaries, architecture design documents, standards documentation, and development frameworks.
• Develop data objects and processes, including marts, tables, and ETL components, within data warehousing and data lake ecosystems according to business and technical specifications.
• Provide data architecture and analysis support to business units for active projects and initiatives and propose effective solutions.
• Troubleshoot data platform, pipeline, and architecture-related issues, providing maintenance and support as needed to ensure maintainable and scalable architecture.
• Stay informed of industry trends and attend training, conferences, and seminars aligned with the organization’s business requirements.
• Participate in Credit Union training and development programs.
• Perform additional responsibilities as assigned.
• Ensure compliance with applicable federal and state laws and regulations, as well as UNFCU’s Code of Ethics & Business Conduct.

What we're seeking

• 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 tools like 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

What makes you stand out

• Experience with Azure Devops, Github, and CI/CD development principles
• Knowledge of financial/banking industry
• Experience working in environments within 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.