Senior Business Intelligence Engineer

Woodgrain; Lawrenceville (GA); Hybrid; USD 100,000 - 135,000; Full time

Benefits offered by this job

Health Insurance

401(k) with employer match

Paid Holidays

PTO accrual

Long-term disability

Employee Assistance Program

Job summary

Woodgrain is seeking a Senior SAP Business Intelligence Engineer to design, develop, and optimize SAP BW/BW4HANA and SAP BusinessObjects solutions. You will work on data modeling, extraction, and reporting, collaborating with IT and business stakeholders to deliver reliable BI services.

The role requires strong SAP BW/BW4HANA and S/4HANA integration experience, plus excellent communication skills. Hybrid work is offered with in-office and remote days to support project delivery.

Qualifications

• Bachelor's degree or equivalent in a related field.
• 7+ years in SAP BW/BW4HANA, SAP BO, and S/4HANA integration.
• Ability to design and deliver complex SAP BI solutions and troubleshoot issues.
• Strong data modeling, extraction, transformation, and reporting skills.
• Excellent English communication and collaboration across teams.

Responsibilities

• Design, develop, maintain, and optimize SAP BW/BW4HANA data models and reports.
• Develop and support SAP BusinessObjects reporting, including universes and WebI.
• Integrate BW with SAP S/4HANA using ODP, CDS, and data replication techniques.
• Translate business requirements into technical specifications and scalable solutions.
• Lead troubleshooting, performance tuning, and production support activities.
• Establish standards, documentation, and testing procedures for reliability.

Skills

SAP BW/BW4HANA

SAP BusinessObjects

S/4HANA integration

Data modeling

ABAP basics

HANA SQL & Calculation Views

BW/BI performance tuning

Analytics reporting

English communication

Education

Bachelor's degree in Computer Science / IT / Business or related field

Tools

SAP BW

SAP BO

ODP / CDS Views

Lumira / SAC (preferred)

Job description

Job Title: Senior Business Intelligence Engineer

Location(s): St. Louis, Missouri | Meridian, Idaho | Lawrenceville, GA

Starting Salary: $100,000 - $135,000 (depending on experience)

Work Environment: Hybrid (4 days in-office, 1 day remote)

Summary of Company Benefits:

• Health, Dental, and Vision Insurance
• Health Savings Account (HSA)
• Flexible Spending Account (FSA)
• 401(k) with an Employer Match
• Group Term Life Insurance and AD&D
• Employer Paid Long-Term & Short-Term Disability
• Voluntary Supplemental Hospital and Accident Plans
• Employee Assistance Program
• 8 Company Paid Holidays & 1 Floating Holiday
• Progressive Paid Time Off (PTO) Accruals
• Annual Salary Incentive Bonus

About Woodgrain:

Woodgrain is one of the top millwork operations in the world, with locations throughout the United States and Chile. With 70 years of quality manufacturing craftsmanship and service, Woodgrain is a top producer of mouldings, doors, and windows, as well as a premier distributor of specialty building products. Woodgrain Inc. is headquartered in Fruitland, Idaho with six divisions and over 45 manufacturing and warehouse facilities in the United States and South America. Since 1954, Woodgrain is proud to be family owned and operated.

Job Summary:

The Senior SAP Business Intelligence Engineer is responsible for designing, developing, optimizing, and supporting SAP Business Warehouse (BW/BW4HANA) and BusinessObjects (BOBJ) solutions, including data modeling, extraction, integration, and reporting. This role provides senior-level technical expertise in SAP S/4HANA integration, data architecture, and business intelligence delivery to ensure reliable, scalable, and accurate reporting capabilities. Working collaboratively with business stakeholders and IT teams, this position translates complex business requirements into technical solutions, leads complex troubleshooting efforts, establishes development standards, and identifies opportunities to improve data quality, system performance, and operational efficiency.

Duties & Responsibilities:

