Application Developer III-Epic ETL and Reporting

Location: Detroit, MI, United States; Hybrid

Departmental Summary

This position supports analytics, reporting, and data delivery exclusively within the Epic platform. Responsibilities include designing, configuring, customizing, testing, deploying, and supporting Epic-provided dashboards, extracts, analytics content, and related data structures available within the out-of-the-box Epic product. This role is not intended for general reporting or ETL work across other internal BCBSM applications.

Departmental Requirements

Candidates must have relevant experience in application programming, systems analysis, reporting, analytics, or data development. Preferred experience includes working with Epic analytics tools and data structures such as Cogito, Chronicles, Clarity, Caboodle, Reporting Workbench, Radar, SlicerDicer, and Cogito SQL. Candidates must be able to develop, test, validate, document, troubleshoot, and support Epic analytics solutions while demonstrating strong analytical, communication, collaboration, data interpretation, quality assurance, and user-focused design skills. Epic certification is required; candidates without certification may be considered if they are willing to complete the required out-of-state Epic training and obtain certification.

Work closely with clients, business analysts and team members on major projects to understand the business requirements that drive the analysis and design of quality technical solutions that align with business and IT strategies and are in compliance with the organization’s architectural standards. Provide support in the full systems life cycle that may span a broad range of applications to ensure application software is delivered on time and within budget.

• Code applications or enterprise wide software systems using a disciplined development process. Integrate solutions with other applications and platforms outside the framework. Create data extracts and reports from system based on requirements. Develop, execute, and document unit test plans. Support and/or execute all testing efforts across the life cycle.
• Identify technical requirements. Create technical design specifications and assist in sizing technical requirements, as needed. Assist and review technical design specifications developed by junior levels.
• Lead the deployment of new modules upgrades and fixes to the production environment, as needed. Make modules production-ready by moving them to libraries, completing forms and version control documents, following procedures, etc. Validate deployment.
• Evaluate new application packages and tools and performs research on best practices. Provide recommendations for solutions.
• Assist in production support. Troubleshoot existing information systems to identify errors or deficiencies and develops solutions. Provide ongoing maintenance applications.
• Evaluate existing applications and platforms and provides recommendations for improving application performance by conducting gap analysis, identifying feasible alternative solutions, and assisting in the scope of modifications. Participate on teams that outline the process and scope out the improvements that can realized through the application solutions.
• Document functions and changes to new or modified modules and test activities/results and other areas such as error handling and backup/recovery procedures. Assist in the development of user guides and training documentation for systems.
• Participate in project planning processes. Develop work plan timelines and manages workflows to meet project timeframes, as needed.
• Identify best sources of data feeds and interfaces with architects to ensure their feasibility with corporate data warehouse, when needed.
• Adhere to standards and procedures; check for compliance. May assists in defining development guidelines and standards. Review modules for quality assurance. 
• Prepare and present formal training to IT staff, as needed. Provide technical leadership, coaching and mentoring to team members. Provide technical guidance or systems process expertise. Develop reports and presentations for senior management, as needed.
• Other duties may be assigned.

"Qualifications"

EDUCATION AND/OR EXPERIENCE

• Bachelor's degree in related field preferred.
• Five (5) years of application programming and analysis experience required.
• Broad level of understanding surrounding information systems and application architecture standards required.
• Experience designing, developing and testing applications using proven or emerging technologies required.
• Project management and experience leading projects preferred.

OTHER SKILLS AND ABILITIES

• Demonstrated ability to analyze and interpret complex problems or processes that span multiple business areas, identify and understand requirements, and develop alternate solutions.
• Understand the necessity and value of accuracy and attention to detail ability to process information with high levels of accuracy.
• Expertise in multiple technical environments and possesses business knowledge that spans one or more business areas.
• Written and verbal communication skills.
• Ability to work independently, or within a team environment.
• Other related skills and/or abilities may be required to perform this job.