Senior Architect - Data & Analytics COE

United Nations Federal Credit Union•New York, NY

2d•$140,000 - $155,000•Hybrid

About The Position

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.

Requirements

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

Nice To Haves

Experience with Azure Devops, Github, and CI/CD development principles
Knowledge of financial/banking industry
Experience working in environments within various firewall layers

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.
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.