BI Data Warehouse Architect

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

Footer