IT Senior Engineer

Strata-G•Oak Ridge, TN

2d•Onsite

About The Position

At Strata-G, we define significance by the extraordinary people we hire, the relationships we build with our clients, and the positive impact we make in the community. Our team of intellectually curious and highly motivated engineers, scientists and business professionals engages with our clients to solve complex energy and environmental challenges around the world. We are driven by our values to create a culture of significant and positive change for our clients and the world. We Care We treat our customers and employees as we wish to be treated. Integrity We are honest and ethical in every endeavor. Service We continuously strive to please our customers and to exceed their expectations. Quality We maintain a culture of continuous improvement. Safety We hold paramount the safety and health of our associates, our customers, the public, and the environment. Innovation We develop creative solutions to better serve our customers. Attitude We maintain a positive attitude and value humor. Outreach We share the results of our successes with the community. Strata-G is seeking an experienced IT Senior Engineer with the following: Summary: Performs professional work as an IT Senior Engineer assisting the PM-30 project management data analytics and DOE Project Analysis and Reporting System (PARS) teams with translating Access efforts into SQL and assisting with development of Power BI presentation within the Department of Energy, Office of Project Management, Project Controls Division (PM-30). This position will be 40 hours per week throughout the period of performance (PoP).

Requirements

Desired knowledge areas: Understanding of EVM concepts and tools used to build SQL structure and output in Power BI to support analytics.
Incumbent must have a valid identification to obtain an HSPD-12 badge through DOE, with document options at DHS PIV Card Acceptable Identity Source Documents .
Tests for the absence of any illegal drug as defined in 10 CFR 707.4, will be conducted by Strata-G and a background investigation by the Federal government may be required to obtain an access authorization prior to employment.

Responsibilities

Supporting PARS team for surge in SQL and Power BI requirements.
Assist PARS Developers in creating Power BI Dashboards to embed within the PARS application, either based on existing SSRS reports or according to specifications developed by PM
Assist PARS Developers by creating SQL stored procedures to support front-end web applications or back-end data processing applications
Develop stored procedures, tables, and other SQL infrastructure to support new DOE metrics, based on either written specifications or MS Access prototype programs
Enhance SSRS reports that have been migrated to Power BI Paginated Reports, improving functionality as needed
Assist with ongoing maintenance and performance improvements in PARS SQL infrastructure, hosted within Microsoft Azure SQL Managed Instances
Willingness to learn and implement new technologies such as GraphQL to support improved data access for PARS applications
Should be familiar with standard cost/scheduling EVMS and cost/scheduling tools and be able to interpret standard EVM terminology such as budget at completion, estimate at completion, schedule risk assessment, Monte Carlo simulation, random seed methods, estimate to complete, measures of location and error, predictive forecast analysis, duration-based percent complete.
Identifies and defines opportunities for improvement and suggestions for alternative courses of action related to SQL, Power BI.
Support PM-30 Performance Team in moving Data Analytics, Data Integrity and Quality Tool, and internal tools for IPM compliance metrics to PARS, moving from Access based tools to SQL and with Power BI output.
Work with PM-30 Data Analytics, PARS, and Performance team to move access-based capabilities, document development, and establish within PARS SQL data and reporting using Power BI.