Senior BI Consultant
- Full-time
- Department: Business Management & Change
Company Description
We pledge "to prove IT can make a real difference to our customer's businesses". We work hard to ensure we understand what our customers need from their technology solutions and then we deliver.
We are an award-winning company who provide world class customer service; we think big and we hire great people. Version 1 are more than just another IT services company - we are leaders in implementing and supporting Oracle, Microsoft and AWS technologies.
Invest in us and we’ll invest in you; if you are driven, committed and up for a challenge, we want to meet you.
Job Description
- 7 years of Designing and developing SSRS and Power BI visualisations, dashboards and reports as per business needs.
- A range of engagements such as new implementations, support, version upgrades, new module implementation, health-checks, and enhancement of existing systems.
- Gathering and analysing data requirements.
- Creating new ETL pipelines and amending existing ones.
- Ensuring effective interactive dashboards for visual analytics (content, functionality, performance, presentation).
- Designing efficient data models from multiple data sources.
- Deploying dashboards/reports to production.
- Creating and maintaining documentation for developed reports.
- Delivering and presenting proofs of concept to of key technology components to project stakeholders.
- Leading changes, teams and stakeholders towards goals.
- Working with other members of the project team to support delivery of additional project components.
Qualifications
- 7+ years of Strong SQL skills.
- Experience planning major changes.
- Experience in Azure Synapse Analytics.
- Experience developing ETL solutions.
- Strong knowledge of Microsoft database development, including T-SQL.
- Ability to use complex expressions to calculate, group, filter, parameterize, optimize and format custom dashboards/reports.
- Experience translating business requirements and design into technical solutions.
- Ability to multi-task across concurrent projects may be required.
- Excellent written and verbal communication and teamwork.
- Experience and demonstrated competencies with multi-dimensional design, star schemas, facts and dimensions.
Additional Information
Nice to have:
- BI and Analytics professional experience across a range of technologies including Microsoft PowerBI, Python and SQL development, with experience in building complex PowerBI dashboards.
- 2+ years of hands-on experience with Microsoft BI tools (Reporting Services, Analysis Services, PowerBI).
- Hands on experience designing and delivering solutions using the Azure Data Analytics platform including Azure Storage, Azure SQL Data Warehouse, Azure Data Lake, Azure Synapse Analytics.
Oracle database and PL/SQL