Senior Architect - Data & Analytics COE

UNFCU; New York (NY); Hybrid; USD 140.000 - 155.000; Vollzeit

Zusammenfassung

UNFCU is seeking a Data Architect to establish and advance our data strategy and architecture within the Data & Analytics Center of Excellence. You will collaborate across data management teams and business units to design scalable data warehouse and data lake solutions, ETL processes, and governance artifacts.

A hybrid work model is provided, with compensation aligned to New York expectations. You will lead development of data objects, marts, and pipelines, while ensuring adherence to data

Qualifikationen

• Bachelor’s degree in CS/IS or related field.
• 3 years of Data Architect experience.
• 5 years in Datawarehousing.
• 5 years in data engineering with MS SQL, Fabric, Snowflake or equivalent.
• Experience in ETL development using MS SQL Server and Oracle DBMS.
• Proficiency in SQL and query performance tuning.
• Experience creating reports in Tableau/Power BI/Qlik.

Aufgaben

• Establish and build out data strategy and architecture for data warehouse and data lake solutions.
• Collaborate with data management teams and business units on enterprise data requirements.
• Partner with BI/analytics, product managers, and leadership to deliver data solutions and promote data policies.
• Ensure data platforms meet IT standards and design requirements.
• Expand data dictionaries, architecture docs, standards, and development frameworks.
• Develop data objects and ETL components within data warehousing and data lake ecosystems.
• Provide architecture support to business units for active projects and initiatives.
• Troubleshoot data platform, pipeline, and architecture issues; ensure scalable solutions.
• Stay informed of industry trends and participate in relevant training and conferences.

Kenntnisse

SQL Proficiency

Data Modeling

ETL Development

Performance Tuning

Cloud Data Platforms

Ausbildung

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

Tools

Tableau

Power BI

Qlik

Jobbeschreibung

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

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