About Brillio:

Brillio is one of the fastest growing digital technology service providers and a partner of choice for many Fortune 1000 companies seeking to turn disruption into a competitive advantage through innovative digital adoption. Brillio, renowned for its world-class professionals, referred to as "Brillians", distinguishes itself through their capacity to seamlessly integrate cutting-edge digital and design thinking skills with an unwavering dedication to client satisfaction.

Brillio takes pride in its status as an employer of choice, consistently attracting the most exceptional and talented individuals due to its unwavering emphasis on contemporary, groundbreaking technologies, and exclusive digital projects. Brillio's relentless commitment to providing an exceptional experience to its Brillians and nurturing their full potential consistently garners them the Great Place to Work® certification year after year.

Primary Skills

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 experience.
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 experience 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 experience 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
PPE: https://www.brillio.com/platform-and-product-engineering/
DAE: https://www.brillio.com/services-data-analytics/
CES: https://www.brillio.com/services-customer-experience-services/
DI: https://www.brillio.com/services-digital-infrastructure/
Know what it’s like to work and grow at Brillio: https://www.brillio.com/join-us/
Equal Employment Opportunity Declaration
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.