| Job Title: | Crystal Reports/Power BI Technical Specialist (Hybrid Onsite) |
| Location: | Trenton NJ |
| Duration: | 6 months with plans to extend the engagement. |
| Interview Process: | Web Cam Interview Only |
| Job Description | The Power BI & Crystal Reports Consultant will serve as a subject-matter expert in business intelligence responsible for designing developing testing and maintaining advanced data visualizations dashboards and operational reporting solutions that support strategic decision-making across the Office of the Public Defender. This role bridges technical analytics with mission-critical public defense work by turning complex legal case and performance data into clear actionable insights for stakeholders throughout the organization. Key Responsibilities -
BI Reporting & Development: Design develop implement and maintain interactive dashboards reports and visual analytics using Power BI and Crystal Reports to support legal services operational performance caseload management and executive reporting. -
Data Visualization & Insight: Translate complex datasets into intuitive high-impact visualizations that facilitate data-driven decisions by leadership attorneys and administrative staff. -
Requirements Gathering: Partner with internal stakeholders to understand reporting needs define key performance indicators and translate business requirements into technical solutions. -
Data Integration & Modeling: Extract transform and model data from multiple systems - including case management and other data sources ensuring data integrity accuracy and performance for all BI deliverables. -
Performance Optimization: Maintain data quality and performance tuning of dashboards and reports; optimize data models and queries for efficiency and responsiveness. Testing & Quality Assurance: -
Work Product Testing: Conduct thorough validation of all reports and dashboards including functional testing of calculations filters visuals and data logic to ensure outputs are accurate and aligned with requirements. This includes validation of measures DAX calculations and data model integrity -
User Testing (UAT): Plan and execute structured user acceptance testing with representative end users to verify that reports meet functional and usability expectations. Ensure feedback is captured logged and resolved before production release. -
Regression Testing: Perform regression testing after updates enhancements or fixes to ensure previously working functionality is unaffected. Document test cases and results and collaborate with stakeholders to resolve defects. -
User Support & Training: Provide training documentation and ongoing support to end users to promote BI adoption and self-service analytics capabilities. -
Governance & Best Practices: Ensure adherence to data governance privacy and security policies in all reporting activities. Required Qualifications -
Education: Bachelors degree in Data Analytics Computer Science Information Systems Criminal Justice Public Administration or a related field (or equivalent experience). -
Experience: Proven experience (typically 5 years)designing and delivering Power BI dashboards and Crystal Reports in a professional environment ideally within public sector legal or justice-related organizations. -
Technical Skills: -
Advanced knowledge of Power BI Desktop & Service DAX Power Query and related visualization best practices -
Expert proficiency building operational and enterprise reports in Crystal Reports. -
Strong SQL skills for querying and transforming data from relational databases. -
Communication: Excellent verbal and written communication skills with the ability to present complex data insights clearly to technical and non-technical audiences. -
Analytical Mindset: Strong analytical and problem-solving skills with attention to accuracy and detail. -
Collaboration: Demonstrated ability to work collaboratively with cross-functional teams including IT data governance and operational leadership. Preferred Qualifications -
Experience working within criminal justice public defense or government agency environments. -
Familiarity with case management systems and legal operations data. -
Exposure to additional BI tools (e.g. SSRS SSIS) and data pipeline processes. -
Prior experience training or mentoring junior BI professionals. Core Competencies -
Strategic Data Visualization: Ability to craft compelling narratives from data that influence decision-making and improve operational outcomes. -
User-Focused Design: Strong understanding of user experience for effective dashboard and report design. -
Adaptability: Comfortable working in a dynamic public-sector environment with evolving priorities. |
| Top Skills & Years of Experience | Required/Desired Skills | Skill | Required /Desired | Amount | of Experience | | Data Engineering & Database Skills | Required | 9 | Years | | Architecture Governance & Security | Required | 9 | Years | | Business & Stakeholder Leadership | Required | 9 | Years | | Advanced Crystal Reports design and optimization | Required | 9 | Years | | Power BI deployment pipelines (Dev/Test/Prod) - THOROUGH END TO END TESTING | Required | 9 | Years | |
| Recruiter Details: | Name : Contact : Eight three two - Nine nine zero -Two four two six |
About US:
GSK Solutions Inc. is a premier information technology services company dedicated to delivering exceptional consulting solutions and staff augmentation to our valued clients. With an unwavering commitment to quality timeliness and budgetary considerations we consistently strive to exceed client expectations building a strong reputation through our reliable execution. Our expertise spans commercial and custom product development covering information security software development consulting and IT audits. We excel in managing critical time-sensitive projects for Fortune 500 clients nationwide ensuring their success is always at the forefront of our mission
Job Title: Crystal Reports/Power BI Technical Specialist (Hybrid Onsite) Location: Trenton NJ Duration: 6 months with plans to extend the engagement. Interview Process: Web Cam Interview Only Job Description The Power BI & Crystal Reports Consultant will serve as a s...
| Job Title: | Crystal Reports/Power BI Technical Specialist (Hybrid Onsite) |
| Location: | Trenton NJ |
| Duration: | 6 months with plans to extend the engagement. |
| Interview Process: | Web Cam Interview Only |
| Job Description | The Power BI & Crystal Reports Consultant will serve as a subject-matter expert in business intelligence responsible for designing developing testing and maintaining advanced data visualizations dashboards and operational reporting solutions that support strategic decision-making across the Office of the Public Defender. This role bridges technical analytics with mission-critical public defense work by turning complex legal case and performance data into clear actionable insights for stakeholders throughout the organization. Key Responsibilities -
BI Reporting & Development: Design develop implement and maintain interactive dashboards reports and visual analytics using Power BI and Crystal Reports to support legal services operational performance caseload management and executive reporting. -
Data Visualization & Insight: Translate complex datasets into intuitive high-impact visualizations that facilitate data-driven decisions by leadership attorneys and administrative staff. -
Requirements Gathering: Partner with internal stakeholders to understand reporting needs define key performance indicators and translate business requirements into technical solutions. -
Data Integration & Modeling: Extract transform and model data from multiple systems - including case management and other data sources ensuring data integrity accuracy and performance for all BI deliverables. -
Performance Optimization: Maintain data quality and performance tuning of dashboards and reports; optimize data models and queries for efficiency and responsiveness. Testing & Quality Assurance: -
Work Product Testing: Conduct thorough validation of all reports and dashboards including functional testing of calculations filters visuals and data logic to ensure outputs are accurate and aligned with requirements. This includes validation of measures DAX calculations and data model integrity -
User Testing (UAT): Plan and execute structured user acceptance testing with representative end users to verify that reports meet functional and usability expectations. Ensure feedback is captured logged and resolved before production release. -
Regression Testing: Perform regression testing after updates enhancements or fixes to ensure previously working functionality is unaffected. Document test cases and results and collaborate with stakeholders to resolve defects. -
User Support & Training: Provide training documentation and ongoing support to end users to promote BI adoption and self-service analytics capabilities. -
Governance & Best Practices: Ensure adherence to data governance privacy and security policies in all reporting activities. Required Qualifications -
Education: Bachelors degree in Data Analytics Computer Science Information Systems Criminal Justice Public Administration or a related field (or equivalent experience). -
Experience: Proven experience (typically 5 years)designing and delivering Power BI dashboards and Crystal Reports in a professional environment ideally within public sector legal or justice-related organizations. -
Technical Skills: -
Advanced knowledge of Power BI Desktop & Service DAX Power Query and related visualization best practices -
Expert proficiency building operational and enterprise reports in Crystal Reports. -
Strong SQL skills for querying and transforming data from relational databases. -
Communication: Excellent verbal and written communication skills with the ability to present complex data insights clearly to technical and non-technical audiences. -
Analytical Mindset: Strong analytical and problem-solving skills with attention to accuracy and detail. -
Collaboration: Demonstrated ability to work collaboratively with cross-functional teams including IT data governance and operational leadership. Preferred Qualifications -
Experience working within criminal justice public defense or government agency environments. -
Familiarity with case management systems and legal operations data. -
Exposure to additional BI tools (e.g. SSRS SSIS) and data pipeline processes. -
Prior experience training or mentoring junior BI professionals. Core Competencies -
Strategic Data Visualization: Ability to craft compelling narratives from data that influence decision-making and improve operational outcomes. -
User-Focused Design: Strong understanding of user experience for effective dashboard and report design. -
Adaptability: Comfortable working in a dynamic public-sector environment with evolving priorities. |
| Top Skills & Years of Experience | Required/Desired Skills | Skill | Required /Desired | Amount | of Experience | | Data Engineering & Database Skills | Required | 9 | Years | | Architecture Governance & Security | Required | 9 | Years | | Business & Stakeholder Leadership | Required | 9 | Years | | Advanced Crystal Reports design and optimization | Required | 9 | Years | | Power BI deployment pipelines (Dev/Test/Prod) - THOROUGH END TO END TESTING | Required | 9 | Years | |
| Recruiter Details: | Name : Contact : Eight three two - Nine nine zero -Two four two six |
About US:
GSK Solutions Inc. is a premier information technology services company dedicated to delivering exceptional consulting solutions and staff augmentation to our valued clients. With an unwavering commitment to quality timeliness and budgetary considerations we consistently strive to exceed client expectations building a strong reputation through our reliable execution. Our expertise spans commercial and custom product development covering information security software development consulting and IT audits. We excel in managing critical time-sensitive projects for Fortune 500 clients nationwide ensuring their success is always at the forefront of our mission
View more
View less
Job Location:
Monthly Salary:
Not Disclosed
Posted on:
7 hours ago
Vacancies:
1 Vacancy
