Glacier Bank - Missoula, MT

posted 3 months ago

Full-time - Mid Level
Missoula, MT
Credit Intermediation and Related Activities

About the position

The Data Warehouse Developer II is responsible for designing, developing, and testing data warehouse integration using type-2 slowly changing dimension techniques. This role requires collaboration with members of the technology, business, and vendor solution teams to create integrated solutions that meet the data analytic needs of the business. The position is corporate and may be located in any available bank division across the eight-state footprint, including AZ, CO, ID, MT, NV, UT, WA, or WY. The mid-rate for this position is $111,574.23+ per year, calculated for Missoula, MT. Compensation offers are analyzed individually, considering factors such as geographic location, years of experience, and educational background. The primary responsibilities include developing and testing Data Warehouse processes to implement ETL (extract, transform, and load) procedures, which integrate, track history, and validate business data from various systems throughout the organization. The role also involves working closely with business and internal technical teams to understand, model, and integrate the data analytics needs of the business. Additionally, the Data Warehouse Developer II provides technical support to reporting and data analysis teams and advises the organization on industry best practices and evolving technology solutions in data analytics, data warehousing, and data modeling. This position requires compliance with all company policies and applicable laws, including the Bank Secrecy Act and the Patriot Act, and completion of assigned online training courses with a passing score by the due date.

Responsibilities

  • Develops and tests Data Warehouse processes to implement ETL procedures to integrate, track history of, and validate business data from disparate systems throughout the organization.
  • Works collaboratively with members of the business, internal technical teams, and vendor solutions teams to understand, model, and integrate the data analytics needs of the business.
  • Provides technical support to reporting and data analysis teams throughout the organization.
  • Advises the organization on industry best practices and evolving technology solutions in data analytics, data warehousing, and data modeling.
  • Evaluates and tests new tools and technologies to enhance the enterprise data toolset.
  • Complies with all company policies and procedures and all applicable laws and regulations.

Requirements

  • Bachelor's Degree in Computer Science, Database Management, or a similar field.
  • 5 years of experience in Data Warehousing (e.g., Oracle, SQL Server, DB2), ETL (e.g., Informatica, Talend, Data Stage), and data modeling (e.g., Erwin, Rational Rose).
  • 5 years of software development and testing experience.
  • 3 years of working with Kimball style dimensional data systems.
  • 3 years of experience extracting data from structured, unstructured, and semi-structured source systems.
  • 3 years of experience delivering data to users or destination systems in both structured and semi-structured formats.
  • 2+ years of experience with development in an Agile environment.
  • 2+ years of experience with Data Analytics and Business Intelligence tools such as SSAS/SSRS, QLik, Tableau, Power BI.

Nice-to-haves

  • Extensive knowledge of data normalization.
  • Exposure to cloud-based enterprise data systems (AWS, Azure, Salesforce, Snowflake).
  • Familiarity with indexing strategies within a relational database.
  • Familiarity with encryption of data both in motion and at rest.
  • Expert knowledge of data warehousing and ETL techniques and skilled in dimensional and normalized data modeling.

Benefits

  • Medical insurance
  • Dental insurance
  • Vision insurance
  • Life insurance
  • Health savings account option
  • Employee Assistance Program (EAP)
  • Health rewards program
  • 401(k) retirement savings plan
  • Discounts on banking products and services
  • Paid sick time
  • Paid holiday time
  • Paid vacation time
  • Ability to participate in incentive plans
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service