Data Warehouse Developer I

America First Credit Union•Riverdale, UT

About The Position

The Data Warehouse Developer I implements data architecture for analytical access, performance and integration. The developer must manage the balance of current and future needs in content. This constructs enterprise-wide data and information to support business intelligence and data integration management efforts. The individual will develop and implement data warehouse and data mart concepts. The individual will partner with the internal analytical resources to prioritize data and information requirements and will help determine strategic direction of data asset management efforts.

Requirements

Must be able to manage multiple tasks simultaneously and react to problems quickly.
Must have prior experience developing analytical solutions in large or midsize companies.
Must be able to translate concepts and directions into practical solutions.
Ability to handle confidential and sensitive data, and meet critical deadlines.
Excellent understanding of SQL, PL/SQL and ELT implementation.
Experience with multiple relational database platforms, Oracle and SQL Server desired.
Programming experience with 4th generation and 3rd generation computer languages such as Python and R desired.
Must be able to develop, maintain, review and explain data models.
Must have excellent verbal and written communication skills.
Must be a team player.
Understanding of the financial services industry desired.
Experience with dashboard design and delivery desired.
Two years of progressive work experience in business intelligence, data warehousing, analytics or data engineering.
Experience working with end users to gather requirements and build technical solutions from concept to implementation.

Responsibilities

Works with data warehouse team to develop a practical roadmap for analytic resources and reporting platforms.
Assist in defining the overall data architecture in conjunction with ad hoc data marts and the overall warehouse vision, including ELT processes, logical & physical data models, and data mart designs.
Develops an understanding of the underlying corporate data sources and their relationship to support credit union data driven decision objectives.
Maintain knowledge of software tools and programming languages that effectively support the environment.
Lead continuous improvement efforts to enhance performance and provide increased functionality.
Provide technical guidance to projects and teams, ensuring that new initiatives enable effective analytic information management.
Develop and oversee metadata repository, business intelligence (BI) and data warehouse strategies and development.
Develop and implement data warehouse and data mart concepts. Provide technical knowledge and business support to BI.
Support data management efforts for enterprise projects through all phases of development life cycle.
Should have a strong understanding of relational and dimensional modeling to facilitate data wrangling, code operationalization, and exploration of data.
Cross-train, support, and work closely with team members in the following roles.
Data Warehouse Architect: implement architecture, build data relationships, and support data structures
Data Warehouse Developer II: support enterprise level data assets
Data Scientist: data wrangling, feature engineering, model development, management, and operationalization.
BI Analyst & Developer: visualizations, report building, analysis of data for consulting purposes, and data mart development.
Database Administration: database security, redundancy and backup, source system ETL