Data Architect
: Job Details :

Position Summary The Data Architect is responsible for the primary strategy and data modeling design of the Enterprise Data Warehouse to consolidate data across many systems into a single source for the analytics and reporting across Kootenai Health. Works strategically to develop, direct, and implement best practices for data warehouse concepts.Responsibilities Provides technical development for, and continues to support, the Enterprise Data Warehouse Strategy Designs, implements, and maintains data management capabilities including the enterprise data platform; its associated data models, ETL processes, and data architecture requirements Enables enterprise information management by cataloging and connecting enterprise data assets into the data lake and working within the governance structure to prioritize ingestion into the structured reporting environment Designs, creates, and manages complex business information models within the enterprise data warehouse Works with Analytics Engineers on creation of simple models or model updates, and validates their work Uses technical knowledge of data mapping mythologies to advise colleagues on best practices Builds solutions that are automated, scalable, and sustainable while minimizing defects and technical debt Monitors system health/utilization for issues and resolves issues or elevates them for resolution when necessary Assists with the creation of standard operating procedures within the enterprise data warehouse platform to enforce uniform best practices with regard to design and deployment pipelines Off-hours and weekends may be required to resolve emergency issues, during implementation and maintenance activities, and during on-call rotations Performs other related duties as assigned Familiar with standard concepts, practices, and procedures within the field Relies on experience and judgment to plan and accomplish goals Regular and predictable attendance is an essential job function Competent to meet age specific needs of the unit assignedRequirements and Minimum Qualifications Bachelor s degree required 10 years experience in working with enterprise data platforms required; transactional and warehouse data in both cloud based and on prem environments preferred 3 years experience working in a solutions architect or enterprise architect capacity as it relates to data and analytics strategies required 5 years experience advanced SQL code/report writing Epic Clarity certification/accreditation required within 120 days of hire Microsoft Fabric Analytics Engineer (DP-600) certification required within 90 days of hire Experience with ETL & Data modeling tools required (SSIS, WhereScape, Data Factory, visio, mermaid, etc.) Excellent communication and collaboration skills, engaging with multiple technical and business stakeholders and leaders Healthcare specific data acquisition, ingestion, and processing experience required Extensive knowledge of designing, developing, and optimizing data structure for the analytics team and strong familiarity with Snowflake Cloud platform, Microsoft Fabric, and MS SQL Server Familiar with advanced statistical analysis techniques and use cases as it applies to design considerations for the data warehouseWorking Conditions Must be able to lift and move up to 10 lbs Must be able to reach arms above or below shoulder height Must be able to maintain a sitting position Typical equipment used in an office job Repetitive movementsContinue your career with Kootenai Health!At Kootenai Health, you can continue learning, growing, and advancing. With 397 beds licensed on the main campus, two critical access hospitals, and more than 50 clinics, we offer an almost endless array of meaningful opportunities. Our Internal Recruiters are dedicated to providing personalized service to our team members. They are available to answer internal mobility questions and assist you in navigating options to transition and expand your career and skills.If you re interested in learning more about other roles, inquiring about the internal hiring process, or better understanding career pathways opportunities, please contact the Internal Recruitment team. We look forward to assisting you in finding a position that meets your lifestyle, goals, talents, and current and future skills.What to Expect after you transfer:If you change your title or department, you will receive a new badge. Badges are printed and available in Security on the Wednesday of the week following your transfer.Your benefits may change if your position status (FT, PT, or PRN) has been updated. Please talk with your Recruiter if you have any questions about your status and benefits.Those with a primary position as a PRN will receive per diem pay. Per Diem rates are tiered depending on number of years of employment.If you are moving into a new role, HR will provide you with a new job description to review and sign. HR will also request documentation for any new requirements for your position, including experience, education, licensure, certification, etc.If EPIC training is required for your role and you have not completed the required module for your position, please complete an EPIC Fast Track Attestation at an advanced background check with Health and Welfare is required for your role and you have not completed one previously, you will need to complete the process before your transfer date.Kootenai Health provides exceptional support for extraordinary careers. We value investing in our employees and look forward to supporting you to find a position that best meets your needs, passions, and goals!Apply today! Please contact Amber or Rebekah by calling us at 208-###-#### or emailing ...@kh.org . You can also contact the HR Front Desk at 208-###-#### or email ...@kh.org with any questions.Kootenai Health complies with applicable federal civil rights laws and does not discriminate on the basis of race, color, national origin, age, disability, veteran status, or sex. Kootenai Health does not exclude people or treat them differently because of race, color, national origin, age, disability, veteran status, or sex.In addition to 100% employer-paid insurance premiums for medical, dental, and vision insurance, full-time employee benefits also include the following:Tuition assistance and career development programsRobust Retirement PlanNight, weekend and PRN shift differentialsEmployee referral bonus programCan't find what you're looking for? Join our Talent Community to stay connected with Kootenai Health about job opportunities and events!What makes a successful employee at Kootenai Health? #J-18808-Ljbffr