Senior Business Intelligence Engineer

Job Title: Senior Business Intelligence Engineer

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

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

Employment Type: Full-Time, Salary

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.