Req ID : 367793

We are currently seeking a Business Intelligence Specialist to join our team in Bangalore, Karnātaka (IN-KA), India (IN).

Bangalore(Global Village Tech Park) or Gurgaon location, working from ODC/Clean Room based on client need

Hybrid working from office minimum 3 Days a week

Regular shift 11 am to 9 p.m. IST

What you will do :

- Design, implement, and optimize efficient ETL processes to transform raw data into actionable insights.
- Develop and maintain robust data warehouse solutions, including the implementation of star and snowflake schemas. Establish and manage reliable data pipelines to ensure timely data availability.
- Create modular, maintainable, and scalable dbt workflows for advanced data transformations.
- Leverage dbt testing, documentation, snapshotting, and Change Data Capture (CDC) for incremental data refresh.
- Implement and manage Type 2 data modelling techniques for historical data.
- Optimize complex SQL queries and leverage Snowflake’s performance-enhancing features like Streams, Time Travel, partitioning, and clustering.
- Orchestrate data pipelines for both batch and near real-time data refresh scenarios.
- Write and optimize Snowflake SQL queries and stored procedures for seamless data transformation and integration.
- Ensure compliance with data governance policies and implement security controls for sensitive data.
- Work closely with data engineering and analytics teams to align workflows with broader data strategies.
- Monitor and implement strategies to improve the performance of large-scale data queries and systems.
- Stay updated on the latest technologies and practices to bring innovation into the data warehousing process.

What we need from you :





- Snowflake - 5+ Years
- SQL - 5+ Years
- DBT - 3+ Years
- Airflow - 1-2 years
- Proficiency in SQL/PL-SQL for data querying and optimization.
- Strong knowledge of data warehousing concepts and design.
- Familiarity with Python for enhancing dbt pipelines.
- Strong analytical, problem-solving,
- Experience in Python programming with minimum 4years along with data loading and transformation experience.

Additional knowledge and/or experience desired :

- Familiarity with the financial services industry, including banking, wealth management, or investment platforms.
- Hands-on experience with ETL tools such as DBT, SSIS, Informatica, or Azure Data Factory.
- Knowledge of Snowflake, including query writing and data integration.
- Familiarity with cloud platforms like Azure Synapse, AWS Redshift, or Snowflake.
- Experience with Agile methodologies.
- Development experience in the financial services industry is a plus.
- Experience with CI/CD tools like Jenkins, Docker, or Terraform.

What we would like from you :

- Strong system/ technical analysis skills
- Self-motivation with an ability to prioritize multiple tasks
- Ability to develop a robust internal network across the platform
- Excellent collaboration, communications, negotiation, and conflict resolution skills
- Ability to think creatively and seek optimum solutions
- Ability to grasp loosely defined concepts and transform them into tangible results and key deliverables
- Very strong problem-solving skills
- Diagnostic skills with the ability to analyze technical, business and financial issues and options
- Action-oriented, with the ability to quickly deal with change

About NTT DATA

📌 Business Intelligence Specialist (Bengaluru)
🏢 NTT
📍 Bengaluru