Data Engineer

Fruition are working with a leading player in its industry, committed to delivering data-driven insights that enhance business performance. With a strong focus on innovation, the company leverages cutting-edge technology to optimise operations and improve customer experiences.

You will play a key role in designing, developing, and maintaining the organisation's data infrastructure. You'll work closely with stakeholders across the business, including product managers, analysts, and software developers, to ensure seamless data integration and reporting capabilities.

This role will focus on building and optimising data pipelines, managing data warehousing, and ensuring high-quality data is available for business decision-making.

Responsibilities:

• Data Pipeline Development: Design, build, and maintain ETL (Extract, Transform, Load) processes to enable efficient data ingestion and transformation.
• Database Management: Support and optimise SQL databases, ensuring performance, reliability, and data integrity.
• SQL Replication: Manage and maintain SQL replication to ensure data consistency across systems.
• SSIS & Data Integration: Develop and maintain SQL Server Integration Services (SSIS) packages to support data workflows.
• Data Warehousing: Work on pulling and structuring data warehousing solutions for efficient storage and retrieval.
• Power BI & Reporting: Develop dashboards and visualisations using Power BI to support data-driven decision-making.
• Azure Data Factory: Leverage Azure Data Factory to build and orchestrate cloud-based data pipelines.
• Collaboration: Work closely with data analysts, software engineers, and business stakeholders to understand data needs and develop solutions.

• Strong SQL development and optimisation skills.
• Experience with SQL Server Integration Services (SSIS) and SQL replication.
• Hands-on experience with Visual Studio for database development.
• Proficiency in Power BI for creating reports and dashboards.
• Experience with Azure Data Factory for cloud-based data integration.
• Understanding of data warehousing concepts and best practices.
• Strong analytical and problem-solving skills.
• Ability to work independently and collaboratively in a fast-paced environment.