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 TM 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