Unison Systems is looking for a BI Database Developer consultant for one of our clients in the Denver Tech Center.
Responsibilities:
- Convert logical dimensional data models to physical models
- Ability to write efficient SQL statements
- Write and maintain SQL Server stored procedure in T/SQL
- Maintain good relationship with DBA team and coordinate BI requirements through them
- Use of performance monitoring tools
- Identify performance tuning opportunities including indexing, partitioning, and physical use of hardware
- Understand and utilize execution plans
- Assist in identifying database maintenance
- Design and build of cubes in SQL Server Analysis Services
- Understand ETL methodologies
- Understand multi tier enterprise reporting methodologies
- Understand data storage inside SharePoint and how to insert, edit, and retrieve
- Keep abreast of new technologies and methodologies
- Interface with enterprise architecture team to ensure best tools and techniques are being used in managing data within the warehouse
- Collaborate with other data management staff in other One IT sub-functions to share experiences and best practice ideas
- Coordinate with IT performance management on continuous improvement opportunities and ideas
- Coordinates across cross functional BI project team of BI analyst, data modeler, report developer, test analyst, support analyst
- Work with BI analyst, BI manager and development lead select architecture, set priorities and escalate issues
- Work with BI support lead to resolve support and break-fix issues
MUST HAVE:
- Bachelor degree in computer science or related technical field required.
- 4 years experience in a highly critical Operational Data Warehouse environment working to develop and apply effective solutions for major Data.
- Warehouse applications required. (MS SQL server)
- Two years experience with Online Analytical Processing (SSAS preferred.)
- May substitute an equivalent combination of education and experience.
- Familiar with Informatica and Business Objects a plus.
- Knowledge of leading practices in loading and maintaining data in complex data warehouse environments required.
LOCATION: Denver Tech Center
Hourly Range: Pending Experience
DURATION: 3 months
Unison Systems Inc. is a full-service IT consulting firm that specializes in both IT contingency based staffing and end-to-end IT Business and Software solutions. As an independent, locally owned consulting firm that has been in business since 1997, we have 3 main areas of expertise: Software Life Cycle Support, Data Warehouse Support, and Infrastructure Support.
Years of Experience Required: 3-5 Years
Expected Travel Time: None
Responsibilities:
- Convert logical dimensional data models to physical models
- Ability to write efficient SQL statements
- Write and maintain SQL Server stored procedure in T/SQL
- Maintain good relationship with DBA team and coordinate BI requirements through them
- Use of performance monitoring tools
- Identify performance tuning opportunities including indexing, partitioning, and physical use of hardware
- Understand and utilize execution plans
- Assist in identifying database maintenance
- Design and build of cubes in SQL Server Analysis Services
- Understand ETL methodologies
- Understand multi tier enterprise reporting methodologies
- Understand data storage inside SharePoint and how to insert, edit, and retrieve
- Keep abreast of new technologies and methodologies
- Interface with enterprise architecture team to ensure best tools and techniques are being used in managing data within the warehouse
- Collaborate with other data management staff in other One IT sub-functions to share experiences and best practice ideas
- Coordinate with IT performance management on continuous improvement opportunities and ideas
- Coordinates across cross functional BI project team of BI analyst, data modeler, report developer, test analyst, support analyst
- Work with BI analyst, BI manager and development lead select architecture, set priorities and escalate issues
- Work with BI support lead to resolve support and break-fix issues
MUST HAVE:
- Bachelor degree in computer science or related technical field required.
- 4 years experience in a highly critical Operational Data Warehouse environment working to develop and apply effective solutions for major Data.
- Warehouse applications required. (MS SQL server)
- Two years experience with Online Analytical Processing (SSAS preferred.)
- May substitute an equivalent combination of education and experience.
- Familiar with Informatica and Business Objects a plus.
- Knowledge of leading practices in loading and maintaining data in complex data warehouse environments required.
LOCATION: Denver Tech Center
Hourly Range: Pending Experience
DURATION: 3 months
Unison Systems Inc. is a full-service IT consulting firm that specializes in both IT contingency based staffing and end-to-end IT Business and Software solutions. As an independent, locally owned consulting firm that has been in business since 1997, we have 3 main areas of expertise: Software Life Cycle Support, Data Warehouse Support, and Infrastructure Support.
Years of Experience Required: 3-5 Years
Expected Travel Time: None
Recruiting
Unison Systems Inc.
5675 DTC Blvd
Englewood, CO 80111
Phone: (303) 623-8800
0 Comments