Job Description :
Job ID: NC0804)

Microsoft R Developer with Power BI, SSRS and SSIS experience

Location: 3200 Atlantic Ave Raleigh NC (NCDST)
Duration: 12+ months
Interview- Either Webcam Interview or In Person

Years Required/Preferred Experience ;
Microsoft R Required 3 Years
Power BI Required 2 Years
SQL Server Reporting Services Required 5 Years
Microsoft SSIS Required 5 Years.

The Department of the State Treasurer is seeking a candidate to perform technical and analytical work supporting SLGFD in multiple analytics projects. The candidate will serve as part of a 4-person development team as well as work independently.

*Remote work is allowed until staff return to site. DST does not know when that will be at this time. The candidate will need to come to the office the first day for orientation and to get all equipment. He or she may be required to come onsite from time to time. The manager will provide as much notice as possible when required to come onsite.

The NC Department of State Treasurer (DST) is a dynamic state agency that serves the people of North Carolina through a variety of functions related to the personal and financial health of the state and its citizens. DST manages $100 billion in assets and the retirement systems for more than 900,000 members including teachers. firefighters, law enforcement officers. state and local government employees and other public workers. The department serves as the State’s Banker for all State agencies, universities, and community colleges, who are considered its customers. The department also administers the State Health Plan. which provides health benefits to more than 720,000 members and dependents. In addition, DST provides fiscal assistance and expertise to local governmental units by assisting them in the sale of local government debt obligations and in maintaining strong fiscal procedures, along with managing the NC Cash database that holds approximately 11.5 million properties valued at nearly $2 billion.

The Information Technology Division’s (ITD) primary purpose is to plan, develop, implement and the technology systems that meet the operational needs of DST. In of NC State and Local Government Finance Division (SLGFD) we are seeking a Data Analyst to with high level data architecture experience and the ability to perform hands-on development.

Development duties include:
*Perform data analysis and develop analytic solutions
*Work with Data Engineers, Data Architects, to define back-end requirements for data products (aggregations, materialized views, tables – visualization)
*Data investigation to discover correlations / trends and the ability to explain them
*Develop frameworks and processes to analyze unstructured information
*Assist in Azure Power BI architecture design

SLGFD handles the sale and delivery of all State and local debt and monitors the repayment of State and local government debt. Staff counsel and assist local governments in determining the feasibility of projects, the size of the financing and the most expedient form of financing. SLGFD is automating many manual processes and consolidating data. Mining models, dashboards and additional reporting needs will access structured and unstructured data from disparate sources.

The candidate is required to be proficient with MS SQL Server 2016, MS Power BI, SSRS, R, MS Visual Studio, and Excel. Additional skills in Azure Web Apps, DevOps , Python, are desired.

The candidate is required to have the ability to interact and serve as a technical resource to technicians and analysts. The candidate is required to possess a high technical knowledge level of data analysis and programming and must understand detailed technical issues to assist in designing the data architecture.

The candidate is required to interact with and serve as a key resource in solving problems of high complexity to other analysts and technicians. The candidate is required to possess the ability to recommend methods of resolving problems.

The candidate is required to consult with clients on issues and requests that require the implementation or creation of a custom solution. The candidate is required to plan and work on shared or joint projects and coordinate with others to achieve agreed upon outcomes.

The candidate is required to establish a positive relationship by demonstrating ownership of customer issues and solicit and select appropriate information and best method or format for delivering or receiving it either in writing or verbally.

Client : STATE OF NC