Business Intelligence Developer & ERP Administrator

AST•Tacoma, WA

7d•$85,000 - $115,000•Onsite

About The Position

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 at 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. 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. Compensation for onsite WA applicants is $85,000 - $115,000. All applicants are welcome to apply. Employee benefits include: Medical (HSA & PPO), Dental, Vision, Long/Short term disability, HSA account with employer contribution, 401(K) (Traditional & Roth options) with up to 5% company match, Education Assistance, Paid Time Off (PTO), Paid Holiday, and bonus potential. 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.

Requirements

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
Ability to contribute both independently and as part of a team
Strong attention to detail
Highly accurate and thorough in tasks
Must be legally authorized to work in the United States without restriction.
Must be willing to take and successfully pass a drug test.

Nice To Haves

Experience with cloud-based BI/ERP solutions, MS Fabric, Salesforce
Knowledge of life sciences and/or manufacturing industries preferred

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