Data Warehouse Engineer II

Job Description:

This position can be located in Billings and Bozeman, MT and Sioux Falls, SD.

What’s Important to You

We know your career is just one aspect of a meaningful, complex, and demanding life. That’s why we designed our compensation and benefits package to provide employees and their families with as much choice as possible.

1. Accrue and use your paid time off (PTO) immediately – no waiting period – plus paid federal holidays in addition to PTO.
2. Child Care Assistance Program for eligible dependent(s).
3. We prioritize wellness by offering eligible employees a monthly stipend, toward a fitness club membership or exercise-related classes.
4. The health and happiness of the places we call home matter to us. Learn a little more about what we do for the and why we want YOU to be a part of it.

We encourage you to apply. Reach for what you want and tell us why your work ethic and willingness to learn make you a natural fit for #TeamFirstInterstate.

SUMMARY

The role of Data Warehouse Engineer is to be involved in the design, analysis, and development efforts for the Data Warehouse and Business Intelligence projects, and to resolve complex business problems. This includes modeling, building, and populating the Data Warehouse, as well as providing reporting capabilities.

ESSENTIAL DUTIES & RESPONSIBILITIES include the following: other duties may be assigned.

• Assess business rules; perform source to target data mapping; design, review, implement and optimize ETL processes.
• Review project plans; develop and test specifications; perform data analysis.
• Provide development support for existing systems; troubleshoot data and/or system issues, build and extend toolsets.
• Create and/or maintain batch jobs.
• Create and maintain online systems and printed documentation.
• Provide data analysis and identify data-related issues within the Data Warehouse environment, as well as source systems as needed.
• Provide quality service satisfaction by possessing strong customer service skills.
• Create and maintain the logical and physical dimensional data models.
• Work within an agile development methodology.
• Participate in peer code reviews.
• Provide feedback to junior data warehouse engineers.
• Effectively manage time by analyzing workload, assign priorities, and maintain focus on productive endeavors.
• Work with minimal supervision to complete tasks assigned.
• Engage as a productive and positive member of the data warehouse team.

QUALIFICATIONS

To 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.

EDUCATION and EXPERIENCE

A Bachelor's degree (BS/BA) from a four-year college or university in Computer Science (or related technical field) and three or more (3+) years' experience; or equivalent combination of education and experience. Experience using Informatica, Microsoft SSIS, or other leading ETL tools preferred. Experience with Spark, Hadoop, or cloud technologies a plus.

LANGUAGE SKILLS

Ability to read, analyze and interpret the most complex documents and to read and interpret data schemas, with emphasis on SQL Server Implementations. Ability to respond effectively to the most sensitive inquiries or complaints. Ability to prepare presentations using original or innovative style, techniques and make persuasive speeches and presentations on controversial or complex topics to top management, public groups and/or board of directors.

MATHEMATICAL SKILLS

Ability to apply advanced mathematical and statistical concepts to tasks such as frequency distributions, analysis of variance, correlation techniques, sampling theory and factor analysis.

REASONING ABILITY

Ability to apply principles, logical or scientific thinking to a wide range of intellectual and practical problems. Ability to deal with a variety of abstract and concrete variables.

PHYSICAL DEMANDS

While performing the duties of this job, the employee is regularly required to talk or hear. The employee frequently is required to stand, walk, and sit. The employee is occasionally required to use hands to finger, handle, or feel; reach with hands and arms; and stoop, kneel, crouch, or crawl. The employee must occasionally lift and/or move up to 25 pounds. Specific vision abilities required by this job include close vision and ability to adjust focus.

WORK ENVIRONMENT

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of the job.

Skills

• Business Intelligence,DEMANDSWhile, Data Warehouse, ETL, ETL processes, Informatica, Computer Science, Microsoft SSIS, SQL, SQL Server, SSIS, agile development, analysis of variance, code reviews, customer service skills, data analysis, data mapping, factor analysis, manage time, persuasive, presentations, project plans, schemas