remote DBT Data Engineer with Very Strong SQL

2 months ago

new delhi, India jupitorconsulting Full time
Job Description

Role:  Data Engineer with Strong SQL
Location: Remote 
Duration: Longterm

POSITION DESCRIPTION


POSITION DESCRIPTION
WHAT YOU’LL DO
• Architect, Design, document & implement the data pipelines to feed data models for
subsequent consumption in Snowflake using dbt, airflow.
• Ensure correctness and completeness of the data being transformed via engineering
pipelines for end consumption in Analytical Dashboards.
• Actively monitor and triage technical challenges in critical situations that require
immediate resolution.
• Evaluate viable technical solutions and share MVPs or PoCs in support of the
research
• Develop relationships with external stakeholders to maintain awareness of data and
security issues and trends
• Review work from other tech team members and provide feedback for growth
• Implement Data Performance, Data security policies that align with governance
objectives and regulatory requirements
YOU’RE GOOD AT
You have experience in data warehousing, data modelling, and the building of data
engineering pipelines. You are well versed in data engineering methods, such as ETL
and ELT techniques through scripting and/or tooling. You are good in analyzing
performance bottlenecks and providing enhancement recommendations; you have a
passion for customer service and a desire to learn and grow as a professional and a
technologist.
• Strong analytical skills related to working with unstructured datasets.
• Collaborating with product owners to identify requirements, define desired
outcomes and deliver trusted results.
• Building processes supporting data transformation, data structures, metadata,
dependency and workload management.
• In this role, SQL is heavily focused. An ideal candidate must have hands-on
experience with SQL database design. Plus, Python.
• Demonstrably deep understanding of SQL (level: advanced) and analytical data
warehouses (Snowflake preferred).
• Demonstrated ability to write new code i.e., well-documented and stored in a
version control system (we use GitHub & Bitbucket)
• Extremely talented in applying SCD, CDC and DQ/DV framework.
• Familiar with JIRA & Confluence.
• Must have exposure to technologies such as dbt, Apache airflow and
Snowflake.
• Desire to continually keep up with advancements in data engineering practices.
• Knowledge on AWS cloud, Python is a plus.
YOU BRING (EXPERIENCE & QUALIFICATIONS)
Essential Education
• Bachelor's degree or equivalent combination of education and experience.
• Bachelor's degree in information science, data management, computer science
or related field preferred.


•
Essential Experience & Job Requirements
• 4+ years of IT experience with major focus on data warehouse/database related
projects
• Must have exposure to technologies such as dbt, Apache Airflow, Snowflake.
• Experience in data platforms: Snowflake, Oracle, SQL Server, MDM etc
• Expertise in writing SQL and database objects - Stored procedures, functions,
views. Hands on experience in ETL/ELT and data security, SQL performance
optimization and job orchestration tools and technologies e.g., dbt, Attunity,
Golden Gate, APIs, Apache Airflow etc.
• Experience in data modelling and relational database design
• Well versed in applying SCD, CDC and DQ/DV framework
• Demonstrate ability to write new code i.e., well-documented and stored in a
version control system (we use GitHub & Bitbucket)
• Good to have experience with Cloud Platforms such as AWS, Azure, GCP and
Snowflake
• Good to have strong programming/ scripting skills (Python, PowerShell, etc.)
• Good to have knowledge around developing financial models and forecasting to
support financial planning, and decision-making processes.
• Experience around responsibility for analyzing and interpreting financial data to
provide valuable insights and support strategic decision-making.
• Experience working with agile methodologies (Scrum, Kanban) and Meta Scrum
with cross-functional teams (Product Owners, Scrum Master, Architects, and data
SMEs)
• Excellent written, oral communication and presentation skills to present
architecture, features, and solution recommendations
YOU’LL WORK WITH
o Global functional product portfolio technical leaders (Finance, HR, Marketing, Legal,
Risk, IT), product owners, functional area teams across levels
o Global Data Product Portfolio Management & teams (Enterprise Data Model, Data
Catalog, Master Data Management)
o Consulting and internal Data Product Portfolio teams across BCG
 


