Senior Business Systems Analyst (Enterprise Data Warehouse)

Moda Health is a company committed to quality healthcare since 1955. The Senior Business Systems Analyst supports the Enterprise Data Warehouse by gathering business requirements, developing data dictionaries, and designing functional solutions throughout the software development lifecycle.

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

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
• 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