Data Analytics Power BI Developer
Datacom, New Zealand
Job Description
Our purpose
Here at Datacom we connect people and technology in order to solve challenges, create opportunities and discover new possibilities for the communities we live in.
Our team
The Data and Analytics team are a progressive group of diverse and creative individuals with a deep love for all things data related. They build platforms and solutions that are leading edge and at the forefront of the technology curve. A close knit and fun team embedded within our rapidly growing Professional Services division, and part of the wider Datacom ecosystem.
The role:
As a Power Business Intelligence developer/consultant, you’ll be asked to analyse requirements, develop ETL solutions, provide functional specification reports, design reporting solutions and create semantic layer as well as providing maintenance and optimisation. This is a client facing role, so you'll need to be an excellent communicator and good with people.
The Senior Business Intelligence consultant works closely with project managers, scrum masters, and client’s stakeholders and teams.
What you’ll do
- Working with clients (businesses users) to gather, clarify requirements and business rules by running workshops with stakeholders.
- Build prototypes and Proofs-of-concept to validate ideas.
- Define meta data and design standards for the data platform including master data management, metadata management and addressing data quality issues.
- Design and implement detailed data platform solutions
- Design and implement ETL / ELT processes using different data integration tools.
- Data modelling (relational and dimensional like star schema and Snowflake schema)
- Data vault modelling
- Managing development life cycle using different source code management tools.
- Resolving any and all issues throughout the development lifecycle.
- Ability to perform performance tuning and optimisation on new and/or existing data warehouse solutions.
- Provide detailed documentation, end user training and knowledge-transfer services to customers, and internal team.
- Continue professional and technical growth through corporate and personnel initiatives.
- Maintain and develop various database scripts and tools to facilitate automation process.
Skills
- Advanced database skills
- Advanced data modelling skills (Star schema, Snowflake schema, data vault)
- Proven record of building EDW
- Advanced ETL /ELT processes design and implementation.
- Advanced semantic layer (Tabular, Cube) development.
- Strong skills in BI visualisation and reporting tools.
- Extensive experience with developing, unit testing, break/fix support of ETL
- Advanced skills in performance tuning, query plan, query plan analysis, indexing, table partitioning.
- Strong skills in cloud platforms such as Azure, AWS amp; GCP
- Strong skills in Azure Data Factory and Data Flows, Azure Databricks, and Azure data platform.
- Strong skills in master data management, data quality and data governance.
- Strong consultation and client management skills
- Strong understanding of Agile delivery methodology.
- Strong documentations skills
- Excellent verbal and written communications.
Required Skills and Qualifications
- Bachelor's degree in Computer Science or related discipline. Master's Degree is preferred.
- Minimum 8+ years’ experience in EDW design and implementation.
- Minimum 8+ years’ experience in ETL architecting and design.
- Minimum 8+ years’ experience in data modelling (Star schema amp; Snowflake schema)
- Minimum 8+ years’ experience in semantic layer development.
- Minimum 8+ years’ experience in reporting and visualization tools.
- Advanced skills in Microsoft BI stack.
- Minimum 8+ years’ experience in various Microsoft SQL server technologies including SSIS, SSRS, SSAS
- Minimum 3+ years’ experience in Power BI
Helpful Knowledge
- Machine Learning frameworks and theory
- Analytic platforms amp; tools such as Databricks, Alteryx, SAS, KNIME or Datarobot
- Custom programming skills (C#, Python etc)
- Data vault Methodology
- DevOps / DataOps