Job Abstract

Category

Information Technology

Position Type

Salaried

Remote

No

Shift Time

40

Location

Montvale

At Benjamin Moore, our brand represents excellence, and we strive to provide a comprehensive total rewards package to match. In addition to competitive base salary, every exempt and non-exempt role in our organization is eligible for a performance-based annual raise and bonus in recognition of their efforts that contribute to the success of our organization. We conduct regular pay audits, using both external market data and internal comparisons to ensure that our employees are compensated fairly and equitably. During our annual compensation review, we implement merit, equity, and promotion increases after a full calibration across all roles. We believe that benefits should connect you to the support you need when it matters most. In addition to our monetary compensation package, Benjamin Moore provides a full range of benefits that are personalized to help support you physically, financially, and emotionally, both through the big milestones and in your everyday life.

At Benjamin Moore, we empower our team members to achieve their goals and make a positive impact in our communities. We offer a rewarding and inspiring work environment that fosters creativity, collaboration, and a strong sense of camaraderie. Our culture of excellence and transparency encourages our colleagues to bring their authentic selves and unique perspectives/ideas every day. With 140 years of rich history behind our brand, we know that our people are the driving force behind our success. We believe in investing in our colleagues by offering work-life balance, competitive/ benefits, ongoing learning/continuing education, and skill development. Through a positive and engaging workplace, we facilitate growth, development, and fulfillment for all.

Join us and be a part of a brand that inspires creativity, innovation, and passion in support of locally-owned stores around the world.

Click here to see how you can paint your future!

The SAP BODS Consultant is responsible for keeping the SAP BODS system running smoothly and building and supporting data integration solutions. They should have experience with SAP HANA modeling, which involves creating and managing data models in SAP HANA using Calculation Views, dimensions, and SQL Scripting.

Install, configure, and maintain SAP BODS servers and repositories

Manage user roles and permissions

Create and manage data sources and targets

Monitor and troubleshoot BODS jobs

Perform backup and recovery of BODS repositories

Implement performance tuning techniques

Deploy code across Dev, QA, and Production environments using central repositories.

Responsible for developing BODS workflows/dataflows/mapping.

Good knowledge of various BODS transformations including DQ-like address cleansing, data cleansing, and Match.

Possess strong knowledge/experience of HANA View Modeling, using calculation views and performance tuning.

Experience with SQL and procedures in Native HANA.

Loading delta records on both source and target level CDC on type 1, type 2, and type 3 SCD.

Must be a resourceful problem solver who possesses creativity in resolving problems

Possess a project-oriented approach to development work

Ability to work independently and drive work to completion

Ability to manage a heavy workload, and achieve results while meeting project deadlines with minimal supervision

Must be able to perform quality testing and beta testing of the applications that are delivered.

Identify, define, and deliver in parallel complex programs and projects/enhancements in a matrix environment.

Translates business goals into appropriate solutions while assessing the feasibility and optimization of the solution.

Work in Planning, Developing, Implementing, and Managing Data Warehouse Project Deliverables, Design Documents, and High-Level Data Mapping for SAP BODS ETL Specifications.

Recognize BODS-related risks/issues that need escalation and arrange for appropriate assistance.

Support Activities

Must be able to analyze and troubleshoot data related issues (joins etc) in a timely manner and best practices of the company

Identify continuous process improvement opportunities and operationalize solutions for same.

Maintain SAP BODS Coding best practices and standards. Ensure that the best practices are enforced and followed during the development process.

Assist business and functional leads with day-to-day development, support, and troubleshooting.

Bachelor's degree in Business (or Management), Computer Science, Engineering, or related discipline, or equivalent work experience is required

At least 5 years of experience in Business Objects Data Services (Admin, workflows. Mapping, dataflows, Data integrator/Data Quality/Platform transformations etc.)

At least 5 years of experience in Data warehousing.

At least 5 years delivering complex data management engagements including all phases of the project life cycle from scoping and planning, requirements gathering, design, development, testing, and go live phases.

Significant amount of experience in SAP HANA Modelling (calculation views)

Strong knowledge of data modeling and star schemas.

Working knowledge and experience with SQL language. 4+ Years.

A good understanding of best practices such as naming conventions in creating BODS jobs.

Experience working with a large data warehouse a plus

Experience in connecting BODS with a REST/SOAP API is a plus.

Experience in extracting semi-structured data like JSON is a plus

Have strong analytical skills and Strong process orientation with significant attention to detail

Effective interpersonal skills with the ability to participate in and lead "Virtual" teams

Compensation Philosophy

At Benjamin Moore, our brand represents excellence, and we strive to provide a comprehensive total rewards package to match. In addition to competitive base salary, every exempt and non-exempt role in our organization is eligible for a performance-based annual raise and bonus in recognition of their efforts that contribute to the success of our organization. We conduct regular pay audits, using both external market data and internal comparisons to ensure that our employees are compensated fairly and equitably. During our annual compensation review, we implement merit, equity, and promotion increases after a full calibration across all roles. We believe that benefits should connect you to the support you need when it matters most. In addition to our monetary compensation package, Benjamin Moore provides a full range of benefits that are personalized to help support you physically, financially, and emotionally, both through the big milestones and in your everyday life.

Diversity, Equity & Inclusion

At Benjamin Moore, we believe diversity of culture, talent, and varying perspectives is key to a collaborative, innovative, and successful business. We are committed to driving change within our organization through purposeful Diversity, Equity & Inclusion (DE&I) efforts, while also focusing on our customers and communities in which we serve. Our DE&I efforts allow each of us to authentically live our corporate values of Openness, Integrity, Community, Excellence and Safety. Our Social Impact programming of strategic local and national partnerships, in-kind donations, volunteerism, and more expands our ability to make a difference in the lives of all of our stakeholders. We hope you will join us and become an advocate for diversity and inclusion here at Benjamin Moore.

At Benjamin Moore & Co, we don’t just accept difference — we celebrate it, we support it, and we thrive because it benefits our employees, our products, and our community. We are an equal opportunity employer and value diversity. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status. Benjamin Moore is proud to be an equal opportunity employer.

Student Loan Repayment Assistance Program

Benjamin Moore provides Student Loan Repayment Assistance Program to support eligible active employees who graduated from an accredited post-secondary educational institution. The Repayment Program is intended to contribute to reducing employee’s student loans. The Company follows all rules and regulations concerning the taxability of student loan repayments provided under applicable law.

EOE

Benjamin Moore & Co. is an equal-opportunity employer that is committed to a culture of inclusion and diversity. We do not discriminate on the basis of race, religion, color, sex, gender identity, sexual orientation, age, disability, national origin, veteran status, or any other basis covered by appropriate law. Our commitment to these principles means all employment decisions are made based on qualifications, merit, and business need.