Req #: 229542 Department: LEARNING TECHNOLOGY & INFRASTRUCTURE (LT & I) Job Location: Harborview Medical Center, Remote/Hybrid Job Location Detail: Remote work avaliable. Posting Date: 01/04/2024 Closing Info: Closes On 01/18/2024 Salary: $7,579 - $8898 per month Other Compensation: Shift: First Shift Benefits: As a UW employee, you will enjoy generous benefits and work/life programs. For a complete description of our benefits for this position, please visit our website, click here.
As a UW employee, you have a unique opportunity to change lives on our campuses, in our state and around the world. UW employees offer their boundless energy, creative problem-solving skills and dedication to build stronger minds and a healthier world.
UW faculty and staff also enjoy outstanding benefits, professional growth opportunities and unique resources in an environment noted for diversity, intellectual excitement, artistic pursuits and natural beauty.
UW Medicine LT&I department is seeking a SQL Developer and Data Analyst (‘Developer’) to join their dynamic team!
LT&I works collaboratively with a diverse medical center user base, such as administrators, directors, managers and other staff to ensure system design and implementation meets client business requirements. The BI Developer will need to have a high-level knowledge of UW Medicine's training operations to effectively support application business owners. In addition, the Developer must collaborate with other ITS teams within UW Medicine to ensure supported applications align with enterprise technical and policy requirements.
The Developer is both a subject matter expert and technical systems expert who possesses an array of cross-functional application knowledge and support skills for data used by multiple UW Medicine customer groups. The Developer's responsibilities span the entire lifecycle of UW Medicine clinical and business systems activities. This position will collaborate with the partners of UW Medicine to develop reporting applications, functions, processes, and solutions, to support analysis for strategic learning activities. The Developer needs to work with many different UW Medicine business customers, prioritizing their requests, meeting the customers’ analytics needs, validating data to ensure data quality, and communicating status and progress to customers.
RESPONSIBILITIES:
Intermediate to Advanced Business Intelligence Development and Implementation (50%)
• Work with domain administrators, users and managers across UW Medicine to build an understanding of underlying reporting needs to analyze trends, develop dashboards and metrics, and manage operations
• Create intermediate to advanced level SSRS reports
• Become expert user with Advanced Reporting vendor tool; implement reporting strategy for its use; train and support users
• Produce and maintain technical documentation and business requirements
• Collaborate with developers and business stakeholders on consistent definitions of data, segments, and attributes across channels
• Research and recommend potential data sources and/or tools to elevate opportunities for improvement. Investigate technical, operational, and business impact of incorporating data sources and tools into existing infrastructure
• Work with end users, vendors and outsourced support teams on requirements gathering, develop and test code, implement new processes in production, maintain and support
• Work with appropriate teams to provide needed data
• Performs intermediate to advanced level audits and reviews and validates databases to ensure data integrity
• Assist with intermediate to advanced level ad hoc report generation and data analysis
• Proactively initiate & contribute to system improvements and innovations
• Conduct intermediate to advanced level unit testing and provide intermediate to advanced level support to troubleshoot and resolve technical & performance issues in a production environment
• Shared responsibility in understanding and supporting reporting infrastructure and tools
• Work effectively with management and team members to clarify needs and priorities
• Develop, maintain and update technical documentation.
• Research questions and issues involving Production BI solutions.
• Work with data architects, SQL administrators, BI administrators, BI Developers, and others as needed to resolve to production issues.
• Provide on-call production support for selected times (i.e., month end processing, year-end processing, system upgrades, etc.)
• Provide technical guidance, establishing oneself as an advisor to various cross-functional BI stakeholders.
• Perform design and code reviews of developed solutions for quality assurance.
• Follow ITS and LT&I Analytics report build standards and change control processes, with a focus on enterprise build and long-term system maintenance.
• Design and develop metrics, reports and analyses of advanced to complex complexity to drive key business decisions.
• Provide scheduled and ad hoc mentoring and professional development to team members.
• Independently develop BI solutions in a proficient and timely manner, consistent with estimates created during design, with minimal technical assistance and support.
• Independently test solutions developed prior to any external reviews or testing.
• Develop and maintain supporting documentation (design documents, report inventory, promotion requests, etc.).
• Lead interactions with customers to communicate status, resolve issues, and obtain signoffs (design complete, testing complete/ready for promotion).
• Perform efficient, complete hand-offs to other developers when required.
• Report project status and issues to the reporting team supervisor in a timely manner.
Intermediate to Advanced Reporting (15%)
• Collaborate with Integration Developer to build, maintain, and administer intermediate to advanced level solutions and toolsets to implement meaningful operational reports and dashboards. May require connecting different tools & frameworks, building of ETL processes and APIs
• Help maintain and optimize data processes in SumTotal
• Secondary backup to support Integration processes and share in baseline support
• Work collaboratively with LT&I Integration Developer to produce technical documentation
Intermediate to Advanced Level Learning Analyst Responsibilities (15%)
• Provide learning analyst support for projects as needed.
• Assess customer training requirements.
• Provide consultation and advise on functionality and constraints of the LMS application.
• Work with the Learning Program Manager and Learning Technologies Manager to determine clear, measurable deliverables for projects.
• Configure activities in the LMS application according to business requirements and needs.
• Develop specifications for reports based on business needs.
• Identify gaps in user requirements and LMS application capacity.
Project and Process Management (10%)
• Prioritize tasks with guidance from designated lead, supervisor, or project manager.
• Track and provide regular project status updates to leaders, customers, and stakeholders on progress and obstacles.
• Guide small projects or larger project sub-components that may include cross-functional teams.
• Follow required Change Control processes to ensure proper creation, approval, coordination, and communication of project tasks.
• Manage and prioritize multiple tasks at once, adjusting for roadblocks and problems.
• Communicate across multiple groups within UW Medicine as well as with customers.
• Analyze current and proposed business practices and workflows to identify testing and training needs associated with change.
• Actively seek out and contribute to process improvement efforts.
• Unit test all changes associated with assigned project tasks.
• Execute functional and integrated test scripts, tracking defects to ensure quality project deliverables.
• Research, inform and recommend opportunities to apply business and technology solutions to areas of assigned responsibilities.
Planning and Documentation (5%)
• Maintain a high level of awareness of the current and future BI technologies and best practices and fully understand the various organizational structures of UW Medicine and their unique requirements; utilize and assist leadership in communicating these best practices.
• Coordinate with Business Analysts, Data Architects, Structured Quality Language (SQL) Administrators, BI Administrators and others to understand and document technical requirements, capabilities, and limitations.
• Collaborate with Business Analysts, Data Architects, SQL Administrators, BI Administrators and others to design appropriate BI solutions based on business and technical requirements.
• Perform project planning related to BI solutions development tasks, including effort and completion date estimates.
• Perform and complete all tasks in the agreed upon timelines.
• Work independently on assigned tasks with minimal assistance.
• Document incidents, problems, and system changes in accordance within organizational change control procedures.
• Obtain and transfers knowledge appropriately when new software or hardware are implemented.
Other (5%)
• Participate in all aspects of improving the team, including education/training of other team members and contributing to process/communication improvement initiatives.
• Work with manager to set professional goals for career development.
• Act as back-up for other team members and functions, as needed.
MINIMUM REQUIREMENTS:
• Bachelor’s Degree in Computer Science, Information Technology, Business Administration, or related field.
• 2 years of progressively responsible IT experience, working within a software development lifecycle, including experience analyzing, designing, developing, testing, implementing and maintaining software applications.
Equivalent education/experience will substitute for all minimum qualifications except when there are legal requirements, such as a license/certification/registration.
ADDITIONAL REQUIREMENTS:
• Demonstrated experience in the design, development and delivery of enterprise applications, and complex data integrations.
• Strong, applied knowledge of relational database systems such as Oracle or SQL and subsequent knowledge of database structures, data definitions and data relationships with experience developing relational database solutions.
• Demonstrated experience with SQL query languages.
• Demonstrated experience developing reports using SSRS.
• Demonstrated experience with commercial, off-the-shelf API development.
• Responsibility in supporting small to medium-scale enterprise customers, both internal and external.
• Excellent written and oral communication abilities with the ability to convey a positive and professional image in person, on the telephone and in correspondence.
• Demonstrated experience developing and executing test plans and test cases.
• End user support and documentation experience.
• Ability to provide accurate work estimates.
• Proven customer service orientation with a history of delivering high quality products on time.
DESIRED:
• Previous experience in and knowledge of academic healthcare systems and/or operational environments.
• Advanced degree (e.g., Master’s, PhD, etc.)
• Knowledge of the SumTotal Learning Management application and database structure.
• Experience utilizing the SumTotal API’s in development efforts.
• Experience with Identity Management concepts and processes.
• Experience developing data interfaces and reports.
• Previous experience working in an IT Healthcare application support setting.
• Knowledge of security and privacy issues in the healthcare industry
WORKING ENVIRONMENT:
• This is an Information Technology deadline-driven work environment.
• Ability to communicate clearly in English, both verbally and in writing.
• Ability to travel to multiple locations within the Seattle area, based on customer needs.
• Must have the ability to meet in person as directed by manager.
Application Process:
The application process for UW positions may include completion of a variety of online assessments to obtain additional information that will be used in the evaluation process. These assessments may include Work Authorization, Cover Letter and/or others. Any assessments that you need to complete will appear on your screen as soon as you select “Apply to this position”. Once you begin an assessment, it must be completed at that time; if you do not complete the assessment you will be prompted to do so the next time you access your “My Jobs” page. If you select to take it later, it will appear on your "My Jobs" page to take when you are ready.Please note that your application will not be reviewed, and you will not be considered for this position until all required assessments have been completed.