Alaska USA Federal Credit Union

Receive alerts when this company posts new jobs.

Similar Jobs

Job Details

Data Warehouse Developer I

at Alaska USA Federal Credit Union

Posted: 10/14/2019
Job Status: Full Time
Job Reference #: *35477C450EF0F623
Keywords:

Job Description

Requisition Number
19-0579

Post Date
7/1/2019

Title
Data Warehouse Developer I

Position Type
Full Time

Company
Alaska USA Federal Credit Union

Location
C Street Administration

City
Anchorage

State
AK

Minimum Salary Grade
Category 10: depending on experience

Work Hours
Monday - Friday 9:00 am - 5:30 pm

Regular Schedule is five 8 hour days?
Yes

Description

Reports to: Vice President, Financial Analysis

Functions Supervised: None

Primary Functions: Assists in eliciting business requirements, designing, building and supporting the components of the data warehouse (data models, metadata, ETL). Assist power users in creating and maintaining reports and dashboards to deliver business intelligence to the organization. Assist in developing governance processes around data management.

Duties and Responsibilities:

  1. Works with Business users and domain SMEs to understand requirements.
  2. Assists in maintaining data models (dimensional models with conformed dimensions, entity relational models), and Data Vault models to satisfy analytics requirements.
  3. Assist in building ETL processes to load and reconcile data in the warehouse.
  4. Assists in data mapping activities by specifying logic and business rules for transforming and preparing data.
  5. Provides assistance and support to the development and publication of reports and dashboards.
  6. Assists with Data Quality (DQ) and Master Data Management (MDM) initiatives.
  7. Assists in developing governance processes around data management and the warehouse development.
  8. Develops knowledge of credit union operations and knowledge of current industry trends as well as current methods and technologies that relate to Data Warehousing, data preparation, data presentation practices and operations.
  9. Performs other duties as assigned.


Requirements

Qualifications

Education: Bachelor's degree in Business, Computer Science, Management Information Systems or related field.

Creditable Experience in Lieu of Education: Minimum of three years progressive experience in data modeling (dimensional and ER), data vaults, and / or SQL for creating data stores, data marts and data warehouses.

Experience/Skills: Strong oral, written, administrative, organizational and inter-personal skills. The ability to analyze problems, develop alternatives and recommendations. Proficiency in converting analytical requirements into dimensional models (star schema, snowflakes, conformed dimensions, etc.), familiarity with scripting languages (python, PowerShell, etc.). Experience with data base design and loading and reconciling data in a SQL warehouse. Proficiency in SQL and self-service analytics tools such as Excel, Power Pivot, YellowFin, Snowflake, PowerBI, Tableau etc. Proficient in developing SSAS cubes and tabular models and SSRS reports. Familiarity with Visual Studio, TFS and SSIS. Familiarity with Master Data Management, data quality tools, data integration tools, R, and Python is desired. Financial Services experience and familiarity of big data concepts is a plus.

Tenure: Assignment to the Data Warehouse Developer I category 10, Data Warehouse Developer II category 09, Data Warehouse Developer III category 08, or Senior Data Warehouse Developer category 07 will be determined by the candidate's education or experience. Advancement requires management recommendation and will be based on the candidate's certifications and/or performance.