Our purpose is to bring hope to life by enabling life-changing therapies for patients around the globe, creating a healthier and happier tomorrow. Our mission is to work side by side with our customers in order to improve patients’ lives by bringing new biopharmaceuticals to market.
The Business Intelligence Analyst will play a key role in managing and optimizing data processes within the Business Development (BD) department at AGC Biologics. This position is responsible for overseeing ETL (Extract, Transform, Load) and SQL (Structured Query Language) processes, ensuring data quality and integrity, and creating impactful BD related data visualizations using Microsoft Power Platform tools. Acting as a data steward, the Business Intelligence Analyst will ensure that BD data is accessible, accurate, and trusted, while collaborating with stakeholders to deliver actionable insights and support decision-making. The ideal candidate will have a strong technical background in data management and visualization, with a focus on building databases and reports to drive business success.
ESSENTIAL JOB DUTIES/RESPONSIBILITIES
-
Oversee and manage ETL processes to extract, transform, and load data efficiently from various sources.
-
Write, optimize, and maintain SQL queries to support data analysis and reporting needs.
-
Develop and maintain Power BI dashboards to provide actionable insights and support data driven decision-making.
-
Leverage the Microsoft Power Platform to automate workflows and enhance data accessibility from diverse sources (Snowflake, Salesforce CRM, Evaluate Pharma, etc.…).
-
Manage the visualizations and reporting of the key performance indicators (KPIs) for the Business Development department.
-
Develop and deliver regular and ad-hoc reports to monitor performance and identify trends.
-
Ensure the correctness, completeness, and integrity of data in source databases to maintain high-level data quality.
-
Develop and deploy Business Intelligence applications for Sales analytics projects.
-
Implement processes and maintain a data inventory and data lineage to ensure transparency and traceability of data across the BD Dept, facilitating improvement in data quality.
-
Act as a data steward to ensure that Business Development data is accessible, usable, safe, and trusted and drives efficient decision making.
-
Establish and enforce data governance practices to maintain data security and compliance.
-
Work closely with BD stakeholders to understand their data needs, data related risks and provide tailored solutions to mitigate risks.
-
Serve as a trusted partner to support data-driven decision-making within the department.
-
Use business data to create compelling visuals and dashboards that communicate insights effectively.
-
Translate complex data into user-friendly insights for various audiences.
-
Design, build, and maintain databases to support the department’s data needs.
-
Develop and deliver data reports that align with business objectives and priorities.
-
Support the digital transformation of the Lead to Contract process.
-
Create user guides and training materials for team members.
-
Recommend and help implement improvements to BI, business tools, data modeling and data management processes.
LEADERSHIP SKILLS
-
Integrates own development into daily tasks and prioritizes and acts on personal development.
-
Is aware of the impact of own tasks and improve day by day.
-
Performs tasks with the customer in mind and acts in due time to secure business results, maintaining high standards of quality.
-
Acts as a team player, promoting and living the AGC Biologics Core Values.
-
Cooperates across the organization.
-
Excels in area of expertise and contributes to the ongoing development of area of expertise.
QUALIFICATIONS
Required:
-
Bachelor’s degree in Business Administration, Information Systems, Data Science, Business Intelligence/Analytics or a related field (or equivalent experience).
-
0-2 years of experience in digitalization, data management, or a related field (internship experience is acceptable).
-
Data savvy with the strong understanding of data models, query optimization, query profiling, and query performance monitoring tools and techniques.
-
Basic knowledge of CRM systems (e.g., Salesforce) is a plus.
-
You have hands on experience with Power BI, exposure to utilizing a data warehouse such as Snowflake.
-
Proficiency in Microsoft Office Suite, especially Excel.
-
Strong attention to detail, organizational and, documentation skills.
-
You are keen to understand the business, ask questions and dive into the data.
-
Eagerness to learn and adapt to new technologies and processes.
-
Excellent communication and teamwork skills.
-
Familiarity with sales processes or the CDMO industry is a plus but not required.
-
Strong communication skills in English (writing and speaking)
Our culture at AGC Biologics is defined by the six core values: Knowledge, Trust, Quality, Ingenuity, Accountability and Teamwork. Our core values stem from our team members and are embedded into our DNA. They provide a common language and understanding of how we as an organization are connected across three continents. Our core values serve as a compass and reminder of how we achieve our purpose of bringing hope to life for patients around the globe.
AGC Biologics is a leading global biopharmaceutical Contract Development and Manufacturing Organization (CDMO) with a strong commitment to delivering the highest standard of service as we work side-by-side with our clients and partners, every step of the way. We provide world-class development and manufacture of mammalian and microbial-based therapeutic proteins, plasmid DNA (pDNA), messenger RNA (mRNA), viral vectors, and genetically engineered cells. Our global network spans the U.S., Europe, and Asia, with cGMP-compliant facilities in Seattle, Washington; Boulder and Longmont, Colorado; Copenhagen, Denmark; Heidelberg, Germany; Milan, Italy; and Chiba, Japan. We currently employ more than 2,500 employees worldwide. Our commitment to continuous innovation fosters the technical creativity to solve our clients’ most complex challenges, including specialization in fast-track projects and rare diseases. AGC Biologics is the partner of choice. To learn more, visit www.agcbio.com. Want to keep posted about our growth and learn more about our company? Follow us on LinkedIn and give us a quick Like on Facebook!
AGC Biologics offers a highly competitive compensation package and a friendly, collaborative culture that values personal initiative and professional achievement. AGC Biologics is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to age, ancestry, color, family or medical care leave, gender identity or expression, genetic information, marital status, medical condition, national origin, physical or mental disability, political affiliation, protected veteran status, race, religion, sexual orientation, or any other characteristic protected by applicable laws, regulations and ordinances.
Top Skills
What We Do
AGC Biologics offers deep industry expertise and uniquely customized services for the scale-up and cGMP manufacture of protein-based therapeutics (using mammalian and microbial systems), mRNA, pDNA, viral vector and cell therapy products, from pre-clinical to commercial production, including our proprietary CHEF1TM Expression System for efficient protein production with CHO cells.
Our company DNA drives us to provide innovative solutions to partner with our customers in helping them reach their goals and accelerate their projects at our cGMP-compliant facilities in the US, Europe and Japan, as well as to facilitate approval and manage spending during the product lifecycle.
We forge exceptionally strong partnerships with our customers and we never lose sight of our commitment to deliver reliable and compliant drug substance.
Visit www.agcbio.com to learn more.
