Principal Architect - R01570796

Team: AI & Data Engineering : Data Engineering

Location: Saint Louis, Missouri, United States

Commitment: Employee

Workplace Type: onsite

Job requirements

Experience Range: With at least 15 years of experience in cloud architecture, including significant hands-on expertise designing and implementing AWS and Databricks-based solutions

 

Key Responsibilities:
1. Design and architect scalable, secure, and high-performance AWS and Databricks solutions, leveraging AWS Networking, Kinesis, Elastic Cache, Redshift, EKS, Cognito, and PaaS services
2. Develop and maintain robust ETL/ELT pipelines using PySpark and Python within Databricks, including notebooks, jobs, Delta Lake tables, and Unity Catalog for governance
3. Implement medallion architecture (bronze, silver, gold layers) and optimize Spark jobs for performance, cost, scalability, and reliability, addressing partitioning, skew, caching, and adaptive query execution
4. Provision and manage cloud infrastructure using Terraform for Databricks workspaces, clusters, jobs, storage (ADLS/S3), networking, IAM roles and permissions, and related resources on Azure and AWS
5. Write efficient SQL queries for data transformation, validation, and analytics within Databricks, ensuring data quality, lineage, security, and compliance
6. Implement and maintain CI/CD pipelines using Jenkins and GitHub Actions for automated testing and deployment of notebooks, jobs, Delta Live Tables, and Terraform configurations
7. Integrate data from diverse sources (databases, APIs, streaming, files) into cloud storage and processing layers
8. Optimize cloud costs through auto-scaling clusters, spot instances, job scheduling, and efficient resource usage
9. Monitor pipeline performance, troubleshoot failures, and implement alerting and observability using Databricks tools, cloud monitoring services, or third-party solutions

 

Required Skills:
1. Advanced proficiency in AWS Networking and VPC design
2. Expertise in AWS Kinesis for real-time data streaming and analytics
3. Deep experience with AWS Elastic Cache for distributed caching
4. Extensive experience with AWS Redshift for data warehousing
5. Strong knowledge of AWS PaaS services including Lambda, S3, and Glue
6. Hands-on experience with AWS EKS for container orchestration
7. Proficiency in AWS Cognito for identity and access management
8. Expertise in Databricks, including Delta Lake, Unity Catalog, and Delta Live Tables
9. Strong Python and PySpark skills for distributed data processing
10. Advanced SQL skills for complex querying and optimization
11. Proficiency in Terraform for infrastructure automation and management
12. Experience with CI/CD tools such as Jenkins and GitHub Actions

 

Preferred Skills:
1. Knowledge of Azure Data Lake, Data Factory, Synapse, and Key Vault
2. Understanding of big data modeling (star/snowflake, dimensional) and lakehouse architecture
3. Experience with performance tuning in Spark and Databricks environments
4. Familiarity with data governance, lineage, and compliance in cloud environments

 

Desired Qualifications:
1. Bachelor's degree in Computer Science, Information Technology, or a closely related discipline
2. AWS Certified Solutions Architect – Professional
3. Databricks Certified Data Engineer Professional or Apache Spark certification

 

Additional Information:
This role requires presence in St. Louis and attendance at the client office three days a week.

 

Know more about DAE: https://www.brillio.com/services-data-analytics/

 

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.

 

 #LI-AY1