JPI is seeking a Senior Software Developer specializing in Applications for SSRS and Power BI will provide advanced expertise in designing, developing, and optimizing reporting solutions. They shall be a key resource by interpreting complex data requirements, design visually compelling reports, and integrate reporting solutions seamlessly with existing systems. Ability to provide user training on SSRS and Power BI reports, ensuring that stakeholders understand how to interpret and utilize the information effectively. Offer responsive support to address user queries and issues. 

At JPI, we strive to empower our people and excel for our clients. We hold ourselves to high standards and prioritize our values of being one team with unwavering integrity. We are motivated by perpetual innovation and delivering passionate service to our clients.

Qualifications: 

• Demonstrate expertise in designing and developing complex reports using SQL Server SSRS, including the ability to create dynamic and interactive reports and dashboards. 

• Possess advanced skills in developing Power BI solutions, including the creation of interactive dashboards, reports, and data visualizations that provide meaningful insights. 

• Showcase a deep understanding of data modeling concepts, with the ability to analyze and structure data effectively for both SSRS and Power BI reporting solutions. 

• Have experience integrating SSRS and Power BI reports into existing applications and systems, ensuring seamless data flow and user accessibility. 

• Strong SQL skills and a deep understanding of relational databases, enabling efficient data retrieval and manipulation for reporting purposes. 

• Ability to customize and brand SSRS reports and Power BI dashboards to align with organizational standards and provide a cohesive user experience. 

Responsibilities include, but are not limited to:

• Assist with day-to-day functions, queries, and data calls.
• Conduct comparative analysis of data output system to ensure accuracy.
• Debug any function errors and provide fixes accordingly.
• Make recommendations for streamlining current and new program processes.
• Maintain database structures and remove redundancies to reduce or eliminate the need for future restructuring due to outside changes as much as possible.
• Maintain and develop user guides for existing databases.
• Maintain all system and database permissions.
• Perform ad hoc queries and VBA code base changes to match any changes from data sources to complete data processing requirements.
• Perform end user reports and systems functions as needed.
• Perform regular error reporting and regular data integrity checks.
• Process backlogged data process items to ensure items are addressed.
• Provide input on risk and issue tracking and mitigation strategies.
• Provide guidance and direction in the fielding of common software of client’s network.
• Test and document performance (time) efficiencies gained over the course of the development process.

• BA/BS with 6 years of experience or master’s degree with 5 years of experience
• Active Public Trust Clearance
• Proficiency in the following Microsoft applications: Word, Excel, PowerPoint, Outlook, One Note, Project, Visio, Teams, PowerBI
• Experience using SSRS & PowerBI
• Experience with the Extract, Transform and Load (ETL) process
• Experience in Database Architecture
• Comfortable communicating with a range of stakeholders both orally and in email.
• Experience building and maintaining a trusting relationship with the client and prioritizing demands.
• Must be a self-starter with the ability to work effectively independently.
• Proven ability to support and coordinate multiple projects simultaneously in a deadline driven process.
• Must be a US citizen.
• Must be able to obtain a Public Trust clearance.

JPI is committed to creating a diverse environment and is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status.