Data Warehouse Developer

Overview

Working at Arkansas Federal Credit Union

 

 

GENERAL DESCRIPTION OF POSITION

 

The Data Warehouse Developer II is responsible for all aspects of the data warehouse environment, including maintenance, development, and enhancements. This role also provides recommendations for loading external data sources/types with adequate documentation for complex assignments under little supervision.

ESSENTIAL DUTIES AND RESPONSIBILITIES

Design and implement secure, resilient, and scalable warehouse architecture that meets current and future needs of the organization.

Design, develop and implement data solutions, including schema design, modeling, metadata repository, database development, root cause analysis, and system testing.

Understand and influence long-term data strategies and advocate for additional data sets and elements to support credit union data-driven decision objectives.

Collaborate with project leads, business analysts, end-users, and third-party contacts to ensure that new initiatives enable effective analytic information management.

Establish and document database standards, process maps for all processes, and measurement methods and metrics to ensure efficiency and effectiveness.

Effectively manage day-to-day warehouse operations, ensuring the scheduled deliverables in support of developer needs and other business requirements. Ensure automation for repeatable database tasks and processes is utilized when possible.

Monitor and support the data warehouse, including data integrations (Oracle, SQL Server, etc.), access management, load balancing, performance, and operational monitoring, meta and master data management, and advise team on improving the performance and reliability of the solution.

Design Business Objects universe layers for business intelligence solutions. Optimize the performance of Business Objects applications.

Strong communication and collaboration skills with the ability to multi-task, reprioritize, and escalate as necessary.

Strong decision making, analytical, problem solving, and time management skills.

Help and constructively mentor team members in their professional development.

Perform any other related duties as required or assigned.

QUALIFICATIONS

 

To perform this job successfully, an individual must be able to perform each essential duty mentioned satisfactorily.  The requirements listed below are representative of the knowledge, skill, and/or ability required.

 

EDUCATION AND EXPERIENCE

• Bachelor's degree in an IT or analytical related field or equivalent work experience.
• 2 - 4 years of hands-on experience in design and implementation of ETL framework for complex data warehouse projects using Microsoft bi technology (SSRS, SSIS, SSAS, and Power BI).
• Experience delivering data quality outcomes, performing and presenting data profiling results, working with relational databases including Oracle PL/SQL or MS SQL, and a multitude of file formats.
• Excellent knowledge of relational data modeling (ERD), SQL and data warehousing.

EEO Statement

Arkansas Federal Credit Union is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, religion, color, national origin, gender, gender identity, sexual orientation, age, status as a protected veteran, among other things, or status as a qualified individual with disability.