Business Intelligence Analyst
NTT DATA Global Delivery Services LtdJob Description
Business Intelligence Specialist
We are seeking an experienced ETL Developer with strong expertise in DBT, Snowflake, and modern Data Warehouse (DWH) practices. The ideal candidate will design, develop, and optimize data pipelines, manage Snowflake assets (dynamic tables, semantic models, tasks, streams), and ensure high‑performance scalable datasets for analytics and reporting.
Key Responsibilities
1. ETL / ELT Development
- Design, build, and maintain ETL/ELT pipelines using DBT and other modern tools.
- Develop modular, testable DBT models (staging, intermediate, marts).
- Implement CI/CD pipelines for DBT job deployments.
- Monitor pipeline performance and ensure high data quality.
2. Snowflake Development
- Build and manage:
- Dynamic Tables
- Semantic Views
- Stored Procedures (SP)
- Tasks and scheduling workflows
- Streams for change data capture (CDC)
- Implement Snowflake resource optimization including clustering, partitioning, caching, and warehouse sizing.
- Use Query Profile for performance tuning and troubleshooting.
- Manage Snowflake security (RBAC), data governance, and cost optimization.
3. Data Warehousing
- Design and enhance DWH structures using dimensional modeling (Star/Snowflake schema).
- Work with business stakeholders to translate requirements into scalable data models.
- Ensure reliability, data quality, lineage, and metadata documentation.
4. Performance Tuning
- Optimize SQL queries, DBT models, and Snowflake compute usage.
- Identify performance bottlenecks using Snowflake Query Profile and DBT artifacts.
- Implement best practices for incremental loads and materializations.
Required Skills & Experience
Technical Skills
- Strong SQL (complex joins, window functions, query optimization)
- Hands‑on expertise with DBT Core / DBT Cloud
- Advanced experience with Snowflake:
- Dynamic Tables
- Semantic Views
- Streams & Tasks
- Stored Procedures (JavaScript/Python)
- Snowflake Performance Tuning
- Query Profile analysis
- Experience with ETL/ELT pipeline design
- Familiarity with Airflow or similar orchestration tools (preferred)
- Understanding of CDC frameworks
- Strong understanding of data warehousing concepts (Kimball/Inmon)
Soft Skills
- Strong analytical and problem‑solving skills
- Excellent communication and documentation abilities
- Ability to work in Agile environments
Ownership mindset with attention to detail
Job role
Job requirements
About company
Similar jobs you can apply for
Field SalesArea Sales Manager
Urban-Infosoft Private LimitedBusiness Development Executive (BDE)
D3 Property Management Private LimitedHome Loan Executive
Kruthik Financial AdvisorsField Sales Manager-Onrole(Fixed CTC+Incentives)
Supro Info Solutions Private LimitedRelationship Manager
Supro Info Solutions Private Limited
Sales & Marketing Manager
Dtdc Express LimitedYou can expect a minimum salary of 0 INR. The salary offered will depend on your skills, experience and performance in the interview.
The candidate should have completed the required education and people who have 2 to 31 years are eligible to apply for this job. You can apply for more jobs in Bengaluru/Bangalore to get hired quickly.
The candidate should have sound communication skills and sound communication skills for this job.
Both Male and Female candidates can apply for this job.
No, it's not a work from home job and can't be done online. You can explore and apply for other work from home jobs in Bengaluru/Bangalore at apna.
No work-related deposit needs to be made during your employment with the company.
Go to the apna app and apply for this job. Click on the apply button and call HR directly to schedule your interview.
The last date to apply for this job is . For more details, download apna app and find Full Time jobs in Bengaluru/Bangalore . Through apna, you can find jobs in 64 cities across India. Join NOW!