Data Engineer

Position

Location

Duration

Pay range:

Insight Global is seeking a skilled Data Engineer to design, build, and maintain our data processing systems using Azure cloud technologies. The ideal candidate will leverage Databricks, Azure Data Factory (ADF), and other Azure services to transform raw data into valuable business insights while ensuring scalability, reliability, and performance of our data infrastructure.

Key Responsibilities

• Design and implement end-to-end data pipelines using Azure Data Factory and Databricks

• Develop, optimize, and maintain ETL/ELT processes to ingest data from various sources

• Write efficient SQL queries and stored procedures for data extraction and transformation

• Create and maintain Databricks notebooks using Python for data processing and analysis

• Implement data quality checks and monitoring solutions

• Collaborate with data scientists and analysts to understand data requirements

• Participate in code reviews and maintain documentation

• Implement CI/CD pipelines for data solutions using GitHub

• Optimize data models for performance, scalability, and cost-efficiency

• Ensure data security and compliance with organizational policies

REQUIRED SKILLS AND EXPERIENCE

• Bachelors, Master's or Ph.D. degree in Computer Science, Mathematics, Statistics, or related field

• 5+ years of experience in data engineering roles

• Strong proficiency in SQL for complex data manipulation and querying

• Python and PySpark programming expertise with focus on data processing libraries

• Hands-on experience with Azure Databricks and Delta Lake

• Experience building and orchestrating data pipelines with Azure Data Factory

• Familiarity with Azure services such as Azure SQL, Azure Storage, Azure Synapse Analytics

• Experience with version control using GitHub and CI/CD practices

• Knowledge of data modeling techniques and best practices

• Understanding of data warehousing concepts and dimensional modeling

• Experience with data large-scale data processing

NICE TO HAVE SKILLS AND EXPERIENCE

• Knowledge of Azure DevOps for pipeline automation

• Familiarity with real-time data processing technologies

• Experience with NoSQL databases

• Azure certifications (Data Engineer, Solutions Architect)

• Experience with data visualization tools (Power BI, Tableau)

• Understanding of data governance and compliance requirements