Senior Data Analyst

Allied Consultants•Austin, TX

About The Position

The Railroad Commission of Texas (RRC) seeks a senior Data Analyst to perform highly advanced (senior-level) data analysis and documentation supporting the agency’s Technology Modernization initiatives (including Mainframe Transformation and LoneSTAR). Work is data-centric: profiling and mapping data, documenting source-to-target (S2T) transformations, analyzing root causes of data defects, defining data quality controls, and creating dataflow/lineage documentation across SQL Server, Oracle, and mainframe/legacy sources. The analyst collaborates with product owners, SMEs, DBAs, ETL engineers (SSIS/ADF/Informatica), and reporting teams (Power BI/SSRS) to translate business needs into requirements, specifications, and testable acceptance criteria, ensure accurate and timely extracts/loads, and support audit-ready reporting. Work is performed under limited supervision with considerable latitude for initiative and independent judgment. This position will be responsible for data analysis and documentation in the implementation of multiple inter-related projects (including implementation of software applications in Software as a Service (SaaS) or Commercial off the Shelf (COTS), migration of data from the mainframe to the new systems and building a Data Warehouse). Assessment of existing Mainframe Transformation business analysis processes, implementation of any necessary improvements to these processes, and monitoring/enforcement of the processes to ensure deliverables and materials are produced and maintained in accordance with newly established processes and procedures, are of consistent quality, and use accepted business analysis methodologies. Make assignments and tracks work of other team members or completes individual assignments as needed. Works under limited supervision, with considerable latitude for the use of initiative and independent judgment.

Requirements

10+ Years Business analysis experience with a focus on data modeling and data flow for software development projects; including the preparation of project related documentation, data model and data flow documentation.
10+ Strong interpersonal, collaborative, analytical, written/verbal/ presentation communication skills in English (specifically technical writing); and well versed with MS Office suite of products and prototyping/screen mock-up tools such as Visio and SnagIt.
10+ Hands-on requirements elicitation: client management and technical documentation including traceability, use cases, prototyping, and data modeling.
10+ Facilitating analysis of business and functional requirements and design of technology specifications, working with business / functional personnel.
10+ Experience working with ETL/ELT teams and artifacts (SSIS, AD F, and/or Informatica): reading/writing S2T specs, documenting transformations, validating loads.
10+ Strong analysis experience and expertise in assessing Production Support issues related to system and/or data bridges to determine Root Cause and document items needed for data or system correction.
10+ Developing/maintaining an understanding of key business drivers/impacts, assisting clients with identifying and solving business-r elated system and data errors.
10+ Facilitating analysis of business and functional requirements and design of technology specifications, working with business / functional personnel.
10+ Defining functional design and systems specifications; preparing/ reviewing/delivering completed packages.
10+ Advanced SQL proficiency (SQL Server and/or Oracle) for profiling, validation, and reconciliation; fluency with ERD/relational modeling, normalization, keys, indexing.
10+ Participating in and providing guidance to Business and Functional Units in developing and completing user acceptance testing, training, and implementation-related activities.
4+ Strong technical writing skills and proficiency with Visio/diagram ming; experience maintaining auditable artifacts in SharePoint/Confluence/Azure DevOps.
4+ Experience SQL, including MS SQL Server; SSIS and .Net development environments; Azure DevOps; Oracle; and analysis of da ta bridges.
Experience with: Oracle databases, Snowflake databases, SQLServer databases, Database Modeling tools, like DBSchema, Mainframe IMS hierarchical databases, Knowledge of Informatica, Microsoft SSIS

Nice To Haves

Familiarity with mainframe environments, including hierarchical databases and their limitations; relational databases; Informatica, MuleSoft, COBOL, Java, Salesforce, Snowflake and GoAnywhere.
Experience with process improvement strategies and methodologies.
Proven ability to lead change and design more efficient processes.
Experience in Oil and Gas industry as well as general compliance and enforcement related projects as a Business Analyst with a focus on data, databases, and data bridges.
Proven ability to work compatibly within multifaceted teams; resolve conflict; and deal with challenging situations.
Bachelor’s Degree in Computer Science, Business Administration or related discipline or equivalent work experience.

Responsibilities

Thorough understanding of the software development lifecycle
Determines and documents database requirements by analyzing business operations, applications, and programming; reviewing business objectives; and evaluating current systems to create or improve database solutions.
Based on requirements, develops and implements data models for new projects, and maintains and/or enhances existing data models and data architectures.
Creates graphics and other flow diagrams (including ERD) to show complex database design and database modeling more simply.
Develop data structures for transactional systems; and Provides guidance for business intelligence systems, as required.
Implements new database solutions and/or corresponding database changes to support new and modified applications and ensure that new designs conform to data standards and guidelines; are consistent, normalized, and perform as required; and are secure from unauthorized access or update.
Creation of technical documentation for process and interface documentation
Follow guidelines on creating data models and various standards relating to governed data. This includes the ability to appropriately classify personally identifiable information.
Collects, queries, and analyzes data using standard database tools , applications, methods, and techniques for the purposes of creating normalized database solutions.
Knowledgeable of Change Data Capture (CDC) for bulk data movement
Ability to promote code from development environments to production
Familiarity with GitHub or equivalent version control systems
Ability to provide status reports and project progress reports to stakeholders and project managers
Performs related work as assigned