Bi Developer

Who are we?
At Multiplex, we are changing skylines across the globe. As a pioneering construction business, we design and build complex, iconic and sustainable structures that add to the economic, cultural and community life in the areas we operate. We've got the boldness to take on projects others say can't be done. We have the entrepreneurial spirit to challenge preconceived ideas. And we've got the determination to unlock and deliver value where others cannot see it.

What is the overall job?
Reporting directly to the Data Architect within the Data function, the Senior BI Developer is responsible for the data engineering and business intelligence development lifecycle for data products and services supporting our global and regional data, analytical and AI needs across all business functions. The role will support delivery, development and ongoing management of the global data platform, data collection and integration, transformation, modelling, governance and visualisation. Other key responsibilities will include:

• Collaborating and liaising with a wide variety of internal and external business, data and technology stakeholders.
• Utilise Azure data architecture knowledge to design and implement scalable data solutions to meet business requirements.
• Design and optimize data storage and retrieval systems, leveraging Azure data services such as Azure Data Lake Storage, Azure SQL Database, and other Azure DB services.
• Create, design, and develop data models including data transformation.
• Develop, maintain, and monitor data pipelines for automated data collection and integration from various sources. Interact with API systems to query and retrieve data for analysis.
• Ensure data quality, integrity, and security across all stages of data processing, implementing appropriate data validation, encryption, and access controls.
• Adhere to data governance, privacy and security standards, helping to build best practices where they do not exist.

What do I need to be successful in this role?

• Hands-on experience with Azure and Databricks architecture and tools such as Azure Data Factory, Databricks, SQL, Data Lake, Power BI, Delta Lake, Spark.
• Data engineering and data modelling experience, bringing together multiple data sources and tables to create data models.
• Proficiency in developing reports and custom queries using T-SQL.
• Strong visualisation experience using Power BI.
• Experience working with Azure SQL databases.
• Solid understanding of data normalization techniques and database concepts.
• Ability to proactively research solutions and apply pragmatic best practices.
• Excellent communication and collaboration skills to effectively work with cross-functional teams.
• Experience of analysing and diagnosing complex data issues and then explain key findings in clear business language.
• Experience of ETL development to read data and apply data profiling and data validation techniques.
• Deep experience with Azure DevOps (Repos, CI/CD etc.).

What's the company like to work for?
We are a construction company and we are all passionate about delivering exceptional projects that leave a positive and lasting legacy in the cities we build. Because we are passionate, we work hard, and our people are driven. Our Culture? We think we're friendly and our flat management structure means that you'll be just as likely to have a chat with our MD in the kitchen as with any of our other team members. We regularly have business wide socials so you can meet people across our projects, and we run plenty of clubs and events, so you'll never be short of things to do! Benefits of working at Multiplex include:

• Discretionary annual bonus, 8% company contribution pension
• Single private medical cover, employee assistance programme, virtual GP service
• 25 days annual leave, options to buy additional leave, 1 day voluntary leave, leave with tenure
• Several flexible/voluntary benefits from dental plans, season ticket loans, discounted gym memberships to a cycle to work scheme.

At Multiplex we are committed to being a diverse business that is inclusive of everyone. Diversity is about celebrating the ways we are all different and appreciating the unique qualities that every employee brings. We strongly encourage suitably qualified applicants from a wide range of backgrounds to apply and join Multiplex.
We offer flexibility in how our people work and value the ongoing development of all staff. We operate “Multiplex Flex” which is much more than working from home! We are open to conversations around flexible working needs for this role and will be more than happy to discuss this with you.
#LI-TR1