Data Warehouse Developer
Job Location:
Charlotte, NC - USA
Monthly Salary:
Posted:
Application Deadline:
Vacancies:
Job Summary
Department:
Status:
Benefits Eligible:
Hours Per Week:
Schedule Details/Additional Information:
We are looking for candidates with strong SQL development skills and experience writing tuning and troubleshooting complex queries are highly preferred. 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. This position is a full time salaried position fully remote.
Pay Range:
$41.10 - $61.65Major Responsibilities:
Analyze develop and enhance analytical and operational data solutions/platforms to meetcomplex business needs.
Lead metric and/or technical design and documentation efforts in collaboration withoperational and IT teams ensuring alignment with strategicobjectivesand effective use ofdata.
Lead multiplemediumto large-scale projects and requests using standard projectmanagement tools and methodologies.
Translate business requirements into well-designed and validated data solutions thatsupport organizational goals including analysis and validation of data from raw source todata solution.
Provide thorough andaccuratedocumentation for all work adhering to current industrystandards.
Provide production support for ETL/ELT/data solutions including problem analysis designimplementation and rigorous testing of data models data integrations (ETL ELTAPIetc.)and reports.
Perform data solutions administration activities including training on call and/orparticipatingin upgrades/changes through all phases with minimal oversight.
Identifyand manage change effectively and efficiently in a changing environment throughuse of standard processes and tools working with teammates toutilizechangemanagement processes and tools to create plans to support adoption of changes requiredby project or initiative.
Stay abreast of healthcare environment EHR ERP Cloud SQL and BI technology andindustry trends to build professional skills and drive innovation.
Mentor junior team members and provideexpertisein the analysis and development ofEnterprise data solutions.
Minimum Job Requirements
Education
Bachelors degree in computer science or equivalent knowledge.
Certification / Registration / License
Depending upon the positions focus Certification(s) may beor obtained within 6 months andmaintainedto 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 offerincludesany missing certifications needed to perform the role.
Experience
Typically requires 2-4 years of experience ina healthcareor comparable setting working with report dataor analytics development. Specifically experience with some or all: enterprise EHR Rev Cycle and/or ERPapplication (depending on role); data/BI tools such as Business Objects Epic Slicer Dicer Power BITableau etc.; database content creation (database tables views stored procedures); traditional databaseplatforms such as Oracle SQL Server DB2 etc.; cloud data development platforms such as SnowflakeFabric/Synapse RedshiftBigQuery etc.; significant SQL Python Java or other data manipulationprocedural or scripting languages; ETL/ELT and data orchestration tools such as SSIS ADF DB2Informatica DataStage etc.; healthcare knowledge (EHR Quality or ERP data experience).
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 allorganizational
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 ETLtools andchange controlmethodology.
Strong understanding of data visualization and data storytelling concepts and EHR and ERP
workflowsand 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
Proficiencywith 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
transformationprocesses.
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.
Our CommitmenttoYou:
Advocate Health offers a comprehensive suite of Total Rewards: benefits and well-being programs competitive compensation generous retirement offerings programs that invest in your career development and so much more so you can live fully at and away from work including:
Compensation
Base compensation listed within the listed pay range based on factors such as qualifications skills relevant experience and/or training
Premium pay such as shift on call and more based on a teammates job
Incentive pay for select positions
Opportunity for annual increases based on performance
Benefits and more
Paid Time Off programs
Health and welfare benefits such as medical dental vision life andShort- 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 your FTE or status (e.g. full-time part-time per diem temporary etc.); please ask a Recruiter for more information during an interview.
About Advocate Health
Advocate Health is the third-largest nonprofit integrated health system in the United States created from the combination of Advocate Aurora Health and Atrium Health. Providing care under the names Advocate Health Care in Illinois; Atrium Health in the Carolinas Georgia and Alabama; and Aurora Health Care in Wisconsin Advocate Health is a national leader in clinical innovation health outcomes consumer experience and value-based care. Headquartered in Charlotte North Carolina Advocate Health services nearly 6 million patients and is engaged in hundreds of clinical trials and research studies with Wake Forest University School of Medicine serving as the academic core of the enterprise. It is nationally recognized for its expertise in cardiology neurosciences oncology pediatrics and rehabilitation as well as organ transplants burn treatments and specialized musculoskeletal programs. Advocate Health employs 155000 teammates across 69 hospitals and over 1000 care locations and offers one of the nations largest graduate medical education programs with over 2000 residents and fellows across more than 200 programs. Committed to providing equitable care for all Advocate Health provides more than $6 billion in annual community benefits.
Required Experience:
IC
About Company
Proudly serving Wisconsin with 18 hospitals, over 150 clinics and 70 pharmacies across 30 communities. Choose Aurora Health Care for you and your family.
