Data Warehouse Developer

Status: Full time, benefits eligible. 40 hours per week, fully remote from approved states.

About the role

We are looking for candidates with strong SQL development skills and experience writing, tuning, and troubleshooting complex queries. The ideal candidate will have a solid understanding of dimensional modeling concepts, including fact and dimension tables, and experience working with data warehouse solutions that support business intelligence and analytics. Experience developing and supporting ETL processes and reporting datasets is desirable. Prior experience working with healthcare data, healthcare operations, or within a healthcare environment is a plus.

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.
• Independently manage medium to large complex projects through all phases of solution development.
• Define, create, and maintain data solutions while providing technical expertise for both Cloud and On-Prem data environments.
• Support the maintenance of database dictionaries and monitor standards and procedures.
• Responsible for production support and maintenance of data solutions, data processes, and reporting tools, and for promoting the standardization of data platforms and tool sets.

Requirements

• Bachelor's degree in computer science or equivalent knowledge.
• Typically requires 2-4 years of experience in a healthcare or comparable setting working with report, data, or analytics development.
• Experience with some or all of the following:
  • Enterprise EHR, Rev Cycle, and/or ERP applications (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).
• 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.

Skills

• Communicate effectively with stakeholders and cross-functional teams at all organizational levels.
• Excellent analytical and logical thinking, creativity, self-reliance, communication skills, and the ability to work with various components of a system.
• 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, 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.
• Team player with a positive attitude, strong commitment to customer service, and 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.

Schedule

• Fully remote role from the following 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.
• 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, or internationally (including while on vacation).
• Travel outside of workplace may be required, exposing the incumbent to weather and road conditions.

Pay

Pay Range: $41.10 - $61.65 per hour.

Benefits

• Comprehensive suite of Total Rewards, including:
  • Competitive base compensation with opportunity for annual increases based on performance.
  • Premium pay such as shift, on call, and more based on the teammate's job.
  • Incentive pay for select positions.
• Paid Time Off programs.
• Health and welfare benefits such as medical, dental, vision, life, and short- and long-term disability.
• Flexible Spending Accounts for eligible health care and dependent care expenses.
• Family benefits such as adoption assistance and paid parental leave.
• Defined contribution retirement plans with employer match and other financial wellness programs.
• Educational Assistance Program.

Note: Eligibility for programs listed above may depend on FTE or status (e.g., full-time, part-time, per diem, temporary, etc.).