Technical Business Analyst & Software Developer

Job Brief Drive enterprise technology transformation by developing and integrating data-driven systems that connect operations, finance, and production. You’ll design smarter solutions, automate workflows, and turn complex business needs into scalable tools. Pay range: $150k to $175k base plus incentive opportunity Technical Business Analysist & 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 ResponsibilitiesReport 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 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 integrationNice 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.