Data Engineer (SR)

Join the Texas Municipal Retirement System (TMRS) as a Senior Data Engineer and help enable data-driven decision-making across TMRS. This hybrid role in Austin, TX focuses on designing and operating enterprise data solutions, owning the end-to-end pipeline and governance foundation, and leading the integration and operationalization of AI and machine learning capabilities.

What you’ll be doing

• Design, develop, and maintain reports, dashboards, and business intelligence solutions aligned to organizational objectives.
• Architect and optimize scalable data pipelines and cloud-based data solutions using modern SaaS and PaaS platforms.
• Create and maintain dimensional and semantic data models that keep enterprise data consistent and usable across reporting and analytics.
• Build and tune ETL/ELT transformations with SQL, PL/SQL, T-SQL, and Python to support complex query and transformation work.
• Maintain reliable data repositories with accurate data lineage, documented definitions, and data integrity across on-premises and cloud environments.
• Integrate data from systems of record using established data modeling standards.
• Set up automated data quality monitoring, reconciliation, and pipeline observability, including defining and reporting data quality measures.
• Lead enterprise AI and machine learning initiatives, including model integration and operationalization.
• Establish end-to-end model lifecycle management with version control, validation and approval, deployment standards, scheduled performance monitoring for drift and accuracy, and periodic review outcomes.
• Enforce data governance standards for quality, classification, retention, and access controls in alignment with organizational policies and Texas records retention requirements.
• Ensure proper AI data usage controls, including approved data sources, privacy practices, and secure handling of sensitive member information.
• Produce control evidence supporting internal audit, external examinations such as SOC, and NIST-aligned security control reviews.
• Translate stakeholder requests into technical requirements and lead projects from intake through design, development, and implementation.
• Lead peer review of code, models, and reports; mentor mid-level and junior data staff and support analytics capability growth among business users.
• Collaborate using Agile methods and tools such as JIRA, Confluence, and Git.
• Investigate new technologies, improve process, performance, and security, and contribute new strategies to support growth.
• Support after-hours as needed, follow applicable policies and procedures including security policies, and complete other duties as assigned.

Key requirements

• Bachelor’s degree in data science, computer science, information systems, engineering, actuarial science, mathematics, statistics, or a related field and at least 7 years of experience delivering data solutions, analytics, and reporting within cloud-based environments.
• Proven experience leading technical projects from intake through design, development, and implementation.
• Ability to translate business needs and stakeholder requests into complex technical requirements.
• Advanced proficiency in SQL and Python for data engineering, transformation, and analysis.
• Strong written and verbal communication skills to convey complex technical concepts to non-technical stakeholders.

Technology scope

SQL, PL/SQL, T-SQL, Python, Azure, AWS, Power BI, Azure Synapse Analytics, JIRA, Confluence, Git, ETL, ELT, MLOps, and Microsoft Azure Data and Microsoft Azure AI certifications.

Preferred experience

• Implementation of data and analytics solutions using Microsoft Power BI and Azure Synapse Analytics.
• Experience implementing large language models with model versioning, prompt and version control, evaluation tracking, continuous monitoring, and deployment lifecycle management.
• Experience sourcing data from Oracle and SQL Server systems of record.
• Data cataloging, master data management, or metadata management tooling.
• Streaming or near-real-time data integration.
• Public sector, pension administration, or financial services experience subject to SOC or NIST-based control requirements.
• Experience supporting actuarial, investment, or financial reporting data needs.

Benefits and work setup

• Participation in the TMRS pension plan with a 2:1 organization match.
• Optional participation in a 457(b) deferred compensation plan.
• Medical, dental, and vision insurance at no cost to employees.
• Hybrid work opportunities; 12 paid holidays; generous leave.
• Modern, centrally located Austin office.
• Onsite presence required a minimum of three days per week. Remote work opportunities exist, but this role is not a remote position.
• Starting base salary (based on experience and qualifications): USD 130,000 - 170,000 per year.

Physical requirements

Sedentary work involving exertion up to 10 pounds of force, with the ability to perform essential job functions safely consistent with federal, state, and local standards.