Solutions Engagement Lead - Ultra Intellect

Job Overview We are seeking a skilled Data Engineer to join our dynamic team. The ideal candidate will be responsible for designing, constructing, and maintaining scalable data pipelines and architectures. You will work closely with data scientists and analysts to ensure the efficient flow of data across various platforms and systems, enabling insightful analysis and decision-making. We are looking for a Data Engineer to join our growing Data and Analytics team. This is ideal for someone with a solid foundation in data engineering who wants to develop deeper skills in Azure Databricks and Microsoft Fabric. You will play a key role in developing and maintaining modern data pipelines, shaping the meta data driver architecture, and building high-quality data models that power reporting and advanced analytics across the business. Duties • Develop and maintain robust data pipelines using technologies such as AWS, Hadoop, and Spark., • Design and implement database solutions for both structured and unstructured data using Oracle and Microsoft SQL Server., • Collaborate with cross-functional teams to understand data requirements and translate them into technical specifications., • Perform data modelling and database design to optimise performance and scalability., • Conduct data analysis to identify trends, patterns, and anomalies in large datasets., • Utilise programming languages such as Python and Java for data manipulation and transformation tasks., • Implement ETL processes using tools like Informatica to ensure seamless data integration., • Write efficient SQL queries for data retrieval, reporting, and analysis., • Create documentation for data processes, workflows, and system architecture., • Employ shell scripting (Bash) for automation of routine tasks., • Build and maintain scalable data pipelines in Azure Databricks and Microsoft Fabric using PySpark and Python, • Support the meta driven architecture (raw, enriched, curated layers) to ensure a clean separation of raw, refined, and curated data, • Design and implement dimensional models such as star schemas and slowly changing dimensions, • Work closely with analysts, governance, and engineering teams to translate business requirements into data solutions, • Apply data governance and lineage principles to ensure documentation, traceability, and quality, • Proven experience in a Data Engineering role or similar position., • Strong knowledge of big data technologies including Hadoop, Apache Hive, and Spark., • Proficiency in programming languages such as Python, Java, VBA, and shell scripting (Bash)., • Experience with database design principles and management of relational databases (Oracle, Microsoft SQL Server)., • Familiarity with data warehousing concepts and best practices., • Excellent analytical skills with the ability to interpret complex datasets effectively., • Strong problem-solving abilities coupled with attention to detail., • Ability to work collaboratively in a team environment while also being self-motivated. If you are passionate about working with data and have the skills required to thrive in this role, we encourage you to apply. Join us in driving our data initiatives forward!, • Familiarity with Agile delivery principles, • Interest in gaining the Microsoft Fabric Data Engineer certification (supported by the business), • Strong SQL and Python skills with hands-on experience in PySpark, • Exposure to Azure Databricks, Microsoft Fabric, or similar cloud data platforms, • Understanding of Delta Lake, Git, and CI/CD workflows, • Experience with relational data modelling and dimensional modelling, • Awareness of data governance tools such as Purview or Unity Catalog, • Excellent analytical and problem-solving ability with strong attention to detail