Overview

The Azure Data Engineer will partner closely with our technology and business teams to enhance the existing data warehouse to provide reporting and insights to the business users. This position will be primarily technical, but will also involve some soft skills. The primary responsibilities of this role include development in the Azure data warehouse using SQL (Create Views and Stored Procedures), Azure Data Factory, Azure Databricks (Python), and Power BI (Desktop and Report Builder), amongst other tools. The Engineer will be expected to design, develop, and test solutions independently in an agile environment while working closely with and taking direction from the Data Warehouse Architect. The Azure Data Engineer will consult with personnel across the Credit Union and leverage knowledge of credit union or financial services industry to ensure successful development and execution of solutions. Through collaboration with business owners, this position will elicit functional requirements and translate these into technical requirements, which the Engineer will then implement in planned sprints. This position will also involve working with business users to assist them with user acceptance testing (UAT). This role may also involve the documentation of user procedures and the training of end-users.

Responsibilities

• Enhances and optimizes components of the data lake and data warehouse to support strategic and operational reporting and data analysis• Designs, develops, maintains, monitors, and supports scalable ETL solutions to deliver data from various source systems to the data lake, which may include both structured and unstructured data• Analyzes source data and builds appropriate data models to structure data to be used to fulfill current business requests, while being flexible enough to be leveraged for future needs• Analyzes data and identifies/resolves data integrity issues and data anomalies• Leverages data governance standards to ensure accuracy, timeliness, and completeness of data warehouse data• Documents data flows and processes; maintains documentation including data dictionary• Develops solutions to meet business reporting and analysis needs using SQL, Azure Databricks, Python, and Power BI• Ensures solutions are well designed, sufficiently documented, and easy to maintain and repurpose for future initiatives• Strong listener with analytical skills who can understand requests from business owners and recommend options for potential solutions based on knowledge of the credit union industry, business needs, and available data• Documents requirements with enough detail, clarity, and key artifacts for traceability in developing solutions that meet the business needs• Performs Quality Assurance (QA) Testing to validate/ensure technological feasibility of proposed solutions• Works with business teams to confirm sample data for testing that meets all key scenarios• Facilitates end-to-end UAT with business owners, which may include developing test cases, ensuring test case traceability to requirements, assisting users with test execution, validating and documenting results, resolving bugs, and providing status reports to project management.• Assesses impact to processes from new projects and initiatives that involve the data warehouse, negotiates modifications to optimize benefits and limit negative impacts, and aligns requirements to solutions• Performs data systems analysis of functions performed within the credit union with the intent of improving overall productivity and efficiency• Participates in (and may periodically be responsible for) creating project communications, training materials, and business procedures/documentation; may be asked to conduct user training on newly developed solutions• Delivers relevant technical and operational information to business stakeholders or other relevant parties. • Participates in production releases by coordinating with production management, performing verification, confirming business readiness, answering questions regarding expected functionality, and gathering user feedback post go-live• Performs other duties as assigned

Qualifications

• Experience in the financial services industry strongly preferred• Advanced knowledge of credit union operations/processes and procedures is desirable• Experience working with data warehouses and data lakes• Familiarity with Azure Cloud and related Azure tools• Very strong technical skills and experience developing in SQL, Python, Power BI• Experience with Agile software development frameworks• Familiarity with industry standard IT security practices is a plus• Experience in translating business requirements into technical requirements• Advanced skill applying innovative approaches to solving technical issues and negotiating with stakeholders to find acceptable solutions to business challenges• Thorough familiarity with problem analysis, determining root cause, scope, and scale of issues, and excellent level of problem-solving capabilities to establish reasonable solutions• Excellent communication - verbal and written• Proven presentation and facilitation skills when working with key stakeholders and management of all areas of the credit union• Ability to work independently, as well as with all levels within the credit union• Must be highly organized and capable of handling multiple tasks concurrently, able to redirect priorities based upon current workload, and flexibility to respond to changes of schedules, plans and priorities• Must be a fast and eager learner, adept at asking the right questions to understand business processes and needs, capable of synthesizing new information quickly, and able to become the subject-matter expert in a functional area• Proficiency with MS Office, DevOps, and experience with diagramming and collaboration tools• Analytical skills to translate needs of users and external entities into projects or tasks, which are practical and are well synthesized and integrated into the systems environment• Ability to translate use cases and requirements into test cases and conduct QA testing, while retaining traceability• Knowledge of UAT process and business analysis function• Ability to work on multiple concurrent projects in a team environment and build relationships with other teams• Experience with user guides and user training is a plus

