Healthcare IT Manager – EDW Development

posted on December 11, 2017

Job Description

Location: Detroit, MI

Type: Permanent

Education / Experience Required:

  • Bachelor’s degree in Computer Science, Information Systems, Computer Engineering, Systems Analysis or a related field required. Master’s degree preferred.
  • 10 years of progressive work experience in multiple IT areas, including 5 – 7 years of relevant domain experience in data warehousing and/or analytics technologies is required.
  • Must have expert level knowledge of
  • a)      ETL tools like Microsoft SSIS/ Data stage / Informatica AbInitio
  • b)      Windows and Unix scripting, SQL , PL/SQL
  • c)      Data Analysis services such as Microsoft SSAS
  • d)      Data Governance, Data architecture and Master data management  processes
  • e)      Programming languages such as Microsoft .NET, C#, Python, Javascript frameworks
  • Prior experience in a technical lead or consulting role leading Information Management related initiatives (system integration, data warehouse build, data mart build, or similar) is required.
  • Requires expert level knowledge and understanding of data warehouse architecture, application design, systems engineering, SDLC and integration.
  • Demonstrated experience leading teams that analyze complex data related issues and/or logical data models in support of corporate and customer information systems requirements.
  • Solid understanding of methodologies and technologies that depict the flow of data within and between technology systems and business functions/operations
  • Must be able to handle difficult and sensitive situations using sound, independent judgment within general policy and legal guidelines.
  • Must have led the design and architecture of end to end implementations of multiple large scale data integration projects
  • Proven track record in managing diverse teams, including highly-skilled technical resources as well as developing team members of varying skill levels.
  • Ability to assign, guide, and monitor the work of others regardless of the reporting relationship (direct, project, indirect).
  • Excellent strategic thinker with ability to provide thoughtful leadership to develop creative solutions for complex business and technical problems.
  • Excellent verbal and written communication skills. Able to develop and present complex material effectively to a variety of audiences – technical and non-technical, staff, management and leadership.
  • Knowledge of large data distributed processing frameworks and advanced analytics technologies such as Hadoop, Machine learning and/or NLP is preferred.
  • High degree of healthcare provider or payer industry knowledge is preferred
  • Knowledge of statistical analytics tools such as SAS, R is preferred

General Summary:

  • Under the general direction of the Director of the Enterprise Data Warehouse/AVP of Business Intelligence: responsible for the technical architectural designs needed for development, enhancement, and support of the Enterprise Data Warehouse (EDW).
  • Responsible for feasibility studies, time and cost estimates, and the establishment and implementation of new or revised applications systems and programs.
  • Assists in projecting software and hardware requirements. Accountable for architect and designing comprehensive solutions that meet business requirements and incrementally move the data warehouse to the future state.
  • The ideal individual will be responsible for successful development and overall accountability for Data Warehousing development projects in the healthcare space.
  • The Manager will assign personnel to various projects and direct their activities.
  • He or she reviews and evaluates work and prepares performance reports; confers with and advises subordinates on administrative policies and procedures, technical problems, priorities, and methods; consults with personnel in other information systems sections to coordinate activities; prepares activity and progress reports.

Principal Duties and Responsibilities:

  • Manage and mentor a large and diverse team of, Software Designers and Developers, and vendor partners to lead the development of the technical solutions platform of Enterprise Data Warehouse to support next-generation data integration and data integrity for business intelligence and analytics.
  • Provide a strong technology leadership to the IT team.
  • Analyze enterprise business drivers and IT strategy to create current state and future state diagrams of EDW technology focusing on data integration but also encompassing data definition, data standardization, data mastering and data governance.
  • Analyze enterprise business drivers to determine corresponding Information Architecture change requirements.
  • Provide technology direction and leadership to proactively upgrade and align solutions with evolving technologies and business needs, including implementation strategies, focusing on solution optimization and stability.
  • Design and govern the implementation of ETL, data processing, and data visualization design based on business requirements and IT strategies
  • Define the principles to guide ETL and data processing solution decisions for the programs / projects leveraging DW and visualization architecture artifacts and industry best practices.
  • Manage the work of and provides leadership to application staff to support the planning, design/build, test, implementation, support and operational needs of the organization. This includes, but is not limited to, project management, resource planning, assessment of integration and/or interface needs, support and maintenance.
  • Create/review conceptual, logical, and/or physical  design ,  incorporating discrete and big data, analytics framework and data integration best practices
  • Define, implement and evolve source code and change/release management methodologies and other Software Life Cycle Development (SDLC) processes and build tools to operationalize them.
  • Plan solutions with performance, scalability, HIPAA security and reusability in mind and drive assessment of these trade-offs throughout the SDLC.
  • Establish performance, efficiency and stability benchmarks, build and implement custom tools to proactively monitor and analyze solution performance and health across all parts, and continually improve them.
  • Act as a technical advisor and participate as needed in development/testing efforts within the team to maintain consistency and continuity.
  • Evaluate trends on performance, capacity and operational health and develops plans to address key issues. Resolve most issues independently within the team and partners with vendors to resolve more complex issues.
  • Provide preventative maintenance, troubleshooting and resolves problems to ensure infrastructure and application stability.
  • Lead continual improvement best practices by identifying and diagnosing improvement opportunities. Suggest improvements to solution architects and supervisors
  • Stay current with EDW and related analytics technology capabilities and bring the best practices into the development of the EDW program.
  • Promote, develop and adhere to system standards, and best practices.
  • Collaborate with team to promote re-use and develop consistent technical build, implementation and support processes.
  • Establish/Support processes to support strong governance around scope, schedules, financials, change management, deliverable quality and release management.
  • Oversee proofs of concepts for new technology, processes, and/or workflows. Implements applications according to requirements, specifications and compliance/regulatory standards.
  • Effectively manage conflict and work together with team members, colleagues, and other leaders.
  • Effectively oversee, lead, communicate, present, influence and utilize reasoning skills to earn support of staff, colleagues, leadership, and customers.
  • Administer personnel-related matters, including interviewing and hiring, performance evaluations, disciplinary action, coaching/mentoring, and staff development