SQL Developer 1
Digital Products Services
Fort Mill, SC
We are looking for an SQL Developer 1 to work as part of the Digital Products and Services team. Team members are responsible for securely managing information systems throughout their lifecycle, including knowing what information systems are within their scope of responsibility, understanding what sensitive data is stored, transmitted, or processed on those information systems, enforcing the security principles of least privilege and least functionality, knowing what events may constitute a cybersecurity incident, and understanding their role in security incident response activities. Responsible for developing data extraction, transformation, and load programs for enterprise data structures (i.e. data warehouses, data repositories, and other data destinations), developing and executing SQL test plans, and automating the SQL process through scheduling and exception-handling routines as well as source to target mapping development, support, and maintenance.
Qualification and Requirements
4 Years Bachelors degree in computer science or related field is required
Minimum of 2+ years of experience in Information Technology
Experience with at least one contemporary data transformation tool
US Work Authorization Required
Licensure/Certification Type (ex NP, RN, CMA)
Obtain Application System Certification
Additional Skills/Requirements (required)
• Must pass all certification with a passing grade within three tries for each test or project from each class. Capable of handling multiple tasks with minimal supervision. Possess good organizational, communication, and analytical skills, able to work independently and flexibly. Working knowledge of standard query language (SQL), knowledge of Data Warehouse concepts and design. Good verbal and written communication skills. Ability to read and understand various data structures. Understanding of Healthcare data is desired. Able to work independently and take ownership of tasks. Able to create conceptual, business, and technical documentation. Ability to drive/travel to multiple facilities/locations as needed.
• SQL Developer operations: Extracts, tests, loads, and validates data. Analyze the data flow requirements and develops a scalable architecture for staging and loading data. Interprets the transformation rules for all target data objects and develops the software components to support the transformation. Assist with design/implementation of data staging methods. Prepare/implement data verification and testing methods. Assist with Metadata Repository management. Assist in moving development to production. Create scripts required to extract, transform, clean, and move data and metadata from a source application so they can be loaded into a data warehouse, data mart, or operational data store. Installs and upgrades SQL server and client software. Installs and upgrades SQL server hardware and operating systems.
• Reporting: Report SQL mapping documentation. Develop SQL packages and jobs. Create SQL error reports. Create SQL data validation result reports. Develop SQL metadata repository. Source and target data files. SQL tool installation and upgrade documentation. Keep SQL system documentation. Create SQL system documentation. Create source to target data lineage documentation. Maintain the development, test, user acceptance, and production SQL environments.
• Compliance: Adheres to the principles of the company's Health Code of Ethics Compliance Plan in every encounter with customers, vendors, regulating agencies, the public and fellow employees. Adhere to corporate policies, procedures and standards relating to SQL and databases. Information Technology Services team members are responsible for securely managing information systems throughout their lifecycle, including; knowing what information systems are within their scope of responsibility, understanding what sensitive data is stored, transmitted, or processed on those information systems, enforcing the security principles of least privilege and least functionality, knowing what events may constitute an information security incident, and understanding their role in security incident response activities.
• Communication: Effective in giving and receiving the information required to perform the job.
All other duties as assigned.
Remote interview process
Personal protective equipment provided or required
Plastic shield at work stations
Social distancing guidelines in place
Sanitizing, disinfecting, or cleaning procedures in place