Azure Data Engineer
Req number:
R3978
Employment type:
Full time
Worksite flexibility:
Hybrid
Who we are
CAI is a global technology services firm with over 8,500 associates worldwide and a yearly revenue of $1 billion+. We have over 40 years of excellence in uniting talent and technology to power the possible for our clients, colleagues, and communities. As a privately held company, we have the freedom and focus to do what is right—whatever it takes. Our tailor-made solutions create lasting results across the public and commercial sectors, and we are trailblazers in bringing neurodiversity to the enterprise.
Job Summary
We are looking for an Azure Data Engineer with experience in designing, building, and maintaining data pipelines to support business and analytics needs, this position will be full time and remote.
Job Description
As an Azure Data Engineer, you will be responsible for designing, building, and maintaining data pipelines to support business and analytics needs. You will work closely with data analysts and business stakeholders to understand their needs and develop solutions to meet those needs.
What You’ll Do
Azure Databricks and Azure Synapse Analytics, Azure Data Lake
Design, develop, manage data flows that integrate information from various sources into a common data lake using Microsoft Azure data Factory.
Extract, transform and load data from variety of sources, including on-premises databases, cloud-based data stores and API calls.
6+ years of working with SQL, implement data processing and transformation logic using SQL, handling complex windowing functions and joins.
Optimize and tune data pipelines for performance, scalability, and cost-efficiency, leveraging best practices and automation tools.
Ensure data quality, integrity, and security throughout the data lifecycle, implementing data governance policies and compliance standards.
Collaborate with data analysts and business stakeholders to understand their data needs and develop data models and solutions to meet those needs.
Monitor and troubleshoot data pipelines, identifying and resolving issues in a timely manner to minimize impact on business operations.
Competencies & Experience Required/Desired
Effective communication and collaboration skills, with the ability to work effectively in a remote and cross-functional team environment.
Experience working on ETL, Microsoft Azure SQL Data Warehouse, SQL Scripting, with exposure to other services on the Azure landscape, API Data Extraction
What You’ll Need
Any Degree
6+ Years of Experience in Azure with Data Engineering.
4+ Hands on experience in Azure technologies such as Azure Data Factory,
Proven experience as a data engineer, with a focus on designing and building data solutions on Azure.
Knowledge of Azure data services such as Azure Data Factory, Azure Databricks, Azure Synapse Analytics, Azure SQL Datawarehouse, and Azure Data Lake Storage.
Strong proficiency in SQL.
Experience with data modeling, schema design, and performance optimization techniques.
Expert in data integration patterns, ETL/ELT processes, and data warehousing concepts.
Excellent problem-solving and analytical skills, with the ability to troubleshoot complex data issues and drive resolution.
Physical Demands
Sedentary work that involves sitting or remaining stationary most of the time with occasional need to move around the office to attend meetings, etc.
Ability to conduct repetitive tasks on a computer, utilizing a mouse, keyboard, and monitor.
Reasonable accommodation statement
If you require a reasonable accommodation in completing this application, interviewing, completing any pre-employment testing, or otherwise participating in the employment selection process, please direct your inquiries to application.accommodations@cai.io or (888) 824 – 8111.
V.R.SENIOR SECONDARY SCHOOL (Affiliated to CBSE) Needs teachers for 2023-2024 with excellent Academic record & Computer savvy. Job Code: Proficiency in...
Apply For This Jobbr{display:none;}.css-58vpdc ul > li{margin-left:0;}.css-58vpdc li{padding:0;}]]> Responsibilities A day in the life of an Infoscion • As part of the Infosys...
Apply For This JobJob Location: Mumbai (Bombay) Job Description: Graphic Artist / Designer Job Description 1.Create visual text and imagery concepts, by hand...
Apply For This Jobbr{display:none;}.css-58vpdc ul > li{margin-left:0;}.css-58vpdc li{padding:0;}]]> Managing a team of representatives offering customer support. Overseeing the customer service process. Selecting and...
Apply For This JobFull Job Description Designation: HR Payroll & Admin Location: Delhi Experience: 4+ Year Only Females candidates Apply Roles and Responsibilities...
Apply For This Jobbr{display:none;}.css-58vpdc ul > li{margin-left:0;}.css-58vpdc li{padding:0;}]]> Designation: Customer Service Associate Process: Voice ( Inbound/ Outbound ) Job Location: Kothrud, Pune Salary:...
Apply For This Job