Lead Business Intelligence Engineer

Who We Are

NFP, an Aon Company, is a multi-year 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 are an organization of consultative advisors and problem solvers. We help companies and individuals around the globe address their most significant risk, workforce, wealth management and retirement challenges through custom solutions and a people-first approach. To learn more, please visit: https://www.NFP.com.

This is a hybrid position with in-office flexibility 2-3 days a week.

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 

NFP is proud to offer a competitive salary, PTO and paid holidays, 401(k) with match, exclusive discount programs, health and wellness programs, and more. Our people-first 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.