Senior Azure Data Engineer

As an Azure Data Engineer at Techstra Solutions, you will play a pivotal role in designing, implementing, and managing data architecture on the Azure cloud platform. You will collaborate with cross-functional teams to ensure that the data infrastructure meets business needs and adheres to industry best practices. If you are a strategic thinker with strong technical expertise, this role offers an exciting opportunity to shape the data landscape. 

Responsibilities: 

• Develop and maintain data pipelines using Azure Data Factory and other relevant Azure technologies

• Optimize ETL processes for performance and scalability, leveraging Azure services such as Azure Data Factory Mapping Data Flows, Azure Data Lake Analytics, or Azure Synapse Pipelines

• Extract data from various sources, transform it into a usable format, and load it into Azure data storage solutions such as Azure SQL Database, or Azure Synapse Analytics

• Collaborate with cross-functional teams to understand data requirements and design scalable and efficient ETL processes using Azure services

• Identify, design and implement ETL solutions for extraction and integration of data to and from data warehouses and data marts for the purposes of reporting, decision support and analysis

• Lead the design, development, and deployment of data solutions on the Azure cloud platform

• Expert level understanding on Azure Data Factory, Azure Synapse, Azure SQL, Azure Data Lake, and Azure App Service is required.

• Designing and building data pipelines using API ingestion and Streaming ingestion methods.  

• Knowledge of Dev-Ops processes (including CI/CD) and Infrastructure as code is essential.  

• Knowledge in Azure Databricks, Azure IoT, Azure HDInsight + Spark, Azure Stream Analytics, Power BI is desirable  

• Manage Azure SQL Databases, Azure Data Factory, Azure Data Warehouses, and other Azure-based data stores 

• Knowledge of C# and Hands-on with PowerShell scripting is desirable.  

• Working knowledge of Python is desirable  

Qualifications: 

• Bachelor's degree in Computer Science, Information Technology, or related field 

• Must have at least 2 years’ experience in Azure Data Factory 

• Must have at least 7 years experience with Microsoft Azure platform and services 

• Azure certifications (e.g., Azure Data Engineer, Azure Solutions Architect) preferred 

• Strong expertise in data modeling, ETL processes, and database management 

• Proficiency in SQL, Azure SQL, and Azure Data Lake Storage 

• Familiarity with data warehousing concepts and tools 

• Excellent problem-solving and communication skills 

• Strong project management and leadership abilities 

• Ability to work collaboratively in cross-functional teams 

Location: 

This position is located in Chicago, IL, Pittsburgh, PA, or remote.

At Techstra Solutions, we help top companies and brands achieve the business value of Digital and Talent Transformation. We believe there are three components in successful business transformation: Business Strategy, Technology and Talent. It is the coming together of these three disciplines that enable companies to take full advantage of opportunities. It differentiates us. Our approach is holistic and all encompassing. We consider the full picture as we guide our clients on this journey. 

We are experts in transformation, business strategy, technology, innovation, and human capital management. We deliver our expertise through client consulting, innovative staffing solutions and software development. From strategy through implementation, we are dedicated to bringing our clients world-class business and talent solutions that fit strategic requirements and most importantly, deliver results. 

Equal Employment Opportunity Statement

Techstra Solutions is an equal opportunity employer. The Company makes its decisions on merit, and its policy of equal opportunity prohibits discrimination in all phases of the employment process, including, but not limited to, recruitment, hiring, promotion, selection, transfer, demotion, layoff, termination, compensation, benefits, and other terms and conditions of employment. The policy of equal opportunity applies without regard to race, color, creed, religion, gender,, sexual orientation, gender identification, pregnancy, marital status, national origin, ancestry, age, disability that can reasonably be accommodated without undue hardship, military status, veteran status, genetic predisposition or carrier status, alienage or citizenship, domestic partnership status, arrest or conviction record, status as a victim of domestic violence, or any other protected categories under federal, state, or local law. The Company also prohibits discrimination or harassment based upon the perception that a person has, or is associated with a person who has, any of these characteristics.