Senior Software & Data Engineer

Senior Software and Data Engineer 

NOW HIRING for our next GeT Aboard Class!

Kick off your career at ATG with a week designed to inspire, connect, and set you up for success. GeT Aboard is our signature onboarding experience - an energizing in-person summit at our North Little Rock corporate headquarters where you’ll meet the team, dive into our culture, and gain the tools to thrive. Attendance is required - but we think you’ll agree it feels more like a launch party than training.

Additional Information
Hiring Process: An on-site interview at either our North Little Rock, AR or our Phoenix, AZ office location is a required step in the hiring process for all ATG opportunities.

Who We Are

At ATG USA, we don’t just support the AEC industry, we help shape it.

ATG USA (Applied Technology Group) is the leading technology business partner focused on the Architectural, Engineering and Construction industry in North America. ATG strives to build relationships within the professional design community by providing a complete solution. ATG has unique service offerings implemented by technical support specialists with industry experience and knowledge.

Role Summary

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.

• Architect and deploy scalable Data Lakehouse environments utilizing Microsoft Fabric and/or Databricks tailored to mid-sized to enterprise client business requirements.
• Drive the implementation of the Medallion Architecture patterns (Bronze, Silver, and Gold) to optimize data quality, governance, and reporting performance.
• Engineer resilient, production grade ELT/ETL data pipelines equipped with robust observability, automated monitoring, and low operational overhead.
• Design and implement dimensional data models (facts, conformed dimensions, and optimized aggregations) structured specifically for high-performance BI, reporting, and downstream analytics.
• Partner with ATG technical leads and client stakeholders to drive end-to-end solution delivery through leading KPI discovery, source system analysis (REST APIs, databases, ODBC), architectural design, and production deployment
• Champion end-to-end data quality and pipeline reliability by establishing automated testing, validation frameworks, continuous monitoring, and comprehensive technical documentation.
• AI Readiness: Prepare and structure enterprise data for AI enablement by leveraging Microsoft Fabric, Azure AI Search, and metadata enrichment to feed AI orchestration platforms such as Azure AI Foundry.
• Consulting: Serve as a trusted client advisor who translates complex data architectures into clear business value.
  • Lead discovery workshops to drive Bronze-to-Silver source mapping and interview stakeholders to design custom Gold data marts.
  • Proactively research and propose technical solutions bringing well-reasoned options and trade-off analyses, not just questions.
• Technical Leadership: Champion engineering excellence and thought leadership, establishing best practices across the team for readable, maintainable, performant, and secure data pipelines.

• Data Lakehouse Platforms: Microsoft Fabric, Databricks, Delta Lake
• Languages: Python (Advanced), SQL (Expert)
• Transformation & Modeling: Dimensional Modeling (Kimball), Medallion Architecture
• Orchestration & Integration: Microsoft Fabric Data Factory, Azure Data Factory, REST APIs, ODBC/JDBC
• DevOps & Engineering: Git, CI/CD (GitHub Actions or Azure DevOps), Automated Testing Frameworks
• Data Quality & Observability: Pipeline logging, alerting, and automated validation tools

• 5+ years of Data Engineering experience with a proven track record of designing, building, and deploying enterprise Data Lakehouse architectures.
• Hands-on expertise in Microsoft Fabric and/or Databricks, including practical experience implementing Medallion Architecture (Bronze, Silver, Gold) in production environments.
• Deep proficiency in Python and advanced SQL for building scalable, high-performance ETL/ELT pipelines and complex data transformations.
• Strong experience with a scriptable approach to maintain modular, version-controlled, and thoroughly tested transformation pipelines.
• Mastery of dimensional modeling principles — expert ability to design facts, conformed dimensions, and performant data marts for business reporting and BI.
• Adherence to software engineering best practices, including version control (Git), CI/CD release automation, code reviews, and robust pipeline monitoring.

• Client Management Skills:
  • Proven ability to lead discovery sessions, map complex source systems, explain trade-offs to stakeholders, and translate business KPIs into technical designs
  • 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

• Experience with Snowflake, Power BI, PySpark, dbt
• Familiarity with data governance, lineage, and cataloging (Microsoft Purview)
• dotnet or Python Django Web Application and RESTful API development
• Azure & AWS infrastructure, Terraform
• Experience with AEC data including Autodesk APS and Autodesk Forma

Benefits:

• Health, Dental and Vision Benefits
• Short-Term and Long-Term Disability
• Wellness Programs
• 3 weeks of PTO each year, paid holidays, and your birthday off
• 2 paid volunteer days each year
• 401k match up to 4% after 90 days of employment
• Great culture with frequent in-person events and gatherings

About ATG Data Solutions

We believe in building inspired professionals, thriving businesses, and healthy communities. We offer technology services that empower people and organizations to do their best work and make an impact that matters. If you like to develop software that helps people, we want to talk to you.

We’re not just looking for developers; we are looking for people who want to become great! We want people who are passionate about learning our client’s businesses and want to solve meaningful problems.

ATG is an Equal Opportunity Employer. We do not discriminate based on race, color, religion, sex (including gender identity and sexual orientation), national origin, age, disability, genetic information, or any other protected status under applicable laws. We’re committed to an inclusive workplace where all backgrounds and perspectives are valued, and we strive to build a team that reflects the diverse world we serve. 

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. 

If you need accommodation during the application or interview process—or on the job—please contact Human Resources. 

Applicants must be authorized to work in the U.S. without company sponsorship. We appreciate your interest in ATG! 

Requirements: 

• 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