Senior Associate - Data Engineer (PySpark,Python)

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.

Creating business intelligence from data requires an understanding of the business, the data, and the technology used to store and analyse that data. Using our Rapid Business Intelligence Solutions, data visualisation and integrated reporting dashboards, we can deliver agile, highly interactive reporting and analytics that help our clients to more effectively run their business and understand what business questions can be answered and how to unlock the answers.

• Deliver projects integrating data flows within and across technology systems.
• Lead data modeling sessions with end user groups, project stakeholders, and technology teams to produce logical and physical data models.
• Design endtoend job flows that span across systems, including quality checks and controls.
• Create technology delivery plans to implement system changes.
• Perform data analysis, data profiling, and data sourcing in relational and Big Data environments.
• Convert functional requirements into logical and physical data models.
• Assist in ETL development, testing, and troubleshooting ETL issues.
• Troubleshoot data issues and work with data providers for resolution; provide L3 support when needed.
• Design and develop ETL workflows using modern coding and testing standards.
• Participate in agile ceremonies and actively drive towards team goals.
• Collaborate with a global team of technologists.
• Lead with ideas and innovation.
• Manage communication and partner with end users to design solutions.

• 5 years of project experience in Python/Shell scripting in Data Engineering (experience in building and optimizing data pipelines, architectures, and data sets with large data volumes).
• 3+ years of experience in PySpark scripting, including the architecture framework of Spark.
• 35 years of strong experience in database development (Snowflake/ SQL Server/Oracle/Sybase/DB2) in designing schema, complex procedures, complex data scripts, query authoring (SQL), and performance optimization.
• Strong understanding of Unix environment and batch scripting languages (Shell/Python).
• Strong knowledge of Big Data/Hadoop platform.
• Strong engineering skills with the ability to understand existing system designs and enhance or migrate them.
• Strong logical data modeling skills within the Financial Services domain.
• Experience in data integration and data conversions.
• Strong collaboration and communication skills.
• Strong organizational and planning skills.
• Strong analytical, profiling, and troubleshooting skills.

• Experience with ETL tools (e.g Informatica, Azure Data Factory) and pipelines across disparate sources is a plus.
• Experience working with Databricks is a plus.
• Familiarity with standard Agile DevOps methodology tools (Jenkins, Sonar, Jira).
• Good understanding of developing ETL processes using Informatica or other ETL tools.
• Experience working with Source Code Management solutions (e.g., Git).
• Knowledge of Investment Management Business.
• Experience with job scheduling tools (e.g., Autosys).
• Experience with data visualization software (e.g., Tableau).
• Experience with data modeling tools (e.g., Power Designer).
• Basic familiarity with using metadata stores to maintain a repository of Critical Data Elements. (e.g. Collibra)
• Familiarity with XML or other markup languages.

Degrees/Field of Study required Bachelor in Business Administration, Bachelor of Engineering Degrees/Field of Study preferred Extract Transform Load (ETL), Python (Programming Language), Structured Query Language (SQL) Accepting Feedback, Accepting Feedback, Active Listening, Analytical Reasoning, Analytical Thinking, Application Software, Business Data Analytics, Business Management, Business Technology, Business Transformation, Communication, Creativity, Documentation Development, Embracing Change, Emotional Regulation, Empathy, Implementation Research, Implementation Support, Implementing Technology, Inclusion, Intellectual Curiosity, Learning Agility, Optimism, Performance Assessment, Performance Management Software