Business Intelligence Data Warehouse Consultant

About Us

Masco Home Products India (MHPI)

world-class Global Business Services organization

Masco Corporation

🔗 Learn more: www.masco.com

🔗 MHPI LinkedIn: MHPI (Masco Home Products India)

🔗 Business Unit Supported: Masco Canada

Position Details

• Requisition ID:

  REQ50848

• Position:

  BI - Data Engineer

• Location:

  India (Permanent Remote)

• Job Type:

  Permanent

• Experience Required:

  Minimum 5 years in Data Engineering, Database Design, and ETL Development

• Shift:

  4:00 PM – 1:00 AM IST (minimum 4.5 hours EST overlap)

• Work Hours:

  9 hours total (8.5 hours working + 30-minute break)

• CTC:

  As per market standards

• Notice Period:

  Immediate joiners or candidates with ≤30 days preferred

• Internet Requirement:

  Minimum 30 Mbps broadband (Jio/Airtel/Tata/Hathway, etc.)

• Work Setup:

  Quiet home office space accommodating 2 monitors + laptop

Job Summary

Senior Manager, Analytics

Primary Responsibilities

• Collaborate with cross-functional teams to define data requirements, standards, and architectures.
• Design and implement strategies for data acquisition, transformation, and storage.
• Develop and optimize

  ETL processes

  using

  SSIS

  and other tools.
• Build scalable data pipelines for batch and real-time data processing.
• Manage databases ensuring

  security, scalability, and performance

  .
• Implement data governance and quality assurance best practices.
• Troubleshoot data issues, optimize queries, and improve processing efficiency.
• Support analytics, data governance, and business teams with data solutions.
• Document workflows, provide training, and ensure compliance with SLAs.

Essential Skills

• Excellent English communication skills (verbal & written).
• Strong analytical, problem-solving, and collaboration abilities.
• Proficiency in

  Python, SQL, or Java

  for data manipulation and integration.
• Strong understanding of

  data modeling

  ,

  database design

  , and

  ETL principles

  .
• Hands-on experience with

  SQL/NoSQL databases

  ,

  big data tools

  (Hadoop, Spark, Kafka), and

  cloud platforms

  (AWS, Azure, GCP).
• Expertise in

  SSIS package development

  , optimization, and error handling.

Preferred Skills

• Experience with

  Power BI

  and data visualization.
• Exposure to

  data warehousing

  ,

  Azure Data Factory

  , and

  Databricks

  .
• Understanding of

  data governance

  ,

  privacy compliance

  , and

  machine learning concepts

  .
• Familiarity with

  ERP systems (JDE)

  and

  ServiceNow

  ticketing.

Education

• Bachelor’s degree in

  Information Technology

  ,

  Computer Science

  , or a related field.