Sr Business Systems Analyst – Enterprise Data Warehouse

Moda Health•Portland, OR

16h•Remote

About The Position

Let’s do great things, together! 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. 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.

Requirements

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.

Nice To Haves

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.

Responsibilities

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.