Acrisure

Information Developer II

Acrisure$110K — $130K *
Information Technology
5 - 7 years of experience
Job Overview by Ladders

Qualifications

  • 7+ years experience with Microsoft SQL Server T-SQL, including writing queries and stored procedures.
  • 7+ years using Microsoft SQL Server Business Intelligence suite tools (SSMS, SSIS, SSRS, Power BI).
  • Proficiency in Visual Basic or C#.
  • Familiarity with cloud services like Azure Data Factory and AWS is a plus.
  • Knowledge of Agile, Scrum, and Kanban for managing development processes.
  • Experience with integrations involving HealthPac, Microsoft Business Central, and Salesforce.

Responsibilities

  • Write T-SQL queries for departmental data extraction.
  • Maintain and develop reports using SSRS and Power BI.
  • Create and manage SSIS packages for data transfer via SFTP.
  • Integrate external vendors and cloud systems using APIs.
  • Facilitate communication with vendors and stakeholders for reporting needs.

Benefits

  • Remote work flexibility available.
  • Opportunities for mentorship and skill development.
  • Occasional travel for team-building and strategy meetings.
  • Focus on continuous learning with resources provided for emerging technologies.
Full Job Description
Job Description

Information Developer II

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.

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.

About Acrisure

Acrisure is an insurance brokerage firm that provides a range of insurance products and services to businesses and individuals. The company was founded in 2005 and is headquartered in Caledonia, Michigan. Acrisure offers a wide range of insurance products, including property and casualty, employee benefits, and personal lines insurance. The company has grown rapidly through a series of acquisitions, and now has over 500 offices in the United States and around the world. Acrisure has been recognized as one of the fastest-growing companies in the United States, and has won numerous awards for its innovative insurance products and services.
Learn more about Acrisure
Size
7,000 employees
Industry
Founded
2006

Similar Jobs

More Jobs at Acrisure

More Information Technology Jobs

Find similar Information Developer II jobs: