Additional details:
The Department of Corrections has been replacing critical legacy applications for the past couple years. DOC partnered with a vendor that specializes in SaaS solutions. DOC is happy with the vendor and the progress, but the SOMI still has a lot of work associated with this migration. The internal staff needs assistance, so the SOMI is looking to hire someone for a long-term contract. This person will be looking at the data, running queries and staging migration data in a SQL Server environment so the SaaS vendor can access the data. This is a great opportunity for someone that likes cleaning up data, testing the data, has some .NET skills and is willing to possibly make coding changes to resize images as one example.
SSRS/Power BI/.NET Developer
- Schedule report delivery utilizing data driven subscriptions, etc. in SSRS/Power BI.
- Create reports, dashboards, and charts using SSRS/Power BI to support data migration support, data quality analysis, and data migration analytics.
- Create SSRS/Power BI reports using report, drop-down, multi-valued parameters and debugging parameter issues in matrix reports and charts.
- Experience in creating multiple SSRS/Power BI reports in drill mode using tables, cross tabs and charts.
- Design and generate reports with different layouts using SSRS/Power BI and export them into Excel and/or PDF.
- Work closely with team members to solve business problems using SSRS/Power BI reports.
- Create report layouts using global expressions, functions, subtotals, sorting the data using SSRS/Power BI.
- Create cross-tab, drill-down, drill-through, linked reports and sub-reports with SSRS/Power BI.
- Optimized SQL Server stored procedures and long running queries using query-optimization techniques.
- Ensure that all development projects adhere to strict development guidelines including testing, acceptance and rollout by implementing change management controls.
- Experience with all areas of .NET development including server-side, client-side, data retrieval, and management.
- Good communication skills.
- Analytical and problem-solving skills.
- Design conceptual, logical, and physical databases for use with SSRS/Power BI.
- Experience in designing and implementing logical data models for data warehouse.
- Generate reports using relational databases, relational data warehouse, and OLAP cubes.
- Experience with Azure DevOps desired.
- Ensure that all development projects adhere to strict development guidelines including testing, acceptance and rollout by implementing change management controls.
- Bachelor of Science degree in Computer Science preferred. A comparable degree and/or experience is acceptable.
- Minimum three years of development using .NET (C# and SQL), Microsoft SQL Server, TSQL, SSRS, Power BI, Stored Procedures, database functions required.