Business Intelligence Architect​/Data Modeler

- Design, develop, and maintain Power BI dashboards, reports, scorecards, and visual analytics solutions that deliver accurate, actionable insights to business stakeholders.

- Build, enhance, and support modern data transformation and reporting solutions using Databricks, SQL, and enterprise business intelligence technologies.

- Develop, optimize, and maintain SSIS ETL workflows to extract, transform, and load data from multiple internal and external systems.

- Design and maintain robust data models, semantic layers, data warehouses, and reporting datasets that enable scalable analytics, consistent reporting, and self-service business intelligence.

- Collaborate with internal stakeholders and external clients to gather business requirements, understand reporting needs, and translate them into effective technical solutions.

- Partner with data engineering, infrastructure, networking, web development, application development, and other IT teams to design and deliver end-to-end BI solutions.

- Establish standardized approaches for extracting, integrating, transforming, and structuring data from diverse enterprise and operational sources.

- Analyze large and complex datasets to identify trends, patterns, risks, and performance opportunities, presenting findings in clear, business-oriented formats.

- Prepare and structure high-quality datasets to support AI-enabled models and emerging analytics initiatives.

- Apply relevant healthcare, pharmaceutical, and pharmacy services knowledge to develop reporting solutions aligned with operational requirements and business priorities.

- Deliver analytics and reporting capabilities that support business performance management, customer reporting, operational insights, and strategic initiatives.

- Maintain data quality, integrity, consistency, and governance through established validation processes, documentation standards, and reporting best practices.

- Produce and maintain comprehensive technical and functional documentation, including data definitions, report logic, ETL workflows, and solution specifications.

- Provide end-user training, technical support, and knowledge transfer to improve adoption and effective use of BI tools and reporting assets.

- Communicate technical concepts and analytical findings clearly to technical and non-technical audiences, helping stakeholders understand data-driven recommendations.

- Contribute to continuous improvement of BI development standards, reporting frameworks, analytics processes, and enterprise data capabilities.

- Support additional projects and business priorities as required, including occasional travel of up to 5%.

- A bachelor's degree in information systems, computer science, data analytics, or a related discipline.

- Between 7 and 10 years of relevant experience in business intelligence, business analytics, reporting, data development, or related technical roles.

- At least five years of hands-on experience with Databricks; relevant certifications are highly desirable.

- At least five years of practical Power BI experience, including dashboard development, report design, DAX, Power Query, data modelling, and publishing best practices.

- Strong SQL skills, including complex querying, data transformation, data validation, and query performance optimization.

- Demonstrated experience developing and maintaining SSIS workflows and traditional ETL or data integration solutions.

- Experience with modern data platforms, particularly Databricks or comparable technologies used for analytics engineering and data transformation.

- Strong knowledge of data modelling, data warehousing principles, semantic layers, and end-to-end business intelligence architecture.

- Experience delivering reporting and…