Senior Data Engineer & Data Platform

PTMA Financial Solutions, provides treasury management, liquidity management, and other financial products and services to the public sector. In addition to more than 12,000 local governments, school districts and other public entities, we also partner with over 1,000 financial institutions to help strengthen communities from coast to coast. Our family of financial services companies offers local government investment pool administration, investment advisory services, term investments, cashflow analysis, bond proceeds management, and public finance services for public entities plus stable deposit funding solutions for financial institutions. Our financial expertise, comprehensive products, and advanced technology help clients achieve more today for a better tomorrow. The firm’s primary operational hubs are in Denver, Colorado, and Naperville, Illinois, with other offices throughout the United States.

Position Summary

Work Authorization (Required)

Candidates must be authorized to work in the United States without employer sponsorship now or in the future. This role is not eligible for visa sponsorship or transfer.

The Senior Data Engineer at PTMA Financial Solutions is a full-time, long-term senior role responsible for operating the company’s data platform in a regulated financial services environment. This role focuses on building, maintaining, and scaling a production-grade Microsoft Fabric-based data platform that supports analytics, reporting, and operational decision-making.

This is a permanent W-2 role intended for a senior engineer seeking long-term platform ownership, stability, and trusted system access. This is not a contract, consulting, or transitional position.

Key Responsibilities

• Platform Standards, Reliability & Data Quality: Establish and maintain data engineering standards that ensure reliability, consistency, and audit readiness. Own data quality controls, validation processes, and reconciliation checks for critical financial datasets.
• Cross-Functional Collaboration: Serve as the primary point of contact for cross-functional data initiatives, translating business requirements into prioritized technical solutions.
• Platform Governance & Prioritization: Guide platform-related decisions and govern data project priorities.
• Microsoft Fabric Ownership: Own and operate the core Microsoft Fabric data platform for PTMA. This includes designing and organizing the OneLake unified data lake, configuring capacities, and overseeing Fabric components and their integration.
• Data Pipeline Design: Lead the design and implementation of enterprise data pipelines and ETL/ELT processes to ingest, transform, and load data from a variety of sources.
• AI & Advanced Analytics Support: Partner with security, legal, and compliance teams to support approved analytics and AI use cases in accordance with internal governance and regulatory requirements.
• Regulatory Compliance & Data Governance: Ensure the data platform supports compliance with financial industry regulations and standards such as SOC 2, including audit trails, access controls, and data retention practices. This role requires eligibility for access to regulated financial systems and participation in U.S.-based audit processes.
• Team Management & Mentorship: Provide technical guidance and mentorship to a small data team. Support day-to-day delivery, knowledge sharing, and technical decision-making while collaborating with leadership on delivery priorities and technical planning.
  
  

Required Qualifications

• Education & Experience: bachelor’s or master’s degree in computer science, Data Engineering, Information Systems, or a related field. 8 years of experience in data engineering or data architecture.
• Technical Proficiency: Excellent SQL skills for data querying and performance tuning, and strong programming ability in Python for developing data pipelines and automation scripts. Deep understanding of relational databases, data modeling, and building data integration workflows.
• Cloud & Azure Expertise: Hands-on experience with Microsoft Azure data services and architecture. This should include familiarity with tools such as Azure Data Factory or Synapse Pipelines, Azure Data Lake Storage, Azure Synapse Analytics or SQL pools, and related Azure infrastructure.
• Governance & Security: Solid understanding of data governance and security best practices. Comfortable implementing data access controls, encryption, masking of sensitive data, and user permission models. Knowledge of compliance standards and frameworks like SOC 2 for managing data securely is required. You should be able to design systems and policies that protect sensitive data and ensure privacy in line with industry regulations.
  
  

Preferred Qualifications

• Industry Experience: Prior experience in the financial services sector or another highly regulated industry is highly desirable. Familiarity with the compliance, security, and data privacy obligations in these environments will help you hit the ground running. Experience working with investment or portfolio data, trading systems, or client reporting in a wealth management context would be a plus.
• Business Intelligence & Analytics Tools: Experience with data visualization or BI tools, especially Microsoft Power BI. Understanding of how to create and manage Power BI datasets, reports, and dashboards, and how they connect to the underlying data models.
  
  

The Pay Range For This Role Is

160,000 - 180,000 USD per year(Colorado)