Job Location: Chicago, IL
Overview
CommonSpirit Health was formed by the alignment of Catholic Health Initiatives (CHI) and Dignity Health. With more than 700 care sites across the U.S. & from clinics and hospitals to home-based care and virtual care services CommonSpirit is accessible to nearly one out of every four U.S. residents. Our world needs compassion like never before. Our communities need caring and our families need protection. With our combined resources CommonSpirit is committed to building healthy communities advocating for those who are poor and vulnerable and innovating how and where healing can happen both inside our hospitals and out in the community.
Responsibilities
Job Summary / Purpose
This Data Engineer will support payment integrity compass (PIC) which is a revenue cycle contract management application. They will monitor data as it passes from patient accounting systems to (PIC) payment integrirty compass. They will also assist with reporting, setup and maintaining security with SQL, SSAS, excel and a visualization work tool either Tableau or PowerBI.
The Data Engineer I develops data models and maintains foundational data architecture supporting Payer Strategy & Relationships (PSR) initiatives. This role manages information using relational databases, database management systems and tools. The Data Engineer I acts as a liaison between super users, data architects, programmers, and analysts to implement and enforce data integrity standards and procedures to ensure data is managed consistently and appropriately integrated within data marts and databases. Additionally, the Data Engineer I manipulates and integrates data from various sources to enlarge and enhance the data repository and is responsible for coding and documenting procedures, programming, testing and debugging.
Essential Key Job Responsibilities
- Develop scripts to automate routine and repetitive database SQL tasks using standard integration processes.
- Interact regularly with team members and clients to improve data structure, ETL processes, and application performance.
- Provide production support as required to ensure the availability and performance of developed applications for both external and internal users.
- Develop stored procedures, triggers, functions and views to support PSR initiatives.
- Develop SQL queries in the creation of business applications and SQL reports from corporate data sources.
- Evaluate, design, develop, implement and maintain PSR repository using industry standard database tools.
- Create and support data integration process through database refreshes and SSIS.
- Maintain data integrity by working to eliminate redundancy.
- Support PSR to continuously improve upon the current work/business processes to achieve high levels of effectiveness and efficiency.
Qualifications
- Bachelor of Science in Computer Science or related technical field. Education and experience may be considered in lieu of degree.
- Minimum of three (3) years of Information Technology (IT) experience in a fast-paced, complex business environment.
- Experience with relational database management systems (RDBMS) such as SQL Server, Oracle, DB2, MySQL, PostgreSQL.
- Experience developing SQL queries in the creation of business applications and SQL reports from corporate data sources.
- Proven ETL development and data integration between multiple data source systems.
- Detailed analytic problem-solving skills, documentation, communication and flexibility with strong attention to detail in high pressure situations.
- Ability to manage time, work within a team environment to meet project goals/deadlines.
- Ability to work on multi (Technical/Business) environments and train end users.
- Strong SSIS/T-SQL troubleshooting and debugging skills.
- Ability to provide effective testing of new technology related to data management, storage, and retrieval.
- Knowledge of all phases of Software Development Life Cycle (SDLC), from user engagement through post-implementation evaluation.
- Experience with creating views, stored procedures, functions, indexes, triggers, and other related SQL objects.
-
Experience with Microsoft development tools and technologies including:
- SQL Server 2008 R2/2012/2014/2016
- MS Office (Excel, Word, PowerPoint, Access, Visio)
- Experience in payer contract analysis and payer process preferred
- Experience with healthcare claims and remit data preferred
- Experience in medical and billing data preferred
- Working knowledge of Python, JavaScript, C# or R preferred
- Working knowledge of Power BI, Tableau, and SAS preferred
A compensation range of $70,000 – $98,000 is the reasonable estimate that CommonSpirit in good faith believes it might pay for this particular job based on the circumstances at the time of posting. CommonSpirit may ultimately pay more or less than the posted range as permitted by law and according to geographic pay area.
While you’re busy impacting the healthcare industry, we’ll take care of you with benefits that include health/dental/vision, FSA, matching retirement plans, paid vacation, adoption assistance, annual bonus eligibility and more!
#missioncritical
#LI-DH
Submit CV To All Data Science Job Consultants Across India For Free
🔍 Explore All Related ITSM Jobs Below! 🚀
✅ Select your preferred "Job Category" in the Job Category Filter 🎯
🔎 Hit "Search" to find matching jobs 🔥
➕ Click the "+" icon that appears just before the company name to see the Job Detail & Apply Link 📝💼