Astec Industries
Business Analyst - Product Support (Oracle OTBI)
Astec Industries, Chattanooga, Tennessee, United States, 37450
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 modulesDevelop, 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 DashboardsPerform 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 deploymentProvide timely scheduled management reportingFollow and enhance BI standards and best practices across the teamCollaborate with team members on methodology, design, and architectureIdentify research questions, problem solve using data analysis, and communicate the results to various stakeholdersReview and interpret ongoing data and business reporting requirementsBuild appropriate and useful reporting deliverablesEngage 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 degree4+ 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 environmentWork as a member of a dynamic high visibility teamWork as a member of a remote team, connected via Microsoft TeamsSupport corporate management reporting for a global user base
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 modulesDevelop, 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 DashboardsPerform 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 deploymentProvide timely scheduled management reportingFollow and enhance BI standards and best practices across the teamCollaborate with team members on methodology, design, and architectureIdentify research questions, problem solve using data analysis, and communicate the results to various stakeholdersReview and interpret ongoing data and business reporting requirementsBuild appropriate and useful reporting deliverablesEngage 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 degree4+ 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 environmentWork as a member of a dynamic high visibility teamWork as a member of a remote team, connected via Microsoft TeamsSupport corporate management reporting for a global user base