Glacier Bancorp
Corporate Data Warehouse Developer II
Glacier Bancorp, Missoula, Montana, us, 59812
About the Role:
The Data Warehouse Developer II is responsible for designing, developing and testing data warehouse integration using type-2 slowly changing dimension techniques. Works collaboratively with members of the technology, business, and vendor solution teams to design and develop integrated solutions to fulfill the data analytic needs of the business.This is a Corporate position which may be located in an available bank division across our eight-state footprint in AZ, CO, ID, MT, NV, UT, WA, or WY.
Click here to learn more about our bank divisions.The mid-rate for this position is $111,574.23+ /year (calculated for Missoula, MT).
All compensation offers are analyzed individually and take into consideration multiple factors including but not limited to geographic location, years of experience, and educational background.Duties and ResponsibilitiesDescription% of Time SpentDevelops and tests Data Warehouse processes to implement ETL (extract, transform and load) procedures to integrate, track history of, and validate business data gathered from disparate systems throughout the organization.40%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.30%Provides technical support to reporting and data analysis teams throughout the organization.15%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.15%Must comply with all company policies and procedures and all applicable laws and regulations, including but not limited to, the Bank Secrecy Act, the Patriot Act, and Office of Foreign Assets Control. Must complete the assigned online training courses and achieve a passing score by the due date.About You:QualificationsTo perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.EducationRequired/PreferredEducation LevelDescriptionRequiredBachelors DegreeComputer Science, Database Management or similar field.ExperienceRequired/PreferredExperience LevelDescriptionRequired5 yearsExperience in the fields of Data Warehousing (e.g. Oracle, SQL Server, DB2), ETL (e.g. Informatica, Talend, Data Stage) and data modeling (e.g. Erwin, Rational Rose)Required5 yearsSoftware development and testingRequired3 yearsWorking with Kimball style dimensional data systemsRequired3 yearsExperience extracting data from structured, unstructured, and semi-structured source systemsRequired3 yearsExperience delivering data to users or destination systems in both structured and semi-structured formatsRequired2+ years of experience with development in an Agile environmentRequired2+ years of experience with Data Analytics and Business Intelligence tools such as SSAS/SSRS, QLik, Tableau, Power BI, etc.RequiredAdvanced / Specialized KnowledgeExtensive knowledge of data normalizationExposure to cloud-based enterprise data systems (AWS, Azure, Salesforce, Snowflake, etc.)Familiarity with indexing strategies within a relational databaseFamiliarity with encryption of data both in motion and at restExpert knowledge of data warehousing and ETL techniques and be skilled in dimensional and normalized data modelingWould an equivalent combination of relevant education and work experience be considered?:
YesLicense/CertificationRequired/PreferredLicense/CertificationDescriptionRequired Skills and AbilitiesEmployee must have strong written and verbal communication skills.Employee must be trustworthy and possess a significant level of credibility, discretion, and diplomacy.Employee must be capable of interacting calmly and professionally with a variety of people from diverse backgrounds at various levels within and outside of the organization.Employee must be well organized with ability to prioritize and multi-task in a fast-paced work environment and meet deadlines with minimal supervision.Employee must be capable of regular, reliable, and timely attendance.Ability to take initiative, and make decisions based on regulations, company policies, knowledge and experience with minimal supervision.Ability to adapt to change (e.g., shifting priorities, demands, and timelines) through time management, analytical, and problem solving skills.Ability to serve as a backup for other staff members in a mutually supportive teamwork environment.Additional RequirementsTravelOccasional travel required: (less than 10 days per year) by automobile (as driver and passenger), commercial airlines, rental vehicles and public transportation and be able to lodge in public facilities.Working ConditionsEnvironment:
Indoors, a climate-controlled shared work area.Noise Level:
Moderate noise.Lifting:
Sedentary work: Exerting up to 10 pounds of force occasionally and/or negligible amount of force frequently or constantly to lift, carry, push, pull or otherwise move objects, including the human body. Sedentary work involves sitting most of the time. Jobs are sedentary if walking and standing are required only occasionally and all other sedentary criteria are met.VisionClose visual acuity to prepare and analyze data and figures, view a computer terminal, and read the computer screen, printed materials, and handwritten materials.Physical ActivitiesFrequencyBalancing: Maintaining body equilibrium to prevent falling and walking, standing or crouching on narrow, slippery, or erratically moving surfaces.Infrequent rare.Climbing: Ascending or descending ladders, stairs, scaffolding, ramps, poles and the like, using feet and legs and/or hands and arms.Infrequent rare.Crawling: Moving about on hands and knees or hands and feet.Infrequent rare.Crouching: Bending the body downward and forward by bending leg and spine.Infrequent rare.Feeling: Perceiving attributes of objects such as size and shape, temperature or texture by touching with skin, particularly that of the fingertips.Infrequent rare.Fingering: Picking, pinching, typing or otherwise working primarily with fingers rather than with the whole hand as in handling.Daily.Grasping: Applying pressure to an object with the fingers and palm.Infrequent rare.Kneeling: Bending legs at knee to come to a rest on knee or knees.Infrequent rare.Lifting: Raising objects from a lower to a higher position or moving objects horizontally from position to position.Occasional now and then.Pushing: Using upper extremities to press against something with steady force in order to thrust forward, downward or outward.Infrequent rare.Pulling: Using upper extremities to exert force in order to draw, haul or tug objects in a sustained motion.Occasional now and then.Repetitive Motion: Making substantial movements (motions) of the wrists, hands, and/or fingers.Daily.Stooping: Bending body downward and forward by bending spine at the waist.Infrequent rare.What We Offer:COMPENSATION & BENEFITS:
Starting salary is dependent upon relevant experience and may vary based on the geographic location of the position. We offer an extensive benefits package that includes, but is not limited to medical, dental, vision, and life insurance, a health savings account option, an Employee Assistance Program (EAP), a health rewards program, a 401(k) retirement savings plan, discounts on banking products and services, and paid sick, holiday, and vacation time and the ability to participate in incentive plans.
Visit our website for more details!COMPANY OVERVIEW:
We are a family of banks whose unique local presence reflects the communities we serve. We welcome the opportunity to grow and change as our customers and communities do the same. Read our story, learn about our banks, and experience life at Glacier Bancorp, Inc. all from our website.
Check it out!We are an Equal Opportunity Employer and qualified applicants or employees will receive consideration for employment without regard to race, color, religion, national origin, sex (including pregnancy), sexual orientation, gender identity, mental or physical disability, genetic information, protected veteran status, or any other category protected by applicable federal, state or local laws.Glacier Bancorp, Inc. does not sponsor applicants for work visas. All applicants must be legally authorized to work in the US.
No Recruiters or unsolicited agency referrals please.
The Data Warehouse Developer II is responsible for designing, developing and testing data warehouse integration using type-2 slowly changing dimension techniques. Works collaboratively with members of the technology, business, and vendor solution teams to design and develop integrated solutions to fulfill the data analytic needs of the business.This is a Corporate position which may be located in an available bank division across our eight-state footprint in AZ, CO, ID, MT, NV, UT, WA, or WY.
Click here to learn more about our bank divisions.The mid-rate for this position is $111,574.23+ /year (calculated for Missoula, MT).
All compensation offers are analyzed individually and take into consideration multiple factors including but not limited to geographic location, years of experience, and educational background.Duties and ResponsibilitiesDescription% of Time SpentDevelops and tests Data Warehouse processes to implement ETL (extract, transform and load) procedures to integrate, track history of, and validate business data gathered from disparate systems throughout the organization.40%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.30%Provides technical support to reporting and data analysis teams throughout the organization.15%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.15%Must comply with all company policies and procedures and all applicable laws and regulations, including but not limited to, the Bank Secrecy Act, the Patriot Act, and Office of Foreign Assets Control. Must complete the assigned online training courses and achieve a passing score by the due date.About You:QualificationsTo perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.EducationRequired/PreferredEducation LevelDescriptionRequiredBachelors DegreeComputer Science, Database Management or similar field.ExperienceRequired/PreferredExperience LevelDescriptionRequired5 yearsExperience in the fields of Data Warehousing (e.g. Oracle, SQL Server, DB2), ETL (e.g. Informatica, Talend, Data Stage) and data modeling (e.g. Erwin, Rational Rose)Required5 yearsSoftware development and testingRequired3 yearsWorking with Kimball style dimensional data systemsRequired3 yearsExperience extracting data from structured, unstructured, and semi-structured source systemsRequired3 yearsExperience delivering data to users or destination systems in both structured and semi-structured formatsRequired2+ years of experience with development in an Agile environmentRequired2+ years of experience with Data Analytics and Business Intelligence tools such as SSAS/SSRS, QLik, Tableau, Power BI, etc.RequiredAdvanced / Specialized KnowledgeExtensive knowledge of data normalizationExposure to cloud-based enterprise data systems (AWS, Azure, Salesforce, Snowflake, etc.)Familiarity with indexing strategies within a relational databaseFamiliarity with encryption of data both in motion and at restExpert knowledge of data warehousing and ETL techniques and be skilled in dimensional and normalized data modelingWould an equivalent combination of relevant education and work experience be considered?:
YesLicense/CertificationRequired/PreferredLicense/CertificationDescriptionRequired Skills and AbilitiesEmployee must have strong written and verbal communication skills.Employee must be trustworthy and possess a significant level of credibility, discretion, and diplomacy.Employee must be capable of interacting calmly and professionally with a variety of people from diverse backgrounds at various levels within and outside of the organization.Employee must be well organized with ability to prioritize and multi-task in a fast-paced work environment and meet deadlines with minimal supervision.Employee must be capable of regular, reliable, and timely attendance.Ability to take initiative, and make decisions based on regulations, company policies, knowledge and experience with minimal supervision.Ability to adapt to change (e.g., shifting priorities, demands, and timelines) through time management, analytical, and problem solving skills.Ability to serve as a backup for other staff members in a mutually supportive teamwork environment.Additional RequirementsTravelOccasional travel required: (less than 10 days per year) by automobile (as driver and passenger), commercial airlines, rental vehicles and public transportation and be able to lodge in public facilities.Working ConditionsEnvironment:
Indoors, a climate-controlled shared work area.Noise Level:
Moderate noise.Lifting:
Sedentary work: Exerting up to 10 pounds of force occasionally and/or negligible amount of force frequently or constantly to lift, carry, push, pull or otherwise move objects, including the human body. Sedentary work involves sitting most of the time. Jobs are sedentary if walking and standing are required only occasionally and all other sedentary criteria are met.VisionClose visual acuity to prepare and analyze data and figures, view a computer terminal, and read the computer screen, printed materials, and handwritten materials.Physical ActivitiesFrequencyBalancing: Maintaining body equilibrium to prevent falling and walking, standing or crouching on narrow, slippery, or erratically moving surfaces.Infrequent rare.Climbing: Ascending or descending ladders, stairs, scaffolding, ramps, poles and the like, using feet and legs and/or hands and arms.Infrequent rare.Crawling: Moving about on hands and knees or hands and feet.Infrequent rare.Crouching: Bending the body downward and forward by bending leg and spine.Infrequent rare.Feeling: Perceiving attributes of objects such as size and shape, temperature or texture by touching with skin, particularly that of the fingertips.Infrequent rare.Fingering: Picking, pinching, typing or otherwise working primarily with fingers rather than with the whole hand as in handling.Daily.Grasping: Applying pressure to an object with the fingers and palm.Infrequent rare.Kneeling: Bending legs at knee to come to a rest on knee or knees.Infrequent rare.Lifting: Raising objects from a lower to a higher position or moving objects horizontally from position to position.Occasional now and then.Pushing: Using upper extremities to press against something with steady force in order to thrust forward, downward or outward.Infrequent rare.Pulling: Using upper extremities to exert force in order to draw, haul or tug objects in a sustained motion.Occasional now and then.Repetitive Motion: Making substantial movements (motions) of the wrists, hands, and/or fingers.Daily.Stooping: Bending body downward and forward by bending spine at the waist.Infrequent rare.What We Offer:COMPENSATION & BENEFITS:
Starting salary is dependent upon relevant experience and may vary based on the geographic location of the position. We offer an extensive benefits package that includes, but is not limited to medical, dental, vision, and life insurance, a health savings account option, an Employee Assistance Program (EAP), a health rewards program, a 401(k) retirement savings plan, discounts on banking products and services, and paid sick, holiday, and vacation time and the ability to participate in incentive plans.
Visit our website for more details!COMPANY OVERVIEW:
We are a family of banks whose unique local presence reflects the communities we serve. We welcome the opportunity to grow and change as our customers and communities do the same. Read our story, learn about our banks, and experience life at Glacier Bancorp, Inc. all from our website.
Check it out!We are an Equal Opportunity Employer and qualified applicants or employees will receive consideration for employment without regard to race, color, religion, national origin, sex (including pregnancy), sexual orientation, gender identity, mental or physical disability, genetic information, protected veteran status, or any other category protected by applicable federal, state or local laws.Glacier Bancorp, Inc. does not sponsor applicants for work visas. All applicants must be legally authorized to work in the US.
No Recruiters or unsolicited agency referrals please.