
Business Intelligence Developer / Consultant
Posted 22 hours ago

Posted 22 hours ago
This is a fully remote position, open to applicants in United Kingdom.
• Collaborate with the Business Insights team by providing specialized knowledge and expertise in Business Intelligence solutions for the NEC Housing product.
• Assist throughout the entire product lifecycle, encompassing pre-sales activities, customer consultancy and support, product development, implementation, and the ongoing enhancement of Business Intelligence solutions.
• Grasp business and data requirements, leading to solution design, development, implementation, and support.
• Aid in the advancement of the Housing Business Intelligence Roadmap.
• Create Power BI reports, dashboards, and analytics.
• Develop Machine Learning and Data Science solutions.
• Provide both operational and strategic reporting.
• Design and develop Data Warehouse ETL processes.
• Deliver customized development for clients.
• Construct end-to-end Power BI solutions from source data to published reports and dashboards.
• Prepare, cleanse, and transform data using Power Query and M.
• Design robust and reusable semantic models utilizing dimensional modeling and star-schema principles.
• Create fact and dimension structures while managing complex data relationships, cardinality, and filter behavior.
• Develop advanced DAX measures and business logic.
• Work with complex modeling scenarios, including multiple fact tables, many-to-many relationships, and bridge tables.
• Create professional, intuitive, and accessible Power BI reports and dashboards.
• Optimize data transformations, semantic models, DAX, and reports for performance and maintainability.
• Utilize Import, DirectQuery, and composite model approaches where appropriate.
• Implement data and report security measures, including Row-Level Security.
• Configure and support Power BI Service, including workspaces, Apps, gateways, data connections, and scheduled refresh.
• Assist in controlled deployment across development, test, and production environments.
• Troubleshoot data, modeling, refresh, security, and performance issues within production solutions.
• Produce and maintain technical documentation.
• Collaborate with both technical and non-technical stakeholders to comprehend requirements and translate them into effective Business Intelligence solutions.
• Provide Business Intelligence consultancy, technical advice, and problem resolution support to customers and internal teams.
• A degree-level qualification in Computer Science, Data Science, Information Systems, Software Engineering, or another relevant technical or analytical field, or equivalent relevant professional experience.
• Prior relevant commercial experience in Business Intelligence, data, analytics, or a closely related technical field.
• Strong hands-on experience in developing solutions using Microsoft Power BI.
• Advanced proficiency in Power Query and M for intricate data preparation and transformation.
• Strong DAX skills, with a solid understanding of filter context, evaluation context, and DAX performance.
• Strong SQL skills and experience with relational databases.
• Solid understanding of dimensional data modeling, including fact tables, dimensions, and star schemas.
• Experience in designing and developing complex Power BI semantic models.
• Experience managing complex relationships, including cardinality, filter direction, bridge tables, and many-to-many scenarios.
• Experience in designing reusable semantic models that can support multiple reports and analytical requirements.
• Good understanding of optimizing Power BI performance 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 in implementing Power BI security, including workspace permissions and Row-Level Security.
• Experience in deploying and supporting Power BI solutions within a production environment.
• Strong analytical and problem-solving skills, with the capability to diagnose complex data and reporting issues.
• Ability to clearly communicate technical concepts to both technical and non-technical audiences.
• Candidates must be able to demonstrate a pre-existing right to work and travel within the UK.
• Documentary evidence will be required.
• All offers are subject to satisfactory vetting and reference checks.
• Private Medical Cover funded by NEC for Employees (with the option to add family members at an additional cost).
• 25 days of paid holiday with the option to buy/sell days.
• 4 x basic salary life assurance cover funded by NEC (with the option to increase cover at an additional cost).
• A Group Pension Plan with excellent employer contributions of up to a maximum of 8.5%.
• A fantastic array of flexible benefits tailored to your individual needs.
• Valuable employee assistance program.
• Complimentary access to LinkedIn Learning, offering over 15,000 courses.
Fortrea
BrightSpring Health Services
Alpaca Health
Alpaca Health
Get handpicked remote jobs straight to your inbox weekly.