: Ab Initio Data Engineer (AWS, Python & Data Modeling)

Job Title: Senior / Lead Ab Initio Data Engineer

Experience Level: 5 – 10 Years

Location / Mode: Sydney / Hybrid

Employment Type: Full-Time

Department: Data Engineering & Cloud Analytics

Primary Tech Stack: Ab Initio (GDE, EME, Conduct>It), AWS, Python, SQL, Data Modeling

Role Summary

We are seeking an experienced Ab Initio Data Engineer with solid expertise in Enterprise Data Modeling, AWS cloud services, and Python development. In this role, you will design, build, and optimize high-volume ETL/ELT data pipelines while supporting cloud modernization initiatives. You will partner with enterprise architects, data analysts, and business stakeholders to translate complex business requirements into scalable, reliable, and well-governed data solutions.

Key Responsibilities

- Ab Initio ETL Development: Design, develop, test, and deploy scalable, high-performance data processing graphs, plans, and workflows using Ab Initio GDE, Co>Operating System, EME, and Conduct>It.
- Enterprise Data Modeling: Design and maintain conceptual, logical, and physical data models (3NF, Star Schema, Snowflake Schema, and Data Vault) tailored for operational data stores and analytical data warehouses.
- AWS Cloud Integration: Architect and integrate data pipelines with AWS ecosystem services including Amazon S3, Redshift, Glue, Lambda, EMR, IAM, and Step Functions to support hybrid and cloud-native workloads.
- Python Automation & Scripting: Develop modular Python scripts for data ingestion, API integration, file validation, metadata automation,



and custom data transformations alongside Unix/Linux shell scripting.
- Performance Tuning & Optimization: Analyze and resolve bottlenecks in Ab Initio graphs, SQL queries, and cloud data warehouses using parallelism, partitioning, and indexing best practices.
- Data Governance & Quality: Implement automated data quality checks, reconciliation frameworks, error-handling routines, and end-to-end data lineage tracking within EME.
- Production Support & Collaboration: Provide Level-3 production troubleshooting, participate in code reviews, maintain technical documentation, and mentor junior data engineers.

Required Qualifications & Technical Skills

- Education: Bachelor’s or Master’s degree in Computer Science, Information Technology, Data Engineering, or a related quantitative discipline.
- Ab Initio Expertise: 5 years of hands-on experience with Ab Initio components (GDE, Co>Operating System, EME, Conduct>It, Express>It, and Continuous Flows).
- Data Modeling Proficiency: Proven track record in dimensional and relational data modeling, slowly changing dimensions (SCD Type 1/2/3), and enterprise data warehouse architecture.
- AWS Cloud Experience:



Strong working knowledge of AWS data services (S3, Redshift, Glue, Lambda, Athena, EC2) and cloud security/IAM policies.
- Python & Scripting: Proficiency in Python (Pandas, Boto3, PySpark, SQLAlchemy) and Unix/Linux shell scripting for workflow orchestration and automation.
- Database & SQL Mastery: Advanced SQL skills with experience across relational and cloud databases such as Amazon Redshift, Snowflake, Oracle, Teradata, or PostgreSQL.
- Scheduling & DevOps: Hands-on experience with enterprise job schedulers (Control-M, Autosys, or Airflow) and CI/CD version control tools (Git, Jenkins).

Preferred Qualifications (Good to Have)

- Cloud Modernization: Experience migrating legacy on-premise Ab Initio ETL workloads to AWS cloud architectures.
- Data Modeling Tools: Familiarity with industry data modeling tools such as ERwin, ER/Studio, or IBM InfoSphere Data Architect.
- Big Data & Streaming: Exposure to Apache Spark, Kafka, or Ab Initio Continuous Flows for real-time data processing.
- Certifications: AWS Certified Data Engineer – Associate or AWS Certified Solutions Architect – Associate.

Core Competencies

- Analytical Problem-Solving: Ability to dissect complex data anomalies and design resilient, fault-tolerant solutions.
- Stakeholder Communication: Clear verbal and written communication skills to collaborate effectively across technical and business teams.
- Agile Delivery: Familiarity with Agile/Scrum methodologies, sprint planning, and iterative delivery.

📌 Ab Initio Engineer (Southern Sydney)
🏢 PAAR Systems
📍 Southern Sydney