Business Intelligence Data Warehouse Developer

About Avaya

Businesses are built by the experiences they provide, and every day millions of those experiences are delivered by Avaya Holdings Corp. (NYSE: AVYA). Avaya is shaping what's next for the future of work, with innovation and partnerships that deliver game-changing business benefits. Our cloud communications solutions and multi-cloud application ecosystem power personalized, intelligent, and effortless customer and employee experiences to help achieve strategic ambitions and desired outcomes. Together, we are committed to help grow your business by delivering Experiences that Matter. Learn more at www.avaya.com.

Job Information

Job Code: 00270233

Job Family: Information Technology

Job Function: Applications

About the Role

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.

 

Job Responsibilities

• 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.

Skills & Competencies

- Thorough understanding of the Kimball Data Warehouse methodology.

- Microsoft Business Intelligence design and development:

• SSIS: Develop complex data transformation and script components and tasks using C# or VB.
• SSAS Design, configure and administer multidimensional cubes including, MDX calculations, actions, security.
• SSRS: Develop parameterized/hierarchical reports using SQL and SSAS data sources.

- Knowledgeable using MDX and T-SQL to query data.
- Use source control systems (TFS, JIRA).
- Experience with SAP and associated data.
- Experience with prem-to-cloud migration.

Experience

Education

Preferred Certifications

Footer

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. You may also review the Avaya Global Privacy Policy (accessible at https://www.avaya.com/en/privacy/policy/) and applicable Privacy Statement relevant to this job posting (accessible at https://www.avaya.com/en/documents/info-applicants.pdf).