A new Job, ID: 135810 <http://www.ejobsville.com/display-job/135810> was added at eJobsVille.com - For the Best Tech Jobs in Town<http://www.ejobsville.com>
Title: ETL Data Analyst and Systems Support Specialist posted on 2014-03-24 16:37:41 Job Description: The Analyst will be responsible for gathering, analyzing, documenting and maintaining all data requirements related to the business applications, interfaces, and reporting environments. This documentation shall include all logical and physical data models, all required Gap analysis, all source to Client specifications & all business logic or rules required to translate the business functional and technical requirements. The Analyst shall be assigned to daily operations, as well as to ongoing projects, with a focus of meeting the business objectives of quality, on time, and on budget goals. The ETL expert shall utilize standard Data Modeling and ETL tools, avoiding hand written SQL or Program coding methods, developing and implementing highly efficient, scalable, and automated ETL processes. The Analyst will be required to develop technical specifications and detailed work plans, ensuring both system and data quality. Data quality management efforts may include: data cleansing, deduplication, error reporting and debugging using the standard ETL tool set. The Analyst shall provide consultation services to clients, technicians and other departments relating to the functions of the supported applications by proactively supporting the Registry of Vital Records and Statistics program area. The ETL Data Analyst is responsible for ensuring high availability of all VIP related business applications through the strict adherence to all ITD and EOHHS PMO, Security, Quality Assurance, Change Management, and Release Management practices. He/she is responsible for effectively prioritizing workload, monitoring performance, and providing expertise in application, infrastructure and internal support related matters. This position reports to VIP Applications Manager and DPH Program Manager. Key Responsibilities * Research, analyze and maintain all Applications and Technical documentation * Assist with report creation, ETL & SQL scripting, and the maintenance of all Ad Hoc reporting databases * Develop work plans, schedules, and negotiate Client deadlines of short term and long range initiatives * Coordinate efforts between internal management, external consultants, and software vendors * Provide technical assistance and information to technical and non-technical users * Responsible for running monthly reports, managing data extracts/imports, and data quality verification processes * Work with internal & external teams, management, other organization service units, and with end users. * Continually look for opportunities to improve and automate current processes. * Ensure adherence and compliance to department policies, guidelines and objectives. Experience & Skills * Experience with Oracle and SQL Server databases and their native utilities (Query Analyzer, Analytical Workbench, Etc.) * Advanced SQL query-writing skills, Linux/Unix scripting, and automated job scheduling * Experience in ETL Development using standard tools like Informatica, SSIS, Data Migrator, etc. * Knowledge of file and file transmission protocols (FTP, Web Services, XML, Flat File) * Strong knowledge of networking protocols and connectivity as it relates to server based connectivity * Knowledge of Applications Security including Authentication and Role Based Access Control * Knowledge and use of Metadata including self-generated documentation. * Experience in Centralized IT data processing. * Strong Data Modeling and Database Design experience * Experience in user application desktop/server support * Strong issue & problem management including root cause analysis and troubleshooting skills. * Strong adherence to source control, version management, or Configuration management practices * Ability to communicate effectively both verbally and in writing (Clearly and Succinctly) * Experienced in providing ongoing maintenance and support of IT systems and User communities * Capable of working independently or as part of a large team. * Experience in maintaining the confidentiality of sensitive information. *Click here to view full job description and apply <http://www.ejobsville.com/display-job/135810> (Registration not mandatory to apply for this job)* ------------------------------ Best regards, eJobsVille.com - For The Best Tech Jobs In Town -- You received this message because you are subscribed to the Google Groups "SAP ABAP" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/sap-abap. For more options, visit https://groups.google.com/d/optout.
