Sr Business Systems Analyst - Enterprise Data Warehouse

About Moda Founded in Oregon in 1955, Moda is proud to be a company of real people committed to quality. Today, like then, we’re focused on building a better future for healthcare. That starts by offering outstanding coverage to our members, compassionate support to our community and comprehensive benefits to our employees. It keeps going by connecting with neighbors to create healthy spaces and places, together. Moda values diversity and inclusion in our workplace. We aim to demonstrate our commitment to diversity through all our business practices and invite applications from candidates that share our commitment to this diversity. Our diverse experiences and perspectives help us become a stronger organization. Let’s be better together. Let’s do great things, together! Moda Health seeks to allow equal employment opportunities for all qualified persons without regard to race, religion, color, age, sex, sexual orientation, national origin, marital status, disability, veteran status or any other status protected by law. This is applicable to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absences, compensation, and training. Position Summary The Senior Business Systems Analyst (BSA) supports Moda’s Enterprise Data Warehouse (EDW). This role gathers and documents business requirements, develops data dictionaries and functional requirements, analyzes system processes, and designs functional solutions. The Senior BSA supports upgrades, vendor integrations, and product enhancements, and plays a key role throughout the software development lifecycle, including requirements, design, testing, implementation, and post-production support. This is a FT WFH position. Pay Range $91,528.82 - $119,013.51 annually (depending on experience). This role may be classified as hourly (non-exempt) depending on the applicant’s location. Actual pay is based on qualifications. Applicants who do not exceed the minimum qualifications will only be eligible for the low end of the pay range. Please fill out an application on our company page, linked below, to be considered for this position. Benefits Medical, Dental, Vision, Pharmacy, Life, & Disability 401K - Matching FSA Employee Assistance Program PTO and Company Paid Holidays Required Skills, Experience & Education 8+ years of experience in technical or business analysis, including at least 5 years as a Business Systems Analyst. 5 years of experience building and maintaining functional and business documentation and data-related documentation; strong procedural and technical writing skills. 5 years of experience working with data teams and data warehouses. Ability to read, write, and execute SQL statements; no development required. Expert facilitation skills for both large and small group meetings or working sessions. Strong critical thinking, time management, and problem-solving skills. Ability to work collaboratively in production support and independently with minimal supervision. Ability to manage multiple priorities in a fast-paced environment. Strong organizational skills with the ability to plan, prioritize, and meet deadlines. Effective verbal and written communication skills with stakeholders of varying technical backgrounds. Familiarity with health insurance administration or clinical/operational healthcare preferred. Experience with SQL Server and cloud data warehouses (Snowflake, Synapse/Fabric, BigQuery, Redshift, Databricks) a plus. Familiarity with modern data transformation tools such as dbt or Coalesce nice to have. Primary Functions Lead requirements engineering across the development lifecycle, including elicitation, analysis, and prioritization of functional and non functional requirements. Mentor junior analysts and ensure alignment with enterprise architecture and strategic objectives. Partner with business and technical leaders to define and validate functional specifications and acceptance criteria for high impact initiatives. Identify and source data related projects aligned with organizational priorities and EDW capabilities. Author and review technical documentation, ensuring compliance with EDW standards. Develop business cases, process models, training materials, test scripts, and metrics for process improvements. Participate in system design reviews, data flow reviews, and implementation planning; recommend design alternatives as needed. Develop and execute test plans and scenarios to ensure stakeholder requirements are met. Perform post implementation QA and troubleshooting with appropriate documentation. Collaborate with IT and project managers on EDW related initiatives. Provide training and communicate system changes to end users. Support production operations, scope bug fixes, and ensure timely resolution of complex data issues. Perform other duties as assigned. Working Conditions Office environment with extensive close PC and keyboard use, constant sitting, and frequent phone communication. Must be able to navigate multiple computer screens. A reliable, high-speed, hard-wired internet connection required to support remote or hybrid work. Must be comfortable being on camera for virtual training and meetings. Work in excess of standard workweek, including evenings and occasional weekends, to meet business need. Must be able to adjust schedule to accommodate production support needs, project schedules and peak work periods. Internally with all levels of Moda personnel and business units. Externally with vendors, consultants, and contractors. Equal Employment Opportunity Moda Health seeks to allow equal employment opportunities for all qualified persons without regard to race, religion, color, age, sex, sexual orientation, national origin, marital status, disability, veteran status or any other status protected by law. This is applicable to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absences, compensation, and training. For more information regarding accommodations, please direct your questions to Kristy Nehler & Danielle Baker via our View email address on click.appcast.io email. #J-18808-Ljbffr Moda Health