Acrisure Trade Credit · 2 hours ago
SQL Developer
Acrisure Trade Credit is a third-party administrator providing affordable ACA-compliant benefits. They are seeking an Information Developer II to manage data file exchange implementations, integrate with cloud-based systems, and enhance efficiency across departments.
FinanceProperty & Casualty InsuranceCreditFinancial ServicesInsurance
Responsibilities
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
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
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
Qualification
Required
7+ years of Microsoft SQL Server T-SQL writing queries, stored procedures, views and functions
7+ years of Microsoft SQL Server Business Intelligence Development suite, including SSMS, SSIS, SSRS, Visual Studio, Report Builder, Power BI, and Power Automate
Experience with Visual Basic or C# is required
Working knowledge of Agile, Scrum, and Kanban methodologies to manage and streamline development processes
Experienced in integrating with HealthPac, Microsoft Business Central, and Salesforce systems
Strong problem-solving, critical thinking, and adaptability skills
Excellent communication and interpersonal skills to effectively collaborate with cross-functional teams and stakeholders
A commitment to continuous learning and staying updated with emerging technologies and industry trends
Mentoring Information Developer I position team members on our related tools and technologies
Preferred
Experience with Azure Data Factory, Logic Apps and AWS is desirable but not required
Postman experience desired but not required
Benefits
Comprehensive medical insurance
Dental insurance
Vision insurance
Life and disability insurance
Fertility benefits
Wellness resources
Paid sick time
Generous paid time off and holidays
Employee Assistance Program (EAP)
A complimentary Calm app subscription
Immediate vesting in a 401(k) plan
Health Savings Account (HSA) and Flexible Spending Account (FSA) options
Commuter benefits
Employee discount programs
Paid maternity leave
Paid paternity leave (including for adoptive parents)
Legal plan options
Pet insurance coverage