Manager, ETL/DB Development

Description

ResponsibilitiesReasonable 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 SolutionsProvide architecture and design guidance to the developers; Drive resolution for technical issues and provide alternate solutionsAssist developers and architects in understanding ACAs 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 managementWork closely with the business to gather, analyze, and document the data requirements for projects of medium to high complexity and moderate to high riskDocument and map interaction (sourcetotarget, sourcetoETL mapping) between business processes, information, and data for projects which are of medium to high complexity and moderate to high riskDefine and document standards, guidelines and processes for Data Warehouse, ETL and Database development; Ensure that the guidelines and processes are followedContribute 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 securityContribute to the creation, management and enhancement of enterprise data management standards and governance processesContribute to earlyphase concept assessments and oversee data management project estimations to help leaders organize business cases for investment decisionsLead the creation and maintenance of reference documentation of the systems, including current state architecture, standards and processesBring thought leadership and work collaboratively across the technology organization on innovation, improvement and efficiency programsOversee quality, testing and implementation of data acquisition, migration and information deliveryKeep up with technology trends in the data management space and lead technology research, evaluation and selection activitiesHandle multiple projects simultaneously and engage in problem solving on these projectsIdentify and recommend technical and process trainings for the teammembersOther tasks as assignedQualificationsBachelors 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 ArchitectureAt least 5 years leading Enterprise Data Management or Systems Integration solutions involving multiple systems3+ years of team management experience, preferably in data management domainExcellent relationship management skillsExpertise in Tools, Architecture and Standards and Processes used for Data Warehouse and Business Intelligence solutionsExperience in programming languages (SQL) relative to database management systems and an understanding of database modeling and designExcellent communication skills verbal, written and presentation including the ability to tailor communications based on the audienceStrong analytical and problemsolving skillsUnderstanding of application development, database, and infrastructure capabilities and constraintsAbility to act quickly and triage in a crisis situation to make decisions and keep key constituents / customers informed of the situationAbility to plan, organize, manage and track multiple detailed tasks and assignments with frequently changing priorities in a fastpaced work environment; demonstrates a sense of urgency around problemsProven 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 objectivesAbility to think strategically and identify and understand business needs and translate into strategic direction, plans and solutionsExcellent 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 plusExperience in Big data technologies Hadoop, Hive, NoSQL etc. or Machine Learning technologies is a strong plusExperience 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.