ETL Fundamentals, SQL, SQL (Basic + Advanced), Alation, Talend, Matillion, Python, Snowflake, Data Warehousing, DBT, Airflow, IICS, Modern Data Platform Fundamentals, Data Modelling Fundamentals, PLSQL, T-SQL, Stored Procedures, Salesforce Marketing Cloud (Marketing)
Job requirements
Role: Data Architect
Years of Experience: 8+ years
Location: Remote
9 plus years of overall IT experience. Proven experience with DBT (Data Build Tool), including model development, transformations, and testing.
Hands on DBT development experiance.
Design, develop, and maintain DBT models, transformations, and SQL code to build efficient data pipelines for analytics and reporting.
Design, build, and maintain robust ETL processes and data pipelines using DBT and other relevant tools. Optimize ETL pipelines for performance, scalability, and cost-efficiency.
Strong Python experience mandatory. Write effective, scalable code in Python. Hands on experiance with Python - Pandas library in detail & Numpy.
Advanced SQL skills are mandatory. Ability to write complex SQL queries to query large amounts of data Troubleshoot and resolve any issues related to the ETL process or data pipeline performance.
Mandatory hands on coding experience in Unix Shell scripting.
Salesforce CDP knowledge and Snowflake implementation will be a plus. Integrate user-facing elements into applications Writing Snowflake SQL queries against Snowflake Developing scripts like Unix, Python, etc. to do Extract, Load, and Transform data.
Working experiance with Airflow, or other data pipeline orchestration tools is a plus.
Knowledge of cloud platforms (AWS, GCP, Azure) and experience with cloud-based data storage solutions (e.g., S3, GCS, Blob Storage).
Coordinate with internal teams to understand user requirements and provide technical solutions
Why should you apply for this role?
(Practice Pitch)
As Brillio continues to gain momentum as a trusted partner for our clients in their digital transformation journey, we strive to set new benchmarks for speed and value creation. The Advisory and Value Assurance (AVA) team at Brillio is at the forefront of leading this charge by reimagining and executing how we structure, sell and deliver our services to better serve our clients.
Know more about <add practice specific page link from Brillio website>
Brillio is an equal opportunity employer to all, regardless of age, ancestry, colour, disability (mental and physical), exercising the right to family care and medical leave, gender, gender expression, gender identity, genetic information, marital status, medical condition, military or veteran status, national origin, political affiliation, race, religious creed, sex (includes pregnancy, childbirth, breastfeeding, and related medical conditions), and sexual orientation.
