ERP Business Analyst

Applied Concepts, Inc. – Richardson, Texas ERP Business Analyst – Job Overview The ERP Business Analyst (ERP BA) is a strategically embedded technology role at Applied Concepts, Inc., responsible for partnering directly with process owners across all departments to design, build, and maintain tailored reporting solutions and interactive analytics dashboards. Rather than serving as a generalist IT resource, this role operates as a dedicated analytics partner - working one-on-one with department leaders to understand their operational workflows, define meaningful metrics, and deliver self‑service tools that surface actionable intelligence at a glance. The IT ERP BA will own the full lifecycle of reporting and dashboard development: from stakeholder discovery and requirements gathering through data modeling, visualization design, drill‑down functionality build‑out, and ongoing iteration based on user feedback. The goal is to eliminate reliance on static, one‑size‑fits‑all reports and replace them with dynamic, role‑specific dashboards that empower each process owner to monitor performance, spot trends, and make informed decisions without requiring IT intervention for every data pull. What You’ll Gain Competitive compensation and benefits Rewards and recognition programs Immersive learning and development opportunities Convenient office location Flexible vacation policy Excellent work/life balance Great culture and collaborative environment The compensation for this position is a combination of salary, medical, dental, and life insurance benefits along with a generous amount of paid time off. The annual salary for this role is $75,000-$108,000, based on skills and experience. Core Focus: Process Owner Partnership This role’s primary value is its direct, sustained engagement with each department’s process owner. The IT PBA will not wait for ticket submissions – they will proactively schedule working sessions with owners, embed in their workflows, and continuously refine reporting outputs to match evolving business needs. Process Owner Engagement Model Conduct structured discovery sessions with each process owner to document current reporting pain points, manual workarounds, and desired metrics. Translate operational language into data requirements, mapping business questions to available data sources and fields. Present iterative prototypes to process owners before finalizing any report or dashboard, ensuring outputs match real‑world decision‑making needs. Schedule recurring check‑ins (monthly or quarterly) with each process owner to review dashboard relevance, add new metrics, and retire obsolete views. Document all requirements, data definitions, and metric logic in a shared reporting catalog accessible to all stakeholders. Serve as the single point of contact between process owners and IT/data infrastructure teams for all analytics and reporting requests. Dashboard & Analytics Development A defining deliverable of this role is the creation and ongoing stewardship of a cross‑departmental analytics dashboard ecosystem. Each process owner will have a purpose‑built dashboard designed around their specific KPIs, with drill‑down capability to move from high‑level summaries into the granular transaction‑level data behind every metric. Critically, dashboards across all departments will share a common library of standardized widgets – ensuring that when data is presented in business decision‑making contexts, it is drawn from consistent definitions, calculations, and visual formats regardless of which department’s view is being referenced. Dashboard Architecture & Design Standards Design executive‑summary landing views for each department showing 5–8 core KPIs as graphical elements (trend lines, gauge charts, bar comparisons, heatmaps). Build and maintain a shared widget library – a centralized repository of standardized chart components, KPI cards, and data elements that are reused across departmental dashboards. Shared widgets enforce consistent metric definitions, calculation logic, and visual formatting, so that figures such as revenue, units processed, cycle time, or headcount mean the same thing and look the same whether viewed in Operations, Customer Service, or Finance. Establish cross‑departmental data standards for all common metrics – defining agreed‑upon formulas, data sources, and refresh cadences – so that any shared widget displays a single, authoritative version of the truth when used across multiple department dashboards. Implement multi‑level drill‑down paths so process owners can click from a summary metric directly into the underlying data – by time period, product, technician, customer, or any other relevant dimension. Apply consistent visual design standards across all dashboards (color coding, layout, iconography) to reduce cognitive load when moving between departmental views. Build role‑based access controls so each process owner sees only their department’s data by default, with cross‑functional views available to senior leadership. Ensure all dashboards refresh automatically on a defined schedule, eliminating manual data pulls and stale reporting. Drill‑Down & Self‑Service Capability Build drill‑down hierarchies that allow process owners to navigate from macro (department‑level) → mid‑level (team, product, region) → transaction‑level (individual records, timestamps, root causes) within a single dashboard interface. Implement filtering and slicing controls (date range, employee, product family, order type) so process owners can answer ad hoc questions without submitting IT requests. Provide export capability from any drill‑down view (PDF, Excel) for use in meetings, audits, and board reporting. Configure automated alerts and threshold notifications so process owners are proactively informed when a KPI breaches a defined limit. Train each process owner and their designated backup on self‑service navigation, filtering, and export functions. Tools & Technology Primary dashboard platforms: RoverBI/Informer5, custom‑built dashboards, or equivalent – selected based on data source compatibility and user accessibility. Data sourcing: Custom‑built ERP (order/production data) and CRM, with the possibility to expand to further data sources in the future. Additional Key Responsibilities – Software & Systems Development Develop and maintain custom reports, scripts, and data pipelines supporting reporting infrastructure and process automation. Build and manage database queries and data models that serve as the foundation for all reporting outputs. Troubleshoot data discrepancies identified by process owners and trace issues back to source systems for resolution. Document all data models, ETL logic, metric definitions, and system configurations. Communication & Change Management Present new dashboard capabilities to process owners and their teams with hands‑on training tailored to each department’s technical comfort level. Develop quick‑reference user guides and short video walkthroughs for self‑service dashboard navigation. Communicate project status, timelines, and any data limitations transparently to all stakeholders. Champion a data‑driven culture by actively promoting dashboard adoption and demonstrating ROI of analytics initiatives to leadership. What You Need to Succeed – Required Bachelor’s degree in Data Science, Statistics, Business Analytics, Information Systems, or a related analytics‑focused field. 3–5 years of experience in a data analytics, business intelligence, or reporting‑focused role, preferably within a corporate BI team environment where delivering stakeholder‑facing dashboards and self‑service reporting tools was a primary responsibility. Demonstrated experience building dashboards with drill‑down functionality in RoverBI/Informer5, Power BI, Tableau, or a comparable platform. Experience conducting requirements‑gathering sessions with non‑technical stakeholders and translating outputs into technical specifications. Strong data visualization skills with an understanding of chart selection, layout hierarchy, and user experience for operational dashboards. Excellent written and verbal communication; able to present technical concepts clearly to department managers and executives. High degree of initiative – comfortable proactively engaging process owners without waiting for formal requests. We will be particularly interested if you have Experience with MultiValue systems (UniVerse, UniData, D3, JBase) and understanding of manufacturing/service data structures. Familiarity with RoverBI/Informer5 reporting platform. Experience in a manufacturing, defense technology, or electronics environment. Familiarity with Smartsheet, ClickUp, Monday.com, or similar work‑management platforms used for operational tracking. Knowledge of REST API integrations for pulling data into reporting layers. Core Competencies – Analytics & Technical Dashboard design & drill‑down architecture Data modeling & query development RoverBI/Informer5 & BI platform proficiency KPI definition & metric logic Visualization best practices Process owner engagement Requirements elicitation Stakeholder communication Training & change management Cross‑functional collaboration Work Environment Office environment with regular interaction across production floor, quality, and service departments. Prolonged computer work; extended hours may occur during dashboard launches or system deployments. Regular scheduled meetings with process owners across all departments; strong time management required. Equal Employment Opportunity Applied Concepts, Inc. is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, or any other characteristic protected by law. #J-18808-Ljbffr Applied Concepts, Inc.