Information Developer II

Company Overview

SBMA, a third-party administrator, is an affordable ACA‑compliant benefits provider to thousands of employers. Their goal is to simplify the complexity of providing employee benefits. SBMA differentiates itself through personal service, implementation speed, and innovative benefits coverage approach.

SBMA is currently seeking an Information Developer II to join our team. This team member will work on managing data file exchange implementations with vendors, integrating with remote or cloud-based systems, and working with other departments to make repetitive and IT-related functions more efficient.

This department fosters a culture of transparency and learning through direct and frequent communication, cross-training, mentorship, and simply trying new things. We believe in:

• Open Communication:
  Encouraging open dialogue and feedback to ensure everyone is heard and valued.
• Continuous Learning:
  Promoting a growth mindset by providing opportunities for professional development and skill enhancement.
• Collaboration:
  
  Working together across departments to achieve common goals and drive innovation.
• Mentorship:
  Supporting team members through regular one-on-one sessions, hands-on learning experiences, and career guidance.
• Innovation:
  Embracing new ideas and approaches to improve processes and deliver exceptional results.

We seek an Information Developer II to join our growing team of Information Developers. This position will require managing data file exchange implementations with vendors, integrating with remote or cloud-based systems, and working with other departments to make repetitive and IT-related functions more efficient. The individual will report directly to the Business Information Development Manager.

The Information Developer II is expected to actively engage in development work with a broad understanding of the internal and external databases and datasets available to the team. Exemplifying attention to detail, a high work ethic, and a desire to thrive in an environment of constant learning and improvement are implicit in this position. Remote work is available. Occasional team-building events are completed remotely or in person.

Some travel to our San Diego, CA, home office for annual or quarterly strategy meetings or special company events may be offered on occasion. A path towards growth and development will include mentorship by the Business Information Development Manager and team leadership. Training in specific technologies used by team members and skills developed in this role will be supported through online or remote training.

• Database Development: 7+ years of Microsoft SQL Server T-SQL writing queries, stored procedures, views and functions.
• Business Intelligence Development: 7+ years of Microsoft SQL Server Business Intelligence Development suite, including SSMS, SSIS, SSRS, Visual Studio, Report Builder, Power BI, and Power Automate.
• Programming
  
  Languages:
  
  Experience with Visual Basic or C# is required.
• Cloud Services:
  Experience with Azure Data Factory, Logic Apps and AWS is desirable but not required.
• Agile Methodologies:
  Working knowledge of Agile, Scrum, and Kanban methodologies to manage and streamline development processes.
• Integration
  
  Experience:
  
  Experienced in integrating with Health Pac, Microsoft Business Central, and Salesforce systems. Postman experience desired but not required.
• Soft Skills:
  
  Strong problem-solving, critical thinking, and adaptability skills. Excellent communication and interpersonal skills to effectively collaborate with cross-functional teams and stakeholders.
• Continuous Learning: A commitment to continuous learning and staying updated with emerging technologies and industry trends.
• Mentorship:
  Mentoring Information Developer I position team members on our related tools and technologies.

• Write T-SQL queries to extract data for various departments' reporting needs.
• Utilize Microsoft SSRS to maintain existing reports and develop new paginated…