EDUCATION and/or EXPERIENCE • Bachelor's Degree in computer science, information systems or analytical techniques preferred, or equivalent work experience (5 plus years in a similar role)o 1 or more years of experience creating PowerBI dashboards and paginated reports required ando 3 or more years of experience as an Azure Data Engineer preferred; experience must include working independently on projects that built or enhanced large and complex production data warehouses in a formal, process-oriented environmento 5 or more years of experience using TSQL• Experience with data vault architecture preferred• Experience programming in Python Using Databricks preferred• Credit union, financial services, or banking industry experience strongly preferredLANGUAGE SKILLSWritten and verbal communication skills, which support effective communication of information to groups of managers and clients. Ability to effectively present information and respond to questions from business line managers and staff. Excellent verbal and written communication skills required.

Ability to read, interpret, analyze and communicate with all levels of staff on a variety of topics, including but not limited to data structures, data warehouse solutions, and data outputs (dashboards and reports). Ability to create technical and process documentation.

TECHNOLOGY PROFICIENCY To perform this job, the employee must possess applicable technology skills and demonstrated expertise. • The requirements for this job include proficiency in Azure Cloud components, SQL, Microsoft SQL Server Management Studio (SSMS), Azure Databricks, ETL processes including familiarity with Azure Data Factory, Python, and development of dashboards and reports in Power BI • Must also have the ability to efficiently use MS Word, Excel, PowerPoint and other Microsoft Office applications; Excel skills will include filtering, formatting, pivot tables, and formulas• Experience with diagramming tools, such as Visio or Lucidchart preferred• Ability to use project management and collaboration tools, such as Confluence, Monday.com, Jira, and DevOps• Solid understanding of the overall SDLC and Agile methodologies

CERTIFICATES, LICENSES, REGISTRATIONS The following certifications are desirable:• Microsoft Certified: Azure Data Engineer Associate• Databricks Certified Data Engineer Associate• Data Vault Certification

OTHER QUALIFICATIONSTo perform this job, the employee must possess strong interpersonal skills, good phone and e-mail etiquette, a professional presentation, and a high degree of personal initiative. Must also possess strong creative skills and good writing skills. Must be organized, self-disciplined and detail-oriented with the ability to manage and juggle multiple projects. Persistent and dependable, especially in meeting deadlines; able to manage multiple competing priorities. Must be able to work during regular business hours and occasional nights or weekends as needed to meet production deadlines.

BluPeak Credit Union is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex including sexual orientation and gender identity, national origin, disability, protected Veteran Status, or any other characteristic protected by applicable federal, state, or local law.

Employment may be contingent upon BluPeak Credit Union’s receipt of an acceptable and job-related background check, drug screen, credit check and vaccine verification, as applicable and permissible by law. BluPeak Credit Union is committed to the safety and wellbeing of our employees and their families; our members and visitors; and the community at large. In accordance with our duty to provide and maintain a workplace that is free of known hazards, we are requiring that employees must have received or be willing to receive the COVID-19 vaccine. BluPeak Credit Union continues to monitor the pandemic following CDC guidelines, federal state and local laws. Policies continue to be adjusted as new information emerges. BluPeak Credit Union is committed to working and provide reasonable accommodation to applicants with physical, mental disabilities and sincerely held religious beliefs. For more information, contact Human Resources.

PM17

Min

Max