Business Analyst - Product Support (Oracle OTBI)

Description BUILT TO CONNECT Astec is a global, manufacturing company of infrastructure development equipment. Our products range from asphalt and concrete plants, aggregate crushers and handlers, industrial heaters and more. Connection is at the heart of everything we do. We design and manufacture products used to build the infrastructure that physically connects the world, but the connections we make with people are what drive us forward. We were founded on innovation and a passion to help our customers succeed. Leveraging innovative solutions and technologies, we serve customers all over the world. We are committed to design and build the most innovative products. LOCATION: ABOUT THE POSITION: The Product Support Business Intelligence Analyst is part of the Customer Support Analytics team. Reporting to the Manager of Product Support Development and Analytics, this position will be responsible to design and deliver database, reporting and dashboard solutions that meet the needs of the organization. This position also requires an understanding of Product Support concepts and approaches, to ensure analysis supports the objectives of a Product Support strategy. Responsibilities will include being able to handle multiple and changing priorities and be able to successfully collaborate with business users, development teams, technology groups, consultants, and key stakeholders. Deliverables & Responsibilities Implement and optimize business intelligence solutions using Oracle OTBI, BI Publisher and SQL Server, focused on CX, CPQ and other related Fusion modules Develop, implement, and optimize table schema, views, stored procedures, and functions using T-SQL. Develop, implement, and optimize reporting , including visualizations in Power BI Reports and Dashboards Perform analysis, design, development, validation, and implementation of reports and visualizations. Ability to analyze data issues within reports. Analyze existing SQL queries for performance improvements. Participate and engage in all phases of solution delivery (requirements gathering, solution analysis, design and implementation, solution unit testing and documentation, user acceptance testing support, solution deployment Provide timely scheduled management reporting Follow and enhance BI standards and best practices across the team Collaborate with team members on methodology, design, and architecture Identify research questions, problem solve using data analysis, and communicate the results to various stakeholders Review and interpret ongoing data and business reporting requirements Build appropriate and useful reporting deliverables Engage with third party vendors to support various development projects To be successful in this role, your experience and competencies are: Bachelor's degree in the field of computer science, finance, accounting, or related degree 4 years' experience working with data warehouses is preferred. Experience with BI development, testing and change management. Strong understanding of SQL Server, T-SQL, and stored procedures. Knowledge of Oracle and related reporting. Experience with Oracle OTBI is highly preferred. Hands-on database tuning and troubleshooting experience. Good understanding of the organization's goals and objectives. Involvement in inter-departmental projects and experience communicating with various stakeholders. Keen attention to testing and quality. Familiarity with source code repository management (such as Git). Good written and oral communication skills. Strong technical documentation skills. Good interpersonal skills. Ability to conduct research into data management issues, practices, and products as required. Ability to present ideas in a user-friendly language. Highly self-motivated and directed with keen attention to detail. Proven analytical and problem-solving abilities. Ability to effectively prioritize and execute tasks in a highly visible technical environment. Adaptable and eager to learn new technologies (Azure, PowerBI and Power Apps) Strong customer service orientation. Experience working in a team-oriented, collaborative environment Work as a member of a dynamic high visibility team Work as a member of a remote team, connected via Microsoft Teams Support corporate management reporting for a global user base