Technical Project Manager

Allied Consultants, Inc. is a Top Ten ranked vendor for the State Government of Texas. Contracted with the State for 33 years, Allied has been a top-tier provider of technical and business professionals to clients in Texas. We are currently seeking an experienced PeopleSoft Administrator to be a key resource on a technical services team for our client, the Railroad Commission of Texas (RRC).

Job Location:

Remote - RRC's preference is for candidates to be based in the Greater Austin, Texas area.

Responsibilities

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.

Project Planning & Execution: Develop and maintain detailed project plans, schedules, and resource allocations for reporting initiatives. Define clear milestones: requirements sign-off, data mapping, ETL or ELT build, report development, quality testing, and production cutover.

• 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.).
• Oversee report/dashboard development in Power BI, and possibly SSRS, ensuring performance tuning and security (row-level).
• Experience in Enterprise Datawarehouse, Data Lake, Datamart, ODS, Normalization, VSAM files.
• Work with stakeholders to build and lead a high-quality BI and Data Warehousing team, designing it to scale
• Manage data warehouse plans, drive data quality, and ensure operational efficiency is maintained when new reports are developed
• Drive efficiency and speed, project management leadership, and a vision for how BI can proactively improve

Minimum Requirements:

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

8 years of:

• Experience managing SDLC-based projects using Agile/Scrum
• Experience with reporting tools (Power BI, Tableau, SSRS) and ETL technologies (IDMC, SSIS, Azure Data Factory).
• Strong SQL skills and understanding of data warehousing concepts (snowflakes/star schemas, Slowly Changing Dimension, Datamart, Datalake, ODS, OLAP).
• Experience in building Enterprise Datawarehouse, Datamart, Data Lake, Operational Data Store.

6 years of:

• Strong leadership and ability to manage cross-functional technical teams
• Experience with resource planning, project budgeting, and vendor coordination
• Excellent communication, presentation, and reporting skills
• Experience in creating project plans, dashboards, Gantt charts, and executive status reports
• Meticulous attention to detail with an ability to produce high-quality work in a dynamic environment
• Highly organized and able to manage multiple projects at once and meet deadlines
• Extensive skill in effective verbal and written communications with stakeholders

Preferred/Optional:

• Experience with mainframe modernization or transformation on projects (added advantage)

Overview

Allied Consultants offers its family of consultants excellent rates, a local support staff, and an attractive benefits package which includes medical insurance (Allied shares a percentage of the cost), life insurance, a matching 401(k) plan and a cafeteria plan. Candidates selected for interview will be required to undergo criminal background checks and may be required to complete a drug screen in accordance with Federal and State Law. Offers of Employment are contingent on a successful background check. Allied Consultants is an equal opportunities employer.