Data Engineer

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. Masco Corporation is a global leader in the design, manufacture and distribution of branded home improvement and building products. Our products enhance the way consumers all over the world experience and enjoy their living spaces. Our portfolio of industry-leading brands includes Behr paint; Delta and Hansgrohe faucets, bath, and shower fixtures; HotSpring spas, to name a few. We have over 18,000 employees across the globe with 28 manufacturing facilities in North America and 10 globally.
Business Unit Supported: BrassCraft
Website: -https://www.brasscraft.com/

Position: Data Engineer

Location: India (Permanent Remote)

Job Type: Permanent

Experience required: Minimum 5 years of experience in Data and Analytics/Business Intelligence Architecture synapse

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+ Half an hour meal break)

CTC: As per market standards

Notice period: (Immediate joiner preferred) candidate serving notice 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:

As a member of the Data Analytics Center of Excellence (COE), the Data Engineer will play a crucial role in the design, development, and maintenance of the organization s data and data pipeline architecture. Their 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 ensure consistent delivery, integrity, quality and reliability of
data in defining a single source of truth to support BrassCraft s strategic analytics and reporting
goals. This role will design, create, and maintain optimized systems for collecting, moving, storing, and organizing data at scale from various systems into structures that meet the requirements for building analytics solutions . A strong foundation in data engineering, database management, and proficiency in various programming languages and data technologies is required.
Primary Duties and 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, integration and coding standards as well as quality assurance policies and procedures.

Build, implement and optimize large-scale data processing systems for batch and real-time data pipelines.

Define and build a data semantic layer and present to Data Analysts and subject matter experts in the business.

Design, manage and maintain databases, ensuring performance, security, and scalability.

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 and efficient flow of data from source to destination.

Implement data quality checks and ensure data integrity throughout the data lifecycle.

Maintain comprehensive documentation for data processes, workflows, and systems.

Provide training and support to other team members as required.

Performs other related duties as needed and assigned.
Must have key skills:

Excellent English communication skills, both verbal and written.

Ability to use a computer for 8.5 hours per day.

Familiar with Microsoft applications Microsoft Word, Excel, and Outlook and computer skills
Minimum of 5 years in data engineering, data analytics, database design and ETL development.
Experience with data warehousing solutions such as Azure Synapse.

Hands on experience with data architecting, data mining, large scale data modeling and business requirements gathering/analysis.

Proficiency in programming/scripting languages such as Python, Java, PowerShell or C#.

Experience with data integration, orchestration, workflow and data management tools such as Azure Data Factory and Data Bricks .

Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.

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 modeling and design principles, data mining and segmentation techniques.

Strong understanding of business processes and data flows.

Strong interpersonal and collaboration skills.

Excellent problem solving, troubleshooting and analytical skills.

Demonstrated successful ability to organize and prioritize work to ensure timely deadlines.
Must work independently and with minimal technical direction, as well as within a team environment. Project leading experience required.

Strong attention to detail and ability to navigate ambiguous situations.
Preferred Key Skills:

Knowledge of data security, compliance and applicable data privacy practices and laws.

Understanding of machine learning concepts.

Familiarity with ERP systems and integrations (JDE) a plus.

Experience data analytics tools - Stratum and Power BI a plus.

Experience with ServiceNow ticketing system a plus.

Experience with agile methodology and Azure DevOps preferred.
Education:
Bachelor s degree in Information Technology, Computer Science, or related field.

Masco Home Products India (the Company ) is an equal opportunity employer and we want to have the best available persons in every job. The Company makes employment decisions only based on merit. It is the Company s policy to prohibit discrimination in any employment opportunity (including but not limited to recruitment, employment, promotion, salary increases, benefits, termination and all other terms and conditions of employment) based on race, color, sex, sexual orientation, gender, gender identity, gender expression, genetic information, pregnancy, religious creed, national origin, ancestry, age, physical/mental disability, medical condition, marital/domestic partner status, military and veteran status, height, weight or any other such characteristic protected by federal, state or local law. The Company is committed to complying with all applicable laws providing equal employment opportunities. This commitment applies to all persons involved in the operations of the Company regardless of where the employee is located and prohibits unlawful discrimination by any employee of the Company.

Masco Corporation is an E-Verify employer. E-Verify is an Internet based system operated by the Department of Homeland Security (DHS) in partnership with the Social Security Administration (SSA) that allows participating employers to electronically verify the employment eligibility of their newly hired employees in the United States. Please click on the following links for more information.

E-Verify Participation Poster: English Spanish
E-verify Right to Work Poster: English , Spanish