Data Engineer (SR)

Texas-Municipal-Retirement-System; Austin (TX); Hybrid; USD 140,000 - 180,000; Full time

Benefits offered by this job

Hybrid work opportunities

12 paid holidays

Generous leave

Job summary

Texas Municipal Retirement System is seeking a Senior Data Engineer in Austin to design, build, and optimize data pipelines and BI solutions across on-prem and cloud environments. You will lead data governance, model lifecycle, and integration of AI/ML capabilities while partnering with stakeholders and executives.

The role requires advanced SQL, Python, and experience with Azure/AWS, Synapse, and Power BI, plus an emphasis on data quality, security, and scalable architecture.

Qualifications

• Hands-on experience with Advanced SQL (Oracle PL/SQL and T-SQL) and Python for data engineering, transformation, and analysis.
• Cloud data platforms and services (Azure and AWS), including storage, compute, and managed data services.
• ETL and ELT pipeline design, orchestration, and scheduling.
• Data warehouse, lakehouse, and dimensional modeling; BI and reporting platforms (Power BI or equivalent).
• Data governance practice: classification, lineage, retention, and access control.

Responsibilities

• Design, develop, and maintain reports, dashboards, and BI solutions aligned with organizational objectives.
• Architect, build, and optimize scalable data pipelines and cloud-based data solutions.
• Develop and tune complex queries and transformations to support ETL/ELT.
• Create and maintain reliable data repositories with data lineage and integrity across on-prem and cloud.
• Lead enterprise AI/ML initiatives, including model integration and lifecycle management.

Skills

Advanced SQL

Python

Cloud platforms

Data modeling

Power BI

Agile / JIRA

Education

Bachelor’s degree in data science, computer science, information systems, engineering, actuarial science, mathematics, statistics, or related field

Tools

Oracle PL/SQL

T-SQL

Azure

AWS

Azure Synapse Analytics

Power BI

JIRA

Confluence

Git

Job description

Job SummaryThe Senior Data Engineer designs, builds, and optimizes enterprise data solutions that enable data-driven decision-making and operational excellence across TMRS. This role is responsible for the architecture and implementation of data pipelines, data repositories, and reporting platforms; applies data engineering and data governance standards; and leads the integration and operationalization of artificial intelligence and machine learning capabilities. Working within the IS Department, this role partners closely with business stakeholders and Executive Leadership to deliver secure, scalable, reliable, and high-quality data solutions that support organizational objectives.Key ResponsibilitiesDesign, develop, and maintain reports, dashboards, and business intelligence solutions aligned with organizational objectives.Architect, build, and optimize scalable data pipelines and cloud-based data solutions using modern SaaS and PaaS platforms.Design and maintain data models, including dimensional and semantic models, that make enterprise data usable and consistent across reporting and analytics.Develop and tune complex queries and transformations using SQL, PL/SQL, T-SQL, and Python to support ETL and ELT processes.Create and maintain reliable data repositories, ensuring accurate data lineage, documented definitions, and data integrity across on-premises and cloud environments.Integrate data from systems of record using established data modeling standardsEstablish automated data quality monitoring, reconciliation, and pipeline observability; define and report on data quality measures.Lead enterprise AI and machine learning initiatives, including model integration and operationalization.Establish and maintain end-to-end model lifecycle management processes, including version control, validation and approval, deployment standards, continuous performance monitoring for drift and accuracy, and scheduled periodic reviews with documented outcomes.Enforce data governance standards, including data quality, data classification, retention, and access controls in alignment with organizational policies and Texas records retention requirements.Ensure proper data usage controls for AI, including approved data sources, data 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 business needs and 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 build analytics capability among business users.Collaborate using Agile methodologies and tools such as JIRA, Confluence, and Git to support iterative development and delivery.Investigate new technologies and assess their viability and usefulness in current and future projects.Improve process, performance, and security of data solutions and integrations.Contribute new viewpoints and strategies to stimulate growth.Ability to use and integrate approved AI solutions.After hours support as needed.Other duties as assigned.Follow all applicable policies and procedures including all security policies.Education & ExperienceHands-on experience withAdvanced SQL (Oracle PL/SQL and T-SQL) and Python for data engineering, transformation, and analysisCloud data platforms and services (Azure and AWS), including storage, compute, and managed data servicesETL and ELT pipeline design, orchestration, and schedulingData warehouse, lakehouse, and dimensional modelingBusiness intelligence and reporting platforms (Power BI or equivalent)Data governance practice: classification, lineage, retention, and access controlMachine learning model integration and lifecycle management (MLOps)Agile delivery tooling: JIRA, Confluence, and Git-based source controlRequiredBachelor’s degree in data science, computer science, information systems, engineering, actuarial science, mathematics, statistics, or related field and a minimum of 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.Demonstrated 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, with the ability to clearly convey complex technical concepts to non-technical stakeholders.PreferredPrevious implementation of data and analytics solutions using Microsoft Power BI and Azure Synapse AnalyticsExperience implementing large language models and managing model versioning, including prompt and version control, evaluation tracking, continuous monitoring, and deployment lifecycle managementExperience sourcing data from Oracle and SQL Server based systems of recordData cataloging, master data management, or metadata management toolingStreaming or near-real-time data integrationPublic sector, pension administration, or financial services environment subject to SOC or NIST-based control requirementsExperience supporting actuarial, investment, or financial reporting data needsCertificates & LicensesMicrosoft Azure Data certifications are preferred.Microsoft Azure AI certifications are preferred.Qualities We Are Looking ForConfident and mature leadership skillsThe highest level of character and integrityExecutive presence and strength of characterExcellent interpersonal and relationship skillsIntellectual curiosity and determination. You are smart, intellectually curious, and grasp complex subjects quickly.Team orientation. You bring integrity and a strong work ethic to your work. You treat people with respect and kindness, work well with different personalities and perspectives, and contribute positively to the team.Effective communicator. You listen carefully, ask questions effectively, and articulate your thoughts and ideas clearly, respectfully, and concisely.Self-driven with strong attention to detail; able to perform structured problem-solving in a collaborative team environment.Physical RequirementsSedentary work: Exerting up to 10 pounds of force. Ability to perform the essential job functions safely and successfully consistent with federal, state, and local standards.TMRS OverviewTexas Municipal Retirement System (TMRS) is a trusted partner to more than 940 cities across Texas, providing retirement, disability, and survivor benefits to over 260,000 public servants and their families. We are proud to be recognized as an example of fiduciary excellence through our management of more than $44 billion in Trust Fund assets.At TMRS, every role supports our mission: providing secure lifetime income to our members. Our work gives back to communities across Texas, and we take pride in doing it with integrity, accountability, and a commitment to excellence.Compensation and BenefitsStarting base salary (based on experience and qualifications)Participation in TMRS pension plan, with a 2:1 organization matchOptional participation in a 457(b) deferred compensation planMedical, dental, and vision insurance at no cost to employeesHybrid work opportunities; 12 paid holidays; generous leaveModern, centrally located Austin officeOnsite presence required a minimum of three days per week; remote work opportunities exist, but this is not a remote positionTMRS is an Equal Opportunity Employer.