Analytics Engineer - (Onsite) Bengaluru, India
Degreed
·
Posted:
July 31, 2023
·
Hybrid
About the position
Degreed India Engineering is seeking an experienced Analytics Engineer to provide timely and accurate data to engineers, data scientists, and business analysts. The role involves developing data pipelines, designing database schemas, and deploying services in an Azure-based data infrastructure. The Analytics Engineer will collaborate with internal teams, provide expertise and support using data, and ensure end-to-end data quality. The ideal candidate should have a track record of shipping impactful software and experience in Python, data modeling, ETL/ELT, data warehousing, and SQL. This role is based in Bengaluru, India.
Responsibilities
- Research systems and APIs to find the best way to connect to production databases
- Develop data pipelines to extract, load, and transform data using SQL, Python, Jinja
- Transform data in the data warehouse to build data models for reporting and analytics
- Design, deploy, and maintain services in the Azure-based data infrastructure
- Partner with internal teams to research and develop requirements for new features
- Design database schemas and queries to ensure performance
- Write automated tests to monitor and ensure end-to-end data quality
- Work with reporting engineers to experiment with and deploy data models
- Consult with teams across Degreed to provide expertise, guidance, and support using data
Requirements
- 3+ years of experience writing performant, maintainable, and scalable Python services
- 4+ years of experience in engineering, including Data Modeling, ETL/ELT, Data Lakes, and Data Warehousing on cloud platforms such as Azure, AWS, GCP, etc
- 4+ years working with SQL such as SQL Server, Postgres, MySQL
- 2+ years of experience deploying and maintaining CI/CD-enabled high-availability production services
- 3+ years of experience with one or more data pipeline platforms like Airflow, Stitch, Meltano, Spark, or others
- Experience using and developing on Snowflake or other large, shared data warehouses
- 2+ years of writing automated testing using tools like Pytest
- Practical experience with software development processes and tools like Scrum, code reviews, GitHub, Jira, etc.
- Experience working in highly collaborative teams
- Experience utilizing Dbt to actualize models
- Exposure to Jinja coding
- Practical hands-on experience with creating Airflow DAGs
- Candidate must be based in Bengaluru, India.
Benefits
- Remote-first company with opportunities for in-office or flex work
- Flexibility to work remotely if needed
- Collaboration through virtual meetings, email, and Slack
- Opportunity to operate 100% virtually from home office
- Equal employment opportunities without discrimination or harassment
- Reasonable accommodations for individuals with disabilities
- Consideration of qualified applicants with arrest and conviction records
- E-Verify employment verification program