Data Architect

About Billigence:

Billigence is a boutique data consultancy with global outreach & clientele, transforming the way organizations work with data. We leverage proven, cutting-edge technologies to design, tailor, and implement advanced Business Intelligence solutions with high added value across a wide range of applications from process digitization through to Cloud Data Warehousing, Visualisation, Data Science, and Engineering or Data Governance. Headquartered in Sydney, Australia with offices around the world, we help clients navigate difficult business conditions, remove inefficiencies, and enable scalable adoption of analytics culture.

About the role:

ed Data Archit

Task Description

• Design and implement end-to-end data architecture

  leveraging

• Snowflake

  and

  Matillion

  for data ingestion, transformation, and storage.
• Define and maintain

  data modeling standards

  , data flows, and architecture best practices (dimensional, normalized, star/snowflake schemas).
• Lead the evaluation and adoption of tools in the

  modern data stack

  , ensuring alignment with business goals and future scalability.
• Collaborate with data engineers, analysts, and stakeholders to define data requirements and create robust data pipelines.
• Ensure data security, access controls, and compliance with governance frameworks (e.g., GDPR, HIPAA, SOC 2).
• Optimize performance of Snowflake through clustering, caching, query tuning, and cost management.
• Oversee data integration strategies from multiple sources (APIs, databases, flat files, third-party platforms).
• Establish

  data quality

  and

  metadata management

  practices across platforms.
• Act as a subject matter expert and provide guidance on

  Matillion orchestration

  , reusable job frameworks, and job performance optimization.

Required Skills and Experience:

Required Qualifications

• 5+ years of experience in data engineering, architecture, or similar roles.
• Proven expertise with

  Snowflake

  (multi-cluster warehouse design, role-based access, data sharing, etc.).
• Strong experience designing and implementing pipelines with

  Matillion ETL

  .
• Proficient in data modeling and building scalable cloud data platforms.
• Deep understanding of ELT/ETL design patterns and orchestration principles.
• Strong SQL and scripting (e.g., Python or Bash) skills.
• Hands-on experience with cloud platforms (preferably

  AWS

  or

  Azure

  ).
• Familiar with CI/CD, version control (Git), and infrastructure-as-code (e.g., Terraform, CloudFormation).

Preferred Qualifications

• Experience with

  dbt

  ,

  Airflow

  , or other orchestration and transformation tools.
• Knowledge of

  BI/reporting tools

  (e.g., Power BI, Tableau, Looker).
• Familiarity with

  data governance

  and

  data catalog

  solutions (e.g., Alation, Collibra, Atlan).
• Background in supporting machine learning platforms and real-time data pipelines.
• Industry experience in [finance, healthcare, retail, etc. — can be customized].

NICE TO HAVE:

• Very good communication skills and can do attitude.
• Very good analytical skills and structured approach (Detail-oriented).
• Organizational skills, team player.
• Ability to work independently, with self-motivation and self-confidence.
• Comfortable working in a fast-paced environment.
• Ability to time manage efficiently to avoid over-commitments.
• Strong customer centric mindset.
• Fluent English (written and spoken).