Data Engineer (SR)

Join the Texas Municipal Retirement System in Austin to design and optimize enterprise data and AI-enabled platforms for data-driven decision-making.

Responsibilities

• Design, develop, and maintain reports, dashboards, and BI solutions aligned with organizational objectives
• Architect, build, and optimize scalable data pipelines and cloud data solutions using modern SaaS and PaaS platforms
• Design and maintain data models, including dimensional and semantic models, to ensure enterprise data consistency across reporting and analytics
• Develop and tune complex data transformations and queries using SQL, PL/SQL, T-SQL, and Python for ETL/ELT
• Create and 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; define and report data quality measures
• Lead enterprise AI and machine learning initiatives, including model integration and operationalization
• Establish end-to-end model lifecycle management covering version control, validation and approval, deployment standards, continuous monitoring for drift and accuracy, and scheduled periodic reviews with documented outcomes
• Enforce data governance standards for data quality, data classification, retention, and access controls aligned to organizational policies and Texas records retention requirements
• Ensure proper AI data usage controls, including approved data sources, privacy, 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 technical projects from intake through design, development, and implementation
• Lead peer review of code, models, and reports
• Mentor mid-level and junior data staff and help build analytics capability among business users
• Collaborate using Agile methodologies with tools such as JIRA, Confluence, and Git
• Investigate new technologies and assess viability for current and future projects
• Improve process, performance, and security of data solutions and integrations
• Support after-hours requirements as needed
• Perform other duties as assigned; follow all applicable policies including security policies

Requirements

• Bachelor’s degree in data science, computer science, information systems, engineering, actuarial science, mathematics, statistics, or a related field
• Minimum 7 years 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 explain complex technical concepts to non-technical stakeholders

Technologies

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

Education & Experience

• Hands-on experience with Advanced SQL (Oracle PL/SQL and T-SQL) and Python for data engineering, transformation, and analysis
• Hands-on experience with cloud data platforms and services (Azure and AWS), including storage, compute, and managed data services
• Hands-on experience with ETL and ELT pipeline design, orchestration, and scheduling
• Hands-on experience with data warehouse, lakehouse, and dimensional modeling
• Hands-on experience with business intelligence and reporting platforms (Power BI or equivalent)
• Hands-on experience with data governance including classification, lineage, retention, and access control
• Hands-on experience with machine learning model integration and lifecycle management (MLOps)
• Hands-on experience with Agile delivery tooling: JIRA, Confluence, and Git-based source control

Preferred

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

Certificates & Licenses

• Microsoft Azure Data certifications (preferred)
• Microsoft Azure AI certifications (preferred)

Benefits

• Participation in 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 at least three days per week; remote work opportunities exist, but this is not a remote position
• Starting base salary based on experience and qualifications

Qualities

• Confident and mature leadership skills
• Highest level of character and integrity
• Executive presence and strength of character
• Excellent interpersonal and relationship skills
• Intellectual curiosity and determination
• Team orientation and strong work ethic with respect and integrity
• Effective communicator with clear, concise articulation of ideas
• Self-driven with strong attention to detail and structured problem-solving in collaboration

Physical Requirements

• Sedentary work; exerting up to 10 pounds of force
• Ability to perform essential job functions safely and successfully consistent with federal, state, and local standards