The ETL Developer is responsible for the development, enhancement and effective operations of data movement between various systems using ETL methodologies for Compliant Pharmacy Alliance (CPA). Responsible for leading company database development efforts and coordinating with business users, 3rd party data providers, and internal developers to maximize the usage and value of company data assets.
Essential Duties and Responsibilities
1) Develop, maintain and administer system databases and EDW – 45%
•Create logical links between databases to create an Enterprise Data Warehouse as required by CPA’s needs. This may be accomplished by utilizing various SQL tools.
•Design, implement, maintain, and deploy SSIS packages.
•Functions as a primary contributor in designing, coding, testing and debugging ETL to create a seamless data flow.
•Supports overall strategy for CPA technology solutions as it relates to database and data warehouse development.
•Monitor, troubleshoot and analyze ETL process failures, data anomalies, inconsistencies and other ETL related issues identified by monitoring, technical staff, and end-users. Effectively communicate findings.
•Performance tune in-house and third-party databases as required. This will include creating and re-organizing indexes, optimizing job schedules, and creating stored procedures and functions.
•Plan, define, and create new databases using database normalization techniques to meet CPA’s needs.
•Set up and maintain user security for databases and connected applications.
•Interact with IT staff, and vendor support personnel to define and resolve systems-related problems.
•Track and document actions and results in accordance with IT “change control” methodology.
•Work closely with Project Managers, Programmers, and Web Developers to ensure a high level of database integrity.
•Actively participate with IT staff in preparing and implementing backup and disaster recovery procedures and processes of mission critical databases.
•Analyze and implement techniques to optimize system utilization, database performance and maintain established service levels.
•Work with business units/data owners to classify database data for appropriate security, backup, and performance characteristics.
•Generate automated, repeatable and stable processes to support data load, data validation, and data synchronizations for the data warehouse.
•Create database code requirements for all data warehouse data migrations and business unit and SQL-server projects via programming and the various SQL languages.
•Identify and resolve data integrity issues between the data warehouses and the original data sources.
•Create and maintain data dictionaries and database diagrams for complex in-house databases.
•Provide on-call support for problem resolution of database-related issues.
2) Applications Development – 25%
•Provide applications development support primarily for data warehouse applications surrounding product development, marketing research, financial analysis and process improvements.
•Conduct needs assessment, program analysis and specifications, coding, testing, implementation, communication and documentation for all database development.
•Maintain appropriate documentation of all changes and user-requested parameters and reports in accordance with IT programming standards.
•Maintain updated documentation for application and system software and various utilities on a regular basis including the data dictionary for the data warehouse.
•Coordinate all activities related to the operational plan, including maintenance of the status of requests for service, internal department assignments and documentation.
•Create, maintain, and document database views for client use in data warehouse reporting.
3) Software Maintenance and Support – 20%
•Implement new SQL server installations and update existing installations to ensure maximum security and efficiency.
•Develop and implement proactive maintenance plan to review and install available third-party data transformation software fixes.
•Actively lead and participate in new release upgrades of software and hardware.
•Maintain data warehouse system parameters and security specifications.
•Provide clients and staff with technical assistance for supported applications.
•Ensure active usage of vendor provided resources, including technical support, education, compliance, reporting, and user groups.
•Maintain professional rapport with vendor contacts to facilitate progress with problem resolution and new product enhancements.
4) Other Job Duties – 10%
•Participate in Technology Division cross-training, including application development, data processing operations, network support and systems consulting.
•Stay abreast of industry trends and continue to enhance technical skills through education, on the job training, reading, professional contacts and participation in user group meetings.
•Assist and mentor CPA staff and programmers on database concepts, procedures, and data use.
•Perform all other duties as assigned.
•Back up fellow Operations Staff as needed.
•Processing all regularly scheduled programs, including daily/nightly, monthly, quarterly, annual and periodic runs. Monitor messages and output for successful completion. Perform recovery/restart if necessary.
◾Bachelor’s degree in Computer Science, Engineering, MIS, or comparable work experience
◾5+ years of relevant experience with computers, computer systems, and servers.
◾Expert SQL Server knowledge of T-SQL and OLTP topics such as normalization, data types, query tuning, indexing, constraints, and query plans, etc.
◾Experience with SQL 2008+
◾Experience with SSIS and ETL development required
◾SQL Reporting Services (SSRS) or comparable reporting tools experience.
◾Experience with Healthcare analytics and EDI.
◾Experience with software deployment, version control, and build automation preferred.
◾Accountability: Someone who holds himself or herself and colleagues accountable to a high standard of performance and professionalism, and who works to achieve positive company results in a timely, ethical and effective manner
◾Customer Focus: Someone who focuses on discovering the needs of a client and figures out how to best meet them.
◾Team Work: Someone who has the ability and the desire to co-operatively work with a group of people to achieve a common goal.
◾Self-Management: Someone who takes responsibility for their assigned work to ensure that it is done accurately and on-time. Someone who sets goals and expectations for themselves and their department. Someone who swiftly tackles performance problems and issues as they arise. Someone who stays on top of all delegations, assignments, and personal projects. Someone who carefully thinks through what he or she will do before they begin the project, which allows him or her to be able to do the right thing the first time around.
◾Problem Solving/Analysis: Someone who is able to understand a situation by moving through the data presented and processing the information in a systematic way in order to make effective and rational decisions.