• Job Description

  Req#: 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: 00270233

  Job Family: Information Technology

  Job Function: Applications

  About the Job

  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.
  Looking for a Data warehouse architect with 10-15 years of experience in architecting and building a data warehouse / data lake at Enterprise level.

  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.
  • Support and train business users using the solution.
  • Participate in code reviews, brown bag sessions and advocate best practices during development.

  About Your Experience

  • Data Modeling and Database Design: Proficiency in designing and implementing relational and dimensional data models (e.g., star schema, snowflake schema, data marts), and thorough understanding of the Kimball data warehouse methodology.
  • ETL (Extract, Transform, Load) Development: Experience with ETL tools and processes to extract data from various sources, transform it into a suitable format, and load it into the data warehouse.
  • SQL Expertise: Strong command of SQL for data manipulation, querying, and optimization.
  • Data Warehousing Concepts: Deep understanding of data warehousing principles, concepts, and best practices, including data governance, data quality, and metadata management.
  • Cloud Platforms: Familiarity with cloud-based data warehousing solutions such as Google Big Query, or ADF / Azure Synapse Analytics. Experience in moving an on-prem data warehouse to cloud a plus.
  • Big Data Technologies: Knowledge of big data technologies like Fabric, Databricks, Hadoop, Spark, or NoSQL databases.
  • Business Intelligence (BI) Tools: Experience with BI and reporting tools (e.g., Tableau, Power BI, QlikView) to enable data analysis and visualization.
  • Data Governance and Security: Understanding of data governance frameworks, security best practices, and compliance requirements (e.g., GDPR, HIPAA).

  About the Skills

  • 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
  • Experienced with source control systems such as TFS, GitHub etc.
  • Experienced using Excel to analyze data

  Preferred Skills

  Experience with SAP and associated data

  Preferred Experience Level

  10 - 15 Years of Experience

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

• About the company

  Avaya is an American multinational technology company headquartered in Durham, North Carolina, that specializes in cloud communications and workstream collaboration solutions.

Notice