Technical Business Analysist & Software Developer

Technical Business Analyst & Software Developer

Innovation drives our future; and quality and service remain at the core.

Overview

Santa Monica Seafood is seeking a seasoned Technical Business Analyst with a strong blend of software development, report writing, and business analysis expertise. The ideal candidate will also have hands-on experience in accounting, the food industry, and business operations relevant to food production and distribution.

This cross-functional role will be instrumental in designing and implementing data-driven solutions, streamlining operational workflows, and building custom software / reporting tools that empower strategic decision-making across the organization.

Key Responsibilities

Report Writing Duties (30%)

Analyze business requirements and convert them into functional specifications.

Create and maintain Power BI dashboards and ERP reports.

Ensure data consistency across platforms (e.g., ERP, CRM, databases). This includes data normalization and standardization.

Monitor KPIs and deliver actionable insights.

Utilize tools such as SQL profiler to translate end user transactions to affected tables for effective report writing.

Setup and maintain data exchange gateways such as PowerBI Gateways.

Train users on Power BI and troubleshoot data / reporting issues.

Software / Integration Developer (50%)

Develop and maintain complex SQL queries, functions, and stored procedures.

Build scalable, secure enterprise applications.

Integrate emerging technologies including AI / ML.

Define and uphold best practices for coding, software architecture, and system integrations, conducting code check-ins and code reviews to maintain high development standards.

Collaborate cross-functionally on solutions and systems integration.

Adopt best practices and innovative software design methodologies.

Use tools such as SQL Profiler to trace transaction activity, identify affected tables, and troubleshoot system locks and / or performance issues.

Monitor cloud and on-prem BSA assets (AWS, Azure, custom apps).

Business Analyst (20%)

Conduct gap analysis, process modeling, and document workflows.

Support M&A, company expansions, and new business startups.

Compose internal and external SOPs, user guides, videos, and documentation.

Participate in the development and execution of effective training programs.

Promote automation to replace manual processes and implement changes to improve processes and workflows.

Consult with VP of Enterprise Solutions and other department leadership regarding ongoing process improvements or changes, potential impact of those changes.

Provide helpdesk support to business operation.

Demonstrate ability to manage conflicting priorities and challenging situations.

Required Qualifications

5+ years in software development / reporting / business analysis.

Strong in SQL (Transact-SQL), Python, Power BI, and cloud platforms.

Experience with Microsoft BI Stack : SSRS, SSIS, SSAS.

Expertise in data modeling, data warehousing, ETL processes.

Background in accounting or financial reporting.

Proven experience in fast-paced environments with tight deadlines.

Familiarity with integrations.

Hands-on with cloud databases (Azure SQL DB, MS SQL DB).

Solid experience in automated testing and QA.

Nice to Have

Full Stack Development skills.

Hands-on accounting experience.

Experience in perishables or food industry operations.

AI / ML experience.

MCP integration.

Nice for You

At Santa Monica Seafood, you'll find more than a job you'll find purpose. We offer competitive pay, top-tier health benefits, company-paid life and disability insurance, and a 401(k) with a generous company match. Plus, we invest in your growth with tuition assistance, continuous learning, and clear career paths within our IT and business systems teams. Join a company that blends tradition with innovation and build something that lasts.