• Design, develop, maintain, and optimize SAP BW 7.x/BW4HANA solutions, including InfoProviders (DSOs, InfoCubes, CompositeProviders), transformations, DTPs, process chains, Open Hub destinations, and BEx Queries.
• Develop and support SAP BusinessObjects solutions, including IDT universes, WebI reports, CMC administration, and report scheduling, ensuring accurate, reliable, and efficient reporting.
• Design and maintain SAP BW integrations with SAP S/4HANA, including ODP, CDS View extraction, source system connectivity, RFC configuration, DataSource replication, delta load management, and ODQMON monitoring.
• Apply knowledge of the S/4HANA data model, including ACDOCA and the Universal Journal, to support financial and operational reporting requirements.
• Translate complex business requirements into technical specifications, data models, and scalable solutions aligned with business objectives and enterprise data architecture.
• Lead technical analysis, performance optimization, and root cause resolution for complex data extraction, transformation, integration, reporting, and production support issues.
• Manage assigned solutions throughout the development lifecycle, including design, development, testing, deployment, documentation, and ongoing maintenance.
• Establish and promote technical standards, documentation practices, data quality controls, and testing procedures to improve system reliability, maintainability, and operational efficiency.
• Collaborate with business stakeholders and cross-functional IT teams, including Security and Basis, to deliver reporting solutions, resolve technical dependencies, and support appropriate user access.
• Identify opportunities to automate processes, improve data integrity, and enhance existing systems; evaluate emerging SAP analytics technologies and recommend improvements as appropriate.

Requirements:

• Bachelor's degree in Computer Science, Information Technology, Business, or a related field; equivalent relevant education, training, and experience may be considered.
• At least 7 years of relevant professional experience in SAP BW, business intelligence engineering, data integration, or a related technical role.
• Demonstrated hands-on experience with SAP BW 7.x and/or BW4HANA, SAP BusinessObjects, and SAP S/4HANA integration.
• Proven ability to independently design and deliver complex technical solutions, troubleshoot system issues, and support enterprise reporting environments.
• Preferred Technical Skills:
• SAP BW statistics and usage monitoring, including 0TCT_C21.
• SLT real-time replication and SAP S/4HANA Embedded Analytics.
• Analysis for Office (AfO), SAC Add-in for Excel, Crystal Reports, and/or Lumira Designer.
• Basic ABAP reading and debugging skills.
• SAP HANA SQL and Calculation Views.
• SAP Datasphere, including data modeling, replication flows, and connections.
• SAP Analytics Cloud (SAC), including story development and live connections to SAP BW and/or S/4HANA.

Additional Skills:

• Strong technical expertise in SAP BW/BW4HANA data modeling, extraction, transformations, process chains, and BEx Query development.
• Strong SAP BusinessObjects experience, including IDT universe design, WebI reporting, CMC administration, and scheduling.
• Hands-on knowledge of SAP S/4HANA integration from a BW perspective, including ODP, CDS Views, ODQMON, ACDOCA, and the Universal Journal.
• Experience with BW source system configuration, RFC connectivity, DataSource replication, and delta load management.
• Strong analytical, troubleshooting, root cause analysis, and performance optimization skills, with the ability to translate complex business needs into effective technical solutions.
• Demonstrated technical ownership, sound judgment, attention to detail, and commitment to data quality, documentation, and continuous improvement.
• Strong communication and collaboration skills, with the ability to work effectively with business stakeholders and geographically dispersed technical teams.
• Ability to manage multiple priorities and deliver reliable solutions in a fast-paced environment.
• Ability to effectively communicate in English, both verbally and in writing. Additional languages preferred.

Physical Demands:

The physical demands and work environment for this role align with those of a standard office setting. While performing job duties, the employee may occasionally need to stand, walk, sit, use hands for handling objects, tools, or controls, reach with hands and arms, climb stairs, balance, stoop, kneel, crouch, or crawl, as well as talk and hear. This role may occasionally require lifting or moving up to 25 pounds.

Travel:

This position does not require travel to other Woodgrain locations.