TDCJ - Administrative Assistant IV - Information T

Texas Department Of Criminal Justice; Huntsville (TX); On-site; USD 95,000 - 125,000; Full time

Job summary

Texas Department Of Criminal Justice is seeking a detail-oriented professional to analyze data dimensions, develop normalization and cleansing rules, and write SQL interfacing with SQL databases. The role emphasizes data governance, collaboration, and leveraging Databricks and Informatica to improve data quality across projects.

The position involves travel and site visits, with a focus on ensuring data integrity and compliance while supporting enterprise data initiatives.

Qualifications

• Experience normalizing and cleansing data.
• Familiarity with Databricks and Informatica.
• Background as a database administrator is a plus.
• Knowledge of data governance and compliance programs.

Responsibilities

• Analyze data dimensions for inconsistencies including schema, datatypes, accuracy and completeness.
• Develop data normalization and cleansing rules to support dimensions.
• Write basic SQL and interface with SQL databases.
• Collaborate across teams on data quality initiatives.

Skills

Data normalization

SQL optimization

Python/PySpark

Databricks

Informatica

Data governance

BI tools

SQL

Team collaboration

Tools

Databricks

Informatica

SQL databases

Excel (M365)

Job description

Job Duties

Analyze data dimensions looking for inconsistencies, including but not limited to data schema, used/assigned datatypes, accuracy, consistency, conformity, completeness, validity, uniqueness, referential integrity and more. Develop data normalization and data cleansing rules in support of the dimensions above. Write basic SQL and interfacing to any popular SQL structured database.

You'll be a GOOD fit if

• Detail oriented professional who works until the job is done and is motivated by the opportunity to learn new skills.
• Previous experience normalizing and cleansing data, familiarity with Databricks and Informatica, experience as a database administrator, proficiency communicating verbally and writing reports.
• Previous state employee experience (Texas preferred)
• Proficiency with M365 products with an emphasis on using Excel, but including Word, PowerPoint, Outlook, SharePoint and Teams.
• Experience with data governance and compliance programs and how these systems are enforced with data.
• Previous experience working in a team and collaborating in multiple areas depending on the project or task.

You'd be a GREAT fit if

• Proficiency writing data normalization and cleansing rules in SQL or Python/PySpark.
• SQL optimization skills, querying, joining, and aggregating data.
• Certifications from Databricks or Informatica.
• Data BI tools and visualization.
• Data modeling, ETL/ELT skills, data quality checks.
• Descriptive statistical analysis, trends and regression.

Additional Information

Travel 25% - Position may spend 15 nights away per month Work Site Visits No Study Material No Pre-Service Training Academy Required No Hazardous Duty/Longevity Position Longevity.

Contact Information

Roberta Poehl Kathy Chandonett; Hiring Manager or Human Resources. Phone: [phone]. Email: [e-mail], [e-mail].

Military Preference

To receive MILITARY PREFERENCE, you are required to provide proof by attaching the necessary documentation to this job application.

Military Occupation Specialty Codes: https://hr.sao.texas.gov/CompensationSystem/JobDescriptions Click on the occupational category for the position. Additional MOS can be found at the State Auditor's Office, Military Crosswalk Guide.

The Texas Veterans Commission provides helpful employment information. Go to: http://www.texasskillstowork.com, http://www.onetonline.org, https://hr.sao.texas.gov/CompensationSystem/JobDescriptions/ or www.careeronestop.org for assistance translating your military experience and training courses into civilian job terms, qualifications/requirements and skill sets.

Eligibility

An applicant must be eligible to work in the United States and must remain eligible, without sponsorship or any assurance of financial or other assistance from this agency, during the term of their employment.

EEO Statement

The State of Texas is an Equal Opportunity Employer and does not discriminate on the basis of race, color, national origin, sex, religion, age or disability in employment or the provision of services.

You may make copies of this application and enter different position titles, but each copy must be signed. Resumes will not be accepted in lieu of applications, unless specifically stated in the job vacancy notice.