Previous Job
Previous
ETL Manager
Ref No.: 18-08954
Location: Spartanburg, South Carolina
ETL Manager
*This is a full time on-site position


The Manager, ETL/DB Development is responsible for all activities related to development, upgrade and enhancement and support of Enterprise Data Warehouse, Data Marts, Extract-Transform-Load (ETL) batch processes and other data management and analytics applications. The manager provides leadership and guidance for design, architecture and implementation of data warehouse and data management and is ultimately accountable for overall solution implementation. May assign personnel to various projects and directs their activities. Monitors project schedules and costs. Confers with and advises subordinates on administrative policies and procedures, technical problems, priorities, and methods. Business matters will be treated with the utmost urgency and focus on results and deadlines until each task or project is completed is key. The qualified candidate will display excellent problem solving, analytical, communication, coordination and team management skills. Daily activities will include reviewing current data load processes, leading daily planning meetings, providing estimates, handling ad-hoc requests, and tracking and communicating daily progress on projects and initiatives. 
This position will also take on various responsibilities throughout the department as assigned.
Responsibilities
Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
  • Lead the design, architecture, documentation, development, deployment and support of Data Warehouse, Data Marts and ETL Solutions
  • Provide architecture and design guidance to the developers; Drive resolution for technical issues and provide alternate solutions
  • Assist developers and architects in understanding processes, procedures, and workflow; hold knowledge sessions to assure clarity and content of training materials;
  • Manage Data Warehouse and ETL project tasks for the team, estimate effort, schedule tasks and drive project deliverables and schedules; communicate status, issues and recommendations with management
  • Work closely with the business to gather, analyze, and document the data requirements for projects of medium to high complexity and moderate to high risk
  • Document and map interaction (source-to-target, source-to-ETL mapping) between business processes, information, and data for projects which are of medium to high complexity and moderate to high risk
  • Define and document standards, guidelines and processes for Data Warehouse, ETL and Database development; Ensure that the guidelines and processes are followed
  • Contribute to development and implementation of standards and tools for data management solutions for metadata management, data mining, data modeling, data cleansing, transformation and matching, data stewardship, data quality, data integration and data security
  • Contribute to the creation, management and enhancement of enterprise data management standards and governance processes
  • Contribute to early-phase concept assessments and oversee data management project estimations to help leaders organize business cases for investment decisions
  • Lead the creation and maintenance of reference documentation of the systems, including current state architecture, standards and processes
  • Bring thought leadership and work collaboratively across the technology organization on innovation, improvement and efficiency programs
  • Oversee quality, testing and implementation of data acquisition, migration and information delivery
  • Keep up with technology trends in the data management space and lead technology research, evaluation and selection activities
  • Handle multiple projects simultaneously and engage in problem solving on these projects
  • Identify and recommend technical and process trainings for the team-members
  • Other tasks as assigned
Qualifications
  • Bachelor's Degree in Information Systems, Business Administration, Computer Science or other relative Technical Degree (equivalent work experience will be considered in lieu of degree)
  • At least 7 years' experience working in Information Technology across one or more of the following areas: Data Warehousing, Business Intelligence, Data Management, Data Modeling, Data Architecture
  • At least 5 years leading Enterprise Data Management or Systems Integration solutions involving multiple systems
  • 3+ years of team management experience, preferably in data management domain
  • Excellent relationship management skills
  • Expertise in Tools, Architecture and Standards and Processes used for Data Warehouse and Business Intelligence solutions
  • Experience in programming languages (SQL) relative to database management systems and an  understanding of database modeling and design
  • Excellent communication skills - verbal, written and presentation - including the ability to tailor communications based on the audience
  • Strong analytical and problem-solving skills
  • Understanding of application development, database, and infrastructure capabilities and constraints
  • Ability to act quickly and triage in a crisis situation to make decisions and keep key constituents / customers informed of the situation
  • Ability to plan, organize, manage and track multiple detailed tasks and assignments with frequently changing priorities in a fast-paced work environment; demonstrates a sense of urgency around problems
  • Proven track record of building influential relationships with internal business and technology customers; ability to influence across departmental lines without direct authority and find common ground to achieve architecture objectives
  • Ability to think strategically and identify and understand business needs and translate into strategic direction, plans and solutions
  • Excellent knowledge of SQL database/instance tuning, optimizing complex SQL statements for best possible performance.
  • Experiences in DW Appliances like Netezza, Teradata, and specialized ETL Tools like Informatica, will be a strong plus
  • Experience in Big data technologies - Hadoop, Hive, NoSQL etc. or Machine Learning technologies is a strong plus
  • Experience in the Financial Services industry is a strong plus.
  • Experience working in an environment with NPI data, masking of NPI data and NPI data access controls is a strong plus.