Who We Are

NFP is a seven-time Best Places to Work award winner in Business Insurance who has also earned the 5-Star Diversity, Equity and Inclusion (DEI) award from Insurance Business magazine and the WORK180 employer endorsement. We’re a recognized Elite Agency award winner and a leading property and casualty broker, benefits consultant, wealth manager, and retirement plan advisor. NFP provides solutions enabling client success through the expertise of over 8,000 global employees, investments in innovative technologies, and enduring relationships with highly rated insurers, vendors and financial institutions. To learn more, please visit: https://www.NFP.com.

Responsibilities:

Design, develop and Test ETL processes per business requirements; Plan deployments, moving from Dev to QA to Production environments; Load/extract data from/to multiple data sources including cloud applications (Salesforce.com and Applied Epic); Ensure designed systems are reliable, self-recovering and require minimal support; Work on troubleshooting data integration errors and identifying the data issues between data sources/targets; Gather reporting and analysis requirements and translate into reporting structured data models, including aggregate tables, pivoted tables, and relational and dimensional (star-schema) data marts; Work independently and collaboratively in the development, testing and implementation lifecycles; Define and document complex technical design/requirements for integrations and data warehousing; Develop/Maintain Informatica on demand Tasks; Develop /Maintain processes that conduct service calls through APIs that interface with applications on cloud; Document all of the following: business requirements, design requirements, and development work; Lead team of junior developers.

Supervises 2 Junior Developers

Education and Experience:

Bachelor’s degree in Engineering, Computer Science, Mathematics or a related field with 6 years of experience in business intelligence development. Four years of experience to include: Utilizing SSIS; and Utilizing SSAS or SSRS. Two years of experience to include: SQL Server Database; Reviewing business requirements; and leading a team.

What We Offer

We're proud to offer a competitive salary, PTO & paid holidays, 401(k) with match, exclusive discount programs, health & wellness programs, and more. Our PeopleFirst culture focuses on building and nurturing lifelong relationships with our employees because, at the end of the day, we exist to be there for others.

NFP and You... Better together!

NFP is an inclusive Equal Employment Opportunity employer.