SAC Lead Data Engineer

At GAF, we cover more than buildings. We cover each other. No matter what role, tenure, or track, under this roof you are empowered to be there for your teammates, your customers, and especially your community. Under this roof, we don’t back down from hard work– we support one another in pursuit of something bigger. We define the future while leading the present. And under this roof, we own our opportunities. Becoming the market leader only happens when everyone feels they have the opportunity, and the support, to thrive. We are GAF. And under this roof, we protect what matters most.

GAF is seeking a SAC Lead Data Engineer to join our IT team, serving as the primary technical authority for our SAP Analytics Cloud environment. In this role, you will be responsible for eliciting complex business needs from FP&A and Group Consolidation stakeholders and translating them into a robust, sustainable technical architecture. Your core responsibilities include designing end-to-end planning models, configuring secure data integration via SAP Cloud Connector and SAML 2.0 SSO, and engineering sophisticated logic through JavaScript scripting and Advanced Formulas (Data Actions) for financial allocations. You will lead the technical lifecycle of the solution—from detailed data wrangling and Import Job orchestration to the implementation of Row-Level Security (DAC) and Role-Based Access Control—ensuring that GAF's consolidation functions are supported by a high-performance, secure, and perfectly documented analytics ecosystem.
Essential Duties

• SAC Advanced Data Modeling & Prep: Architect and maintain complex Analytical and Planning models; perform technical Data Wrangling, mapping, and transformation for seamless integration of diverse data sources.

• Planning & Input Management: Design and deploy high-performance Input Forms for business users, utilizing Data Locking, Planning Calendars, and Private/Public Version management to control the budgeting lifecycle.

• Calculations & Advanced Formulas: Engineer sophisticated KPIs using Calculated Measures and create complex, script-based Data Actions (Advanced Formulas) to automate allocations, currency translations, and inter-company eliminations.

• Custom Scripting & Application Design: Develop highly interactive, custom-coded applications within the SAC Analytics Designer using JavaScript for event-based logic and dynamic user experiences.

• Data Integration & Connection Admin: Establish and monitor technical connections (Live and Import) via SAP Cloud Connector and CORS; manage the scheduling, monitoring, and troubleshooting of recurring Data Import Jobs.

• Security & Data Governance: Implement robust security frameworks using SAML 2.0 SSO, Role-Based Access Control (RBAC), and Data Access Control (DAC) to ensure row-level security and regulatory compliance.

• Story & Dashboard Architecture: Build executive-level Stories and Dashboards using Optimized View Mode, ensuring consistent UI/UX through corporate theming and advanced visualization components.

• System Optimization & DevOps: Monitor system health using Performance Traces and Audit Logs; lead the technical "promotion" of content from Dev to Production via the Content Network.

• Solve complex business problems utilizing business process redesign and cloud computing technologies.

• Develop new standard operating procedures documentation aligned with business requirements.

• Develop and maintain efficient Finance, P&L, balance sheet, and workforce planning models along with reporting to support GAF’s business planning process

• Prepare and present findings, recommendations, new operating models, and new workflows in consultation with the business team.

• Create methodology to measure process performance against established metrics

• Responsible for completing assignments with the ability to work on 1-3 projects

• Translate business needs into documented artifacts. Collaborate with business users to analyze processes and systems, identifying and defining beneficial system changes to enhance efficiency and performance.

• Develop and execute testing scenarios and plans, supporting teams through the testing phase.

• Partner with project teams and business users during planning, delivery reviews, and UAT to confirm software meets requirements.

Qualifications Required

• Bachelor’s Degree Computer Science, Finance, Information Systems, or related majors required

• 8+ years of IT experience; preferably in a manufacturing organization.

• 3+ year experience with FP&A /Group Consolidation domain experience

• 2+ year experience with SAP Analytical Cloud for Planning

• 2+ SAC architecture experience

• 2+ SAC reporting experience

Qualifications Preferred

• Experience with implementation and transformation projects using cube technology, such as SAC Planning, Anaplan, Hyperion, OneStream, etc.

• Experience with the Finance process in SAP.

• Strong implementation and support experience with SAC Planning and data integration needs from SAP and other sources.

• Design and develop integrated business solutions that interact between multiple enterprise platforms and applications, both on-premises, CSP’s and SaaS providers.

• General knowledge of Agile and SDLC software development practices and technical documentation (requirements, functional specifications, test plans, etc.)

• Strong strategic business acumen and understanding of organizational strategy and the ability to design IT systems to deliver that strategy.

• Strong ability to define multiple solution options to business problems.

• Excellent conceptual and analytical abilities.

• Proficient verbal and written communication.

• Adept at managing multiple concurrent projects.

• Capable of balancing both long-term ("big picture") and short-term situational perspectives.

• Champion change and innovation.

Base salary and/or rate of pay ranges listed are exclusive of fringe benefits and potential bonuses. Individual compensation offers will be determined based on a variety of factors, including but not limited to geographic location, relevant candidate experience and skill, education, and/or qualifications.

Base Salary Range: $132,000-$181,500

How We Protect What Matters Most:

1. We offer a wide range of health insurance options that include medical, dental, and vision for you and your family. 2. Our Family-Building benefits support the many different journeys to fertility and parenthood. 3. Our robust 401K plan includes an employer match contribution with your pre-tax and/or Roth contributions. 4. Other exciting programs and perks are available to help employees achieve work-life balance, including (but not limited to) a wellness program, free financial coaching, a referral program, and product rebates when purchased for an employee’s primary residence. 5. Professional growth and development are very important to us! We offer internal training programs and courses, as well as a generous tuition reimbursement program. 6. We're committed to fostering a culture that reflects our values to connect, empower, evolve, and inspire. We offer many opportunities for employees to connect with one another, including through our Employee Resource Groups who focus on education and allyship for all of our employees.

GAF complies with federal, state, and local disability laws and makes reasonable accommodations for applicants and employees with disabilities. If a reasonable accommodation is needed to participate in the job application or interview process, to perform essential job functions, and/or to receive other benefits and privileges of employment, please contact HR Services at 833-HR-XPERT.

We believe our employees are our greatest resource. We offer competitive salary, benefits, 401k, and vacation packages for all full time permanent positions. We are proud to be an equal opportunity workplace. We are committed to equal employment opportunity on the basis of each candidate's qualifications, experience, and merit, without regard to race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity, or Veteran status. If you have a disability or special need that requires accommodation, please let us know. If applying for positions in the U.S., must be eligible to work in the U.S. without need for employer sponsored visa (work permit).