Career

Overview

The Azure Data Engineer will partner closely with our technology team to provide reporting and insights. 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

• 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)
  • 1 or more years of experience creating PowerBI dashboards and paginated reports required and
  • 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 environment
  • 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 preferred
  LANGUAGE SKILLS
• Written 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

Overview

As a liaison between our technology and business teams, the Business Intelligence Analyst (BIA) will closely partner and consult with cross-functional department and personnel across the organization to ensure successful development and execution of solutions and services.

The BIA provides strategic, analytical, and technical support for Business Insights activities. The analyst leverages data to gain key insight into business opportunities, and effectively presents these insights to business stakeholders. The analyst is also heavily involved with the distribution and successful delivery of all reports. This role will work with data analysis and reporting tools to assist with business growth. During the first year this role will assist in the establishment of new software and infrastructure. The Business Intelligence Analyst will need to take on a project management role in the initial year. The scope of deliverables and analysis will increase as the new team is established within 12-18 months.

Responsibilities

ESSENTIAL DUTIES AND RESPONSIBILITIES:

• The Business Intelligence Analyst will help design, develop, implement, and maintain a comprehensive suite of business intelligence tools to inform and support key business decisions related to deposit portfolio and the Credit Union’s loan portfolio.
• Effectively manage vendors.
• Serve as subject matter expert in the development of business information deliverables (reports, dashboards, etc.).
• Support data architecture management, system-to-system management, data integration, data investigation and data integrity initiatives
• Construct, maintain and analyze various reports including those identifying needs, concentrations, exceptions, and other data useful to assess deposit and credit risk.
• Provide analytical support for various operational functions including Executive management, deposits, and lending as well as project management divisions.
• Utilize the Credit Union’s systems to create reports to manage the assets that require special attention and monitoring.
• Partners with stakeholders, process specialists, and users to elicit and document business requirements.
• Partners with business teams to define and document business requirements for new metrics and reports.
• Designs, develops, and maintains reports and analytical tools.
• Performs ongoing monitoring and refinement of reports.
• Provides technical support for existing reports, dashboards, or other tools.
• Identifies and analyzes errors and inconsistencies in the data and provides timely resolutions.
• Translates data results into dashboards, written reports, tables, graphs and charts to convey information to management in a digestible and visually appealing format
• Creates written communication materials that effectively summarize findings and support recommendations.
• Creates ad hoc reports and views on a frequent basis to assist management in understanding, researching and analyzing issues.
• The analyst leverages data to gain key insight into business opportunities, and effectively presents these insights to business stakeholders.
• The analyst is also heavily involved with the distribution and successful delivery of all reports.
• Teaches and advocates the use of business intelligence tools across levels of the organization.
• Provides strategic, analytical, and technical support for Business Insights activities.
• Performs Market analysis and maintains existing reports on a recurring basis.
• Supports implementation of new technologies and platform.

Qualifications

EDUCATION and/or EXPERIENCE

• Bachelor’s Degree in business, computer science, information systems or analytical techniques preferred, or equivalent work experience.
• 3 or more years of experience in Power BI tool including story telling of data visualization is required
• 3 or more years of experience in business intelligence analytics required
• Minimum 3 years of experience in project management or equivalent experience.
• 3 or more years of direct experience in dashboard and report writing required
• Familiarity with relational databases.
• Experience in a financial institution is highly preferred
• Manual dexterity and coordination are required while operating standard office equipment. such as computer keyboard and mouse, calculator, telephone, copiers, etc.
• Advanced knowledge of MS Office, SQL, and MS SQL Server.
• Advanced knowledge of common software to build dashboards.
• Demonstrated experience using data to drive business decision.
• Advanced analytical skills and attention to detail.
• Experience writing technical documentation.
• Strong skills in project management and requirement gathering.
• Proven ability to quickly learn new applications, processes, and procedures.
• Able and willing to collaborate in a team environment and exercise independent judgment.
• Strategic, intellectually curious thinker with focus on outcomes.
• Financial services, or banking industry experience preferred.

LANGUAGE SKILLS

Excellent written and verbal communication skills, which support effective communication of information to groups of managers, clients, customers, and the general public.

Professional with the ability to form good partner relationships across functions. Ability to effectively present information and respond to questions from business line managers and staff. Excellent verbal and written communication skills required.

Strong interpersonal, oral, and written communication skills and the ability to support the business owner with the presentation of business cases and/or other project related matters to Senior Management.

OTHER QUALIFICATIONS

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

Ability to work on multiple concurrent projects in a team environment, build excellent relationships, take ownership of team performance and results, and foster a sense of urgency and dedication to meeting goals.

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.

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 able to work during regular business hours and occasional nights or weekends as needed to meet production deadlines in a remote environment.