Job Title: Sr. Data Engineer

Company Name: MTC Holding Corporation

Job Details: RemoteFull,Time

Job Url: https://hiring.cafe/viewjob/rpglf81yeez839yn

Job Description: Posted 1mo agoSr. Data Engineer@ MTC Holding CorporationView All JobsWebsiteOverland Park, Kansas, United StatesRemoteFull TimeResponsibilities:Designing workloads, Tuning queries, Collaborating with stakeholdersRequirements Summary:5–7+ years in data engineering; strong SQL Server/T-SQL; cloud data pipelines; Microsoft Fabric; Python (PySpark); Azure DevOps and Git; data modeling.Technical Tools Mentioned:Microsoft Fabric, Azure Data Factory, SQL Server, T-SQL, Python, PySpark, Delta Lake, Data Vault 2.0, Data Mesh, Azure DevOps, Git, Logic Apps, Power BI, Tableau
Description  TTS - Data EngineerTrust Technology Solutions – Overland Park, Kansas - Fully Remote with the optional access to our regional office locations. Position OverviewAs 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 ResponsibilitiesWork 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 SkillsExperience: 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 InsuranceDental InsuranceFlexible Benefits PlanLife and AD&D Insurance401k Profit Sharing PlanVoluntary benefits, including vision, disability, long-term care, accident and cancer insuranceSalary commensurate with experienceTrust Technology Solutions, LLC is an Equal Opportunity Employer