Data Analyst (Python + PostgreSQL)
Posted on Jul 17, 2021 by Mercator IT Solutions
Please only apply if you have Python and PostgreSQL
The Role: My Client is seeking a Data Analyst who has a strong interest in data. As a Data Analyst within our Data Operations Team you would be required to work closely with our energy market analysts and off-shore IT team to be responsible for day-to-day data processes. In this role you will look to understand data and apply the applicable business logics and metadata to turn data into information, information into insight and insight into business decisions. You will also work closely with Business Intelligence and IT teams to implement data changes into databases, products and processes.
The Impact: This role has a core impact to our Energy analytics team by adding value to our data through data quality and enhancements. This role serves as the backbone of our European data operations team and you will contribute to turning our data into information and insights.
The Team/The Business: Dynamic Data team tasked with ensuring the integrity of our data and the automation and visualization of processes and data flows. The team is supportive and collaborative with exposure to many business units from Datamodelling to IT. They work great at moving forward with the group's mission and goals. A new member of this team will hit the ground running and collaborate with their team members immediately.
What We're Looking For: We are looking for a process orientated, methodological thinker with a keen eye for detail. Someone who enjoys dealing with large sets of data and problem solving. This role would be ideal for someone proactive and eager to learn about energy markets or data. The role is a great place to hone your skills and grow within a strong and collaborative team.
Analyse data workflows, understanding how they link to our platforms.
Contribute and manage daily processes ensuring you find, investigate, resolve and report issues to internal and external platform users to maintain the integrity of our European energy data.
Maintain and creating data documentation including mappings, and quality thresholds.
Collaborate with cross-functional teams to understand their data requirements/issues to generate innovative ideas and solutions.
Maintain new and existing data change request backlog to ensure all requests are tracked and completed. Prioritise backlog with analysts to ensure our dataset is accurate and up to date.
Assist in analytical support of data sets by working with wider data team, analysts and Business Intelligence team to ensure we have a complete and accurate dataset for European Gas, Power, Global LNG and other commodities.
Work with Data Collections group to ensure new data collection requests are processed and prioritized.
Ensure new and edited data points are quality assured before release and integrated into products, business logics and quality assurance processes to ensure consistency between database and products.
Enthusiastic about problem solving
STEM (All Science, Technology, Economics or Maths) related University level education or equivalent
Ability to retrieve, interrogate, manipulate and analyse data and presenting findings
Advanced troubleshooting and multi-tasking skills with a meticulous eye for detail
Experience of processes in agile work streams driving data quality and improvement, experience of Visual Studio (VSTS) desirable but not essential
A Strong track record and demonstrable interest in analysing data.
Knowledge/interest of energy markets or energy data desirable but not essential.
Strong Knowledge/exposure Python, Pandas, NumPy, SQL (PostgreSQL), Data Structures