Snowflake Data Engineer with Apache Doris
Avance Consulting · Austin, Texas Metropolitan Area · 1 mo ago
On-siteAnalystFull-time
About the role
In the assigned Job Role of Technology Consultant 2, your Area Of Responsibility will include:
- Contribute to the requirements elicitation process by documenting assigned parts of business requirements, in line with guidance provided
- Facilitate software application design discussions, and document design decisions to guide the technical team towards building software solutions
- Participate in coding and integrate new features or updates into existing applications, with a focus on maintaining system stability
- Conduct code reviews, do changes to the codebase and maintain code repositories
- Implement test strategies, analyse results, and coordinate bug fixes to uphold the software quality standards
- Develop user training programs, documentation, and support frameworks to ensure a smooth transition to new software applications
- Actively participate in resolving production issues and recommend preventive strategies to enhance system reliability
- Maintain detailed records of code, testing techniques, and support activities to enrich the knowledge base and assist other similar projects
Your contribution to the team
- A collaborative spirit and excellent communication skills
- The ability to handle end to end SDLC phases from requirement gathering to implementation
- A knack for translating complex requirements into actionable development tasks
- A passion for design and hands-on coding experience
- A proactive approach to testing, troubleshooting, and refining our applications
- The ability to work with cross-functional teams and do software integration
Requirements
- Working experience in Snowflake and Apache Doris
- Experience in writing complex SQLs, expertise in performance tuning of SQLs
- Experience in Python scripting and programming
- Hands-on Gen-AI skills preferably with Claude Code, etc and ability to create solutions in client context
- Knowledge of BI, Reporting and Data Warehousing
- Ability to play a Techno Functional role
- Experience in designing end-to-end reporting and dashboarding applications
- Experience is working with client business users and other stakeholders to understand reporting / dashboarding requirements and then translating them into technical design and implementing entire technical solutions
- Experience in designing and developing ETL data pipelines
- Hands-on experience in building Tableau dashboards
- Hands-on experience in database and table design
- Working with huge volumes of data would be an advantage
- Expected to lead offshore data engineers
Preferred Skills
- Experience in GEN AI
- Experience in SQL
- Experience in Spark
- Apple GBI experience is preferred