Data Warehouse Manager Loc:Dallas, TX

Data Warehouse Manager Loc:Dallas, TX

  • Posted on : 09-08-2023
  • Job Type : Full Time only
  • Salary : 100,000 - 200,000

Job Description:

Primary Responsibilities
  • Data quality and production ensure data is accurate and production-ready; identify quality KPIs for daily reporting; ensure systems are fault-tolerant and scalable; identify quality processes and process improvements to maintain a production-ready data warehouse; ensure high availability and high performance of the data warehouse; build consistent and reliable communication processes with Production to allow for holding and resuming production in the event of an error in the data.
  • Automated Data Transformation and Quality Reporting (ETL/DQS) define a set of core principles for ETL processes in regards to reporting and monitoring error responses; identify and oversee resources creating ETL processes; design daily operational reports on database quality and health; respond to quality challenges and improve processes; design customer-facing data health reports.
  • Vendor and Partner Communications meet regularly with data vendors and partners to discuss data quality and synchronization of the Company data warehouse roadmap with upcoming changes in their systems; routinely scan the data provider landscape for opportunity to improve on data quality and cost for the Company.
  • Planning and Design create and maintain a data warehouse road map including design, integration, and platform components; ensure road map is aligned with the Company strategic goals; work with IT to architect and refactor the EDW database
Qualifications
  • 5+ years of experience working with automation, quality and database design required3-5 years managing a data warehouse team is requiredBS degree in IT related field or equivalent work experience is requiredMicrosoft Certification is preferredMust have knowledge of SQL Server 2000 through SQL 2014; MS Windows Server 2008 through 2012; Scribe ETL, Informatica; SSRS and SSIS; Data Quality Processes; Bulk, Transactional and Reporting database design; Database Source Control and Testing Tools; as well as TSQL, Views, Stored Procedures and Database Design preferredStrong skills in managing technical teams of various skill level required
  • Good understanding and prior experience working with Scrum Agile Development Process is required
  • Excellence in working closely with other departments; establishing rapport and trust, and maintaining positive relationships within the organization requiredMust have the ability to plan, organize, prioritize duties, tasks and assignments; express ideas and communicate effectively at all levels; as well as quickly analyze, classify and assimilate new technical knowledge required

  • Latest Jobs
    Featured Jobs
    Trending Jobs
    Share Job: