Data Integration Engineer (Senior Associate)

Grant Thornton INDUS is the in-house offshore center for Grant Thornton US- a member firm of Grant Thornton International, with offices in Bangalore and Kolkata. Our team of over 2,400 professionals specializes in Tax, Audit, Advisory, Operations, and Enabling functions, delivering exceptional client service, and driving excellence across all domains. We are proud to have been recognized as aGreat Place to Work® for the last two consecutive years, reflecting our commitment to building a high-trust, high-performance culture.AtGrant Thornton INDUS, our people-centric culture is rooted in empowering individuals, bold leadership, and a commitment to providing distinctive client experiences. We foster a transparent, competitive, and performance-driven environment where professionals are given opportunities to contribute to meaningful and impactful initiatives. Our young and dynamic workforce not only excels in delivering business outcomes but also inspires and gives back to the community through generous and impactful service initiatives.

Why Join Grant Thornton INDUS?

• Empowered Environment:We encourage autonomy and bold decision-making at all levels, shaping our future together.
• Significant Contributions:We provide ample opportunities to deliver transformational results and exceptional client service, driving innovation and growth.
• Culture of Excellence:We promote transparency, competitiveness, and a relentless drive to excel.
• Learning Opportunities:We offer diverse, multi-platform learning opportunities for dynamic growth.
• Vibrant Culture:Our open culture fosters diversity, acceptance, engagement, and enjoyment for all.
• Community Impact:We support initiatives that enable employees to make meaningful contributions to society and make a wider difference.

Summary

Grant Thornton GTech’s Data & Analytics function is dedicated to designing and delivering robust global data platforms that enable business solutions and high-quality analytics. The Analytics Engineer is responsible for building curated, analytics-ready datasets and semantic models that bridge data engineering and analytics, enabling trusted reporting and self-service consumption within the organization’s Data Lakehouse. This hands-on role focuses on transformation development (dbt), dimensional modeling, semantic-layer and BI delivery (Power BI), and data quality. Working closely with Business teams, Data Architects, Data Engineers, and Analysts, the Analytics Engineer turns business requirements into well-structured, governed, and performant data products that serve as a trusted foundation for analytics, reporting, and AI.

Responsibilities

·Design, build, and maintain curated, analytics-ready (gold-layer) datasets and semantic models that enable trusted reporting and self-service consumption.

·Develop and maintain modular, well-documented data transformations using dbt, following established engineering standards and reusable patterns.

·Build and optimize dimensional models (star/snowflake schemas, data marts) aligned with the Medallion architecture (Bronze/Silver/Gold layer separation).

·Develop semantic models, metric definitions, and certified datasets in Snowflake and Power BI to support consistent, governed analytics consumption.

·Translate business and reporting requirements into transformation logic and business rules in partnership with data analysts and stakeholders.

·Conduct data profiling, validation, and reconciliation using Snowflake SQL to ensure the accuracy, completeness, and integrity of analytics outputs.

·Perform data lineage and impact analysis across Snowflake, upstream sources, transformation layers, and reporting layers.

·Implement data quality checks, tests, and observability for analytics pipelines and datasets.

·Optimize Snowflake queries, models, and transformations for performance, reliability, and cost efficiency.

·Collaborate with data engineers, ETL/ELT developers, and QA, and support UAT to resolve data-related gaps through iterative testing and validation.

·Apply governance-by-design practices (access, classification/metadata, certified datasets), and mentor and guide more junior team members.

Skills

·Proven experience with Machine Learning, predictive analytics, and natural language processing.

·Strong programming skills in SQL and Python for data validation, profiling, reconciliation, and analytics.

·Strong hands-on Snowflake experience is required, including, ability to construct & optimize complex SQL queries, variant/JSON parsing, schema and stage understanding, performance analysis & troubleshooting, dynamic tables/materialized views, dbt-on-Snowflake (Streams & Tasks), and secure views/masking for certified datasets.

·Working experience in Medallion Architecture (Bronze, Silver, Gold data layers) including mapping data flows across layers.

·Strong hands-on experience with dbt for building and maintaining modular, tested data transformations (ELT/ETL development and maintenance).

·Hands-on experience building semantic models and reports in Power BI (metric definitions, certified datasets, and self-service enablement).

·Experience developing curated, analytics-ready (gold-layer) datasets and reusable transformation patterns.

·Strong understanding of data lineage, metadata traceability, and impact analysis.

·Experience applying governance-by-design and data observability (data quality tests, lineage, and certified datasets).

·Effective communication skills with ability to work directly with business stakeholders.

·Excellent analytical and problem-solving skills.

Education / Professional Experience/ Qualifications

·Bachelor of Science (BS) in Computer Science, Information Systems, Analytics, or related field (or equivalent work experience).

·5+ years of analytics engineering, BI/data warehouse development, or related data experience in enterprise data environments.

·Preferred: Experience in professional services, accounting industry, or client service/consultative technology roles.

·Experience with ETL/ELT tools (Informatica, dbt).

·Experience with BI/reporting tools (Power BI, Tableau, Excel).

·Experience with data modeling methodologies (Dimensional modeling, Data Marts, Data Warehousing, Star/Snowflake schema).

·Familiarity with cloud data platforms (Azure, AWS, GCP).

·Agile/Scrum delivery exposure.

Grant Thornton INDUS (Full-Time Employee) Benefits:

• Insurance: Health, Accidental, and Term Life Insurance for employees (and dependents as applicable).
• Wellness:Employee Assistance Program, Corporate Health Plans, Gym (Bangalore), Wellness Webinars, Health months.
• Work-Life Balance:Hybrid work model, flexible work options for returning mothers.
• Parental Support:Maternity/Paternity leave, daycare facilities, flexible work arrangements.
• Mobility:Secondment opportunities, relocation benefits, internal job postings.
• Retirement:Provident Fund, Gratuity, Leave Encashment, National Pension Scheme.
• Additional Benefits:Women’s security (night transport), home office setup allowance, certification reimbursements, meal cards, appreciation holidays, service awards.
• Learning:Multi-channelIn-house learning platform, LinkedIn Learning, certification programs.