About the Role
We’re looking for a Data Modelling Analyst with strong SQL and data‑design skills, and someone who is already beginning to use AI tools to enhance their workflow. Data is central to how we operate, powering the search experience, insights, and pricing intelligence that help our customers stay focused on what matters most: discovering and delivering the life‑saving drugs of the future.
We need someone who brings both technical rigour and the curiosity to explore how AI can make modelling faster, smarter and more efficient. You’ll use AI to accelerate tasks like generating first‑draft SQL or DAX, improving documentation, or spotting optimisation opportunities — but more importantly, you will apply the critical thinking and verification needed to ensure outputs are accurate, reliable and production‑ready.
You’ll thrive in this role if you:
- have solid experience in data modelling, semantic layers and metric design
- are comfortable using AI tools to support your work, with the ability to prompt effectively and validate outputs carefully
- bring a mindset focused on efficiency, automation and continuous improvement
- understand how to structure data for self‑serve analytics and AI‑assisted insights
- are curious, proactive and motivated to explore new tools and techniques that make analytics faster and more reliable
This is a rare opportunity to step into a forward‑looking role dedicated to improving how analytics are built, accessed and automated across MyAmici — shaping the foundations of our next‑generation data platform and helping the business focus on insight, decision‑making and transformation.
What will you be doing?
- Design and deliver high‑quality semantic models, datasets, and metric layers that support both BI and AI use cases.
- Build governed, reusable data structures that enable automation, self‑serve analytics, and consistent reporting across the organisation.
- Use AI tools to accelerate development, automate repetitive tasks, and improve efficiency — while validating outputs to ensure accuracy and trust.
- Define business metrics and translate them into robust, well‑structured DAX measures.
- Create Power BI models, datasets, and paginated reports using best‑practice modelling standards.
- Design and optimise SQL stored procedures, views, and ETL/ELT processes to feed BI and AI systems.
- Work closely with BI, Engineering and business teams to understand data needs and translate them into well‑structured, scalable models.
- Identify opportunities to automate manual reporting, streamline workflows and enhance self‑serve capabilities.
- Contribute to a culture of continuous improvement by exploring new tools, techniques and AI‑assisted approaches that make analytics faster and more effective
- Improve data quality, governance, lineage, and documentation
What are we looking for?
- 2+ years’ experience in a data modelling role (e.g., Analytics Engineer, BI Developer, Data Analyst with strong modelling skills)
- Strong understanding of semantic modelling principles, including star schema design, Kimball methodology and industry‑standard modelling patterns
- Experience building and maintaining semantic layers that support both BI and AI consumption.
- Expert SQL skills, including stored procedure development and performance optimisation.
- Experience working with BI tools (e.g., Power BI) and a solid understanding of how modelling choices impact downstream reporting.
- Experience using AI tools to support your workflow, with the ability to prompt effectively and validate outputs carefully.
- Experience with automation tools (e.g., Power Automate) and repeatable data processes.
- Excellent attention to detail and a commitment to data quality and governance.
- Strong communication skills, with the ability to translate complex data concepts into clear, actionable insights.
What is in it for you?
We offer an intrapreneurial environment where people are supported to do their best work, and everyone has the opportunity to make a difference. As a company, we never stop investing in our culture. We appreciate empowering, motivating and developing employees to offer a challenging and rewarding experience at MyAmici.
