Sr. Data Engineer at Trust Technology Solutions, LLC

Overland Park, Kansas, United States -

Full Time

Start Date

Immediate

Expiry Date

24 May, 26

Salary

0.0

Posted On

23 Feb, 26

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Microsoft Fabric, SQL Server, T-SQL, Python, PySpark, Spark, Data Modeling, Data Vault 2.0, Data Mesh, DataOps, Azure DevOps, Git, Logic Apps, Data Factory, Performance Tuning, Data Contracts

Industry

Information Technology & Services

Description

Description TTS - Data Engineer Trust Technology Solutions – Overland Park, Kansas - Fully Remote with the optional access to our regional office locations. Position Overview As a Senior Data Engineer, you will be a key architect of our data ecosystem. We are looking for a high-ceiling technical lead to design and scale enterprise-grade data products within Microsoft Fabric. This role requires a sophisticated blend of modern cloud engineering and deep SQL Server fundamentals. You won't just move data; you will define the standards for data reliability, performance, and cross-functional collaboration, ensuring our clients can rely on high-fidelity information for mission-critical decisions. Key Responsibilities Work in the established Fabric Architecture: Design and implement sophisticated end-to-end workloads within Microsoft Fabric. You will help determine the optimal use of the Lakehouse (Spark/Notebooks) versus the SQL Warehouse based on specific performance and scale requirements. Advanced SQL Development: You will develop complex stored procedures and functions while also performing deep-dive performance tuning and indexing strategies within SQL Server and Fabric environments. Automated Validation Frameworks: Maintain robust, automated data validation and quality frameworks. You will ensure that data integrity is "baked into" the pipelines, catching anomalies and schema drift before they impact downstream analytics. Strategic Collaboration: Partner with Data Analysts and business stakeholders to define and enforce Data Contracts. You will act as a bridge, translating high-level business objectives into durable technical architectures. Advanced Data Modeling: Implement modern architectural patterns, including Medallion, Data Vault 2.0, Data Mesh, and others, ensuring data is structured for both long-term scalability and ease of end-user consumption. DataOps: Drive operational excellence through CI/CD via Azure DevOps, Git-based version control, and automated monitoring/alerting systems using Logic Apps and other Azure services. Requirements Required Skills Experience: 5–7+ years of proven experience in Data Engineering, with a strong emphasis on database design and cloud architecture. SQL Mastery: Advanced proficiency in T-SQL and SQL Server internals. You should be comfortable solving complex query performance issues and designing highly efficient relational models. Cloud Orchestration: Demonstrable experience building and managing complex pipelines using Fabric Data Factory or Azure Data Factory. Programming & Big Data: Proficiency in Python (PySpark) for large-scale data transformation and Spark-based processing within a Lakehouse environment. Excellent communication skills with the ability to lead technical discussions, define requirements with non-technical partners, and mentor junior team members. Architecture Mindset: Deep understanding of modern data patterns (Lambda/Kappa, Delta Lake, and Distributed Systems). Preferred Experience- Proficiency with Microsoft Fabric for analytics and data processing.- Advanced knowledge of modern data architectures (Medallion, DataVault, Lambda/Kappa)- Solid Experience with DevOps practices using Azure DevOps or Git.- Knowledge of business intelligence tools like Power BI or Tableau.- Azure certifications (e.g., Azure Fundamentals, Power Platform certifications).Company DescriptionTrust Technology Solutions is an IT company with a mission to centralize, standardize, and economize information technology services used by MTC Holding Corporation companies, their affiliates and their clients in pursuit of overall enterprise objectives. Those objectives include the delivery of secure, reliable, scalable, and innovative solutions for our financial services clients.Benefits include: Medical Insurance Dental Insurance Flexible Benefits Plan Life and AD&D Insurance 401k Profit Sharing Plan Voluntary benefits, including vision, disability, long-term care, accident and cancer insurance Salary commensurate with experience Trust Technology Solutions, LLC is an Equal Opportunity Employer

Responsibilities

The Senior Data Engineer will architect and scale enterprise data products primarily within Microsoft Fabric, defining standards for data reliability and performance. Key duties involve designing end-to-end workloads, developing advanced SQL, and maintaining automated data validation frameworks.