Data Architect I
Job Description
The Data Architect I will be responsible for designing, creating, deploying and managing ETL jobs or other custom data applications\solutions. The projects will involve integrating data among EPIC, departmental repositories, research data, legacy and external repositories in the hospital’s hybrid (on-premises and cloud) data environment. This position will also be responsible for the administration of data analytics systems under the ownership of the Data Discovery and Development under the Stanley Manne Children’s Research Institute.
Essential Functions
- 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 and Development 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
Knowledge, Skills, Abilities
- Bachelor's Degree in Information Systems, Computer Science or related field
- 3+ years of experience with database and data development
- 3+ years of Object Oriented Programming
- Advanced knowledge of SQL – stored procedures, functions, dynamic SQL, triggers, etc.
- Experience with SQL Server Stack (SQL, SSIS, SSAS, SSRS, PowerBI)
- Experience with Microsoft Azure
- Advanced Data modeling design experience. Experience in overall data solutions (ETL, ODS, Data Marts, Cubes, and Reporting)
- Experience with Solution architecture
- Ability to work independently on complex project
- Working knowledge of Healthcare data and analytics (prefer Epic knowledge)
- Understanding of data integration problems, including validating and cleaning data
- Ability to work independently on complex project
- Ability to collaborate in iterative design process with users
- Excellent communication skills
Education
- Bachelor's Degree
Pay Range
$93,600.00 - $154,440.00
Benefits
- Medical, dental and vision insurance
- Employer paid group term life and disability
- Employer contribution toward Health Savings Account
- Paid Time Off (PTO), Paid Holidays and Paid Parental Leave
- 403(b) with a 5% employer match
- Variety of Voluntary Benefits
AI Notice
Lurie Children’s utilizes certain AI-enabled features within our recruiting platform to support candidate engagement and assist recruiters in identifying and prioritizing applicants whose experience aligns with job requirements. All employment decisions are made by individuals. It is a civil rights violation with respect to recruitment, hiring, promotion, or employment for an employer to use artificial intelligence that has the effect of subjecting employees to discrimination on the basis of protected classes under the Illinois Human Rights Act or to use zip codes as a proxy for protected classes.