Our client is a manufacturing company who are seeking a Data Engineer to extract, transform and present data from various sources to support data-driven decision-making processes. This role is crucial in ensuring data integrity, accessibility, and usability for analysis and reporting, ultimately contributing to the company's strategic objectives.
Reporting directly to the head Group IT Manager, this is an excellent opportunity to join a small team in a good sized, highly successful company, where initiative is encouraged and hard work rewarded.
Responsibilities:
* Data Extraction:Obtain data from various sources including MS SQL databases, Excel workbooks, and CSV files.
* Data Integration:Integrate and transform data using MS Synapse to ensure it is ready for analysis.
* Data Presentation:Utilise SQL Server Reporting Services (SSRS) and Power BI to create and present reports for data review and analysis.
* Data Management:Maintain and optimize data pipelines and workflows to ensure data accuracy and reliability.
* Collaboration:Work closely with data analysts, business stakeholders, and other team members to understand data requirements and deliver solutions.
* Documentation:Document data processes, workflows, and methodologies to ensure transparency and reproducibility
Skills and Experience:
* Proven experience in obtaining data from MS SQL databases, Excel workbooks, and CSV files.
* Proficiency in MS Synapse and SSRS for data integration and reporting.
* Strong analytical skills with the ability to interpret complex data sets and provide actionable insights.
* Excellent problem-solving skills with a proactive approach to identifying and resolving data issues.
* Strong communication skills to effectively collaborate with team members and stakeholders.
* Working effectively with cross-functional teams including data analysts, business stakeholders, and IT professionals.
* Ability to analyse complex data sets and derive meaningful insights
* Proficiency in SQL and experience with databases like MS SQL, Oracle, or MySQL.
* Experience with visualization tools like Tableau, Power BI, or SSRS.
* Ensuring data accuracy and integrity.
* Staying updated with the latest technologies and best practices in data engineering.
A Bachelor's degree in Computer Science, Information Technology, or a related field is preferred but applicants with demonstrable experience will of course be considered regardless.
Key success factors:
* Ensuring the accuracy, consistency, and reliability of data.
* Developing efficient data pipelines and workflows.
* Ensuring compliance with relevant data protection regulations and standards.