Information Developer II

Job Description

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.

Our Culture

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.

To perform this job successfully an individual must satisfactorily perform each essential duty. The requirements below represent knowledge skill and/or ability. Reasonable accommodation may be made to enable individuals with disabilities to perform basic functions.

Job Purpose

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.

Development and Performance Expectations

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

Required Skills Experience and Qualifications

Tools and technologies relevant to this position

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

Key Responsibilities

Development

• Write T-SQL queries to extract data for various departments reporting needs.

• Utilize Microsoft SSRS to maintain existing reports and develop new paginated reports.

• Utilize Microsoft Power BI to develop new dashboard reports and maintain existing ones.

• Create and maintain Microsoft SSIS packages to extract/import data using SFTP to send and receive files.

• Integrate with outside vendors and cloud-based systems using API connectivity.

Communication and Attributes

• Ability to communicate verbally and via email with vendors brokers and clients.

• Ability to build productive team relationships.

• Responsible for fully supporting the teams reporting and processes with little oversight.

• Self-motivated.

• Detailed.

• Organized.

• Works well under pressure.

Additional Duties

• Ability to learn new information at a reasonable pace by taking excellent notes and asking relevant questions.

• Ability to lead daily scrum stand-ups and sprint planning sessions.

• Maintain documentation for IS-related processes.

Compensation

$110000 to $130000

Pay Details:

Candidates should be comfortable with an on-site presence to support collaboration team leadership and cross-functional partnership.

Why Join Us:

At Acrisure were building more than a business were building a community where people can grow thrive and make an impact. Our benefits are designed to support every dimension of your life from your health and finances to your family and future.

Making a lasting impact on the communities it serves Acrisure has pledged more than $22 million through its partnerships with Corewell Health Helen DeVos Childrens Hospital in Grand Rapids Michigan UPMC Childrens Hospital in Pittsburgh Pennsylvania and Blythedale Childrens Hospital in Valhalla New York.

Employee Benefits

We also offer our employees a comprehensive suite of benefits and perks including:

• Physical Wellness: Comprehensive medical insurance dental insurance and vision insurance; life and disability insurance; fertility benefits; wellness resources; and paid sick time.

• Mental Wellness: Generous paid time off and holidays; Employee Assistance Program (EAP); and a complimentary Calm app subscription.

• Financial Wellness: Immediate vesting in a 401(k) plan; Health Savings Account (HSA) and Flexible Spending Account (FSA) options; commuter benefits; and employee discount programs.

• Family Care: Paid maternity leave and paid paternity leave (including for adoptive parents); legal plan options; and pet insurance coverage.

• and so much more!

This list is not exhaustive of all available benefits. Eligibility and waiting periods may apply to certain offerings. Benefits may vary based on subsidiary entity and geographic location.

Acrisure is an Equal Opportunity Employer. We consider qualified applicants without regard to race color religion sex national origin disability or protected veteran status. Applicants may request reasonable accommodation by contacting .

Final candidates will be required to complete post-offer verification processes related to the role and in accordance with applicable laws.

California Residents: Learn more about our privacy practices for applicants by visiting the Acrisure California Applicant Privacy Policy.

Recruitment Fraud: Please visit here to learn more about our Recruitment Fraud Notice.

Welcome your new opportunity awaits you.