Full Stack BI Developer

Summary: We are looking for a highly skilled Full Stack BI Developer to join our ETL/Data Engineering team. The candidate will be responsible for designing, developing, and maintaining scalable data pipelines, transforming data in Snowflake and Snaplogic for the creation of dashboards.

Responsibilities:

• Perform analysis, design, development, and unit testing of data warehousing applications using industry-accepted methodologies and procedures.
• Write complex SQL queries to implement ETL (Extract, Transform, Load) processes and for Business Intelligence reporting.
• Deliver robust solutions through query optimization ensuring data quality.
• Experience in writing functions and stored procedures.
• Strong understanding of the principles of data warehouse using fact tables, dimension tables, star and snowflake schema modeling.
• Analyze and translate functional specifications/user stories into technical specifications.
• Good interpersonal skills, experience in handling communication and interactions between different teams.

Requirements:

• 4-8 years of experience in data engineering/ETL/BI development.
• Bachelor’s degree in Computer Science or related field.

Required Skills:

• Strong experience in Python for ETL and data processing.
• Hands-on Snowflake experience (Snowpipe, Streams, Tasks).
• Advanced SQL skills (queries, joins, procedures).
• ETL/ELT pipeline development.
• Data warehousing concepts.
• Data validation and performance tuning.
• Version control (Git) and Agile methodologies.

Preferred Skills:

• Experience with ETL tools (DBT, ADF, SnapLogic, Informatica).
• Cloud exposure (AWS / Azure).
• Handling semi-structured data (JSON, XML).
• Pipeline orchestration tools.
• Power BI (DAX, dashboards, data modeling). #AditiConsulting # 26-03914