Technical Project Manager

I. CANDIDATE SKILLS AND QUALIFICATIONS

Minimum Requirements :

Must have required years below

Required Graduation from an accredited four-year college or university with a degree in computer science or a related field

8 Required Experience managing SDLC-based projects using Agile / Scrum

8 Required Experience with reporting tools (Power BI, Tableau, SSRS) and ETL technologies (IDMC, SSIS, Azure Data Facto ry).

8 Required Strong SQL skills and understanding of data warehousing concepts (snowflakes / star schemas, Slowly Changing Dimension, Datamart, Datalake, ODS, OLAP).

8 Required Experience in building Enterprise Datawarehouse, Datamart, Data Lake, Operational Data Store.

6 Required Strong leadership and ability to manage cross-functional technical teams

6 Required Experience with resource planning, project budgeting, and vendor coordination

6 Optional Experience with mainframe modernization or transformation projects (added advantage)

6 Required Excellent communication, presentation, and reporting skills

6 Required Experience in creating project plans, dashboards, Gantt charts, and executive status reports

6 Required Meticulous attention to detail with an ability to produce high-quality work in a dynamic environment

6 Required Highly organized and able to manage multiple projects at once and meet deadlines

6 Required Extensive skill in effective verbal and written communications with stakeholders

The Railroad Commission of Texas requires the services of a Technical Project Manager, hereafter referred to as Candidate, who meets the general qualifications for this role and the specifications outlined in this document for Railroad Commission of Texas.

The Candidate will lead cross-functional teams through the execution of complex technical Reports and Extracts-related projects, including those primarily from the Mainframe Transformation initiative. We're seeking a Technical Project Manager with deep experience delivering enterprise reporting and analytics solutions. In this role, you will lead cross-functional teams through the full project lifecycle-requirements gathering, design, development, testing, and deployment of dashboards, ETL pipelines, and reporting platforms (e.g., Power BI, SSRS). You'll partner closely with business stakeholders, data engineers, and QA to translate reporting needs into scalable technical solutions, ensuring on-time delivery and data quality. The Candidate will be responsible for delivering multiple Reports and Extracts-related projects on schedule and within approved scope by applying project management best practices, ensuring scope alignment, managing stakeholder expectations, and tracking project risks and issues. The ideal candidate will have technical acumen to understand architecture and integration efforts from multiple database technologies and provide oversight across SDLC phases of report and extract development using Waterfall, Agile, and Hybrid methodologies.

Key Responsibilities

• Project Planning & Execution

o Develop and maintain detailed project plans, schedules, and resource allocations for reporting initiatives.

o Define clear milestones : requirements sign-off, data mapping, ETL or ELT build, report development, quality testing, and production cutover.

o Facilitate workshops with business units to elicit reporting requirements and KPI definitions.

o Document functional specifications, data mapping for source and target, data dictionaries, including data quality and data integrity within the

acceptance criteria; manage change control when scope shifts.

o Engage with cross-functional teams, including quality, to ensure alignment of requirements and DW, DL, and ODS systems design.

o Develop a deep understanding of the RRC DW, DL, and ODS systems processes and operational challenges.

o Experience initiating and completing business intelligence (BI) reports and dashboards, data warehousing and / or analytical projects with minimal

guidance

o Simplify complex issues and deliver clear and concise information to all level of technical and business users within RRC.

o Negotiate with business users to define project scope for development and deployment of new reports and extracts, from the pre-determined

mainframe reports and extract scope. Schedule and deliverables must follow a strict path as it must be coordinated with other efforts. The

estimation of technical efforts and identification of risks must be known and tracked for each effort.

o Foster and maintain strong relationships with business users and IT Technical staff.

o Coordinate with data architects and engineers on ETL design (IDMC, SQL, SSIS, SSRS, Azure Data Factory, Mulesoft, GoAnywhere, and the

Scheduling Tool) and data modeling (snowflake / star schemas, Slowly Changing Dimensions, Normalizations, cubes, dashboards, etc.).

o Oversee report / dashboard development in Power BI, and possibly SSRS, ensuring performance tuning and security (row-level).

o Experience in Enterprise Datawarehouse, Data Lake, Datamart, ODS, Normalization, VSAM files.

o Work with stakeholders to build and lead a high-quality BI and Data Warehousing team, designing it to scale

o Manage data warehouse plans, drive data quality, and ensure operational efficiency is maintained when new reports are developed

o Drive efficiency and speed, project management leadership, and a vision for how BI can proactively improve

o Single Point of Contact (SPOC) for Cross functional interface for Data collection and Analysis critical for moving Reports and Extract off of the RRC

mainframe

o Design, build, and launch new BI reports and pipelines in production; Deliver high-impact dashboards and data visualizations

o Responsible for ensuring all department and RRC driven Reporting requirements are completed within SLA, while identifying any improvements in

the data governance and report-related processes in place

o Work with large and complex data sets to solve a wide array of challenging problems

o Experience with data querying languages (e.g. SQL), ETL Tools (IDMC), Reporting Tools (PowerBI, OBIEE) and development experience in at least

one object-oriented language (Python, Java, etc.)

o Establish test plans for data accuracy, performance, and user acceptance.

o Manage release pipelines using CI / CD (e.g., Azure DevOps), coordinate cutover, and PM support hypercare for 30 days post go-live.

o Identify project risks (data latency, source system changes, user training) and drive mitigation strategies.

o Provide regular status updates and escalations to leadership and governance forums.

o Develop best-practices playbooks for reporting governance, version control, and documentation.

o Facilitate post-project retrospectives to capture lessons learned and optimize future delivery.