Wirehead | Talent Solutions
Contingent Workforce Management
On behalf of our Government client, Wirehead has a new contract opportunity for a Senior Power BI Developer.
Client: Government
Type: Contract / Onsite Hybrid
Term: 12 Months + extension
Start date: 2-3 weeks
Req ID: RQ07802
Requirements: What you’ll need
Skills, Knowledge, Experience, and Qualifications:
· 10+ years of experience with developing code in SQL and Azure SQL, T-SQL
· In-depth knowledge of on premise SQL Server
· Demonstrated experience with power query/power pivot, and being able to combine datasets from different sources
· Demonstrated experience with On-Premise data gateway
· Demonstrated experience with PowerBI and PowerBI best practices
· Demonstrated experience in enabling role-based security in the reports by restricting access to information (record-based access) and reports
· Demonstrated experience with deployment of Report into Azure infrastructure.
· Demonstrated ability to translate complex business requirements into technical solutions
· Analytical mind with a problem-solving aptitude
· Experience with UI Design Principles is an asset
· Familiar with Azure Streaming Analytics SQL, Azure Event Hub
· Familiar with Data Lake Store (Gen 2), Data Factory
· Familiar with SSAS Partitioning
Design and Development Experience
· 10+ years of technical data warehousing experience with a focus in the design and development of Business Intelligence
· Experience with Azure Analysis Services / SSAS (tabular/multidimensional), SQL Server Reporting Services (SSRS) and Power BI
· Experience with end to end management of the Software Development Life Cycle (SDLC)
· Demonstrated experience in design and data modeling of data warehouse (e.g. dimensional modeling), data cubes, tabular models to support reporting, both ad-hoc and “canned” reports.
· Demonstrated experience in design and development of data models for OLTP (On-line Transaction Processing) and OLAP (On-line Analytical Processing) environments based on industry best practices.
· Demonstrated experience in design and development of visualizations for various reports/dashboards including near real-time to be shared with both B2B and B2C
· Demonstrated experience in building and deploying Mobile dashboards
· Familiar with design and development of ETL (Extract, transform, load) processes, and validating data sources
Communication Skills
· Strong verbal and written communication skills that enable to effectively communicate ideas and concepts. Strong Interpersonal and negotiation skills.
· Writing Business Requirements Document
· Ability to work with minimal supervision in an agile environment, be an effective communicator with other team members and the business owners.
· A demonstrated team player with a proven track record for meeting deadlines
· Demonstrated experience in creating of conceptual, logical, and physical data documentation for knowledge retention and transfer.
Industry Experience
· Experience in working on multi-year projects
· Experience with building enterprise level reporting solutions that protect high-sensitive information
· Demonstrated knowledge and experience with Public Sector governance methodologies (e.g. UPM, architecture gating) an asset
MUST HAVES:
· 10+ years of experience with developing code in SQL and Azure SQL, T-SQL
· Demonstrated experience with power query/power pivot, and being able to combine datasets from different sources
· Demonstrated experience with PowerBI and PowerBI best practices
· 10+ years of technical data warehousing experience with a focus in the design and development of Business Intelligence
PREFERRED SKILLS
Power BI + Azure SQL + SQL Server + T-SQL + DataLake
HOW TO APPLY
Submit your resume in confidence to: patrick@wirehead.com
We thank all candidates for their interest but advise that only candidates selected for interviews will be contacted directly. Rest assured that your resume will be kept on our database and will be considered for all future opportunities.
Applicants must be authorized to work in Canada.
Wirehead Talent Inc. is proud to be an Equal Opportunity Employer
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, sexual orientation, gender identity or expression, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, status as a crime victim, disability, protected veteran status, or any other characteristic protected by law. Wirehead is committed to working with and providing reasonable accommodation to individuals with physical and mental disabilities. If you need special assistance or an accommodation while seeking employment, please contact a member of our Human Resources team to make arrangements. Email: talent@wirehead.com
Your Right to Work – All persons hired will be required to verify identity and eligibility to work in the Canada and to complete the required employment eligibility verification document form upon hire.
Copyright 2007 – 2024 | Wirehead Talent | All rights reserved
