Database Manager Architect I

3 weeks ago


Ann Arbor, United States Trinity Health Full time

Employment Type: Full time Shift: Description: Applicants for this position must be authorized to work for any employer in the U.S. We are unable to sponsor an employment visa for this position. General Summary The Database Manager/Architect is responsible for the design, administration, development and expansion of a multi-source, multi-hospital, multi-schedule data warehouse to support business intelligence, advanced analytics, clinical research as well as routine health system quality and safety reporting. This is a key position in an innovative environment in which team members see how their work is used to improve patient care. Essential Functions and Responsibilities Designs, administers and maintains data warehouse: Responsible for the ETL processes; Manipulates, cleans, loads data from internal and external sources; Tests and maintains data integrity across multiple databases with edit checks; Develops and maintains framework for adding additional data sources into warehouse. Maintains database server integrity and security. Develops new processes for the warehouse to optimize the existing data; implements new database and online technology from time to time; improves efficiency of existing database systems by utilizing keys and indexes. Audits, modifies and updates data in systems using processes such as SAS, SQL commands, hand-editing, and bulk import. Develops and enforces database and user standards and procedures. Schedules database projects, transaction log backups, and notifications. Works with TIS, home office, external organizations for efficient and accurate data management. Maintains the confidentiality of information acquired pertaining to patients, physicians, employees, and visitors to Trinity Health Michigan. Collaborates with staff on database projects: Collaborates with the team and participates in team meetings/project meetings to determine user requirements. Reviews technical designs, reports, documentation, and other materials produced by staff. Assists team members in the development and creation of SQL and Web-based databases and database systems. Works closely with physicians and hospital staff to determine their information needs. Required Education, Experience and Certification/Licensure Bachelor's degree in computer science, information management or related field. Certification in Microsoft SQL server preferred. A minimum of 3 years of experience in a database environment (SQL Server preferred) with significant responsibilities. Knowledge of SAS, Bases SAS, SAS macros, INTRNET, ACCESS, CONNECT strongly preferred. Business Objects, Desktop Intelligence, Web Intelligence preferred. HL7 experience preferred. Experience working in the healthcare industry preferred. REQUIRED SKILLS AND ABILITIES Demonstrated understanding of current data structures, database theory and database administration concepts Proficient with MSSQL Server 2018 or higher, Oracle or similar, stored procedures, importing/exporting data, back up/restoring databases, triggers. Knowledge of FTP and ODBC Connectivity. Familiarity with basic retrieval, security and back-up. Strong analytical, problem-solving and conceptual skills. Ability to manage multiple concurrent projects. Strong teamwork and interpersonal skills. Timely and effective verbal and written communication skills. Our Commitment to Diversity and Inclusion Trinity Health is one of the largest not-for-profit, Catholic healthcare systems in the nation. Built on the foundation of our Mission and Core Values, we integrate diversity, equity, and inclusion in all that we do. Our colleagues have different lived experiences, customs, abilities, and talents. Together, we become our best selves. A diverse and inclusive workforce provides the most accessible and equitable care for those we serve. Trinity Health is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other status protected by law. Our Commitment to Diversity and Inclusion Trinity Health is a family of 115,000 colleagues and nearly 26,000 physicians and clinicians across 25 states. Because we serve diverse populations, our colleagues are trained to recognize the cultural beliefs, values, traditions, language preferences, and health practices of the communities that we serve and to apply that knowledge to produce positive health outcomes. We also recognize that each of us has a different way of thinking and perceiving our world and that these differences often lead to innovative solutions. Our dedication to diversity includes a unified workforce (through training and education, recruitment, retention, and development), commitment and accountability, communication, community partnerships, and supplier diversity. EOE including disability/veteran


  • Solution Architect.

    5 months ago


    Ann Arbor, United States Cisco Full time

    Who We Are: Duo Security, now part of Cisco, is the leading multi-factor authentication (MFA) and Zero Trust Security solutions provider. Our solutions serve millions of users and perform around 2 billion authentications per month. Duo’s primary offering is MFA, but Duo is pushing boundaries across many fronts in the Zero Trust cybersecurity field as a...


  • Ann Arbor, Michigan, United States KLA Full time

    Job DescriptionThis role involves designing and architecting IT solutions for business user needs, primarily on the 3DExperience platform from Dassault Systems.Key Responsibilities:Champion Enovia PLM system implementation and its integrations as an architect and design and develop new solutions at enterprise scaleParticipate and lead business requirement...


  • Ann Arbor, Michigan, United States Quinn Evans Full time

    Job Title: Senior Architect Project ManagerJob Description:We are seeking a highly skilled Senior Architect Project Manager to join our team at Quinn Evans. As a key member of our project management team, you will be responsible for leading a variety of projects across cultural, learning, and heritage practice areas. Your excellent communication, design,...

  • Solution Architect

    4 weeks ago


    Ann Arbor, Michigan, United States Cisco Full time

    Platform Engineering LeadCisco is seeking a highly skilled Platform Engineering Lead to join our team. As a key member of our Platform Engineering group, you will be responsible for designing and implementing scalable, secure, and reliable platform solutions that support our expanding global customer base.Key Responsibilities:Lead the technical vision for...


  • Ann Arbor, Michigan, United States Domino's Full time

    Job SummaryAs a SQL Database Administrator at Domino's Pizza Inc., you will be responsible for managing the Microsoft SQL Server environment, ensuring the highest levels of performance, availability, and security. This hybrid position requires 3 days of onsite work in Ann Arbor office.Key ResponsibilitiesManage Microsoft SQL Server environment, including...


  • Ann Arbor, Michigan, United States Domino's Pizza LLC Full time

    Database Systems EngineerWe are seeking a skilled Database Systems Engineer to join our team at Domino's Pizza LLC. As a key member of our database team, you will be responsible for managing and maintaining our Microsoft SQL Server environment, ensuring the highest levels of performance, availability, and security.Key Responsibilities:Install, configure, and...


  • Ann Arbor, Michigan, United States Domino's Pizza LLC Full time

    Job Summary:Domino's Pizza LLC is seeking a skilled SQL Database Administrator to manage and maintain our Microsoft SQL Server environment. The ideal candidate will have experience with transactional systems, enterprise data warehouse environments, and critical business applications.Key Responsibilities:Manage and administer database servers and processes to...


  • Ann Arbor, Michigan, United States Actalent Full time

    About the Role:We are seeking a highly skilled Landscape Architect to join our team at Actalent. As a Landscape Architect, you will be responsible for designing and developing landscape projects that meet the needs of our clients.Key Responsibilities:Design and develop landscape projects using AutoCAD and Adobe Creative Suite.Collaborate with clients to...


  • Ann Arbor, Michigan, United States University of Michigan Full time

    Job SummaryThe University of Michigan is seeking a highly skilled Senior BI Solutions Architect to join our team. As a key member of our Financial Systems team, you will be responsible for designing and administering enterprise-level reporting solutions that integrate our cloud-hosted reporting applications and data warehouses.ResponsibilitiesAdminister the...


  • Ann Arbor, Michigan, United States University of Michigan Full time

    Job SummaryThe University of Michigan is seeking a highly skilled Senior Business Intelligence Solutions Architect to join its Financial Systems team. As a key member of the team, you will be responsible for designing and administering enterprise-level reporting solutions, integrating cloud-hosted reporting applications, and data warehouses. Your primary...


  • Ann Arbor, Michigan, United States University of Michigan Full time

    Job SummaryMichigan Medicine is seeking a skilled Solution Architect to orchestrate the seamless operationalization of machine learning models across both on-premises and cloud environments.You will design and ensure the continued operation of application systems, bridging the gap between data science innovation and real-world impact.Key...


  • ANN ARBOR, United States Charles Schwab Full time

    Position Type: RegularYour opportunityAt Schwab, you’re empowered to make an impact on your career. Here, innovative thought meets creative problem solving, helping us “challenge the status quo” and transform the finance industry together. Schwab’s Enterprise Architecture team is looking for a talented Solution Architect to join a centralized...

  • Experienced Finance

    3 weeks ago


    Ann Arbor, United States Audi, Porsche, Volkswagen of Ann Arbor Full time

    Germain Volkswagen of Ann Arbor - Experienced Finance & Insurance Manager (F&I Manager) - Ann Arbor, MI Germain Offers: Medical, Dental, and Vision Insurance 401(k) Savings Plan Paid Vacation Paid Company Holidays Company Outings and Activities Ongoing Professional Development Employee Discounts Family-Friendly and Inclusive Culture Career Growth and...


  • Ann Arbor, Michigan, United States Clarivate Analytics US LLC Full time

    We are seeking a highly skilled Senior Cloud Architect to lead the design and implementation of our cloud-based architecture. This is an exciting opportunity to work on our Vega Product Suite, a next-generation cloud native public library experience.This role reports to a Technical Manager and requires collaboration with stakeholders and colleagues to drive...


  • Ann Arbor, MI, United States Charles Schwab Full time

    Position Type: RegularYour opportunity At Schwab, you’re empowered to make an impact on your career. Here, innovative thought meets creative problem solving, helping us “challenge the status quo” and transform the finance industry together. Schwab’s Enterprise Architecture team is looking for a talented Solution Architect to join a centralized...


  • Ann Arbor, Michigan, United States The Annex Management Group LLC Full time

    Job SummaryWe are seeking a highly experienced Senior Construction Manager to join our team at The Annex Management Group LLC. The ideal candidate will have a strong background in commercial construction management, with a proven track record of delivering projects on time and within budget.Key ResponsibilitiesOversee the coordination and execution of...


  • Ann Arbor, Michigan, United States Gpac Full time

    Job Title: Senior Preconstruction Manager/Lead EstimatorThe Senior Preconstruction Manager/Lead Estimator plays a pivotal role in leading the preconstruction phase of projects, overseeing project development from initial concept to construction start. This position is responsible for creating and managing estimates, schedules, project scopes, budgets, and...


  • Ann Arbor, United States McDonald's Full time

    MUST BE ABLE TO SPEAK SPANISH This job posting is for a position in a restaurant owned and operated by an independent franchisee and not McDonald's USA. This franchisee owns a license to use McDonald's logos and food products, for example, when running the restaurant. However, this franchisee is a separate company and a separate employer from McDonald's USA....

  • Territory Manager I

    2 weeks ago


    Ann Arbor, United States The Hillman Group Full time

    Come join the Hillman Group!At Hillman our spirit runs deep. Every person across every function is empowered to influence the company-bringing forth new ideas and finding better ways to do old things. Find out what it's like to be part of an industry-leading team. We provide excellent compensation plans, world class benefit plans including Health, Dental-,...

  • Product Manager

    2 weeks ago


    Ann Arbor, United States Clarivate Analytics US LLC Full time

    We are looking for a Product Manager to join our team. You will contribute to several functional areas of responsibility to drive quality products from concept to market. You will lead definition and planning through production, release, and end of lifecycle. You will also have end-to-end responsibility for developing feature/function specifications on new...