BI Data Engineer

Job description

Description

About Us 

Masco Home Products India (MHPI) is a fully owned subsidiary of Masco Corporation, headquartered in Livonia, MI.

The vision of MHPI is to be recognized as a world-class Global Business Services organization driven by the desire for excellence in its people, business solutions, execution, and partnerships with internal customers to develop “Lean and Simple” business solutions.

Headquartered in Livonia, Michigan, Masco Corporation is a global leader in the design, manufacture and distribution of branded home improvement and building products.

Our portfolio of industry-leading brands includes Behr® paint; Delta® and hansgrohe® faucets, bath and shower fixtures; Liberty® branded decorative and functional hardware; and HotSpring® spas.

We leverage our powerful brands across product categories, sales channels and geographies to create value for our customers and shareholders.

For more information about Masco Corporation, visit

Masco Home Products India (MHPI)

Business Unit Supported: MASCO CANADA 
Website: - ;

• Position: BI- Data Engineer
• Location: India (Permanent Remote) 
• Job Type: Permanent 
• Experience required: Minimum of 5 years in data engineering, database design and ETL development
• Assessment Test: (based on role requirement) will be required to take a skill assessment test prior interview.


• Shift: 04:00 pm - 01:00 am IST (min 4.5 hrs EST overlapping) 
• Work hours- total 9 hrs (8.5 hrs working+ 30 minutes break) 
• CTC: As per market standards 
• Notice period: (Immediate joiner preferred) candidate serving notice and left with 30 working days notice period preferred.


• Must have Broadband availability: Min 30 MBPS (national service provider JIO/TATA/Airtel Hathway etc) 
•  Important: Access to a quiet home office environment with above mentioned broadband availability and working space to accommodate two monitors +1 Laptop.

(based on role requirement) 

Job Summary:
• Reports To: Senior Manager, Analytics
the Data Engineer will play a crucial role in the design, development, and maintenance of the organization’s data architecture.

The primary focus will be on constructing, testing, and maintaining scalable data architecture and infrastructure to meet the business’ growing data needs.

The Data Engineer shall also implement methods to improve data quality and reliability while ensuring high levels of availability.

The Data Engineer shall also develop test architectures that enable data extraction and transformation for predictive/prescriptive modelling.

This role requires a strong foundation in data engineering, database management, and proficiency in various programming languages and data technologies.

Primary Responsibilities:
• Collaborate with cross-functional teams to understand data requirements, define data standards, and design efficient data models and architectures.
• Develop and implement strategies for data acquisition, transformation, and storage.
• Evaluate, recommend, and select data warehouse components, including hardware, database management systems, ETL software and data mining tools.
• Coordinate and work with other IT staff to develop database architectures, coding standards and quality assurance policies and procedures.
• Build and optimize large-scale data processing sytems for batch and real-time data pipelines.
• Implement data integration solutions to collect and combine data from various sources.
• Design and manage databases, ensuring performance, security, and scalability.
• Conduct regular database maintenance, backups, and updates.
• Design and implement redundant systems, policies and procedures for disaster recovery and data archiving to ensure availability, protection, and integrity of data assets.
• Develop and maintain ETL (extract, transform, load) processes to ensure smooth flow of data from source to destination.
• Troubleshoot and optimize ETL workflows for efficiency.
• Implement data quality checks and ensure data integrity throughout the data lifecycle.
• Enforce data governance policies and best practices.
• Work closely with data analysts, data governance and other stakeholders to understand their data requirements and provide support.
• Collaborate with IT and business teams to integrate data engineering solutions into existing systems.
• Identify and resolve Performance bottlenecks in data pipelines and databases.
• Optimize queries and processes for improved efficiency.
• Maintain comprehensive documentation for data processes, workflows, and systems.
• Provide training and support to other team members as required.

Essential Skills:

• Excellent English communication skills, both verbal and written.


• Proficient with Microsoft applications and computer skills
• Strong understanding of business processes and data flows.
• Strong interpersonal, communication and collaboration skills.
• Excellent problem solving, troubleshooting and analytical skills.
• Demonstrated successful ability to organize and prioritize work to ensure timely deadlines.
• Thrives in a team-oriented environment while capable of working autonomously.
• Strong attention to detail and ability to navigate ambiguous situations.
• Good time management and ability to manage multiple concurrent projects/tasks within time constraints.

Must Have “Technical” Skills:
• Minimum of 5 years in data engineering, database design and ETL development
• Hands on experience with data architecting, data mining, large scale data modeling and business requirements gathering/analysis.
• Proficiency in programming languages such as Python, Java or SQL.
• Strong knowledge of database management systems (i.e., SQL, NoSQL).


• Familiarity with big data technologies (i.e., Hadoop, Spark, Kafka) and cloud platforms (i.e., AWS, Azure, GCP).
• Understanding of data modeling and design principles.
• Advanced data manipulation skills: read in data, process and clean it, transform and recode it, merge different data sets, reformat data between wide and long, etc.


• Technical expertise in data models, data mining, and segmentation techniques.
• Experience with data processing flowcharting techniques

Preferred Skills: 
• Power BI visualization experience
• Experience with data warehousing solutions.
• Knowledge of data security, compliance and applicable data privacy practices and laws.
• Understanding of machine learning concepts and data analytics.
• Familiarity with ERP systems and integrations (JDE) a plus.
• Experience Power BI a plus.
• Experience with ServiceNow ticketing system a plus.
• Experience in Microsoft platforms, Data Bricks and Azure Data Factor preferred.

Education: 
• Bachelor’s degree in Information Technology, Computer Science, or related field

Disclaimer: 
It has come to our attention that there have recently been some employment scams that have utilized reputable companies’ names, including ours, to solicit personal information as part of a fraudulent hiring scam.

Please note that all of our open positions are posted at or and any role not posted there is not a role we have open.

If you are seeking a position at Masco Home Products Private Limited (MHPI), we recommend that you write to us on if you have any questions about our hiring process, need to verify a Masco Home Products Private Limited (MHPI) job posting or offer or need to speak with a MHPI representative directly.
 
 

Company

Required Skill Profession

Other General