Job Code: #13802
Title: Data Warehouse Engineer
Job Location: Salt Lake City, Utah
Job Description:
PDS has an immediate opening for a Data Warehouse Engineer. This opportunity is with an outstanding organization in Salt Lake City.
Job Title: Data Warehouse Engineer
Job Summary
The Business Intelligence team of our client works with multiple departments to take their data and transform it into information that will allow them to make better decisions. The successful candidate will work with multiple internal departments.
The data warehouse engineer is responsible for gathering requirements and the design, creation, and support of the data warehouse. Engineers have the opportunity to help the departments of our client to have the information they need to move the work forward.
Qualifications
- Requires a Bachelor’s degree in computer science or related field
- Typically 5-7 years of business intelligence experience
- Proficiency with SQL
- Experience with ETL tools and methodologies
- Experience with dimensional data modeling
- Proficiency with data analysis and report design/development
- Ability to quickly learn new tools and technology
- Strong problem solving, analytical and diagnostic skills
- Ability to interact well in a team environment
- Excellent documentation and communication skills
Responsibilities
- Gather and document requirement for the data warehouse
- Design dimensional Star Schema data models to support front-end BI tools including ad-hoc reporting
- Create and support ETL jobs pulling data from various source systems and loading into the data warehouse
- Design and create a semantic layer to support end-user self-service
- Create reports using various reporting tools such as SQL Server Reporting Services (SSRS) and BusinessObjects Web Intelligence
- Create dashboards using various tools such as Microsoft Power B
- Quickly and accurately respond to Ad-Hoc information requests
- Analyze data and trends and create reports that highlight areas in need of performance improvement
- Work with all levels of end users, including executive staff
- Interact with customers as a technical resource to troubleshoot problems with the delivered BI solutions
Please contact our Recruiting Team for more information: utahjobs@pdsinc.com