BI Architect

Date: May 30, 2026

Location:

Pune, MH, IN

Requisition ID: 37310

About Avaya

Avaya is an enterprise software leader that helps the world’s largest organizations and government agencies forge unbreakable connections.

The Avaya Infinity™ platform unifies fragmented customer experiences, connecting the channels, insights, technologies, and workflows that together create enduring customer and employee relationships.

We believe success is built through strong connections – with each other, with our work, and with our mission. At Avaya, you'll find a community that values your contributions and supports your growth every step of the way.

Learn more at https://www.avaya.com

Job Information

Job Code: 00270212

Job Family: Information Technology

Job Function: Applications

About the Opportunity

The Avaya Data Warehouse provides consistent, quality analysis and reporting across multiple business units and processes. Your work (design, develop, implement and support) will not only need to meet the existing standards but challenge proven methodologies with new ideas to improve the data warehouse, the development team, and user community. Team members help drive the continuous push to improve business intelligence capabilities and keep the systems and solution current, efficient, and productive.

About the Responsibilities

Supervise team of developers, managing the backlog and assigning workload.
Interact with business users to review requirements, propose, design, document and implement solutions.
Accountable for the full cycle of consulting, design, data modeling, coding, testing and documentation of the company's data warehouse.
Translate user requirements into technical architecture vision and implementation plan.
Perform hands-on development of solutions; and supports the analysis and discovery processes.
Responsible for providing advanced technical skills and leadership in the design, development, control, and use of business data.
Model and develop multidimensional data warehouse solution.
Support and train business users on using the solution.
Participate in code reviews, brown bag sessions and advocate best practices during development.

Who we are looking for -

Experience in designing and developing complex data warehousing solutions
Thorough understanding of the Kimball data warehouse methodology
Strong understanding of data warehousing concepts & technologies such as dimensional modeling, data marts, star schemas, facts and dimensions
Skilled in the following areas:
- Develop complex data transformation using SSIS Data Flow components.
- Develop SSIS script components and tasks using C# or VB.
- Design, configure and administer multidimensional cubes in SSAS (calculations, actions, security).
- Develop parameterized/hierarchical reports in SSRS using SQL and SSAS as a data source.
- Knowledgeable using MDX and T-SQL to query data.
Advanced knowledge of identifying and documenting business requirements in a business intelligence environment
Proven experience with requirements analysis, design, development, testing, and deployment of Microsoft BI Solutions (End-to-End), over multiple technologies, size and scale of projects.
Experienced with source control systems such as TFS.
Experienced with using Excel to analyze data.

Preferred skills

Experience with SAP and associated data

Experience

8+ Years of Experience

Education

Bachelor degree or equivalent experience

Master Degree is preferred but not essential in Computer Science or Related Field

Footer

Applicants must be currently authorized to work in the United States without the need for visa sponsorship now or in the future.

Avaya is an Equal Opportunity employer and a U.S. Federal Contractor. Our commitment to equality is a core value of Avaya. All qualified applicants and employees receive equal treatment without consideration for race, religion, sex, age, sexual orientation, gender identity, national origin, disability, status as a protected veteran or any other protected characteristic. In general, positions at Avaya require the ability to communicate and use office technology effectively. Physical requirements may vary by assigned work location. This job brief/description is subject to change. Nothing in this job description restricts Avaya right to alter the duties and responsibilities of this position at any time for any reason.