Dbt (Data Build Tool)

India- Remote**About Us**
Affine is a global leader in professional services and solutions at the forefront of AI, data engineering, and cloud technologies. With our distributed team of over 500 analytics professionals across North America, Europe, and Asia, we are dedicated to enabling global enterprises to transform and innovate through the power of AI (Artificial Intelligence), data engineering, and cloud technologies.

We offer exciting career opportunities for professionals seeking to make a significant impact. Our diverse team represents a rich tapestry of talent, expertise, and cultural backgrounds. As an Affine employee, you'll be part of a dynamic and inclusive work environment that values collaboration, creativity, and continuous learning. Joining Affine means immersing yourself in a world of cutting-edge projects and solutions. We work closely with global clients spanning various sectors, including manufacturing, gaming, consumer packaged goods (CPG), media and entertainment, travel, and technology. As a member of our team, you'll have the opportunity to leverage your skills and contribute to transformative projects that shape industries and redefine the future.

We believe in investing in our people and nurturing their growth. Affine is dedicated to your professional development and offers a range of learning opportunities, mentorship programs, and career advancement paths. We also encourage innovation and thought leadership through our strong connections with esteemed institutions like UC Berkeley and premier Indian Institutes of Technology (IITs), ensuring that you stay at the forefront of industry advancements. At Affine, we foster a culture of collaboration, where ideas are valued, and teamwork is celebrated. As you work alongside some of the brightest minds in the industry, you'll be inspired to push boundaries, solve complex challenges, and make a lasting impact on the world.

**Responsibilities**:

- Assist in the design and implementation of Snowflake-based analytics solution (data lake and data warehouse) on AWS
- Requirements definition, source data analysis and profiling, the logical and physical design of the data lake and data warehouse as well as the design of data integration and publication pipelines
- Develop Snowflake deployment and usage best practices
- Help educate the rest of the team members on the capabilities and limitations of Snowflake
- Build and maintain data pipelines adhering to suggested enterprise architecture principles and guidelines
- Design, build, test, and maintain data management systems
- Work in sync with internal and external team members like data architects, data scientists, data analysts to handle all sorts of technical issue
- Act as technical leader within the team
- Working in Agile/Lean model
- Deliver quality deliverables on time
- Translating complex functional requirements into technical solutions.

**Job Requirement**

**Essential Skills, Education and Experience**
- Should have a B.E. / B.Tech. / MCA or equivalent degree along with 4-7 years of experience in Data Engineering
- Creation and maintenance of optimum data pipeline architecture for ingestion, processing of data
- Creation of necessary infrastructure for ETL jobs from a wide range of data sources using Talend, DBT, S3, Snowflake.
- Experience in Data storage technologies like Amazon S3, SQL, NoSQL
- Data modeling technical awareness
- Experience in working with stakeholders working in different time zones

**Good to have**
- AWS data services development experience.
- Working knowledge on using Bigdata technologies.
- Experience in collaborating data quality and data governance team.
- Exposure to reporting tools like Tableau
- Apache Airflow, Apache Kafka (nice to have)
- Payments domain knowledge
- CRM, Accounting, etc. in depth understanding
- Regulatory reporting exposure

**Other skills**
- Good Communication skills
- Team Player
- Problem solver
- Willing to learn new technologies, share your ideas and assist other team members as needed
- Strong analytical and problem-solving skills; ability to define problems, collect data, establish facts, and draw conclusions.