IT Manager- EDW Development

Collabera Technologies; Dearborn (MI); On-site; USD 120,000 - 150,000; Full time

Job summary

Collabera Technologies is seeking a technical leader specializing in data warehousing to manage a diverse team in Dearborn, MI. You will analyze business drivers, guide technology implementation, and design data integration solutions.

The ideal candidate will possess a Bachelor’s degree and extensive experience in IT leadership with a focus on analytics technologies. This role offers opportunities for strategic leadership and team development in a collaborative environment.

Qualifications

• 10 years of progressive work experience in IT, with a focus on data warehousing.
• Prior experience in a technical lead or consulting role.
• Expert knowledge of data warehouse architecture and systems engineering.

Responsibilities

• Manage and mentor a team of software designers and developers.
• Provide technology leadership to the IT team.
• Design and govern ETL and data processing solutions.

Skills

Leadership

Data Warehousing

Systems Engineering

Problem-solving

Communication

Education

Bachelor’s degree in Computer Science, Information Systems, or related field

Master’s degree (preferred)

Tools

ETL tools

Data Visualization Tools

Job description

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.

Job Description

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, present, influence and utilize reasoning skills to earn the support of staff, colleagues, leadership, and customers.
• Administer personnel‑related matters, including interviewing and hiring, performance evaluations, disciplinary action, coaching/mentoring, and staff development.

Qualifications

• 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.
• 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.
• 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.
• Ability to handle difficult and sensitive situations using sound, independent judgment within general policy and legal guidelines.
• 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 the ability to provide thought 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.

Additional Information

All your information will be kept confidential according to EEO guidelines.