Alorica Manager Data Warehouse in Plano, Texas
- Manager Data Warehouse*
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
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