Santa Monica Seafood · 2 months ago
Technical Business Analysist & Software Developer
Los Angeles, CA
Full-time
Onsite
Senior Level
$150K/yr - $175K/yr
5+ years expSanta 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 design and implement data-driven solutions, streamline operational workflows, and build custom software/reporting tools to empower strategic decision-making across the organization.
Food and Beverage
Responsibilities
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
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)
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
Qualification
Required
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
Preferred
Full Stack Development skills
Hands-on accounting experience
Experience in perishables or food industry operations
AI/ML experience
MCP integration
Benefits
Competitive pay
Top-tier health benefits
Company-paid life and disability insurance
401(k) with a generous company match
Tuition assistance
Continuous learning
Clear career paths within our IT and business systems teams
Company
Santa Monica Seafood
Santa Monica Seafood is a full-service fresh and frozen seafood processor and distributor.
Founded in 1939Rancho Dominguez, California, USA
501-1000 employees
H1B Sponsorship
Santa Monica Seafood has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (1)
Funding
Current Stage
Late StageLeadership Team
Roger O’Brien
President and CEO
Recent News
Company data provided by crunchbase