Azure Data Architect

at  Techstra Solutions

As an Azure Data Architect 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:

• 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
• Experience developing security models.
• Develop and maintain data models, schemas, and architectures to optimize data storage and retrieval
• Implement ETL processes to ensure seamless data flow across systems
• Establish data security protocols and ensure compliance with industry standards and regulations.

Qualifications:

• Bachelor’s degree in Computer Science, Information Technology, or related field
• Must have experience in Azure Data Factory
• Proven experience as a Data Architect with a focus on Azure cloud technologies
• 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 Pittsburgh, PA.
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.

• 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
• Experience developing security models.
• Develop and maintain data models, schemas, and architectures to optimize data storage and retrieval
• Implement ETL processes to ensure seamless data flow across systems
• Establish data security protocols and ensure compliance with industry standards and regulations