Summary: Designs and implements reporting solutions based on users' needs and consistent with the overall design of the organization's information systems architecture. Under limited supervision, collects and analyzes information from system users and Analysts to formulate the requirements and objectives of the report. Prepares business requirements and design documents. Interprets business requirements and designs reporting solutions. Estimates the costs of solutions and defines tasks to be included in project plans. Prepares and maintains technical documentation to guide system users and/or Analysts. Leads medium to large projects and serves as a mentor to others.
Standard Work Duties: Data Warehouse Developer IV - Identifies and seeks opportunities for activities related to team development, employee engagement and achievement of department goals and objectives. - Serves as a expert, consultant regarding the reporting capabilities of systems within the organization. - Serves as an information system consultant throughout organization. This includes gathering and interpreting business requirements. Independently formulates and implements reporting solutions based on requirements and following IT methodologies, processes and standards. - Participates in the ongoing maintenance of reporting tools, ETL feeds and reports. Maintains specifications, requirements, designs, data flows, test scripts and support plans of existing reports. - Proactively facilitates communication and activities with areas of responsibility, within the department, across the organization and with solution vendors. Creates relationships built on trust and results with customers. - Defines, documents test plans for reporting solutions and assists in test execution. This will be done in collaboration with Analysts and other resources responsible for the systems being interfaced. - Serves as technical lead, coordinating and implementing medium to large IT solutions within and across departments. - Independently and consistently demonstrates the ability to identify system issues/risks and proactively identifies and facilitates early interventions. - Demonstrates a complete understanding of the solution(s) supported. - Assists in training and mentorship of others.
10+ years experience in reporting or operational data store services.
5+ years experience in data warehouse design
Five plus years of experience using SQL Server and data transformation (data modeling, T-SQL, stored procedures, and SSIS). SQL and database connectivity experience. Experience Preferred: Project management. Process improvement. Healthcare business and operations.
Internal Number: 6722
About Lakeland Regional Health
Lakeland Regional Health is committed to providing patient-focused, health care services while continuing to improve the quality of care to our patients, families, guests and physicians.