Data & AI Azure Data Services SQL Server Data Consultant

About the position We are: The Advanced Technology Centers (ATCs) is the engine for reinvention in our clients’ transformation journey. Powered by more than 255,000 people across 24 countries, ATCs will provide our clients seamless access to industry insights and innovative technology solutions. Stronger together! The Advanced Technology Centers (ATCs) make tremendous impact in solving our clients’ business problems leveraging Innovation, Intelligence, Industry insights, new IT and new technology skills. Now, with the global environment changing at a faster pace, our clients are facing unprecedented challenges and they need us more than ever before. As a Network, ATCs are positioned to unlock greater opportunities and exponential value for our clients. The value for our clients and our people For our clients, the Network provides the strength of our geographic diversity, greater resilience, and seamless access to the deepest industry knowledge, the latest in Gen AI solutions, and tech expertise from around the world. For our people, it brings an opportunity to shape truly boundaryless career paths in a highly collaborative team of experts where they can learn from each other and solve the world’s most complex client challenges. You are: A skilled Data Engineer with deep expertise in Microsoft Azure Data Services and SQL Server, capable of designing, building, and optimizing modern data pipelines and platforms. You enable organizations to collect, store, process, and operationalize data at scale through secure, well-architected cloud solutions. The Work: There will never be a typical day and that’s why people love it here. The opportunities to make a difference within exciting client initiatives are unlimited in the ever-changing technology landscape. You will be part of a highly collaborative and growing network of technology and data experts, who are taking on today’s biggest, most complex business challenges using the latest data and analytics technologies. We will nurture your talent in an inclusive culture that values diversity. You will have an opportunity to work in a variety of roles covering all aspects of Data Engineering including Data Modelling, Integration, Pipeline Development, Quality & Governance.

Responsibilities

• Design, build, and maintain scalable data pipelines and ETL/ELT processes using Azure Data Factory, Azure Databricks, or Synapse Pipelines.
• Develop and optimize robust relational data models, stored procedures, and SQL workloads in SQL Server and Azure SQL Database.
• Architect and implement data solutions leveraging Azure Data Lake Storage (ADLS), Azure Synapse Analytics, and other Azure-native services.
• Ensure data quality, governance, security, and reliability through best practices in monitoring, validation, version control, and metadata management.
• Collaborate with analytics, reporting, and business teams to ensure data structures and pipelines support accurate, consistent, and accessible insights.
• Troubleshoot performance issues and optimize database operations, queries, and compute configurations for efficiency and scale.
• Document data architectures, pipelines, and processes, and provide knowledge transfer to engineering and analytics teams.

Requirements

• A minimum of 3 years of professional experience as a Data Engineer or in a data-focused engineering role with strong hands-on experience with Azure Data Services, such as: Azure Data Factory, Azure Synapse Analytics, and Azure Data Lake Storage
• A minimum of 3 years of professional experience with Advanced Microsoft SQL Server and T-SQL, including performance tuning, indexing, and stored procedure development.
• Bachelor's degree or equivalent (minimum 12 years) work experience. (If Associate Degree, must have minimum 6 years work experience)

Nice-to-haves

• Experience with Azure DevOps, CI/CD pipelines, Infrastructure-as-Code (ARM, Bicep, Terraform), or automated deployment of data assets.
• Familiarity with big-data or distributed compute frameworks (e.g., Spark via Azure Databricks).
• Exposure to real-time or streaming architectures using Azure Event Hubs or Azure Stream Analytics.
• Experience integrating Azure data solutions with BI platforms such as Power BI for analytics consumption.
• Ability to automate data workflows using Python, PySpark, or PowerShell.
• Ability to design and implement scalable ETL/ELT architectures following modern cloud data engineering patterns.
• Strong understanding of data modeling (dimensional and relational), data warehousing concepts, and schema design.
• Knowledge of data security, access control, and governance within Azure environments.

Apply tot his job Apply To this Job