Business Intelligence Developer & ERP Administrator

Business Developer

At AST, we enhance the efficiency, productivity, and safety of flexible aseptic manufacturing processes for the worldwide Life Science Industry by offering innovative products, services, and solutions. Do you want to contribute to a shared vision and mission? Would you like to bring your unique talents to have a significant impact with a growing company? At AST we strive to build a workplace that enables every team member to meet and exceed their capabilities. We set our expectations high and provide the environment and resources necessary to bring out the very best. Competitive compensation for onsite WA applicants is $110,000-$145,000. All applicants are welcome to apply. Remote work may be considered for highly qualified candidates residing outside of Washington State. Employee benefits include: Medical (HSA & PPO), Paid Dental, Vision, HSA account with employer contribution, (eligible the first of the month following your date of hire), Long/Short term disability, 401(K) (Traditional & Roth options) with up to 5% company match (eligible 90 days after date of hire), Education Assistance, Paid Time Off (PTO), Paid Holiday, and bonus potential. All benefits on this page are subject to change.

What can I expect in this role? AST is seeking a versatile and highly motivated professional to bridge the gap between our core business systems and data-driven decision-making. This hybrid role requires an individual who can both manage and optimize our Enterprise Resource Planning (ERP) system infrastructure while simultaneously designing, developing, and deploying Business Intelligence (BI) solutions to transform raw data into actionable insights. The ideal candidate will ensure the ERP system runs smoothly and securely, while also empowering stakeholders with the data and reports needed for strategic initiatives.

Key Responsibilities

• ERP implementation & customizations, systems & infrastructure management.
• Design, develop, and maintain scalable BI solutions, including interactive dashboards, reports, and data visualizations.
• Translate business requirements into technical specifications and data models.
• Train end-users on Power BI and best practices to help drive data consumption.
• Develop, optimize, and manage ETL (Extract, Transform, Load) processes to integrate data from various sources (ERP, databases, etc.) into our data warehouse.
• Data modeling, write and optimize complex SQL queries for data extraction, analysis, and performance tuning.
• Create custom data points for analysis using calculated fields & expressions.
• Proactively design, test, and deploy new dashboards & visualizations.
• Ensure data accuracy and integrity across all reports.
• Create and maintain documentation including requirements, design, and user manuals.
• Build & perform routine audits of data in reports/dashboards.
• Provide first and second-line support to end-users, resolving system issues and managing support tickets in a timely manner.
• Requirements gathering, business process mapping, and change management.
• Other duties as assigned.

Qualifications

• Bachelor's degree in Computer Science, Statistics, Economics, or other quantitative related discipline.
• 5+ years of professional ERP & analytics experience.
• Successful experience using SharePoint, DAX, Power Platform (BI, Query, Automate), C#, Visual Basic, SQL, REST APIs, and Python.
• Advanced to expert MS Excel skills.
• Deep experience with recursion, pivot/unpivot, and Window functions.
• Experience with cloud-based BI/ERP solutions, MS Fabric, Salesforce.
• Ability to contribute both independently and as part of a team.
• Strong attention to detail.
• Highly accurate and thorough in tasks.
• Knowledge of life sciences and/or manufacturing industries preferred.

Eligibility Requirements

• Must be legally authorized to work in the United States without restriction.
• Must be willing to take and successfully pass a drug test.
• Must be willing to submit and successfully pass a background check.

AST is proud of our team. Providing challenging and rewarding work, with opportunities for personal/professional development is our key to this longevity. AST is an equal opportunity employer.