IT Manager- EDW Development

Our client was founded in 1915 and has more than 30,000 employees (2017). It is the sixth‑largest employer in metro Detroit and among the most diverse. They specialize in Cancer Care, Heart Care, Neurology, Neurosurgery, Orthopedics, Primary Care, Bariatric Surgery, Organ Transplantation, Medical Education, and Medical Research. The organization is one of the largest and most popular across the globe, and the work environment is excellent and friendly.

Principal duties and responsibilities:

• Manage and mentor a large, 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 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 provide leadership to application staff to support the planning, design/build, test, implementation, support and operational needs of the organization, including 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 develop plans to address key issues. Resolve most issues independently within the team and partner with vendors to resolve more complex issues. Provide preventative maintenance, troubleshooting and resolve 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. Implement 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,…