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:

We are seeking an experienced Data Architect to lead the d data architecture and modeling, with a focus on Snowflake and Matillion.The ideal candidate for this position is pro-active, self-directed, team player and passionate. 

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).