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 team’s 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
$110,000 to $130,000
Pay Details:
The base compensation range for this position is $110,000 - $130,000. This range reflects Acrisure's good faith estimate at the time of this posting. Placement within the range will be based on a variety of factors, including but not limited to skills, experience, qualifications, location, and internal equity.
Candidates should be comfortable with an on-site presence to support collaboration, team leadership, and cross-functional partnership.
Why Join Us:
At Acrisure, we’re building more than a business, we’re 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 Children's Hospital in Grand Rapids, Michigan, UPMC Children's Hospital in Pittsburgh, Pennsylvania and Blythedale Children's 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 leaves@acrisure.com .
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.