Negotiable
Undetermined
Undetermined
West Midlands, England, United Kingdom
Summary: The role of Data Engineer involves managing the entire lifecycle of data transformation for a unique project, focusing on converting unstructured data into structured formats for analysis in Excel and Salesforce. The position requires collaboration with colleagues to ensure data integrity and the implementation of efficient workflows for data cleaning and transformation. The candidate will also need to demonstrate expertise in SQL, Python, and data modelling principles. Occasional travel to the headquarters is expected as part of the role.
Key Responsibilities:
- Convert large volumes of unstructured data into structured formats suitable for relational databases.
- Prepare datasets for compatibility with Excel and Salesforce by designing integration processes.
- Join multiple datasets while maintaining consistency and addressing discrepancies.
- Correct data types and formats, handle missing values, and verify record accuracy.
- Implement checks to maintain data integrity and ensure high-quality outputs.
- Collaborate with colleagues to design workflows for ongoing data cleaning and transformation.
Key Skills:
- Expertise in SQL and relational database design.
- Advanced proficiency in Python for data wrangling and transformation.
- Understanding of data modelling principles and best practices.
- Strong knowledge of Excel functions and familiarity with Salesforce data structures.
- Experience with Power BI or Tableau for creating reports and visualisations.
- Clear communication skills for explaining technical concepts to non-technical audiences.
Salary (Rate): undetermined
City: West Midlands
Country: United Kingdom
Working Arrangements: undetermined
IR35 Status: undetermined
Seniority Level: undetermined
Industry: IT
Data Engineer UK (with occasional travel to HQ) Interim
I am currently looking for an interim Data Engineer to assist with a unique project. You will be responsible for taking ownership of the entire lifecycle of data transformation from initial parsing of raw files through to delivering structured outputs ready for analysis in Excel and Salesforce.
Data Engineer – What will you be doing?
- Convert large volumes of unstructured data into structured formats suitable for use in relational databases, ensuring all information is logically organised and accessible.
- Prepare datasets for seamless compatibility with Excel spreadsheets and Salesforce systems by designing processes that facilitate smooth integration and usability.
- Join multiple disparate datasets together, maintaining consistency across various systems while addressing any discrepancies or gaps in the data.
- Correct data types and formats throughout the transformation process, handle missing values appropriately, and verify the accuracy of all records before final delivery.
- Implement rigorous checks at every stage to maintain data integrity, ensuring that all outputs meet high standards of reliability and quality.
- Collaborate with colleagues to design efficient workflows for ongoing data cleaning, organisation, and transformation tasks as new information becomes available.
Data Engineer – What will you need?
- Demonstrated expertise in SQL and relational database design, with a proven ability to structure complex datasets for optimal performance and accessibility.
- Advanced proficiency in Python for data wrangling, cleaning, and transformation tasks required by large-scale projects.
- Comprehensive understanding of data modelling principles and best practices for managing information within modern database environments.
- Strong working knowledge of Excel functions as well as familiarity with Salesforce data structures to ensure smooth interoperability between platforms.
- Experience using Power BI or Tableau to create insightful reports and visualisations from processed datasets.
- Clear communication abilities that allow you to explain technical concepts effectively to non-technical audiences including lawyers and other stakeholders.
Robert Walters are proud to specialise in BI & Data recruitment across the UK, offering amazing opportunities on a permanent and interim basis. We are also proud to be heading up the Data Leaders roundtables and PBI BRUM meetup group, bringing new and exciting networking opportunities to candidates and clients in the Midlands.
If you would be interested in speaking about the role or having a general chat about your job search, please send your CV to matthew.collier@robertwalters.com.
*Applicants must reside in the UK & have full right to work*
Robert Walters Operations Limited is an employment business and employment agency and welcomes applications from all candidates