In_specialist_ Dbt Data Engineer SQL Snowflake_d&a_advisory_bangalore

**Line of Service** Advisory **Industry/Sector** Not Applicable **Specialism** Data, Analytics & AI **Management Level** Specialist **Job Description & Summary** At PwC, our people in data and analytics focus on leveraging data to drive insights and make informed business decisions. They utilise advanced analytics techniques to help clients optimise their operations and achieve their strategic goals. In data analysis at PwC, you will focus on utilising advanced analytical techniques to extract insights from large datasets and drive data-driven decision-making. You will leverage skills in data manipulation, visualisation, and statistical modelling to support clients in solving complex business problems. \*Why PWC At PwC, you will be part of a vibrant community of solvers that leads with trust and creates distinctive outcomes for our clients and communities. This purpose-led and values-driven work, powered by technology in an environment that drives innovation, will enable you to make a tangible impact in the real world. We reward your contributions, support your wellbeing, and offer inclusive benefits, flexibility programmes and mentorship that will help you thrive in work and life. Together, we grow, learn, care, collaborate, and create a future of infinite experiences for each other. Learn more  [about us](https://www.pwc.in/about-us.html) . At PwC, we believe in providing equal employment opportunities, without any discrimination on the grounds of gender, ethnic background, age, disability, marital status, sexual orientation, pregnancy, gender identity or expression, religion or other beliefs, perceived differences and status protected by law. We strive to create an environment where each one of our people can bring their true selves and contribute to their personal growth and the firm’s growth. To enable this, we have zero tolerance for any discrimination and harassment based on the above considerations. " **Job Description & Summary:**   A career within Data and Analytics services will provide you with the opportunity to help organisations uncover enterprise insights and drive business results using smarter data analytics. We focus on a collection of organisational technology capabilities, including business intelligence, data management, and data assurance that help our clients drive innovation, growth, and change within their organisations to keep up with the changing nature of customers and technology. We make impactful decisions by mixing mind and machine to leverage data, understand and navigate risk, and help our clients gain a competitive edge.  **Responsibilities:**  _About the Role:_  We are hiring sharp, hands-on Data Engineers to build scalable data solutions and drive performance across both traditional and cloud-based data platforms. If you love writing clean code, solving tough data problems, and designing robust data architectures, this role is for you.  _What you will do:_   * Design and implement scalable data pipelines for batch and near real-time use cases in cloud environments  * Write optimized, complex **SQL** queries for data transformation and analysis in cloud data warehouses  * Develop efficient **Python** and **PySpark** scripts for large-scale data processing and ETL workflows   * Create and maintain data models in **Databricks**, ensuring data quality and consistency   * Optimize queries and scripts over large-scale datasets (TBs) with a focus on performance and cost-efficiency   * Implement data governance and security best practices in cloud environments   * Collaborate across teams to translate business requirements into robust technical solutions  **Mandatory skill sets:**  **‘Must have’ knowledge, skills and experiences**   * 5+ years of hands-on experience in Data Engineering   * Strong command over **SQL**, **Python**, and **PySpark** for data manipulation and analysis   * Deep experience with data warehousing concepts and implementation in cloud environments (**Azure**/**AWS**)   * Proficiency in data modeling techniques for cloud-based systems (**Databricks, Snowflake**)  * Solid understanding of ETL/ELT processes and best practices in cloud architectures  * Experience with dimensional modeling, star schemas, and data mart design   * Strong analytical thinking and problem-solving skills  **Preferred skill sets:**  **‘Good to have’ knowledge, skills and experiences**   * _Familiarity with data lake architectures and delta lake concepts_   * _Familiarity with_ _Snowflake/Databricks_ _Data Warehouse_  * _Knowledge of data warehouse migration strategies to cloud_   * _Experience with real-time data streaming technologies (e.g., Apache Kafka, Azure Event Hubs)_   * _Exposure to data quality and data governance tools and methodologies_   * _Understanding of data virtualization and federated query engines_   * _Understanding of performance optimization techniques for cloud-based data warehouses_   * _Apache Airflow_ _– Workflow orchestration and scheduling_  * _Certifications in Azure or AWS or Databricks_  **Years of experience required:**  **Experience**   * _5-8 years_  **Education qualification:**  * BE, B.Tech, ME, M,Tech, MBA, MCA (60% above)  **Education** _(if blank, degree and/or field of study not specified)_ Degrees/Field of Study required: Master of Engineering, MBA (Master of Business Administration), Bachelor of Engineering Degrees/Field of Study preferred: **Certifications** _(if blank, certifications not specified)_ **Required Skills** AWS Database Migration Service (DMS), Database Modeling, Snowflake Data Warehouse **Optional Skills** Accepting Feedback, Accepting Feedback, Active Listening, Agile Methodology, Automation Algorithms, Automation Engineering, Automation Framework Design and Development, Automation Programming, Automation Solutions, Automation Studio, Automation System Efficiency, Blue Prism, Business Analysis, Business Performance Management, Business Process Analysis, Business Process Automation (BPA), Business Transformation, Business Value Optimization, C++ Programming Language, Cognitive Automation, Communication, Conducting Discovery, Configuration Management (CM), Continuous Process Improvement, Data Analytics {+ 31 more} **Desired Languages** _(If blank, desired languages not specified)_ **Travel Requirements** **Available for Work Visa Sponsorship?** **Government Clearance Required?** **Job Posting End Date** July 25, 2026