Alorica Manager Data Warehouse in Plano, Texas

  • Manager Data Warehouse*

  • Job Functions:*

  • People task management and assignment – 20%

  • Client engagement and solution design – 20%

  • Architecture of EDW and Integration with 3rd party systems – 20%

  • Integration with File Movement and Reporting teams to support their initiatives – 20%

  • Ad-Hoc special requests for data and analytics – 5%

  • Operations oversight of daily workloads – 15%

  • Key Job Responsibilities:*

  • Maintain data architecture standards and ETL/ELT best practices consistent with a column-oriented data store in an analytic use case

  • Architect, plan, and implement a highly available, scalable, and adaptable end-to-end data environment that addresses longer-term business needs.

  • Design, development and re-engineering of process to improve performance results, organization effectiveness and/or systems/quality/services.

  • Manage a team of 8 engineers augmented by contractors when needed. Guide and mentor team members

  • Keeps company leaders informed of important developments, potential problems, and related information necessary for effective management. Coordinates and communicates plans and activities with others to ensure a coordinated work effort and team approach.

  • Manage team in activities related to the data portion of various projects ranging from the installation of new packaged applications to the development of custom databases for in-house developed applications.

  • Partner with all key stakeholders to deliver world-class technology platforms and high-quality data driven solutions, meeting business needs.

  • Communicate with users to plan, develop, improve and maintain complex components of the logical/physical corporate data model.

  • Work fluently in different styles of data modeling as needed, including Data Vault, Dimensional (Star Schema), OLTP, hierarchical

  • Create, maintain, adhere to, and enforce enterprise modeling standards.

  • Develop and Mentor Team Members in order to build a productive and well-prepared team.

  • Work closely with Database Administrators and Data Integration (ETL) Developers resulting in effective solutions

  • Lead efforts at establishing Data Architecture standards, best practices, and Data Governance procedures. Oversee adherence to these standards.

  • Participate in road-mapping and implementation of strategic future Enterprise Data Strategies. Research and evaluate new data managements techniques

  • Responsible for understanding and complying with all policies, procedures, and regulations relating to job duties.

  • Perform other duties as assigned by management.

  • Education and Experience*

  • Degree in Computer Science, Management Information systems, Statistics, related field or equivalent work experience.

  • 8+ more years of experience working directly with subject matter experts in both business and technology domains

  • 6+ years of experience leading or managing small team

  • Microsoft Tech Stack: 12 years (Required)

  • SQL Server: 10 years (Required)

  • Working with SME: 10 years (Required)

  • Job control and ETL loads 8 years

  • Others:*

  • Web services (SOAP, XML, REST, UDDI, WSDL)

  • Strong programming ability

  • Experience in building real time streaming data ingestion and processing pipeline using Microsoft Technical Stack to support analytics or data science use case

  • Experience with data processing tools

  • Experience building ETL/ELT pipelines