> Markdown version of [/jobs/ext/117830-senior-software-data-engineer](https://www.wearedevelopers.com/jobs/ext/117830-senior-software-data-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Senior Software & Data Engineer - **Company:** Applied Technology Group Inc - **Location:** United States (Remote available) - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** .NET Framework, Artificial Intelligence, Amazon Web Services, Business Analytics Applications, Microsoft Azure, Continuous Integration, Information Engineering, Data Governance, Extract Transform Load (ETL), Data Mart, Data Security, Data Systems, Data Warehousing, Dimensional Modeling, Django Web Framework, Github, Information Systems Security Architecture Professional, Python (Programming Language), Microsoft Data Access Components, Microsoft Windows SDK, SQL Azure, Performance Tuning, Power BI, Search Technologies, Secure Coding, SQL Stored Procedures, Data Streaming, Systems Architecture, Transact-SQL, Web Applications, Azure Data Factory, Snowflake, Multi-Agent Systems, Indexer, Data Strategy, Git, Build Management, Microsoft Fabric, Data Lakes, Pyspark, Restful APIs, Terraform, Azure Synapse Analytics, Autodesk Autocad, Software Version Control, Data Pipelines, Serverless Computing, Databricks - **Published:** May 22, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=a6aeb6534e09ea2c ## About the Role Do you have experience in T-SQL?, This full-time role requires a minimum of 40 hours per week, with additional hours as needed to meet deadlines. Candidates must be able to sit or stand for extended periods, travel between office locations (including those with stairs), and lift up to 30 pounds. Strong verbal and written English communication skills, along with adequate visual and auditory abilities (with or without aids), are essential. The physical demands described are representative of those needed to perform the job's essential functions, with or without reasonable accommodation., Applicants must be authorized to work in the U.S. without company sponsorship. We appreciate your interest in ATG!, * 5+ years experience with data engineering experience with at least 2 years on the Microsoft platform * Microsoft Fabric: OneLake, Lakehouse, Warehouse, Pipelines, Notebooks, Dataflows Gen2. * Azure SQL: schema design, performance tuning, indexing, partitioning, and security. * Medallion Architecture: hands-on experience designing and building Bronze / Silver / Gold layers in Microsoft Fabric and Azure SQL. * T-SQL: advanced querying, stored procedures, window functions, performance optimization. * ELT / ETL pipeline development: ingestion, transformation, orchestration, and monitoring across the Bronze >> Silver >> Gold flow leveraging tools such as Azure Data Factory, Synapse Analytics, Azure Functions, Python and PySpark for Notebook development. * Data warehouse modeling: dimensional modeling (Kimball), slowly changing dimensions, conformed dimensions in the Gold layer. Professional and Consulting Skills: * Project Management: * Document requirements, data flows, and system architecture * Estimate effort accurately and communicate blockers or timeline risks proactively * Team player: * Champion best practices for readable, maintainable, performant, and secure code * Mentor junior engineers and share knowledge across the team * Manage your time effectively and communicate technical trade-offs clearly * Detail oriented: ability to understand and business processes & data Nice to haves: * Power BI and DAX for semantic models and reporting * Git-based source control and CI/CD for data pipelines (Azure DevOps or GitHub Actions) * Experience with Snowflake and Databricks * Experience with AEC data including Autodesk APS and Autodesk Forma * Familiarity with data governance, lineage, and cataloging (Microsoft Purview) * Experience with Microsoft Foundry and Azure AI Search * .NET or Python Django Web Application and RESTful API development * Azure & AWS infrastructure, Terraform ## Description We are seeking an experienced developer and data engineer to build and evolve data warehouse, data lake, lakehouse, and analytics solutions on the Microsoft data platform. The role is hands-on: designing data models, building ELT/ETL pipelines using the Medallion Architecture (Bronze / Silver / Gold), and delivering reliable, well-modeled data products on Microsoft Fabric and Azure SQL. As a data engineer you will build resilient data pipelines and create visibility into data quality issues, building client trust in their data and our ability to deliver dependable solutions. You will work with clients directly to understand their data sources, governance and security requirements, and the nature of their business. You will build data pipelines and position data for analytics matching our client's current capabilities to query and leverage the data, but also design the scalable, secure architecture needed to set them up for the future and AI.. Your expertise will be critical in shaping our clients' data strategy, driving architectural decisions, and mentoring team members to deliver scalable and reliable data solutions, * Design and build data warehouse solutions on Microsoft Fabric and Azure SQL aligned to client business needs. * Implement and evolve the Medallion Architecture - Bronze (raw), Silver (cleansed/conformed), and Gold (business-ready) layers - on Fabric and Azure SQL. * Develop and maintain ELT/ETL pipelines that are reliable, observable, and easy to operate. * Model data for analytics and reporting - fact/dimension design, conformed dimensions, performant aggregates. * Collaborate with ATG technical leads and client stakeholders to translate requirements into delivery-ready solutions. * Own quality - testing, validation, documentation, and monitoring of pipelines and datasets. * Research and propose solutions independently; bring options and tradeoffs, not just questions. * AI Readyness: understanding of leveraging Fabric and Azure AI Search to tag data and make data available to Enterprise AI Orchestration platforms such as Foundry. * Consulting: Able to explain various data and analytic approaches to non-technical stakeholders. Able to conduct Bronze to Silver analysis and mapping and present to clients. Able to interview clients to design data marts for Gold. * Technical Leadership: Provide thought leadership on best practices for readable, maintainable, performant, and secure data pipelines. ## Related Videos - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [PySpark - Combining Machine Learning & Big Data](https://www.wearedevelopers.com/videos/44-pyspark-combining-machine-learning-big-data) - [Innovating Developer Tools with AI: Insights from GitHub Next](https://www.wearedevelopers.com/videos/1268-innovating-developer-tools-with-ai-insights-from-github-next) - [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94) - [Empowering Retail Through Applied Machine Learning](https://www.wearedevelopers.com/videos/976-empowering-retail-through-applied-machine-learning) - [Bringing AI Model Testing and Prompt Management to Your Codebase with GitHub Models](https://www.wearedevelopers.com/videos/1536-bringing-ai-model-testing-and-prompt-management-to-your-codebase-with-github-models) ## Related Articles - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [Dev Digest 120 - Apple and peers](https://www.wearedevelopers.com/magazine/455-dev-digest-120-apple-and-peers) - [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries)