Manager, Finance Business Intelligence
Weston, WI - USA
Job Summary
About Apotex Inc.
Apotex is a Canadian-based global health company. We improve everyday access to affordable innovative medicines and health products for millions of people worldwide with a broad portfolio of generic biosimilar innovative branded pharmaceuticals and consumer health products. Headquartered in Toronto with regional offices globally including in the United States Mexico and India we are the largest Canadian-based pharmaceutical company and a health partner of choice for the Americas for pharmaceutical licensing and product acquisitions.
For more information visit:.
The Business Intelligence Manager is responsible for leading the design development and optimization of business intelligence solutions that support data-driven decision-making across the organization. This role partners closely with cross-functional teams including Finance Sales Marketing Demand Planning Customer Support and global stakeholders to deliver impactful reporting and analytics capabilities. The position oversees the development of interactive dashboards and reports in Power BI and leverages Databricks for data processing transformation and advanced addition this role serves as the U.S. AI champion helping to identify advance and promote practical AI use cases across the business including AI-enabled solutions and automation opportunities.
- Design develop and maintain Power BI dashboards reports and visualizations to support business performance management and decision-making.
- Conduct data analysis develop user acceptance testing criteria and maintain business intelligence documentation to support solution delivery and adoption.
- Partner with stakeholders to gather business requirements and translate them into effective reporting and analytics solutions.
- Perform complex data transformations and calculations using DAX within Power BI to support business reporting needs.
- Optimize reporting solutions for performance scalability and user experience.
- Leverage Databricks to support data preparation transformation and analytics processes.
- Work with large and complex datasets using Databricks notebooks Delta Lake and Spark SQL.
- Collaborate with data engineers analysts and business intelligence teams to ensure efficient and reliable data flow between Databricks and Power BI.
- Promote adherence to data governance standards including data security privacy and compliance requirements.
- Communicate insights recommendations and analysis effectively to technical and non-technical stakeholders including senior leadership.
- Apply best practices in report design including user experience and interface design principles.
- Serve as the U.S. AI champion by supporting the adoption of AI capabilities identifying business use cases and contributing to the design and implementation of AI-enabled solutions including intelligent agents and automation initiatives.
- Comply with all company policies and procedures including applicable safety rules and regulations.
- Perform duties in accordance with the Companys Code of Conduct Business Ethics and all established regulatory compliance and safety requirements.
- Demonstrate the Companys core values of Collaboration Courage Perseverance and Passion in the execution of all responsibilities.
- Perform other duties as assigned.
- Works in a safe manner collaborating as a team member to achieve all outcomes.
- Demonstrate Behaviours that exhibit our organizational Values: Collaboration Courage Perseverance and Passion.
- Ensure personal adherence with all compliance programs including the Global Business Ethics and Compliance Program Global Quality policies and procedures Safety and Environment policies and HR policies.
- All other relevant duties as assigned.
- Education
- Bachelors degree in Computer Science Information Technology Data Science or related field (or equivalent work experience).
- Knowledge Skills and Abilities
- Knowledge of integrating Databricks with business intelligence tools such as Power BI Tableau or similar platforms.
- Working knowledge of programming languages such as Python or R for data manipulation analytics and process automation.
- Knowledge of data visualization best practices and user experience/interface design principles.
- Experience
- Minimum of 5 to 7 years of experience developing and maintaining interactive Power BI dashboards and reports.
- Minimum of 2 to 3 years of experience working with Databricks in a data engineering analytics or business intelligence environment.
- Experience working with large complex datasets and supporting ETL or data transformation processes.
- Hands-on experience with AI solutions including the development of AI agents identification of business use cases and application of generative AI or automation tools to enhance business processes and support decision-making.
- Experience with cloud platforms such as Azure AWS or Google Cloud is preferred.
- Relevant Databricks certifications are preferred (for example Databricks Certified Associate Developer for Apache Spark).
At Apotex we are committed to fostering a welcoming and accessible work environment where all everyone feels valued respected and supported to succeed.
We offer accommodation for applicants with disabilities as part of its recruitment process. If you are contacted to arrange for an interview or testing please advise us if you require an accommodation.
Required Experience:
Manager
About Company
Apotex is the largest Canadian-owned pharmaceutical company providing patients around the globe with quality, affordable medicines. We are an innovative global research and technology leader in generic pharmaceuticals that serves customers and partners in the U.S. market, as well as 1 ... View more