Sr. Data Engineer
firstPRO, Inc
•
Mt. Laurel, NJ
0
0
0
0
Mid-Senior level
Posted March 26, 2026
Job link
Thinking about this job
Responsibilities
Responsibilities
- Develop management and client reports using SSRS, Power BI or other designated tool.
- Create and optimize MSSQL queries, stored procedures, views and user-defined functions.
- Create and manage report and dataset distribution functions via SSRS to recipients via email, file share, FTP or other designated method.
- Prepare and execute test plans to validate data accuracy.
- Administer user access to reporting via the web client and FTP site.
- Responsible for development of management reporting package and assist with ad-hoc data requests for various transactions and modeling purposes.
- Work with internal staff and consultants to integrate reporting data with disparate systems, as needed.
- Create and support processes to import data from third- party vendors to be used for internal reporting purposes.
Not Met Priorities
What still needs stronger evidence
Requirements
- 5+ years’ experience in SQL Server Reporting Services, Power BI, or Business Objects.
- MSSQL proficiency in data extraction, manipulation, transformation and integration.
- Proficiency with SQL Server Management Studio.
- Ability to bring disparate pieces of data together for reporting purposes using a variety of software programs such as MS Access, Excel, SQL server and Power BI to gather and interpret data.
- Exceptional ability to communicate data insights effectively with management, clients and other non-technical audiences to understand their reporting needs.
- Familiarity with accounting software packages (e.g., Quickbooks)
- Strong organizational skills with the ability to handle multiple projects simultaneously while focusing on continuous improvement.
- Understanding of web services.
Preferred Skills
- Visual Studio experience.
- Experience in a loan or payment plan origination and servicing environment
- Experience with financial modeling.
- Microsoft Power Platform experience to automate tasks.
- Demonstrated use of artificial intelligence resources to simplify development.
- Advanced Power BI expertise including DAX, Power Query, data modeling, report design and dashboard UX principles.
Description: The Data Analyst role is responsible for designing and delivering reporting and analytics solutions by leveraging SQL Server Reporting Services (SSRS). This position has a primary focus on creating static and interactive reports that drive business processes and decisions across the company. The solutions developed by the Data Analyst also enable critical data to be accessible by clients on-demand or on a regularly scheduled basis. This individual will work closely with company management, accounting and sales to develop the solutions. Job Functions:
Develop management and client reports using SSRS, Power BI or other designated tool.
Create and optimize MSSQL queries, stored procedures, views and user-defined functions.
Create and manage report and dataset distribution functions via SSRS to recipients via email, file share, FTP or other designated method.
Prepare and execute test plans to validate data accuracy.
Administer user access to reporting via the web client and FTP site.
Responsible for development of management reporting package and assist with ad-hoc data requests for various transactions and modeling purposes.
Work with internal staff and consultants to integrate reporting data with disparate systems, as needed.
Create and support processes to import data from third- party vendors to be used for internal reporting purposes. Necessary Skills:
5+ years’ experience in SQL Server Reporting Services, Power BI, or Business Objects.
MSSQL proficiency in data extraction, manipulation, transformation and integration.
Proficiency with SQL Server Management Studio.
Ability to bring disparate pieces of data together for reporting purposes using a variety of software programs such as MS Access, Excel, SQL server and Power BI to gather and interpret data.
Exceptional ability to communicate data insights effectively with management, clients and other non-technical audiences to understand their reporting needs.
Familiarity with accounting software packages (e.g., Quickbooks)
Strong organizational skills with the ability to handle multiple projects simultaneously while focusing on continuous improvement.
Understanding of web services. Preferred Skills:
Visual Studio experience.
Experience in a loan or payment plan origination and servicing environment
Experience with financial modeling.
Microsoft Power Platform experience to automate tasks.
Demonstrated use of artificial intelligence resources to simplify development.
Advanced Power BI expertise including DAX, Power Query, data modeling, report design and dashboard UX principles.
Develop management and client reports using SSRS, Power BI or other designated tool.
Create and optimize MSSQL queries, stored procedures, views and user-defined functions.
Create and manage report and dataset distribution functions via SSRS to recipients via email, file share, FTP or other designated method.
Prepare and execute test plans to validate data accuracy.
Administer user access to reporting via the web client and FTP site.
Responsible for development of management reporting package and assist with ad-hoc data requests for various transactions and modeling purposes.
Work with internal staff and consultants to integrate reporting data with disparate systems, as needed.
Create and support processes to import data from third- party vendors to be used for internal reporting purposes. Necessary Skills:
5+ years’ experience in SQL Server Reporting Services, Power BI, or Business Objects.
MSSQL proficiency in data extraction, manipulation, transformation and integration.
Proficiency with SQL Server Management Studio.
Ability to bring disparate pieces of data together for reporting purposes using a variety of software programs such as MS Access, Excel, SQL server and Power BI to gather and interpret data.
Exceptional ability to communicate data insights effectively with management, clients and other non-technical audiences to understand their reporting needs.
Familiarity with accounting software packages (e.g., Quickbooks)
Strong organizational skills with the ability to handle multiple projects simultaneously while focusing on continuous improvement.
Understanding of web services. Preferred Skills:
Visual Studio experience.
Experience in a loan or payment plan origination and servicing environment
Experience with financial modeling.
Microsoft Power Platform experience to automate tasks.
Demonstrated use of artificial intelligence resources to simplify development.
Advanced Power BI expertise including DAX, Power Query, data modeling, report design and dashboard UX principles.