Business Intelligence Developer / Consultant
Prefer a full account with a password? Sign Up to Apply
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.
Requirements
Department: Housing
Function: Information Technology
Experience Level: Associate