Data Engineer (Intermediate OR Senior)

Teacher Retirement System of Texas is hiring an on-site Data Engineer (Intermediate or Senior) in Austin, TX.

Responsibilities

• Design, develop, and optimize data pipelines, data modeling, and data platform management to support reliable integration and operations
• Maintain data warehouses, generate complex reports, and perform in-depth data analysis
• Develop and manage data platforms, including ETL processes and data lake management
• Implement and manage CI/CD pipelines (intermediate proficiency for Intermediate; advanced for Senior) using DevOps practices
• Create and maintain data models (basic for Intermediate; advanced for Senior) for structured data storage and accessibility
• Manage and enhance data catalogs to maintain an organized, accessible repository of data resources
• Perform administrative tasks and assist with basic system administration duties to support upkeep of data systems
• Manage and optimize data permissions to ensure proper access control and data security
• Optimize system performance and improve ease of management, reliability, and availability of data environments
• Develop data-driven applications and support data solutions aligned to business needs
• Write and run reporting queries and support advanced reporting tasks as required
• Build visually appealing, intuitive dashboards providing visibility into key performance, risk, and control indicators across agency divisions and departments
• Collaborate with stakeholders to gather requirements and contribute to defining project scopes and objectives
• Engage in scrum activities and participate in Agile methodologies (lead scrum activities at the Senior level)
• Proactively collaborate with the Data Engineering Team, IT staff, and enterprise stakeholders, including agency employees
• Guide the evolution of Investment data platforms and systems by shaping how critical investment data is integrated, secured, and delivered at scale
• Serve as a technical advisor to Investment teams by implementing modern platform capabilities and supporting adoption across the business
• Perform related work as assigned

Requirements

• Bachelor’s degree from an accredited college or university in computer information systems, computer science, data management, information systems, information science, mathematics, or a closely related field
• High School diploma or equivalent with additional full-time experience in data pipeline builds and implementation may be substituted on an equivalent year-for-year basis
• Three (3) to Five (5) years of full-time directly related, progressively responsible experience in data pipeline builds and implementation; experience using ETL tools to create ETL scripts; Power BI or an equivalent modern data visualization package or related experience
• Experience may be concurrent
• A master’s degree or doctoral degree in a closely related field may be substituted on an equivalent year-for-year basis

Technologies

• ETL tools
• CI/CD pipelines
• Power BI
• Data lake
• Data warehouses
• Data catalogs
• DevOps practices
• Microsoft Fabric
• Databricks
• Snowflake
• Spark
• SQL
• Python
• Cloud platforms
• Data encryption (REST, SOAP, XML, JSON)
• Web services (SSL, SSH, SFTP, Certificates)
• Reporting tools

Preferred Qualifications (Data Engineer)

• Experience with data architecture and data modeling
• Experience with Microsoft Fabric, Databricks, Snowflake, Spark, SQL, Python, and cloud platforms
• Experience with data encryption (REST, SOAP, XML, JSON) and web services (SSL, SSH, SFTP, Certificates)

Preferred Qualifications (Data Engineer Senior)

• Advanced experience with data architecture and data modeling
• Advanced experience with Microsoft Fabric, Databricks, Snowflake, Spark, SQL, Python, and cloud platforms
• Advanced experience with data encryption (REST, SOAP, XML, JSON) and web services (SSL, SSH, SFTP, Certificates)

Knowledge, Skills, and Abilities

• Strong knowledge of business intelligence tools, databases, SQL, and object-oriented programming languages to support data analysis and predictive analytics
• Database modeling and data warehousing principles
• System development life cycle concepts
• Knowledge of data platforms and assisting with platform management
• Knowledge of ETL concepts and assisting with building pipelines
• Knowledge of data architecture and modeling
• Knowledge of Microsoft Fabric, Databricks, Snowflake, Spark, and cloud platforms
• Knowledge of data encryption (REST, SOAP, XML, JSON) and web services (SSL, SSH, SFTP, Certificates)
• Proficient (or advanced) proficiency in Python and SQL
• Use technical and statistical analysis skills to deliver clear, concise, and visually appealing management metrics and reports
• Write report queries with an understanding of relational databases
• Business process analysis and problem solving
• Complete detailed work with a high degree of accuracy
• Plan, organize, and prioritize work assignments to manage a high-volume workload in a fast-paced, changing environment
• Use a computer in a Windows environment with Microsoft Office word processing, spreadsheets, and other business software
• Effective written and verbal communications, including explaining complex information and writing clear policies, procedures, and training or other materials
• Work effectively in a team environment; influence a diverse group of stakeholders
• Operate effectively in a fast-paced environment with competing and shifting priorities
• Continually learn new concepts and tools; pursue ongoing professional development
• Establish and maintain harmonious working relationships with coworkers, agency staff, and external contacts
• Participate in Scrum activities with an advanced understanding of Agile

Military Encouragement

• Veterans, Reservists, or Guardsmen with experience in the Military Occupational Specialty (see crosswalk at https://www.trs.texas.gov/files/trs-military-crosswalk.xlsx) along with the minimum qualifications listed above may meet minimum requirements and are highly encouraged to apply
• Contact Talent Acquisition at [email protected] with questions or for additional information

Location: Austin, TX, United States (onsite)

Salary: USD 98,214 - 149,898 per year

Minimum experience: 3 years