ETIC, Azure Data Engineer, Senior Associate
Job Description & Summary
A career within Data and Analytics services will provide you with the opportunity to help organisations uncover enterprise insights and drive business results using smarter data analytics. We focus on a collection of organisational technology capabilities, including business intelligence, data management, and data assurance that help our clients drive innovation, growth, and change within their organisations in order to keep up with the changing nature of customers and technology. We make impactful decisions by mixing mind and machine to leverage data, understand and navigate risk, and help our clients gain a competitive edge.
You’ll focus on aligning client data strategies to their business strategy. You will assist clients in choosing a platform, defining their data needs and migrating them to a modern cloud data environment using cloud providers such as Azure, Google Cloud Platform, Amazon Web Services, Snowflake, Databricks or Teradata.
- You’ll have 4+ years of hands-on experience of data analytics solutions on cloud platforms
- You’ll be well versed in data architecture approaches to ingest, model and serve data from various sources including structured and unstructured data sources
- In addition, you should also be comfortable in implementing the right solution, whether that is ELT or ETL
- Delivery of solutions through the full lifecycle of a enterprise data platform implementation, including data warehouses, Big Data, MDM and DQM / data profiling
- Experience of design and implementation of Information Strategy, Information Architecture and Governance projects to ensure the security, integrity, and availability of information with appropriate technical documentation and QA activities
- Modern data lakes and data warehouse solutions.
- The ability to design and implement data models from concept through to reality, which could include slowly changing dimensions or single customer views
- Experience in infrastructure elements of a cloud platform including the setup and implementation of DevOps, networking and security elements
- Having experience within at least one business area function (e.g marketing, sales, finance, workforce, procurement etc.)
- Experience in adapting your communication style to help translate complex technical information to audiences unfamiliar with the technologies
Technical Skills
- Foundational understanding of Data & Analytics Architectures, definition of KPIs / metrics and insight requirements
- You should have experienced delivery knowledge in at least one of the following vendors: SAP Business Analytics, Oracle, Cognos, Informatica, IICS, SSIS, Datastage, Talend, data warehouse and data management vendors
- Proficient in SQL and performance tuning of queries, ensuring solutions are both scalable and maintainable
- Practical knowledge of core data modelling, manipulation and visualisation skills- for example using tools such as Excel, Alteryx, PowerBI/Tableau/Qlik
Project Skills
- Experience in shaping and planning projects through either Waterfall or Agile methodologies
- Experience using Agile project management tools (DevOps, Trello, JIRA, Kanbanchi etc)
Supporting the design and delivery of data transformation projects with clients. This will include:
- Translating business requirements into technical specifications, helping to understand and create solutions to our clients’ key challenges
- Participating in end-to-end planning, coordination and oversight of the project lifecycle including resourcing, scoping, architecting and delivery
- Developing client relationships including with C-level staff, Heads of Data and Analytics, IT and Data Architects and other business stakeholders during the lifecycle of a project
- Collaborating with our wider D&A teams across the firm, whether that be locally or working with our alternative delivery teams (onshore and offshore)
- Taking an active role in coaching and developing skills for more junior team members
- Man interface with client relationships including with C-level staff, Heads of Data and Analytics, IT and Data Architects and other business stakeholders during the lifecycle of a project.
- Microsoft Azure Data Engineering certification is needed
- Microsoft Azure Fundamentals certification is a plus