The job
Company Description
Come join us and make a difference in the world!
Discover more at www.necsws.com
Job Description
Please note - this role will be remote or hybrid working, subject to the successful applicant's location in line with company policy
Our Business Intelligence Developer/Consultants work as part of the Business Insights team, providing specialist knowledge and expertise in Business Intelligence solutions for the NEC Housing product.
The team is involved throughout the full product lifecycle, including pre-sales activities, customer consultancy and support, product development, implementation and the ongoing development of our Business Intelligence solutions. The role provides an opportunity to work across the full end-to-end lifecycle of Business Intelligence projects, from understanding business and data requirements through to solution design, development, implementation and support.
The Housing Business Intelligence Roadmap covers a broad range of reporting and analytics capabilities. The BI team is responsible for supporting and developing this roadmap, including:
- Power BI reporting, dashboards and analytics
- Machine Learning and Data Science
- Operational and strategic reporting
- Data Warehouse ETL design and development
- Customer bespoke development
A key focus of this role will be the design and development of Power BI solutions. We are looking for someone who can work beyond report visualisation and has strong experience in the more complex technical aspects of Power BI development.
Key responsibilities will include:
- Developing end-to-end Power BI solutions, from source data through to published reports and dashboards.
- Preparing, cleansing and transforming data using Power Query and M.
- Designing robust and reusable semantic models using dimensional modelling and star-schema principles.
- Designing fact and dimension structures and managing complex data relationships, cardinality and filter behaviour.
- Developing advanced DAX measures and business logic.
- Working with complex modelling scenarios, including multiple fact tables, many-to-many relationships and bridge tables.
- Developing professional, intuitive and accessible Power BI reports and dashboards.
- Optimising data transformations, semantic models, DAX and reports for performance and maintainability.
- Working with Import, DirectQuery and composite model approaches where appropriate.
- Implementing appropriate data and report security, including Row-Level Security.
- Configuring and supporting Power BI Service, including workspaces, Apps, gateways, data connections and scheduled refresh.
- Supporting controlled deployment of Power BI solutions across development, test and production environments.
- Troubleshooting data, modelling, refresh, security and performance issues within production solutions.
- Producing and maintaining appropriate technical documentation.
- Working with technical and non-technical stakeholders to understand requirements and translate these into effective Business Intelligence solutions.
- Supporting customers and internal teams with Business Intelligence consultancy, technical advice and problem resolution.
Qualifications
Qualifications
We are looking for an experienced Business Intelligence professional with a strong technical background and demonstrable experience delivering Power BI and data solutions within a commercial environment.
Essential qualifications and experience
- Degree-level qualification in Computer Science, Data Science, Information Systems, Software Engineering or another relevant technical or analytical subject, or equivalent relevant professional experience.
- Previous relevant commercial experience working within Business Intelligence, data, analytics or a closely related technical discipline.
- Strong practical experience developing solutions using Microsoft Power BI.
- Advanced experience with Power Query and M for complex data preparation and transformation.
- Strong DAX skills, including a good understanding of filter context, evaluation context and DAX performance.
- Strong SQL skills and experience working with relational databases.
- Strong understanding of dimensional data modelling, including fact tables, dimensions and star schemas.
- Experience designing and developing complex Power BI semantic models.
- Experience managing complex relationships, including cardinality, filter direction, bridge tables and many-to-many scenarios.
- Experience designing reusable semantic models capable of supporting multiple reports and analytical requirements.
- Good understanding of Power BI performance optimisation across data preparation, semantic models, DAX and report design.
- Practical experience with Power BI Service, including workspaces, Apps, gateways, data connections and scheduled refresh.
- Experience implementing Power BI security, including workspace permissions and Row-Level Security.
- Experience deploying and supporting Power BI solutions within a production environment.
- Strong analytical and problem-solving skills, with the ability to diagnose complex data and reporting issues.
- Ability to communicate technical concepts clearly to both technical and non-technical audiences.
Useful skills and knowledge
Experience or knowledge in any of the following areas would be advantageous:
- Hands on experience using NEC Housing
- WhereScape RED Data Warehouse ETL development
- Oracle SQL and PL/SQL
- Data Warehouse design and dimensional modelling
- Jaspersoft Studio report development
- Jaspersoft Server configuration
- Microsoft Fabric and related Microsoft data technologies