Data Engineer

Ideas | People | Trust

We’re BDO. An accountancy and business advisory firm, providing the advice and solutions entrepreneurial organisations need to navigate today’s changing world.

We work with the companies that are Britain’s economic engine – ambitious, entrepreneurially-spirited and high growth businesses that fuel the economy - and directly advise the owners and management teams that lead them.

We’ll broaden your horizons

The Data Office partners with every part of the firm to help turn data into a strategic asset. We govern, enable and empower the use of data, helping colleagues make better decisions, deliver stronger client outcomes and drive sustainable growth. Through trusted data foundations, value-focused data products, and the skills and confidence to use them effectively, we’re transforming the way BDO works with data. Join us, and you'll be part of a team that's helping to empower everyone at BDO with data.

We’ll help you succeed

Leading organisations trust us because of the quality of our advice.  That quality grows from a thorough understanding of their business, and that understanding comes from working closely with them and building long-lasting relationships.

You’ll be someone who is both comfortable working pro-actively and managing your own tasks, as well as confident collaborating with others and communicating regularly with senior managers, directors, and BDO’s partners to help businesses effectively. You’ll be encouraged to identify and draw attention to opportunities for enhancing our delivery and providing additional services to organisations we work with.

With the new focus of the Data Office Team to deliver and support a cloud centric data analytics service, the Data Engineer will be responsible for the delivery of the data platform that will underpin the production of data analytics solutions. This role sits within the IT Data Office Team and will play a vital part in the delivery of the emerging BDO Data and Analytics Strategy.

Collaborating with cross functional teams such as Data Analysts, Solution Architects and end users across BDO, the Data Engineer will be instrumental in delivering data warehousing technology that aligns with the data and analytics strategy as well as the overall IT strategy. You’ll be working with the latest on-premises and cloud-based technology solutions following Agile and DevOps methodologies in the delivery of data engineering solutions.

Reporting to the Data Engineering Manager, the Data Engineer will play a key role in the management and delivery to the newly established Data and Analytics Programme. It is also their responsibility to influence the overall design of the Data Architecture ensuring that structure and content of the data warehouse not only meets the needs of the business but is also delivered in a supportable and cost effective way.

They will act as the primary resource and subject matter expert on data integration, ETL, data warehouse management and will set and maintain standards and development best practices in these domains.

You’ll be someone with:

• Proven experience of working as a Data Engineer.
• Extensive hands-on experience with Microsoft Azure data engineering techniques.
• Extensive experience developing analytics using Azure Synapse Analytics, Azure Data Factory, Azure Logic Apps and Azure Functions.
• Strong experience in data extraction and processing languages including SQL, Python/Spark.
• Experience of working with cloud data storage such as Data lakes, Data Warehouses, SQL and No SQL (Cosmos DB).
• Experience of managing internal technical staff as well as external consultants. 
• Experience with designing, building and managing data pipelines for data structures encompassing data transformation, data models, schemas, metadata and workload management.
• Knowledge of optimizing data pipelines, pipeline architectures and integrated datasets using traditional data integration technologies. These should include ETL/ELT, data replication/CDC, message-oriented data movement and API design.
• Understanding of data security and information governance guidance and best practice.
• A track record in making data solutions accessible for end-users.
• Experience of working with stakeholders to deliver a data-driven approach to decision making.
• Experience in working with both IT and business users translating business requirements into cohesive data solutions.
• Expert knowledge of star schema/snowflake modelling including dimensional data modelling, the identification of dimensions, facts, measures and hierarchies.
• Hands on experience of agile methodologies and capable of applying Azure DevOps and increasingly Azure DataOps principles to data analytics to improve the communication, integration, reuse and automation of data flows between data managers and consumers across an organization

Competencies/Characteristic

• Organizationally savvy, with a good understanding of the enterprise's political climate and how to navigate, influence and persuade political waters
• Ability to communicate, influence and persuade peers
• Ability to understand the long-term ("big picture") and short-term perspectives of situations
• Ability to translate future-state business capabilities and requirements into solution architecture requirements
• Ability to propose and estimate the financial impact of solution architecture alternatives
• Ability to apply multiple technical solutions to business problem
• Ability to quickly comprehend the functions and capabilities of new technologies
• Proven ability to work well with others
• Technology neutral: remains unbiased toward any specific technology or vendor choice, and is more interested in results than personal preferences
• Displays intellectual curiosity and integrity
• Motivated and driven by achieving long-term business outcomes

Excellent Client Service

• Demonstrate confidence in dealing with all levels of the firm, including executive management levels
• Demonstrate ownership and responsibility for deliverables/services.
• Excellent customer service and consulting skills
• Experienced in managing internal and external/3rd-Party resource partnership models
• Demonstrable skills in influencing and negotiation methods and techniques.

At BDO, we’ll help you achieve your personal goals and career ambitions, and we have programmes, resources, and frameworks that provide clarity and structure around career development.

We’re in it together

Mutual support and respect is one of BDO’s core values and we’re proud of our distinctive, people-centred culture.  From informal success conversations to formal mentoring and coaching, we’ll support you at every stage in your career, whatever your personal and professional needs.

Our agile working framework helps us stay connected, bringing teams together where and when it counts so they can share ideas and help one another.  At BDO, you’ll always have access to the people and resources you need to do your best work.

We know that collaboration is the key to creating value for the companies we work with and satisfying experiences for our colleagues, so we’ve invested in state-of-the-art collaboration spaces in our offices.  BDO’s people represent a wealth of knowledge and expertise, and we’ll encourage you to build your network, work alongside others, and share your skills and experiences.  With a range of multidisciplinary events and dedicated resources, you’ll never stop learning at BDO.

We’re looking forward to the future

At BDO, we help entrepreneurial businesses to succeed, fuelling the UK economy.

Our success is powered by our people, which is why we’re always finding new ways to invest in you. Across the UK thousands of unique minds continue to come together to help companies we work with to achieve their ambitions

We’ve got a clear purpose, and we’re confident in our future, because we’re adapting and evolving to build on our strengths, ensuring we continue to find the right combination of global reach, integrity and expertise. We shape the future together with openness and clarity, because we believe in empowering people to think creatively about how we can do things better.