Cloudtrend Inc. specializes in building and managing an exclusive network of IT professionals to better their career opportunities and meet the demand of the market. We provide career management services and opportunities.
Position
Our client requires a Business Intelligence Analyst to provide the following services: • Contribute as part of a team, responsible for delivering business intelligence capabilities to support internal and external ministry stakeholders’ information needs. • Deliver work products based on various sets of data including (but not limited to) education, post-secondary education, apprenticeship, finance and census data. • Work with a selection of technology products that must scale to the ever changing technology and increasing appetite for information from internal and external ministry stakeholders. • Must be able to work effectively with a team made up of in-house staff and contract resources. • Analyzing data and preparing information results • Gathering and documenting client requirements • Designing and constructing information products • Capturing business and technical metadata for information products • Gathering requirements for control processes including schedule management, status reporting, issues, risk, and change management at the program level. • Producing deliverables within specified quality standards and timeline • Defining and performing quality assurance on BI deliverables • Responding to ad-hoc information inquiries • Perform data analysis, data quality audits/reviews, statistical analysis and data mining. • Escalating issues and risks, as appropriate • Working within a multi-vendor/staff environment.
Requirements
University graduation, diploma, certificate in business, management or a currently active professional certification or accreditation in a related discipline and 7-yr BIA experience
Experience with Microsoft business intelligence technologies: Microsoft PowerBI, PowerView, PowerQuery, Excel
Experience with Microsoft business intelligence technologies: Microsoft SQL Reporting Services (SSRS), Microsoft SQL Integration Services (SSIS), Microsoft SQL Analytical Services
Experience with Business Intelligence solution requirements gathering
Experience with relational database modeling techniques
Experience in designing, developing and maintaining business intelligence solutions with MicroSoft BI technologies
Desirables
Experience with unit testing, system testing and test-driven development and tools within an enterprise organization
Experience developing in the SAS VA environment, including experience with SAS/VA Explorer, Designer, and Viewer
Experience with stored procedures and triggers
Experience working in an N-tier development environment