UNFCU
Senior Architect Data & Analytics COE
UNFCU, Long Island City, New York, United States, 11109
Why Join This Team
Collaborate with various data management teams and business units, enhancing and architecting data warehouse and data lake solutions, extracting data (ETL), and testing it upon completion. Possess knowledge of coding languages like SQL and Python, data warehouse architecture, data security, and data strategy. Create a highly efficient data solution that suits the data storage, modeling, and visualization needs of the company. This position is expected to be hybrid. NYC Salary Range - $140,000-$155,000 annually; compensation is commensurate to geographic location. What You'll Do
Regardless of seniority or role, uphold UNFCUs 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 the companys overarching data requirements. Maintain and improve existing processes; ensuring that data architecture remains scalable and maintainable. Gather requirements and business process insights to transform data to support end-user needs. Design and code data warehousing and data lake systems to desired specifications. Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities. Extract company data for migration to the new data warehousing environment; conduct testing to validate functionality and data accuracy post-migration. Collaborate with business units, developers, product managers, and leadership to design and deliver precise, high-quality data solutions. Analyze data to identify potential issues within ETL pipelines, communicating findings to end-users, and proposing effective solutions. Develop and maintain technical artifacts related to data practices across the organization. Support business units for various open projects. Troubleshoot issues, providing maintenance and support as needed. Stay abreast of industry trends, and attend training, conferences, and seminars according to the organizations 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 UNFCUs Code of Ethics & Business Conduct. What We're Seeking
Bachelors degree in Engineering, Computer Science, or related field 2+ years of experience in Data Architect Role 4+ years of strong working knowledge in Datawarehouse 4+ years software development experience on Microsoft data products Proven work 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 Knowledge of ETL tool like SSIS, Azure pipeline, Synapse Analytics, Data factory Ability to analyze big-picture data needs for the organization Experience in Data Migration from various systems to SQL Server Database What Makes You Stand Out
Experience with creating reports in tools like Tableau or Power BI Exposure to Microsoft cloud technologies like Microsoft Fabric, SQL Data Lake, Azure Data Warehouse Knowledge of various SQL data storage mechanisms and Big Data technologies Proficiency in coding languages, including Python, SQL, and DAX Experience in warehousing architecture techniques, including MOLAP, ROLAP, ODS, Data Marts, and Enterprise Data Warehouse Experience with data security practices using a combination of layered security controls: network, identity, privacy, and authorization Familiarity with single sign-on (SSO) authentication using Azure Active Directory (Azure AD) Exposure to Data encryption tools and standards Exposure to XML and HTML Knowledge of financial/banking industry 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.
Collaborate with various data management teams and business units, enhancing and architecting data warehouse and data lake solutions, extracting data (ETL), and testing it upon completion. Possess knowledge of coding languages like SQL and Python, data warehouse architecture, data security, and data strategy. Create a highly efficient data solution that suits the data storage, modeling, and visualization needs of the company. This position is expected to be hybrid. NYC Salary Range - $140,000-$155,000 annually; compensation is commensurate to geographic location. What You'll Do
Regardless of seniority or role, uphold UNFCUs 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 the companys overarching data requirements. Maintain and improve existing processes; ensuring that data architecture remains scalable and maintainable. Gather requirements and business process insights to transform data to support end-user needs. Design and code data warehousing and data lake systems to desired specifications. Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities. Extract company data for migration to the new data warehousing environment; conduct testing to validate functionality and data accuracy post-migration. Collaborate with business units, developers, product managers, and leadership to design and deliver precise, high-quality data solutions. Analyze data to identify potential issues within ETL pipelines, communicating findings to end-users, and proposing effective solutions. Develop and maintain technical artifacts related to data practices across the organization. Support business units for various open projects. Troubleshoot issues, providing maintenance and support as needed. Stay abreast of industry trends, and attend training, conferences, and seminars according to the organizations 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 UNFCUs Code of Ethics & Business Conduct. What We're Seeking
Bachelors degree in Engineering, Computer Science, or related field 2+ years of experience in Data Architect Role 4+ years of strong working knowledge in Datawarehouse 4+ years software development experience on Microsoft data products Proven work 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 Knowledge of ETL tool like SSIS, Azure pipeline, Synapse Analytics, Data factory Ability to analyze big-picture data needs for the organization Experience in Data Migration from various systems to SQL Server Database What Makes You Stand Out
Experience with creating reports in tools like Tableau or Power BI Exposure to Microsoft cloud technologies like Microsoft Fabric, SQL Data Lake, Azure Data Warehouse Knowledge of various SQL data storage mechanisms and Big Data technologies Proficiency in coding languages, including Python, SQL, and DAX Experience in warehousing architecture techniques, including MOLAP, ROLAP, ODS, Data Marts, and Enterprise Data Warehouse Experience with data security practices using a combination of layered security controls: network, identity, privacy, and authorization Familiarity with single sign-on (SSO) authentication using Azure Active Directory (Azure AD) Exposure to Data encryption tools and standards Exposure to XML and HTML Knowledge of financial/banking industry 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.