Business Intelligence Architect, BI Architect
2 days ago
As part of the Astellas commitment to delivering value for our patients, our organisation is currently undergoing transformation to achieve this critical goal. This is an opportunity to work on digital transformation and make a real impact within a company dedicated to improving lives.
DigitalX our new information technology function is spearheading this value driven transformation across Astellas. We are looking for people who excel in embracing change, manage technical challenges and have exceptional communication skills.
We are seeking committed and talented Business Intelligence (BI) Architect to join our new FoundationX team- which lies at the heart of DigitalX. As a member of FoundationX, you will be responsible for ensuring our BI applications are performant, operational, scalable and continue to drive business value.
This is a remote position and is based in India. We would like to invite applicants who live in the Bangalore region to apply. Remote work from certain states may be permitted in accordance with Astellas' Responsible Flexibility Guidelines. Candidates interested in remote work are encouraged to apply.
Purpose And Scope
As a Business Intelligence Architect, you will be responsible for designing and implementing robust BI solutions that empower business users with actionable insights. You'll collaborate with cross-functional teams to create scalable, efficient, and user-friendly data platforms. You will play a pivotal role in building maintaining and enhancing our BI applications. This is a fantastic global opportunity to use your proven agile delivery skills across a diverse range of initiatives, utilise your development skills, and contribute to the continuous improvement/delivery of critical IT solutions.
Essential Job Responsibilities
- Data Strategy Contribution: Contribute to the organization's data strategy by identifying opportunities for data-driven insights and improvements.
- Participate in smaller focused mission teams to deliver value driven solutions aligned to our global and bold move priority initiatives and beyond.
- Design, develop and implement robust and scalable data analytics using modern technologies.
- Collaborate with cross functional teams and practises across the organisation including Commercial, Manufacturing, Medical, DataX, GrowthX and support other X (transformation) Hubs and Practices as appropriate, to understand user needs and translate them into technical solutions.
- Provide Technical Support to internal users troubleshooting complex issues and ensuring system uptime as soon as possible.
- Champion continuous improvement initiatives identifying opportunities to optimise performance security and maintainability of existing data and platform architecture and other technology investments.
- Participate in the continuous delivery pipeline. Adhering to DevOps best practises for version control automation and deployment. Ensuring effective management of the FoundationX backlog.
- Leverage your knowledge of data engineering principles to integrate with existing data pipelines and explore new possibilities for data utilization.
- Stay-up-to-date on the latest trends and technologies in data engineering and cloud platforms.
Qualifications
Required
- Bachelor's Degree in computer science, information technology, or related field (or equivalent experience.)
- 5 years+ experience in using Qlik, PowerBI or equivalent technologies
- Familiarity with Business Intelligence and Data Warehousing concepts.
- Web integration skills (Qlik Sense).
- Advanced SQL knowledge.
- Understanding of stored procedures, triggers, and tuning.
- Business Intelligence Tools:
- QLIK: Proficiency in designing, developing, and maintaining QLIK applications. Experience with QLIK Sense and QLIKView is highly desirable. Experience working with N-Printing, Qlik Alerting
- Expert at creating and consuming complex Qlik/PowerBI data models
- Power BI: Strong expertise in creating interactive reports, dashboards, and visualizations using Power BI. Knowledge of DAX (Data Analysis Expressions) is essential and Power Automate (MS Flow) or PowerBI alerts
- Data Modeling and Integration:
- Best practice knowledge of modelling data that is to be consumed by QlikSense or PowerBI
- Ability to design and implement logical and physical data models.
- Familiarity with data warehousing concepts, including star schema, snowflake schema, and data marts.
- Understanding of ETL (Extract, Transform, Load) processes and data integration techniques.
- SQL and Database Management:
- Proficiency in SQL for querying and manipulating data.
- Knowledge of database management systems (e.g., SQL Server, Oracle, MySQL).
- Data Governance and Quality:
- Understanding of data governance principles, data lineage, and metadata management
- Experience ensuring data quality, consistency, and accuracy
- Experience performance tuning BI data models and reports to ensure apps are responsive to users' needs
- Proven skill at creating dashboards of pixel perfect quality
- The ability to work with end users to uncover business requirements and turn these into powerful action orientated applications.
- Create and maintain technical documentation
- Ability to communicate and work effectively with other technical team members to agree best solution
- A self-starter able to work on own but know when to collaborate with wider team to ensure best overall solution.
- Experience working with data warehousing and data modelling
- Understanding of Qlik, Tableau and or PowerBI architecture or any equivalent technology
- Ability to install, configure and upgrade Qlik/ PowerBI or equivalent systems
- Conducting Unit Testing and troubleshooting BI systems
- Data Analysis and Automation Skills: Proficient in identifying, standardizing, and automating critical reporting metrics
- Ensuring Data Security and Compliance with relevant internal, global and or regional regulation
- Assist users with ad-hoc queries and data troubleshooting.
- Use analytics to understand root causes and drive decision-making for customer acquisition and retention.
- Analytical Thinking: Demonstrated ability to lead ad hoc analyses, identify performance gaps, and foster a culture of continuous improvement.
- Agile Champion: Adherence to DevOps principles and a proven track record with CI/CD pipelines for continuous delivery.
Preferred
- Experience with other BI tools (Tableau, ) is a plus.
- Subject Matter Expertise: possess a strong understanding of data architecture/ engineering/operations/ reporting within Life Sciences/ Pharma industry across Commercial, Manufacturing and Medical domains.
- Other complex and highly regulated industry experience will be considered across diverse areas like Commercial, Manufacturing and Medical.
- Data Analysis and Automation Skills: Proficient in identifying, standardizing, and automating critical reporting metrics and modelling tools
- Analytical Thinking: Demonstrated ability to lead ad hoc analyses, identify performance gaps, and foster a culture of continuous improvement.
- Technical Proficiency: Strong coding skills in SQL, R, and/or Python, coupled with expertise in machine learning techniques, statistical analysis, and data visualization.
- Agile Champion: Adherence to DevOps principles and a proven track record with CI/CD pipelines for continuous delivery.
- Experience working in the Pharma/ Lifesciences industry.
- Experience in storytelling with data
- Visualisation best practices
- Knowledge/experience using Qlik, or PowerBI SaaS solutions.
Category FoundationX
Astellas is committed to equality of opportunity in all aspects of employment.
EOE including Disability/Protected Veterans
-
Bengaluru, Karnataka, India Astellas Pharma Full time ₹ 1,04,000 - ₹ 1,30,878 per yearAs part of the Astellas commitment to delivering value for our patients, our organization is currently undergoing transformation to achieve this critical goal. This is an opportunity to work on digital transformation and make a real impact within a company dedicated to improving lives.DigitalX our new information technology function, is spearheading this...
-
BI Architect
2 weeks ago
Bengaluru, Karnataka, India Brillio Full time ₹ 6,00,000 - ₹ 18,00,000 per yearBI Architect - 10 yrs experience Primary Skills Data Warehousing MSBI (SSIS, SSAS, SSRS), SQL, Power BI, Tableau, Looker , Azure, Fabric , Power App, Synapse Excellent Communication (written and verbal) Minimum 10yrs of experience Strong SQL writing experience Specialization Microsoft BI Full Stack Development: Architect, Business...
-
BI Architect â GenAI
8 hours ago
Bengaluru, Karnataka, India Thoucentric Full time ₹ 20,00,000 - ₹ 25,00,000 per yearKey ResponsibilitiesArchitect BI Stack: Design and oversee a scalable and performant BI platform that serves as a single source of truth for key business metrics across functions (Sales, Marketing, Supply Chain, Finance, etc.).Advise BI Lead: Act as a technical thought partner to the BI Lead, aligning architecture decisions with long-term strategy and...
-
Power BI Architect
4 days ago
Bengaluru, Karnataka, India Harman Full time ₹ 15,00,000 - ₹ 20,00,000 per yearLocation:Bangalore - Karnataka, India - EOIZ Industrial AreaJob Family:Artificial Intelligence & Machine LearningWorker Type Reference:Regular - PermanentPay Rate Type:SalaryCareer Level:T4(A)Job ID:R Description & RequirementsIntroduction: A Career at HARMAN Technology Services (HTS)We're a global, multi-disciplinary team that's putting the innovative power...
-
Data and Analytics Solution Architect
6 days ago
Bengaluru, Karnataka, India Cisco Full time ₹ 12,00,000 - ₹ 36,00,000 per yearMeet the TeamJoin Cisco's modern Manufacturing Data & Analytics team, a group of innovators dedicated to transforming manufacturing operations through data-driven digital twin solutions. This team collaborates closely with business architects, engineers, and manufacturing leaders to deliver actionable insights, process optimization, and measurable value...
-
Data Architect
2 days ago
Bengaluru, Karnataka, India Quantiphi Analytics Solution Pvt Ltd Full time ₹ 10,00,000 - ₹ 25,00,000 per yearArchitect - Data While technology is the heart of our business, a global and diverse culture is the heart of our success. We love our people and we take pride in catering them to a culture built on transparency, diversity, integrity, learning and growth.If working in an environment that encourages you to innovate and excel, not just in professional but...
-
Technical Data Architect
3 weeks ago
Bengaluru, Karnataka, India, Karnataka GrayMatter Software Services Full timeJob Overview:We are seeking a highly skilled Technical Architect with 12+ years of experience to oversee and guide the development of advanced data architectures, business intelligence solutions, and ETL workflows using Azure Data Bricks (ADB), Power BI, and related technologies. This is a strategic role in which you will collaborate with cross-functional...
-
Data and Analytics Solution Architect
4 days ago
Bengaluru, Karnataka, India Cisco Full time ₹ 12,00,000 - ₹ 25,00,000 per year**Meet the Team**** Join Cisco's cutting-edge Manufacturing Data & Analytics team, a group of innovators dedicated to transforming manufacturing operations through data-driven digital twin solutions. Our team collaborates closely with business architects, engineers, and manufacturing leaders to deliver actionable insights, process optimization, and...
-
Business Intelligence Analyst
3 weeks ago
Bengaluru, Karnataka, India, Karnataka Birlasoft Full timeAbout Birlasoft:Birlasoft, a powerhouse where domain expertise, enterprise solutions, and digital technologies converge to redefine business processes. We take pride in our consultative and design thinking approach, driving societal progress by enabling our customers to run businesses with unmatched efficiency and innovation. As part of the CKA Birla Group,...
-
BI Specialist – R01556627
2 weeks ago
Bengaluru, Karnataka, India Brillio LLC Full time ₹ 12,00,000 - ₹ 36,00,000 per yearBI Specialist - R BI SpecialistPrimary SkillsData WarehousingMSBI (SSIS, SSAS, SSRS), SQL, Power BI, Tableau, Looker , Azure, Fabric , Power App, SynapseExcellent Communication (written and verbal)Minimum 10yrs of experienceStrong SQL writing experienceSpecializationMicrosoft BI Full Stack Development: Architect, Business IntelligenceJob requirementsData...