BI Architect
BI Architect
India - Hyderabad Apply NowABOUT AMGEN
Amgen harnesses the best of biology and technology to fight the world’s toughest diseases, and make people’s lives easier, fuller and longer. We discover, develop, manufacture and deliver innovative medicines to help millions of patients. Amgen helped establish the biotechnology industry more than 40 years ago and remains on the cutting-edge of innovation, using technology and human genetic data to push beyond what’s known today.
What you will do
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.
EQUAL OPPORTUNITY STATEMENT
Amgen is an Equal Opportunity employer and will consider you without regard to your race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, or disability status.
We will ensure that individuals with disabilities are provided with reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request an accommodation.
