Job details
![Newsletter form background]()
Work Type: Active - Benefit Eligible and Accrues Time Off
Exempt: Yes
Shift Time: 8:00am-5:00pm
Location: SunTrust Office, US: FL: Lakeland
Position Summary
Summary:
The Data Architecture team is looking for experienced Data Warehouse Architect who understands how to design efficient data storage systems and enjoys the exploration of data sources and combining them together in meaningful ways. The Data Warehouse Architect reports to the Manager of Data Architecture in executing projects that will positively impact our community's health and well-being. In this role you will explore and deliver the data needed to support analytics that drive our organization forward.
This position assists the other members of the team in data discovery and mapping, ETL and schema design, and review of their projects while also working directly with the data warehouse and data marts when required. S/he will assist in designing Fact and Dimension tables using the Kimbal Data Warehouse Model, develop ETL (extract transform and load) processes using SSIS to populate the data warehouse, prepare and maintain technical documentation to guide system users and/or Analysts.
This role will need a strong technical background across multiple technology stacks to facilitate activities with our corporate IT department and analytics users. They will proactively monitor our internal systems for quality, performance, and reliability ensuring all data is available when it is needed. S/he is expected to perform all work in accordance with all relevant LRH and IS standards, policies, and procedures. May perform other duties as assigned.
Position Details
Detailed responsibilities:
Qualifications & Experience
Education:
Essential:
Education equivalent experience:
Essential:
Experience:
Preferred:
Agile SCRUM project management
Experience with Microsoft SQL Server including SSIS
Source Control products specifically Team Foundation Server or Azure Dev Ops
Lakeland Regional Health is not accepting unsolicited assistance from search firms/Agencies for this employment opportunity. All resumes submitted by search firms/Agencies to any employee at LRH via-email, the Internet or in any form and/or method without a valid written Statement of Work in place for this position from Lakeland Regional Health, HR/Recruitment will be deemed the sole property of LRH. No fee will be paid in the event the candidate is hired by LRH as a result of the referral or through other means.
Data Warehouse Architect I - Data Solutions - job 1 of 2
Position Information
Work Type: Active - Benefit Eligible and Accrues Time Off
Exempt: Yes
Work Schedule: Monday - Friday (remote)
Shift Time: 8:00am-5:00pm
Location: SunTrust Office, US: FL: Lakeland
Position Summary
Summary:
The Data Architecture team is looking for experienced Data Warehouse Architect who understands how to design efficient data storage systems and enjoys the exploration of data sources and combining them together in meaningful ways. The Data Warehouse Architect reports to the Manager of Data Architecture in executing projects that will positively impact our community's health and well-being. In this role you will explore and deliver the data needed to support analytics that drive our organization forward.
This position assists the other members of the team in data discovery and mapping, ETL and schema design, and review of their projects while also working directly with the data warehouse and data marts when required. S/he will assist in designing Fact and Dimension tables using the Kimbal Data Warehouse Model, develop ETL (extract transform and load) processes using SSIS to populate the data warehouse, prepare and maintain technical documentation to guide system users and/or Analysts.
This role will need a strong technical background across multiple technology stacks to facilitate activities with our corporate IT department and analytics users. They will proactively monitor our internal systems for quality, performance, and reliability ensuring all data is available when it is needed. S/he is expected to perform all work in accordance with all relevant LRH and IS standards, policies, and procedures. May perform other duties as assigned.
Position Details
Detailed responsibilities:
- Standard Work: Data Warehouse Architect I
- Serves as a data warehouse consultant within the department. This includes gathering and interpreting business requirements. Is able to formulate and implement data warehouse solutions based on requirements and following IT methodologies, processes and standards.
- Deployment of SSIS ETL Jobs, Stored Procedures and Views to production servers.
- Participates in the ongoing maintenance of the data warehouse and ETL programs.
- Remains vigilant of data architecture standards and best practices to ensure solutions are maintainable and scalable.
- Oversee the creation and maintenance of specifications, requirements, designs, data flows, test scripts and support plans documentation of data warehouse artifacts.
- Create and modify the structure of database objects in database using T-SQL DDL.
- Implements LRH data security policies across the data warehouse platform including encryption, masking, column and row level permission where necessary.
- Mentoring junior level data warehouse developers.
- Facilitate code review and approval process.
People at The Heart of All We Do- Fosters an inclusive and engaged environment through teamwork and collaboration.
- Ensures patients and families have the best possible experiences across the continuum of care.
- Communicates appropriately with patients, families, team members, and our community in a manner that treasures all people as uniquely created.
Safety And Performance Improvement- Behaves in a mindful manner focused on self, patient, visitor, and team safety.
- Demonstrates accountability and commitment to quality work.
- Participates actively in process improvement and adoption of standard work.
Stewardship- Demonstrates responsible use of LRH's resources including people, finances, equipment and facilities.
- Knows and adheres to organizational and department policies and procedures.
Qualifications & Experience
Education:
Essential:
- Bachelor's Degree
Education equivalent experience:
Essential:
- Information Systems, Computer Science or related field.
Experience:
Essential:
5+ years' experience with ETL (Extract, Transform, Load) tools
5+ years' experience working with T-SQL or PL-SQL
5+ years of data warehouse design and implementation experience
2-3 years of experience with code review and deployment
1-2 years SQL Server Administration or equivalent
5+ years' experience with ETL (Extract, Transform, Load) tools
5+ years' experience working with T-SQL or PL-SQL
5+ years of data warehouse design and implementation experience
2-3 years of experience with code review and deployment
1-2 years SQL Server Administration or equivalent
Epic Clarity and Caboodle developer and administration
Experience in supporting client requirements on top Epic Clarity and in Caboodle
Experience in building star, snowflake, and flat data models
Experience:
Experience:
Essential:
Current Certification in Epic Clarity and Caboodle
Preferred:
Agile SCRUM project management
Experience with Microsoft SQL Server including SSIS
Source Control products specifically Team Foundation Server or Azure Dev Ops
Lakeland Regional Health is not accepting unsolicited assistance from search firms/Agencies for this employment opportunity. All resumes submitted by search firms/Agencies to any employee at LRH via-email, the Internet or in any form and/or method without a valid written Statement of Work in place for this position from Lakeland Regional Health, HR/Recruitment will be deemed the sole property of LRH. No fee will be paid in the event the candidate is hired by LRH as a result of the referral or through other means.
Lakeland Regional Health (FL) Glassdoor Company Review
Danielle Drummond
3.9
Lakeland Regional Health (FL) DE&I Review
No rating
CEO of Lakeland Regional Health (FL)
Approve of CEO
Caring is at the heart of what we do every day – caring for patients and families, for self, for others and the community. We share a deep commitment of time, passion, education and understanding and believe it is the best way to provide care. We...
8 jobsINDUSTRY
TEAM SIZE
LOCATION
DATE POSTED
August 3, 2023
Subscribe to Rise newsletter
🔮
Hi, I'm Risa! Your AI Career Copilot
Want to see a list of jobs tailored to
you, just ask me below!
you, just ask me below!
Other jobs
Posted last year
Posted 2 years ago
Dental Insurance
Disability Insurance
Flexible Spending Account (FSA)
Vision Insurance
Paid Holidays
Posted last year
Posted last year
Sign up for our weekly
newsletter of fresh jobs
ABOUT RISE
FOR COMPANIES
REMOTE JOBS & MORE
LOOKING FOR A JOB?
FIND A JOB NEAR ME
CONNECT
