IT Data Solutions Developer

Atrium Health Enterprise; Allenton (WI); Remote; USD 100,000 - 140,000; Full time

Job summary

Atrium Health Enterprise is seeking a data solutions professional to analyze and enhance analytical and operational data platforms for complex business needs. You will lead design efforts with IT and operations, manage multiple projects, and translate requirements into validated data products across raw sources to final solutions.

Maintain documentation, support ETL/ELT processes, and mentor junior teammates while staying current with healthcare data trends, EHR/ERP, cloud, SQL, and BI

Qualifications

• Bachelor's degree in computer science or equivalent knowledge.
• Experience designing and delivering analytical data solutions.
• Strong SQL and data modeling fundamentals.

Responsibilities

• Analyze, develop, and enhance data solutions to meet complex business needs.
• Lead design and documentation with operations and IT teams to align with objectives.
• Oversee multiple medium/large projects using standard PM tools.
• Translate business needs into validated data solutions from raw sources.
• Provide thorough documentation and industry-standard practices.
• Support ETL/ELT/data solutions with testing of models, integrations, and reports.
• Mentor junior staff and stay current with healthcare data trends.
• Stay informed on EHR/ERP/cloud/BI tech to drive innovation.

Skills

Data analysis

ETL/ELT development

SQL

Python/Java

Data modeling

Business Intelligence

Education

Bachelor's degree in computer science

Tools

Power BI

Tableau

SSIS

Azure Data Factory

Informatica

DataStage

Job description

• Analyze, develop, and enhance analytical and operational data solutions/platforms to meet complex business needs.
• Lead metric and/or technical design and documentation efforts in collaboration with operational and IT teams, ensuring alignment with strategic objectives and effective use of data.
• Lead multiple medium to large-scale projects and requests using standard project management tools and methodologies.
• Translate business requirements into well-designed and validated data solutions that support organizational goals including analysis and validation of data from raw source to data solution.
• Provide thorough and accurate documentation for all work, adhering to current industry standards.
• Provide production support for ETL/ELT/data solutions, including problem analysis, design, implementation, and rigorous testing of data models, data integrations (ETL, ELT, API,etc.), and reports.
• Perform data solutions administration activities including training, on call and/or participating in upgrades/changes through all phases with minimal oversight.
• Identify and manage change effectively and efficiently in a changing environment through use of standard processes and tools, working with teammates to utilize change management processes and tools to create plans to support adoption of changes required by project or initiative.
• Stay abreast of healthcare environment, EHR, ERP, Cloud, SQL, and BI technology, and industry trends to build professional skills and drive innovation.
• Mentor junior team members and provide expertise in the analysis and development of Enterprise data solutions.

Minimum Job Requirements

Education

Bachelor's degree in computer science or equivalent knowledge.

Major Responsibilities

• Analyze, develop, and enhance analytical and operational data solutions/platforms to meet complex business needs.
• Lead metric and/or technical design and documentation efforts in collaboration with operational and IT teams, ensuring alignment with strategic objectives and effective use of data.
• Lead multiple medium to large-scale projects and requests using standard project management tools and methodologies.
• Translate business requirements into well-designed and validated data solutions that support organizational goals including analysis and validation of data from raw source to data solution.
• Provide thorough and accurate documentation for all work, adhering to current industry standards.
• Provide production support for ETL/ELT/data solutions, including problem analysis, design, implementation, and rigorous testing of data models, data integrations (ETL, ELT, API,etc.), and reports.
• Perform data solutions administration activities including training, on call and/or participating in upgrades/changes through all phases with minimal oversight.
• Identify and manage change effectively and efficiently in a changing environment through use of standard processes and tools, working with teammates to utilize change management processes and tools to create plans to support adoption of changes required by project or initiative.
• Stay abreast of healthcare environment, EHR, ERP, Cloud, SQL, and BI technology, and industry trends to build professional skills and drive innovation.
• Mentor junior team members and provide expertise in the analysis and development of Enterprise data solutions.

Minimum Job Requirements

Education

Bachelor's degree in computer science or equivalent knowledge.

Certification / Registration / License

• Depending upon the position’s focus, Certification(s) may be required or obtained within 6 months and maintained to vendor or department requirements.
• For Epic focused roles, Epic certification(s) in relevant Cogito/reporting application
• For Workday focused roles, Workday certification(s) in relevant WD reporting application
• Learning plan requirements to be provided with offer includes any missing certifications needed to perform the role.

Experience

Typically requires 2-4 years of experience in a healthcare or comparable setting working with report, data, or analytics development. Specifically, experience with some or all: enterprise EHR, Rev Cycle, and/or ERP application (depending on role); data/BI tools such as Business Objects, Epic Slicer Dicer, Power BI, Tableau, etc.; database content creation (database tables, views, stored procedures); traditional database platforms such as Oracle, SQL Server, DB2, etc.; cloud data development platforms such as Snowflake, Fabric/Synapse, Redshift, BigQuery, etc.; significant SQL, Python, Java or other data manipulation, procedural, or scripting languages; ETL/ELT and data orchestration tools such as SSIS, ADF, DB2, Informatica, DataStage, etc.; healthcare knowledge (EHR, Quality or ERP data experience).

Preferred remote locations in IL, WI, NC, GA

Fully Remote Role from these states: AL, AK, AR, AZ, DE, FL, GA, IA, ID, IN, IL (Only WI/IL Division), LA, KS, KY, ME, MI, MO, MS, MT, NC, ND, NE, NH, NM, NV, OH, OK, PA, SC, SD, TN, TX, UT, VA, WI, WV, WY.

Due to complex requirements, remote work is NOT permitted for short or long periods in: CA, DC, CO, CT, HI, MA, MD, MN, NJ, NY, OR, RI, VT, WA. and working Internationally (this includes working while on vacation).

No relocation, No Sponsorship or transfer of visa for this position now or in the future.

Knowledge / Skills / Abilities

• Communicate effectively with stakeholders, and cross-functional teams at all organizational levels.
• Show excellent analytical and logical thinking, creativity, self-reliance, communication skills, and the ability to work with various components of a system.
• Have experience in logical and physical database design, data modeling, complex queries, business intelligence and ETL tools, and change control methodology.
• Strong understanding of data visualization and data storytelling concepts and EHR and ERP workflows and reporting.
• Strong change management skills and understanding of change management processes.
• Work independently or as part of a team and manage multiple priorities while completing tasks efficiently.
• Be a team player with a positive attitude, a strong commitment to customer service, and a willingness to learn healthcare systems and business processes.
• Perform independent analysis on key clinical, financial, ERP, and operational metrics.
• Manage multiple small to medium-sized projects and tasks effectively.
• Mentor and develop junior teammates
• Create clear documentation to support education and presentation efforts.
• Self-motivated, solution-focused, and able to function with minimal supervision.
• Understanding of software or data development lifecycle and process design.
• Proficiency with Microsoft products, EHR and ERP workflows and reporting, as well as hardware and software systems.
• Knowledge of ETL/ELT tools and principles, supporting robust data integration and transformation processes.
• Maintain technical currency and advanced certifications in specialized areas of responsibility.

Physical Requirements And Working Conditions

• Travel outside of workplace is required and thus incumbent is exposed to weather and road conditions.
• Operates all equipment necessary to perform the job.
• Exposed to normal office environment.
• Remote work environment.

This job description indicates the general nature and level of work expected of the incumbent. It is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities required of the incumbent. Incumbent may be required to perform other related duties.