Data Engineer (Python/Power BI)

Job Description

Data Engineer (Python/Power BI) - Financial Services

A financial services company based in the City of London is seeking a Data Engineer that has a strong background in Python and Power BI to join the Software Delivery team to strengthen the power of data within the business. The company is moving its data from legacy stores to a strategic data warehouse and data lakes to optimise its operational workload, research, and analytics.

This person will help influence high-level decisions regarding various processes including design choices, technical standards, coding standards, and tools, while also working collaboratively with the team by utilising communication and problem solving skills.

Key responsibilities:

• Ability to build data pipelines that will allow optimal extraction, transformation, and incorporation of data from various data sources.
• Be able to utilise Power BI to build dashboards and reports.
• Understand the Data Virtualisation layer and partner with the Business for continued deployment and Business enhancements.
• Improve solutions and be able to anticipate where the demand is for the business.
• Build analytics tools that utilise the data pipeline to provide key insights for various areas of the business.
• Automate processes for early feedback.
• Communicate progress and risk to appropriate teams.
• Contribute to the continual evaluation of suitability of tool choices.
• Collaborate towards the onboarding of Jupiter playbooks/python apps.

Your experience:

• Building API's with a key focus on Python.
• Optimise 'big data' data pipelines, architectures and data sets.
• Strong experience in Power BI including advanced ability to design dashboards.
• Strong SQL skills.
• Build processes supporting data transformation, data structures, metadata, dependency and workload management.
• The ability to manipulate, combine, process, and extract value from disconnected datasets.
• Strong experience in automating formulas from Excel to Power BI.
• Be able to guide other members of the team on Power BI.
• Working experience developing Power Bi custom visuals in R.
• Experience in merging disparate data sets from multiple data sources

This is a contract position based in London that operates on a hybrid work setup of three days per week in the office.