Data Engineer - Azure -ETLCalgaryJob Description: Data EngineerWe are looking for a Data Engineer who can work as individual contributor within Team, should have good communication skills. Need to involve in requirement discussion and responsible for designing, building and maintaining the infrastructure that enables data collection, storage and processing.Key Responsibilities:Data pipeline developmento Design, build and maintain scalable ETL (Extract, Transform, Load)o Automate data ingestion from multiple sources (APIs, database, files, etc.).Data Storage & Managemento Develop and optimize data storage solutions (e.g. datalakes, warehoures)o Ensure data integrity, consistency and security across systems.o Work with Azure cloud storageData Processing & Transformationo Process and clean raw data for analysis and visualizationreporto Implement real-time and batch data processing workflows using Spark, KafkaDatabase Managemento Design and optimize relations (SQL) and NoSQL databases.o Improve database performance indexing, and query optimizationData Governance & Securityo Implement Data quality, validation and governance standards.o Ensure compliance with data privacyoRequirements:Strong proficiency in Databricks, Azure Data Factory and API integration.Proficiency in programming languages such as Python, SQL and PySpark.Familiarity with data modeling, ETL processes and data governance.Design, develop and maintain robust and scalable data pipelines using Databricks, Azure Data FactoryFamiliarity with DevOps practices and tools for CI/CD pipelines.Experience with Azure cloud platformIntegrate data from various APIs and external sources to enrich and expand datasets.Collaborate with cross-functional teams to understand data requirements and translate them into technical solutions.Implement data integration processes to collect and store structured and unstructured data from multiple sources.Ensure data quality and integrity throughout the data lifecycle.Excellent attention to detail and ability to work independently.Strong communication and collaboration skills.Project-Specific Requirements:Data Engineer will be responsible for creating a pipeline, ETL. Ingesting data from multiple sources like API, SharePoint, SAB. Communicate with stakeholders to gather and clarify requirements.
