TDCJ - Administrative Assistant IV - Information T

Please paste the following URL into a browser to view the entire job posting on the CAPPS Careers page.https://erphcmprd.cpa.texas.gov/psp/candidateportal/EMPLOYEE/HRMS/c/HRS_HRAM_FL.HRS_CG_SEARCH_FL.GBL?Page=HRS_APP_JBPST_FLandAction=UandFOCUS=ApplicantandSiteId=1andJobOpeningId=106441andPostingSeq=1Job DescriptionApplicants must submit both a rsum and a completed application to be considered. Both documents should include sufficient work history to assess qualifications. For the most accurate and up-to-date information about your application, please log in to the CAPPS application portal regularly to monitor status changes or updates.* To expedite the application process, please attach your valid government-issued photo identification card, your social security card or proof of authorization to work in the United States, and your proof of education (official diploma or transcript)

• 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 databaseYou'd 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.
• For the full Job Description, please click the link below:Administrative Assistant IV 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
• Outside applicants will be required to submit to pre-employment drug testing as a condition of employment.Contact Information: Questions concerning this Questions concerning the applicationposition can be directed to: process can be directed to: Roberta Poehl Kathy ChandonettHiring Manager OR Human Resources936-437-2239 936-437-4106roberta.poehl@tdcj.texas.gov hr.selectionsteam3@tdcj.texas.gov Important Note to the Candidate:Military PreferenceTo receive MILITARY PREFERENCE, you are required to provide proof by attaching the necessary documentation to this job application.Military Occupation Specialty Codeshttps://hr.sao.texas.gov/CompensationSystem/JobDescriptionsClick 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.Applications submitted through Work in TexasWork In Texas (WIT) applicants must complete supplemental questions to be considered for the position. To complete the su plemental questions please go to CAPPS Recruit to register or login and access your profile.EligibilityAn 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.