ITBM Developer Lead

ITBM Developer Lead

Remote within Texas (Austin local preferred, if local must work onsite 2 days/wk)

6-8 months contract with possibility to extension

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 judgment. May direct the work of others. The essential duties for this contract include:

• Translate business needs to technical specifications
• Design, build and deploy BI solutions (e.g. reporting tools)
• Maintain and support data analytics platforms (e.g. MicroStrategy)
• Create tools to store data (e.g. OLAP cubes)
• Conduct unit testing and troubleshooting
• Evaluate and improve existing BI systems, collaborate with teams to integrate systems
• Develop and execute database queries and conduct analyses
• Create visualizations and reports for requested projects
• Develop and update technical documentation
• Review, confirm understanding of Service Provider contracted requirements (e.g., financial exhibits, SLA exhibits)
• 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

Required Skills:

Years - Skills/Experience

9 - Experience with Information Technology projects

5 - Experience designing and deploying BI solutions using Power BI and Tableau; experience with data warehousing projects, data preparation, and data gateways

5 - Create, test, and deploy Power BI scripts, as well as execute efficient deep analysis

5 - Experience working with Microsoft Business Intelligence Stack having Power BI, SSAS, SSRS, and SSIS

5 - Experience in data preparation, data gateway, and data warehousing projects

5 - Experience using JavaScript, CSS, SQL, and other JavaScript libraries

5 - Recognize business requirements in the context of BI and create data models to transform raw data into relevant insights

5 - Experience developing and organizing IT Application departments according to the mission and goals of the organization

3 - Experience with software and/or asset management, include reporting of compliance metrics

8 - Possess strong verbal and written skills in communicating with peers and different levels of users including executive staff.