208406 / Datawarehouse BI Consultant
At a glance
Mid-level Data Analysis & BI role at Procom Services. Hillsboro · no salary stated · we estimate $86,500–$135,038 across the United States.
Procom Services has not published a salary for this role. The figure below is our estimate, not theirs.
dataroles summary, based on the employer's posting.
What you'll do
- Build and extend ETL pipelines, SQL, and application code for SharePoint BI and web applications
- Combine information from transaction, scheduling, and defect tools in a data warehouse, then create an online data tool
- Develop small applications that collect data and help expand the deliverable for other groups
- Debug and resolve issues with importing ETL data and presenting it correctly
- Shape the data warehouse setup and identify what the group needs from its data tools
What you bring
- You have three to five years of recent experience with the required skills, plus seven to ten years overall
- You bring strong development experience in SharePoint BI or another business intelligence application
- You have advanced data development skills, including stored procedures and SSIS packages
- You hold a bachelor's degree in a relevant area such as computer science or engineering
Who this fits
This mid-level, hands-on development role suits someone who can build both data warehouse components and small applications. The position is onsite in Hillsboro.
From the employer
Procom is a leading provider of professional IT services and staffing to businesses and governments in Canada.
With revenues over $500 million, the Branham Group has recognized Procom as the 3rd largest professional services firm in Canada and is now the largest “Canadian-Owned” IT staffing/consulting company.
Procom’s areas of staffing expertise include:
• Application Development
• Project Management
• Quality Assurance
• Business/Systems Analysis
• Datawarehouse & Business Intelligence
• Infrastructure & Network Services
• Risk Management & Compliance
• Business Continuity & Disaster Recovery
• Security & Privacy
Specialties• Contract Staffing (Staff Augmentation)
• Permanent Placement (Staff Augmentation)
• ICAP (Contractor Payroll)
• Flextrack (Vendor Management System)
Consolidating data from multiple online trans-actional systems, scheduling tools, defect management tools, gathering and dropping info in a datawarehouse, then from there creating an online data tool. Need a Datawarehouse BI person - architecting and datawarehouse environment and building and extracting loads. The group has the need to have small applications built to gather data and the person needs to grow the value of this. Identifying what the group wants and growing the entire deliverable potential for other groups in the future as a model.
Job Duties: The candidate will possess SharePoint, .NET, Java and MS SQL skills and will apply those skills to create/extend ETL, SQL and application code for Sharepoint Business Intelligence and web applications. Candidate will also troubleshoot, debug, identify and correct problems related to the import and presentation of ETL data.
- Strong development background in SharePoint BI or other Business Intelligence application.
- Experienced in developing stored procedures, SSIS Packages, with advanced data development skills.
- Solid software development skills including -Java, Javascript, HTML, T-SQL, CSS XML, ASP.NET
- 3-5 Years with recent required skills and 7-10 overall experience and with all tools.
- Degree Type: BS in relevant field..CS, Engineering, etc.