Data Architect I (*Grant Funded) at Ann & Robert… · North…

Summary: Ann & Robert H. Lurie Children’s Hospital of Chicago is a leading pediatric care provider known for its commitment to innovation and excellence. The Data Architect I will be responsible for designing and managing ETL jobs and custom data applications, integrating data across various systems in a hybrid data environment. This role includes developing data solutions and supporting the analytics team while adhering to compliance standards. Responsibilities: - Design and implement ETL or other data integration solutions among EPIC Clarity, EPIC Clinical Data Warehouse, departmental repositories, research data, legacy and external repositories in the hospital’s hybrid and unified data platform - Develops custom data and analytics solutions to collect, manage, and distribute data including database design and programming, interface design and programming, and application development and implementation - Provides application implementation monitoring and support for existing and/or new applications, technical guidance, and serve as primary resolution point for all issues regarding assigned applications - Installs, deploys and upgrades data analytics systems; maintains documentation, and performs routine systems administration maintenance activities - Scope client requirements and create design documents - Create project plans and project manage solutions - Develop and test ETL or other data integration processes; provide code review for other team members - Support the reporting and data analytics team - Work with the Director of Data Discovery to prioritize projects - Consult with Information Management staff regarding the interaction between computer software, hardware, and peripherals - Respond to all requests with high standards for customer service - Adhere to HIPAA and JCAHO compliance standards - Perform job functions adhering to service principles with customer service focus of innovation, service excellence and teamwork to provide the highest quality care and service to our patients, families, co-workers and others Required Qualifications: - Bachelors Degree in Information Systems, Computer Science or related field - 1-3 years of experience with database and data development - 1-3 Coding experience in object orient language - Knowledge\Experience with SQL Server Stack (SQL, SSIS, SSAS, SSRS, PowerBI) - Ability to design, write and implement Office 365 or MS Teams applications - Software Administration experience - Working knowledge of Healthcare data and analytics (prefer Epic knowledge) - Data modeling design experience. At least 1 of the following : relational, dimensional, or modern data models - Knowledge\Experience in more than 1 data solution (ETL, ODS, Data Marts, Cubes, and Reporting) - Understanding of data integration problems, including validating and cleaning data - Excellent communication skills Required Skills: ETL solutions, SQL Server Stack, Data modeling design Important Skills: Object-oriented coding, Healthcare data analytics Nice-to-Have Skills: Software Administration, Office 365 applications, Data integration understanding, communication Benefits: Medical, dental and vision insurance, Employer paid group term life and disability, Employer contribution toward Health Savings Account, Flexible Spending Accounts, Paid Time Off (PTO), Paid Holidays and Paid Parental Leave, 403(b) with a 5% employer match, Various Voluntary Benefits, Supplemental Life, AD&D and Disability, Critical Illness, Accident and Hospital Indemnity coverage, Tuition assistance, Student loan servicing and support, Adoption benefits, Backup Childcare and Eldercare, Employee Assistance Program, and other specialized behavioral health services and resources for employees and family members, Discount on services at Lurie Children’s facilities, Discount purchasing program