Spectrum Health Application Development Analyst - Data Warehouse in Grand Rapids, Michigan
Facility: Priority Health - GRAND RAPIDS, MI
Department: Is-Ph-Business Intelligence
Category: Information Technology
Classification: Full-time with Benefits (A1)
Individuals in these roles will work with business intelligence and data warehousing technologies to deliver data applications to analysts and other users. The primary technologies used by these individuals include Oracle, Informatica, SAP Business Objects, and Tableau.
Under minimal supervision, designs, codes or configures, tests, debugs, deploys, documents and maintains programs using a variety of software development toolkits, programming languages, testing/verification applications and other tools, while adhering to specific development best practices and quality standards.
Gathers business requirements, translating that information into detailed technical specifications from which programs will be written or configured, and validating that the proposed applications align with both the architectural design and the business needs.
Participates in process leadership for work groups, and product/service delivery strategy and work plans.
Competent to work on most phases of applications systems analysis and programming activities, but requires instruction and guidance in others.
Provides coaching to less experienced Application Development Analysts.
Participate in an on-call rotation to provide system support outside of normal working hours.
Other responsibilities may include assisting with troubleshooting and issue analysis, as well as coding, testing and implementing software enhancements/upgrades and/or applying patches.
Experience in various phases of SDLC such as system analysis, design, development, testing and implementation of ETL functionalities for data warehouse/data marts.
Experience in Performance Tuning, Fixing Bugs, and writing complex query SQL and PL/SQL programs.
Programming experience in an enterprise-class extract, transform and load (ETL) tool (Informatica PowerCenter is a plus).
Experience in advanced data warehousing concepts.
o Metadata Analysis.
o Data Modeling (Relational/Dimensional).
o Data Profiling.
o Data Visualization.
Creating adhoc reports and dashboards using BO tool.
Experience in Oracle Report Express (RPX) is a big plus.
Experience in Healthcare industry.
Experience in Scrum methodology.
Education - Associate's Degree or equivalent in related field
Experience - 2 years of experience typically gained through skills/knowledge/abilities in developing and supporting applications, and or system development lifecycle including coding, testing, and implementation
Education - Bachelor's Degree in related field
Spectrum Health grants equal employment opportunity to all qualified persons without regard to race, color, national origin, sex, disability, age, religion, genetic information, marital status, height, weight, sexual orientation, veteran status, or any other legally protected category.