AI and Power BI Developer (JHB North) at Aspen Pharma Group

OBJECTIVE OF ROLE

• The AI & Power BI Developer is a combined, forward-looking role responsible for delivering AI-driven analytics and best-in-class Power BI front-end development. This role exists for someone with a genuine passion for Artificial Intelligence who also brings strong Power BI front-end development skills and SQL proficiency. The successful candidate will use AI tools and automation to transform how the organisation consumes data, builds reports and makes commercial decisions.

KEY RESPONSIBILITIES

Power BI Front-End Development & Reporting

• Design, build and maintain polished, user-friendly Power BI dashboards and reports for Sales, Marketing and Key Account Teams
• Connect Power BI models directly to SQL tables, writing and optimising queries to ensure accurate, efficient data retrieval
• Implement robust DAX measures, KPIs and calculated columns to meet commercial reporting requirements
• Manage data model architecture — relationships, star schemas, performance optimisation and incremental refresh
• Ensure all reports are governed, documented and published to managed Power BI workspaces
• Continuously improve front-end design and UX of existing dashboards based on stakeholder feedback

AI-Driven Analytics & Automation

• Build and deploy AI-enabled reporting tools, intelligent dashboards and automated insight-generation pipelines
• Integrate AI/ML models and APIs (e.g. Azure AI, OpenAI, Microsoft Copilot) into existing Power BI and data workflows
• Automate manual reporting processes using Python, Power Automate and AI tooling to reduce turnaround times
• Stay at the forefront of AI advancements and proactively introduce innovations that enhance commercial decision-making

SQL Data Management & Integration

• Work directly with SQL tables as the primary data source for all Power BI models and analytical outputs
• Write, review and optimize SQL queries to extract, transform and load data accurately into reporting layers
• Trace and validate data lineage from source SQL tables through to final dashboard outputs
• Collaborate with IT and data engineering teams to ensure SQL structures support scalable, reliable analytics
• Perform data cleansing, transformation and validation within SQL and Power Query environments

Stakeholder Engagement & Data Enablement

• Partner with Sales, Marketing and Key Account Teams to understand reporting needs and translate them into fit-for-purpose AI and Power BI solutions
• Conduct training and knowledge-sharing sessions to improve data literacy, AI awareness and Power BI adoption across stakeholders
• Provide ad hoc analytical support to address business questions and exploratory insight requests
• Communicate AI outputs and dashboard insights clearly to non-technical commercial audiences

Data Governance & Systems Support

• Ensure data quality, accuracy and consistency through proactive validation and issue resolution across SQL sources and Power BI models
• Support optimisation of reporting tools and systems (Power BI, SQL, Excel, SAP and other relevant platforms)
• Maintain robust documentation of dashboards, SQL queries, data models and AI/automated processes
• Adhere to data governance policies and security standards across all analytical outputs

Requirements
EDUCATIONAL REQUIREMENTS

• Matric / Grade 12
• Degree or Diploma in Business Analysis, Business Science, Computer Science, Data Analytics, Information Technology or a related field preferred

KNOWLEDGE & EXPERIENCE REQUIREMENTS

• 3+ years’ experience working in or with BI teams, with proven Power BI front-end development experience
• Strong interest in and exposure to Artificial Intelligence, Machine Learning or AI-enabled analytics tools — with a genuine passion to build capability in this space
• SQL experience required — comfortable working with SQL tables and relational data structures as a primary data source for Power BI models
• Data analytics experience in the pharmaceutical or healthcare industry advantageous

SOFT SKILLS AND COMPETENCY REQUIREMENTS

• Sound knowledge of data and insight integration to inform, support, and direct business strategy
• Strong analytical, strategic, and creative problem-solving skills
• Storytelling and sense-making of data to translate into business insights
• Demonstrate the ability to turn data driven insights into actionable ways to drive business results
• Able to proactively identify business opportunities and translate it to key stakeholders
• Efficient prioritization of tasks for critical business deliverables, balancing daily, weekly, monthly, quarterly, and half-yearly reporting cadences
• Ability to develop and deliver compelling executive-level presentations
• Ability to perform well under pressure and maintain commitment to deadlines
• Cross collaboration across the organization
• Excellent interpersonal, teamwork and communication skills
• Self-motivated, curious, and critical thinker
• Excellent written and verbal communication skills and the ability to simplify complex data-driven insights
• Drives accountability for personal and team performance