3 Bi Architecture Jobs

Let's do this. Let's change the world. In this vital role you will an experienced BI Architect with expertise in Databricks, Power BI, and enterprise business intelligence (BI) solutions to design and implement scalable, high-performance BI architectures. This role will focus on data modeling, visualization, governance, self-service BI enablement, and cloud-based BI solutions, ensuring efficient, data-driven decision-making across the organization. The ideal candidate will have strong expertise in BI strategy, data engineering, data warehousing, semantic layer modeling, dashboarding, and performance optimization, working closely with data engineers, business partners, and leadership to drive BI adoption and enterprise analytics excellence. Design and develop enterprise BI architectures, integrating Power BI, and cloud-based analytics platforms to enable self-service analytics and data democratization. Create and optimize Power BI semantic models, including DAX calculations, tabular models, DirectQuery, Composite Models, and row-level security (RLS) for scalability and usability. Architect and implement ETL/ELT pipelines and data transformations within Databricks, SQL-based cloud data platforms, and data lakehouse architectures to ensure high-quality BI data sources. Design and manage enterprise BI frameworks, ensuring standardized critical metrics, business logic, and governed semantic layers across Power BI, Tableau, Looker, Qlik Sense, or other BI tools. Optimize BI query performance, indexing, partitioning, caching, and report rendering to enhance dashboard responsiveness and data refresh speed. Implement real-time and batch data integration strategies, ensuring smooth data flow from APIs, ERP/CRM systems (SAP, Salesforce, Dynamics 365), cloud storage, and third-party data sources into BI solutions. Establish and enforce BI governance best practices, including data cataloging, metadata management, access control, data lineage tracking, and compliance standards. Lead the design and development of interactive dashboards, paginated reports, and embedded analytics solutions that deliver actionable insights. Enable Power BI Service administration, including workspace management, deployment pipelines, API integrations, and BI automation strategies. Implement DataOps and CI/CD pipelines for BI, leveraging Power BI Deployment Pipelines, Git integration, and Infrastructure as Code (IaC) to enable version control and automation. Stay up to date with emerging BI technologies, cloud analytics trends, and AI/ML-powered BI solutions to drive innovation. Collaborate with business leaders, data analysts, and engineering teams to ensure BI adoption, self-service analytics enablement, and business-aligned critical metrics. Provide mentorship and training to BI developers, analysts, and business teams, fostering a data-driven culture across the enterprise. What we expect of you Master's degree and 4 to 6 years of experience in Computer Science, IT or related field experience OR Bachelor's degree and 6 to 8 years of experience in Computer Science, IT or related field experience OR Diploma and 10 to 12 years of experience in Computer Science, IT or related field experience Microsoft Certified Power BI Data Analyst Associate certification Basic Qualifications: Experience in BI architecture, data analytics, and enterprise BI solution development. Strong expertise in Power BI, including DAX, Power Query (M), tabular modeling, dashboard development, data visualization standard methodologies, and report optimization. Hands-on experience with Databricks (Apache Spark, Delta Lake, SQL, PySpark) for data processing, transformation, and analytics. Proficiency in SQL, Python, or Scala for data engineering and data manipulation. Expertise in BI strategy, critical metric standardization, and enterprise data modeling, including dimensional modeling, star schema, and data virtualization. Hands-on experience with cloud BI solutions and enterprise data warehouses, such as Azure Synapse, AWS Redshift, Snowflake, Google BigQuery, or SQL Server Analysis Services (SSAS). Strong understanding of Power BI Service, Power BI Embedded, Power Automate, and API-based data integrations. Experience with BI governance, access control, metadata management, data lineage, and regulatory compliance frameworks. Expertise in Agile BI development, Scaled Agile (SAFe), DevOps for BI, and CI/CD practices for BI deployments. Ability to collaborate with C-level executives, business units, and engineering teams to drive BI adoption and data-driven decision-making. Preferred Qualifications: Experience with SSAS (SQL Server Analysis Services), AAS (Azure Analysis Services), SAP BW, or other OLAP technologies. Knowledge of AI-powered BI, natural language processing (NLP) in BI, and automated machine learning (AutoML) for analytics. Experience with multi-cloud BI architectures and federated query solutions using Google Looker, Qlik Sense, or Tableau. Understanding of GraphQL, REST APIs, and data mesh principles for enterprise data access in BI. Knowledge of AI/ML pipeline integration within enterprise data architectures. Soft Skills: Excellent analytical and troubleshooting skills. Strong verbal and written communication skills Ability to work effectively with global, virtual teams High degree of initiative and self-motivation. Ability to manage multiple priorities successfully. Team-oriented, with a focus on achieving team goals. Ability to learn quickly, be organized and detail oriented. Strong presentation and public speaking skills.

