Business Intelligence (BI) & Report Analyst

From $80,000+ per year. Open to hybrid work. Requires domestic travel up to 25% of the time.

Supports 24/7 business operations as occasionally needed.

CK Power is a family-owned business that has been providing off-highway power solutions for 90 years. At CK Power, we have the well-deserved reputation for engineering and building products that simply can’t be made by the competition. We provide custom diesel power units and generators to a diverse group of industries that power the background of everyday life. To learn more, please visit us at www.ckpower.com.

CK Power is looking for a Business Intelligence and Report Analyst at our St. Louis, MO location. You’ll be responsible for the design, development, and maintenance of business reporting solutions to support CK Power Family of Companies’ operational and strategic objectives, to support a conversion to Oracle Cloud Fusion ERP and the development of data reporting approach.

This role develops and maintains reports, dashboards, and data models using Crystal Reports, Power BI, SQL, and Oracle Cloud Fusion. The position ensures data accuracy, supports business decision-making, and promotes consistent information delivery across departments

What You’ll Do:

Report Development

• Design, develop, and maintain operational and financial reports using SAP Crystal Reports and Microsoft Power BI.
• Develop and manage interactive dashboards and visualizations for various business units.
• Translate business requirements into technical report specifications.

Data Management

• Create and optimize SQL queries, stored procedures, and data models for reporting purposes.
• Integrate and extract data from Oracle Cloud Fusion Analytics, ensuring data accuracy and reliability.
• Maintain documentation for data sources, structures, and relationships across multiple systems.

Business Analysis and Support

• Collaborate with stakeholders to gather, clarify, and document reporting requirements.
• Analyze data trends to identify opportunities for process improvement and cost reduction.
• Provide user support, troubleshooting, and training related to reporting tools and dashboards.

System Integration and Optimization

• Work with IT and application teams to maintain data connectivity between Oracle Fusion and other internal systems.
• Ensure performance optimization and security standards for all reporting environments.
• Participate in the design and implementation of data warehouse or business intelligence initiatives.

Governance and Documentation

• Maintain a comprehensive inventory of reports and dashboards.
• Document data definitions, reporting logic, and process workflows.
• Ensure compliance with data governance and company information management standards.

What You’ll Need:

People Skills

• Experience collaborating with business stakeholders to understand their functional requirements and translate them into technical specifications.
• Passion for customer service, with a strong customer focus, and excellent problem-solving and analytical skills.
• Excellent communication skills. You can clearly explain complex technical concepts.
• You can apply creative use of industry-standard tools to aid in the diagnostic process.
• Ability to learn and extend your capabilities with self-based training.
• Desire to seek innovative ways to improve the process of delivering solutions to customers.

Technical Experience

• Strong working knowledge of SQL (queries, stored procedures, joins, indexing, and performance tuning).
• Experience with Crystal Reports
• Well-developed implementation and troubleshooting skills with the ability to analyze details and synthesize "the big picture.”
• Ability to relate the product functionality to business processes and thus offer implementation advice to customers on how to meet their various business scenarios.
• Should have the ability to read and decipher software Log and Trace files, as well as the ability to act upon the finding to determine a problem resolution.
• Should be able to understand business process flow and perform functional testing as per business requirement with appropriate test scripts.
• Knowledge of external data integration services to load data into Oracle Fusion Applications from external sources, such as legacy systems and third-party applications.
• Knowledge of localizations.

What Helps:

• Associate’s degree or higher preferred.
• Experience with Global Shop.
• Experience with Oracle ERP Cloud (Fusion) data structures (Financials, Procurement, or Operations modules).
• Experience with Power BI (DAX, Power Query, and data modeling).
• Experience with Data extraction and ERP systems Oracle Cloud Fusion, OTBI, or BI Publisher.
• Familiarity with Azure Data Gateway, SSRS, or other BI tools.
• Experience integrating data from multiple systems into a single reporting platform.
• Knowledge of ETL processes, data governance, and metadata management.
• Prior experience in a diesel services, equipment, or industrial operations environment.
• OIC,OCI, Test Scripts, Month End Period Close, ETL and Data Migration Experience with SQL Server, Cost Accounting, MRP, XML, Java, J2EE and Oracle ADF, PL/SQL, Forms, Reports, Scripts, Discoverer, Workflow, BI Publisher / OTBI Reports, Java / JSP, Web ADI, OAF, ADF, PaaS Integrations, OIC, SOAP, Web Services, Javascript, jQuery, KnockoutJS, NodeJS, HTML, CSS, python, HCM Extract, HDL File Transfers, OSI Model

The above list is non-exhaustive. Other essential job functions may exist that are not listed here.

Competitive pay and benefits!

Ask about our sign-on bonus!

Equal Opportunity Employer including veterans and persons with disabilities.

Job Type: Full-time

Pay: From $80,000.00 per year

Benefits:

• 401(k)
• 401(k) matching
• AD&D insurance
• Dental insurance
• Disability insurance
• Flexible spending account
• Health insurance
• Health savings account
• Life insurance
• Paid holidays
• Paid sick time
• Paid time off
• Retirement plan
• Vision insurance

Work Location: In person