Additional Information

All your information will be kept confidential according to EEO guidelines.

  • Snowflake Data Engineer

    3 weeks ago

    delhi, India Lapis Data Analytics Full time

    Company DescriptionLapis Data Analytics is a dynamic and innovative data engineering company founded in 2020 and located in Chennai. Our primary focus is on designing, building, and maintaining robust data pipelines that convert raw data into actionable insights. With a team of seasoned experts and cutting-edge technology, we deliver customized data...

  • Global IT Data Engineer Manager

    3 weeks ago

    New Delhi, India Boston Consulting Group Full time

    WHAT YOU'LL DODesign, document & implement the data pipelines to feed data models for subsequent consumption in Snowflake using dbt, and airflow.Ensure correctness and completeness of the data being transformed via engineering pipelines for end consumption in Analytical Dashboards.Actively monitor and triage technical challenges in critical situations that...

  • Global IT Data Engineer Manager

    2 weeks ago

    New Delhi, India Boston Consulting Group Full time

    WHAT YOU'LL DODesign, document & implement the data pipelines to feed data models for subsequent consumption in Snowflake using dbt, and airflow.Ensure correctness and completeness of the data being transformed via engineering pipelines for end consumption in Analytical Dashboards.Actively monitor and triage technical challenges in critical situations that...

  • Data Engineer

    4 weeks ago

    Delhi, India Straive Full time

    Job Role- AWS Data Engineer Experience- 4 to 6 years Mode- Remote The Data Engineering team is looking for a Data Engineer with experience in building modern data platforms from the ground up. The successful candidate will build and maintain cloud-centric data processing capabilities that unleash the value of the data assets to gain competitive advantage in...

  • Global IT Data Engineer Manager

    3 weeks ago

    New Delhi, India Boston Consulting Group Full time

    WHAT YOU'LL DODesign, document & implement the data pipelines to feed data models for subsequent consumption in Snowflake using dbt, and airflow.Ensure correctness and completeness of the data being transformed via engineering pipelines for end consumption in Analytical Dashboards.Actively monitor and triage technical challenges in critical situations that...

  • Global IT Data Engineer Manager

    2 weeks ago

    New Delhi, India Boston Consulting Group Full time

    WHAT YOU'LL DODesign, document & implement the data pipelines to feed data models for subsequent consumption in Snowflake using dbt, and airflow.Ensure correctness and completeness of the data being transformed via engineering pipelines for end consumption in Analytical Dashboards.Actively monitor and triage technical challenges in critical situations that...

  • Data Engineer

    2 months ago

    Delhi, India Straive Full time

    Job Role- AWS Data EngineerExperience- 4 to 6 yearsMode- RemoteThe Data Engineering team is looking for a Data Engineer with experience in building modern data platforms from the ground up. The successful candidate will build and maintain cloud-centric data processing capabilities that unleash the value of the data assets to gain competitive advantage in the...

  • Global IT Data Engineer Manager

    3 weeks ago

    New Delhi, India Boston Consulting Group Full time

    WHAT YOU'LL DODesign, document & implement the data pipelines to feed data models for subsequent consumption in Snowflake using dbt, and airflow.Ensure correctness and completeness of the data being transformed via engineering pipelines for end consumption in Analytical Dashboards.Actively monitor and triage technical challenges in critical situations that...

  • Global IT Data Engineer Manager

    2 weeks ago

    New Delhi, India Boston Consulting Group Full time

    WHAT YOU'LL DODesign, document & implement the data pipelines to feed data models for subsequent consumption in Snowflake using dbt, and airflow.Ensure correctness and completeness of the data being transformed via engineering pipelines for end consumption in Analytical Dashboards.Actively monitor and triage technical challenges in critical situations that...

  • Global IT Data Engineer Manager

    3 weeks ago

    new delhi, India Boston Consulting Group Full time

    WHAT YOU'LL DO Design, document & implement the data pipelines to feed data models for subsequent consumption in Snowflake using dbt, and airflow. Ensure correctness and completeness of the data being transformed via engineering pipelines for end consumption in Analytical Dashboards. Actively monitor and triage technical challenges in critical situations...

  • Global IT Data Engineer Manager

    2 weeks ago

    new delhi, India Boston Consulting Group Full time

    WHAT YOU'LL DO Design, document & implement the data pipelines to feed data models for subsequent consumption in Snowflake using dbt, and airflow. Ensure correctness and completeness of the data being transformed via engineering pipelines for end consumption in Analytical Dashboards. Actively monitor and triage technical challenges in critical situations...

  • Principal Data Engineer

    2 months ago

    Delhi, India Cornerstone OnDemand Full time

    We're looking for aPrincipal Data EngineerThis role isRemotePrincipal Data EngineerWe are seeking a talented Principal Data Engineer in Pune, India. Reporting to the Sr. Manager – Data Engineering. The right candidate has strong communication skills, passion for solving business problems with data, domain knowledge in Finance – O2C, FP&A or Human...

  • AWS Glue with DBT

    2 weeks ago

    delhi, India 6 concourse parkway Full time

    Job Summary for AWS Glue with DBT:Our client is looking for AWS Glue engineer to join the team.Job Qualifications and Responsibilities for AWS Glue with DBT:5yrs experience in AWS GlueMust have experience with DBTRedshift, CI/CDpython

  • Azure Lead Data Engineer

    4 weeks ago

    Delhi, India IntraEdge Full time

    As Azure Lead Data Engineer, you will have to take over the key activities of designing, coding, and implementing data solutions in the platform. With a focus on leveraging DBT for data transformation and modelling, as well as expertise in MDM tools, you will play a pivotal role in architecting scalable and performant data pipelines and warehouses. You will...

  • Senior Analytics Engineer(Snowflake/DBT)

    3 weeks ago

    Delhi, India Tide Full time

    Department: Data ScienceWho are Tide:At Tide, we’re on a mission to save businesses time and money. We’re the leading provider of UK SME business accounts and one of the fastest-growing FinTechs in the UK. Using the latest tech, we design solutions with SMEs in mind and our member-driven financial platform is transforming the business banking market. Not...

  • Senior Analytics Engineer(Snowflake/DBT)

    6 days ago

    Delhi, India Tide Full time

    Department: Data ScienceWho are Tide:At Tide, we’re on a mission to save businesses time and money. We’re the leading provider of UK SME business accounts and one of the fastest-growing FinTechs in the UK. Using the latest tech, we design solutions with SMEs in mind and our member-driven financial platform is transforming the business banking market. Not...

  • ▷ (25/05/2024) Operations Specialist

    3 weeks ago

    Delhi, India Data Engineer Academy Full time

    Job Title: Operations AnalystLocation : RemoteCompany Overview:Data Engineering Academy is a pioneering force in data engineering education, founded by FAANG data engineers with extensive industry expertise. Our platform provides comprehensive programs tailored to empower aspiring data engineers, equipping them with the skills and confidence necessary to...

  • Senior Data Engineer

    4 weeks ago

    Delhi, India Velotio Technologies Full time

    Velotio Technologies is a product engineering company working with innovative startups and enterprises. We have provided full-stack product development for 110+ startups across the globe, building products in the cloud-native, data engineering, B2B SaaS, IoT & Machine Learning space. Our team of 325+ elite software engineers solves hard technical problems...

  • Senior Data Engineer

    3 weeks ago

    Delhi, India Jobberman Full time

    Job DescriptionResponsibilities:As a Data Engineer, you work closely with our customers. You set the stage because you come with the right data, at the right time and to the right people. You thus create a strong foundation for our customers to have easy access to work with data and most importantly, that they can put action behind data.You may spearhead or...

  • Data Engineer

    1 month ago

    delhi, India NAB Full time

    Consultant - Data Engineer role exists to ensure the delivery of the Right data to the Right customer at the Right time and at the Right Cost using the Right tools and the Right Technology on NAB’s target state Marketing Platforms.You will enable the move, flow and processing of reusable data assets in the Technology and Enterprise Operations space for...