Power BI Expertise Min overall experience of 11-14 years with 8+ years of proficiency in Power BI /MSBI for data visualization, report creation, and dashboard development. Skills in data modeling, DAX (Data Analysis Expressions), and performance optimization are crucial. Generative AI Knowledge Understanding of Generative AI technologies, including integrating large language models (LLMs) and APIs into applications. Familiarity with AI frameworks and tools is important. Strong experience (or knowledge) of Power BI CoPilot or Gen AI / OpenAI/Claude etc. Data Management Strong skills in data management , including data storage, retrieval, and optimization. Knowledge of Retrieval-Augmented Generation (RAG) architecture and vector databases is beneficial. Analytical and Problem-Solving Skills Ability to analyze complex data sets and derive actionable insights. Strong problem-solving skills to address technical challenges and optimize solutions. Technical Proficiency Expertise in a range of BI and hosting technologies like the AWS stack, Azure & Snowflake . He/she can work on multiple project streams for a client and apply pharma domain knowledge for better business decision-making especially around Cloud Data Warehouse . Domain 5+ years of Pharma Domain experience in Commercial or Patient areas. Presales Experience RFP response and proactive proposal writing and presentation experience for medium and large pharma companies. Behavioral Collaboration and Communication: Excellent communication skills to work with stakeholders, translate business requirements, and mentor teams. Ability to collaborate effectively across different departments. Leadership: Ability to lead and inspire teams, drive innovation, and ensure project goals are met. Foster a collaborative and productive work environment. Problem-Solving: Proactive approach to identifying and resolving issues. Strong analytical skills to navigate challenges and implement effective solutions. Adaptability: Flexibility to adapt to changing technologies and business needs. Staying current with industry trends and integrating new tools and methodologies is crucial. Attention to Detail: Meticulous attention to detail to ensure accuracy and and quality in data analysis and reporting. Precision is key in delivering reliable insights. Good to Have Skills & Competencies Technical Experience with back-end technologies like Python, Node.js, or Java for designing robust architectures. Front-end skills in HTML, CSS, and JavaScript frameworks (e.g., React, Angular) are also valuable. Familiarity with other BI tools (e.g., Tableau, QlikView) is advantageous. Behavioral Creativity: Ability to think outside the box and develop innovative solutions. Creativity can lead to unique approaches in data visualization and AI integration. Curiosity: A strong desire to learn and stay updated with the latest trends and technologies. Curiosity drives continuous improvement and adaptation. Resilience: Ability to handle setbacks and challenges with a positive attitude. Resilience ensures persistence in achieving project goals despite obstacles. Conflict Resolution: Skills in resolving conflicts and maintaining a harmonious work environment. Effective conflict resolution fosters teamwork and collaboration. Strategic Thinking: Ability to see the big picture and align projects with organizational goals. Strategic thinking ensures that solutions are not only technically sound but also aligned with business objectives.

Technology Leadership Lead and guide the team independently or with minimal support to design, implement, and deliver complex reporting and BI project assignments. Technical Portfolio Expertise in a range of BI and hosting technologies like the AWS stack, Azure & Snowflake. Ability to work on multiple project streams for a client and apply pharma domain knowledge for better business decision-making, especially around Cloud Data Warehouse. Responsible for designing and implementing enterprise-grade BI solutions on cloud platforms. Understand business requirements in a BI context and design data models to transform raw data into meaningful insights. Building Power BI Data Models, reports using charts, slicers, pivots, and custom visuals. Create relationships between data and develop tabular and other multidimensional data models. Experience in creating business-level datasets for interactive Reports & Dashboards. Ability to write complex DAX functions, Power Query, Power Apps. Strong in RDBMS/SQL Server and handling complex queries. Logical Thinking Able to think analytically, use a systematic and logical approach to analyze data, problems, and situations. Must be able to guide team members in analysis. Client Relationship Manage client relationships and client expectations independently. Should be able to deliver results back to the Client independently. Excellent communication skills. Project Management (Good to know) Get accurate briefs from the Client and translate into tasks for team members with priorities and timeline plans. Must maintain high standards of quality and thoroughness. Should be able to monitor accuracy and quality of others work. Ability to think in advance about potential risks and mitigation plans. Job Requirements Rich experience in the Pharmaceutical / Life Sciences Domain . Define and drive the BI strategy and roadmap in alignment with business goals. Lead the design and architecture of scalable and robust Power BI solutions . Provide technical leadership and mentorship to BI developers and analysts. Can work across a variety of projects from advanced analytics, ad-hoc analysis, and reporting . Strong in logical reasoning, structuring of analysis, asking the right questions, and a logical approach to analyze data, problems, and situations. Proficiency in Power BI, including Power Query, Power Pivot, and DAX . Strong understanding of data modeling, data warehousing concepts, and relational databases (e.g., SQL Server, Oracle). Experience with ETL processes and tools . Knowledge of data visualization best practices . Experience with custom visuals and DAX formulas . Familiarity with other BI tools (e.g., Tableau, QlikView) is advantageous. Strong analytical and problem-solving skills . Ability to analyze complex datasets to identify trends, patterns, and insights. Ability to develop and implement key performance indicators (KPIs) and metrics . Excellent verbal and written communication skills . Ability to translate complex data findings into actionable insights for non-technical stakeholders. Experience in training and supporting end-users on Power BI functionalities. Qualification BE/ B. Tech/ /M Tech/MBA Skills (Must Have) 11-15 years of experience in Designing, Developing, and publishing Power BI reports. 3+ years of Pharma domain experience in Commercial or Clinical or Patient functional areas. Strong experience (or knowledge) of Power BI CoPilot or Gen AI / OpenAI/Claude etc. Extensive Experience in building Power BI Data Models , reports using charts, slicers, pivots, and custom visuals. Hands-on experience of Design, Development of visualizations (Charts, Plots, themes etc.), Adhoc reporting. Strong knowledge of SQL and ability to write DAX queries and do customization as per requirement. Extensive self-service BI roll-out and end-user training experience. Experience of Designing, Developing Report data model, ETL data Processes in preparation of Dashboards. Strong expertise in reports performance optimization through reporting platform settings and underlying data layer optimization. Good knowledge and expertise in PBI Admin features and capabilities . Experience in creation of technical documentation . Knowledge of Cloud technologies is a must-have. Experience / Strong knowledge of CoPilot, AI/ML, Narrative features of PBI . Excellent written, presentation, and verbal communication skills. Skills that Give You an Edge Good to have work experience in other BI tools such as Tableau, MicroStrategy, QlikView etc.