Overview
On Site
Depends on Experience
Contract - W2
Contract - Independent
Contract - 12 Month(s)
Skills
ADF
SQL
SLA
ServiceNow
Azure Portal
Extract
Transform
Load
Microsoft Azure
Job Details
Job Description:
***Crop to Crop resumes are accepted
Location Requirement: This position requires candidates to be in onsite 5 days a week. Candidates must be LOCAL.
Work involves planning, developing, implementing, and monitoring BI solutions and supporting TxDoT ITD process for ITBM application that tracks financials and performance metrics for service providers. Works under minimal supervision, with extensive latitude for the use of initiative and independent judgement. DUTIES - The essential duties for this contract include:
- Proactively developing enhancements based on customer requirements to ensure growth in the application
- Ability to learn Input application processes to understand source data impact to core application
- Review, confirm understanding of Service Provider contracted requirements (e.g., financial exhibits, SLA exhibits)
- Design, build and deploy BI solutions and ADF pipelines (e.g. reporting tools)
- ETL data tasks using ADF, SharePoint, SQL, ServiceNow and PowerBi
- Conduct unit testing and troubleshooting
- Integration of PowerBI reporting with variety of applications and tools, including ServiceNow
- Evaluate and improve existing BI systems, proactively collaborate with teams to integrate systems
- Support definition of financial Billing Triggers (source data, algorithms), and SLA Triggers (source data, algorithms)
- Support documentation for source systems (e.g., ITSM, project management) definition of source system data requirements
- Review, confirm understanding of target system processing logic (e.g., services, rates, calculations)
- Perform development and configuration of target system including data input processing, calculation and charge/SLA processing, report configuration, invoice reconciliation processing
- Perform peer code reviews
- Perform development and configuration of reports
- Support development of test plans and create test plan data (unit, system, UAT, performance)
- Execute test plans (unit, system, UAT, performance) and resolve defects
- Support development of Operational Readiness plan
- Support activities to ensure the system is operationally ready for go-live
- Document ITFM/ITSLM operational processes
Required Skills:
- 8+ - Experience with Information Technology projects
- 8+ - Experience developing and organizing IT Application departments according to the mission and goals of the organization
- 8+ - Possess strong verbal and written skills in communicating with peers and different levels of users including executive staff.
- 8+ - Experience building relationships with executive level leadership from multiple business units
- 8+ - Recognize business requirements in the context of BI and create data models to transform raw data into relevant insights
- 8+ - Experience with ADF pipelines, Azure Portal, GitHub
Desired Skills:
- Experience with ServiceNow or other ticketing system a plus
- Experience with Service Level Agreements a plus
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.