Data Architect
Swansea, United Kingdom
OSTC
We are a leading institutional liquidity provider for the listed futures market with long-standing partnerships with the world’s largest exchanges.Company Description
In just over 17 years, OSTC has become one of the leading trading companies in the world. Our success is focused on hiring and developing talented people and helping them to perform to their maximum and fulfil their potential.
We are a trading company, however, unlike many other trading companies, we are continually innovating new products to support our business.
Job Description
We are looking for an experienced Data Architect to join our Data Reporting team.
The main purpose of the role is to increase efficiency across the business through the use of data. Therefore, strong Excel, Visual Basic, SQL and Power BI skills will be a key element of this role.
Your Responsibilities:
Reporting to the Finance Data Manager, the extent of your duties will include but not be limited to:
- Creating bespoke analytical reports for the Exec and Management teams.
- Analysing trading data and reporting this in a professional manner.
- Sourcing and maintain data required for key business processes.
- Ensuring the integrity of the data collected and reported by working closely with third parties and following robust business processes.
- Maintaining the analytical models required for reporting.
- Supporting business projects which require data expertise.
- Assist in the automation of key reports.
- Identifying areas for business process improvement.
- Maintaining business processes and policies for the Data Reporting department.
- Assessing and monitoring these processes to ensure their effectiveness and adjust accordingly.
- Setting up data sources to enable self-serve report generation for others in the business.
- Interacting with the Development team when further automation is required.
Qualifications
You are a proactive self-starter with knowledge of creating and managing data structures, along with experience in creating reports with a strong focus on data visualisation using tools such as Excel, VBA, SQL and Power BI.
This position requires you to manage tight deadlines, solve problems with excellent attention to detail, and be able to communicate effectively with colleagues and stakeholders.
Good communication and interpersonal skills will be needed, as you will be liaising with stakeholders up to the board level, to deliver data reports and dashboards to improve performance.
You have experience in identifying data sources, extracting and cleansing the data, knowledge of creating and managing data structures, and experience in creating bespoke data visualisation reports through tools such as Power BI.
Required skills and experience:
- Excellent English language skills, both written and oral.
- Proficient with data extraction techniques, data analysis tools, and scripting languages.
- Experience in creating and managing data structures.
- Experience in identifying data sources, extracting and cleansing the data,
- Experience in creating reports with a strong focus on data visualisation.
- Advanced Microsoft Excel skills, including VBA.
- Knowledge of Power Query and Power BI.
- Advanced knowledge of SQL
Additional Information
We offer:
We are offering a unique opportunity for the right individual to join our business and develop their career in a fast-paced, challenging yet rewarding and supportive environment.
We embrace a culture of knowledge sharing and constantly strive for improvement and learning.
- Entrepreneurial culture, flat structure, open-door policy;
- Flexible working hours and working-from-home opportunities.
- Self-learning and further development opportunities
- Global role with challenging tasks but tangible results.
- Company bonus - discretionary
- Company events - online and offline
Take the opportunity:
We have built a company where financial success is tied closely to technical achievement. We are always on the lookout for people who can bring their intellect, enthusiasm, and ability to execute to the team.
We promote a working environment in which diversity is recognised, valued and encouraged. OSTC is an equal opportunities employer, therefore, all appointments and promotions are made on the basis of performance and ability.
Terms and conditions:
OSTC Limited is strongly committed to protecting the privacy of your personal information. The OSTC Job Applicant Privacy Notice explains how we treat the information you submit and we collect as a part of the recruitment process. By using the OSTC careers website and submitting your personal information through this site, you agree that OSTC Limited may process your personal information for the purposes described in the OSTC Job Applicant Privacy Notice. OSTC Limited is the data controller for the information you provide through this website.
OSTC is committed to building a diverse, equitable and truly inclusive organization. It actively encourages diversity and inclusion, while opposing all forms of unlawful and unfair discrimination on the grounds of age, disability, gender reassignment, marriage and civil partnership, pregnancy and maternity, race, religion or belief, sex and sexual orientation.
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Data analysis Excel Finance Power BI Privacy SQL
Perks/benefits: Career development Flex hours Team events
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Marketing Data Analyst jobs
- Open MLOps Engineer jobs
- Open AI Engineer jobs
- Open Senior Data Architect jobs
- Open Junior Data Scientist jobs
- Open Data Engineer II jobs
- Open Sr Data Engineer jobs
- Open Data Analytics Engineer jobs
- Open Power BI Developer jobs
- Open Senior Business Intelligence Analyst jobs
- Open Principal Data Engineer jobs
- Open Manager, Data Engineering jobs
- Open Product Data Analyst jobs
- Open Business Data Analyst jobs
- Open Data Manager jobs
- Open Data Quality Analyst jobs
- Open Sr. Data Scientist jobs
- Open Data Scientist II jobs
- Open Big Data Engineer jobs
- Open Business Intelligence Developer jobs
- Open Data Analyst Intern jobs
- Open Principal Data Scientist jobs
- Open ETL Developer jobs
- Open Azure Data Engineer jobs
- Open Data Product Manager jobs
- Open Data quality-related jobs
- Open Business Intelligence-related jobs
- Open Privacy-related jobs
- Open Data management-related jobs
- Open GCP-related jobs
- Open Java-related jobs
- Open ML models-related jobs
- Open Finance-related jobs
- Open Data visualization-related jobs
- Open Deep Learning-related jobs
- Open APIs-related jobs
- Open PyTorch-related jobs
- Open PhD-related jobs
- Open TensorFlow-related jobs
- Open Consulting-related jobs
- Open Snowflake-related jobs
- Open NLP-related jobs
- Open Data governance-related jobs
- Open Data warehouse-related jobs
- Open Airflow-related jobs
- Open Databricks-related jobs
- Open Hadoop-related jobs
- Open LLMs-related jobs
- Open DevOps-related jobs
- Open Kubernetes-related jobs