Mô Tả Công Việc
To maximise the effective use and value of Marketing and Enterprise data assets by delivering on a strategic data management roadmap through a combination of:
- The design and articulation of a structured and comprehensive approach to data management and data governance within Marketing (both tactical and strategic).
- End to end definition and governance of data features within the Marketing data environment on (S3, Redshift, Airflow, DataBricks)
- Working closely with business and technology teams to leverage enterprise Target State data capabilities
This role will provide critical thinking and a high degree of technical development and attention to detail. This role will have varying degrees of analysis, design, development, documentation, testing and support responsibilities.
Specific accountabilities for the role
- Analysis of data for use in Marketing campaigns, designing solutions for data features, data modelling and code for data features.
- Delivering data features per solution designs for Marketing campaigns.
- Developing optimal, performant queries, maintain code standards and adhere to Data Governance principles. Defining business requirements into technology teams
- Documentation of data product patterns and processes
Yêu Cầu Công Việc
Essential capabilities
- Advanced or demonstrable experience in SQL, Python,
- Experience with Source code control (GitHub) and Jenkins
- Ability to design, develop, execute, complete ETL
- Ability to articulate complex technical issues and desired outcomes of system enhancements
- Proven analytical skills and evidence-based decision making
- Excellent problem solving, troubleshooting & documentation skills
- Strong written and verbal communication skills
- Excellent collaboration and interpersonal skills
- Strong delivery focus with an active approach to quality and auditability
Desired Capabilities
- Understanding and ability to translate/physicalise Data Models (Star Schema, Data Vault 2.0 etc) – ErWin Data Modeller experience
- Knowledge and exposure to Big Data technologies Hadoop stack such as HDFS, Hive, Impala, Spark etc, and cloud Big Data warehouses - RedShift, Snowflake, DataBricks.
- Exposure to AWS technologies including EMR, Glue, Athena, Data Pipeline, Lambda
- Exposure to orchestration technologies such as Airflow
- Knowledge of PEGA XCAR (bonus points)
Experience
Hands on in SQL and its Big Data variants (Hive-QL, DataBricks ANSI, Redshift SQL)
It is expected that the role holder will most likely have the following qualifications and experience.
- 6+ years technical experience (within financial services industry preferred)
- Solid experience, knowledge and skills in Data Engineering, BI/software development such as ELT/ETL, data extraction and manipulation in Data Lake/Data Warehouse/Lake House environment.
- Hands on programming experience in writing Python, SQL, Unix Shell scripts, Pyspark scripts, in a complex enterprise environment
- Experience in configuration management using Ansible/Jenkins/GIT
- Hands on experience of using AWS Services - S3,EC2, EMR, SNS, SQS, Lambda functions, Redshift
- Knowledge of Data Modelling techniques and practices used for a Data Warehouse/Data Mart application.
- Experience with Source Control Tools – Github or BitBucket
- Skilled in querying data from a range of data sources that store structured and unstructured data
- Knowledge or understanding of Power BI (Recommended)
Qualification Requirements
Tertiary qualification in technology related degree (e.g. Bachelor Degree in Computer Science, Data Analytics or Engineering)
Hình thức
Quyền Lợi
- Very competitive remuneration package
- Generous private family healthcare for yourself and your family members
- A solid team behind you - great people who love what they do
- The pleasant, enthusiastic, international work environment
- Opportunity for traveling & training in Australia
- Brand new & state of the art Agile offices
- Latest technologies, flexible working hours
- A promising training and career path
- Fun team activities & outing
- English learning with native English teachers
If this excites you, let's have a chat over a cup of coffee!