Job Summary

Data Developer – Senior is a role in the Center for Health System Sciences (CHASSIS) at Atrium Health. The role is responsible for providing custom data solutions for a wide range of medical research projects. Eligible candidates must be able to translate requirements into an actionable data management plan. This includes, but is not limited to designing, coding, debugging, testing, deploying code/processes, and communicating results. Regular interaction with clients. Candidates will be successful in this role if they become a subject matter expert with internal data warehouses, are proficient in SQL to source and manipulate data, have a customer centric mindset, proactively mitigate and addresses conflict, and communicate results to clients. In addition, this position contributes to teammate development and training. The Data Developer- Senior develops and administers data management processes; query and reporting tools, and analytical applications. Analyzes data systems and decision support business requirements and associated source systems to design and develop the application architecture and data management architecture. Handles the detailed design specification development, coding, testing, debugging, and documentation associated with implementing and maintaining the analytical applications and data management processes.

Essential Functions

• With limited direction, customizes data solutions and offers insights for medical research projects, translating research requirements into an actionable data 
  management plan and successfully executing that plan, including all relevant documentation; collaborates with customers to formulate scope/objectives. Identifies unique solutions to problems within the project's scope; demonstrates exceptional customer service/communications skills.
• Demonstrates subject matter expertise related to two or more internal data sources, external data sources, data analysis tools and/or the healthcare industry. Is regularly sought out for their expertise by teammates. 
• Leads process improvement initiatives to successful completion, collaborating with immediate teammates. (e.g. improve data accuracy/availability, streamline 
  workflow, institute best practices, etc.).
• Contributes to ongoing projects and team initiatives, supporting teammates through mentoring, trouble shooting, and sharing knowledge of healthcare, standards, and regulations. Provides input for performance evaluation on teammates.
• Develops work plans, estimated tasks, and provides budget input for items related to the development of data management processes and analytical applications. Provides input into determining project scope and is able to communicate and manage project scope.
• Identifies, defines, documents, analyzes, and obtains customer sign-off on data systems/decision support business requirements. Analyzes these requirements to establish the application architecture.
• Establishes the data management architecture through an analysis of business requirements source system data, and source system application architectures. Confers with peers to evaluate and approve technical architecture and to define the optimal location and configuration of extract, load, and transformation, routines.
• Coordinates development of extract routines with source system team leads. Identifies and coordinates timeframes for test file and production file delivery.
• Plans and manages system tests, customer acceptance tests, and performance tests efforts. Establishes testing procedures. Coordinates the execution of such tests and the resolution of any issues, escalating to management when appropriate.

Physical Requirements

Works under normal office conditions; may include sitting for long periods of time, standing, walking, climbing stairs, using repetitive wrists/arms motions of lifting articles up to 35 lbs. Must travel in personal care to other facilities occasionally. This position requires overtime occasionally.

Education, Experience and Certifications

High School Diploma or GED required; Bachelor's Degree preferred. 4 years in healthcare planning, operations, or managed care is strongly preferred. 4 years of experience designing, implementing, and supporting data systems/decision support systems strongly preferred. High proficiency using computer software tools and working with databases required. Expertise in Epic is strongly preferred. Strong skills in design and development of SQL Server, SSIS, SSAS, relational database design, star schema design/dimensional modeling, Business Objects, and MS Windows. Familiarity with data visualization design principles and with database performance tuning concepts preferred. Strong business perspective and facilitation skills. Thorough knowledge or ability to rapidly acquire such knowledge of the operations, functions, and procedures. Strong communication skills necessary to be effective communicating at all levels of the organization.