Sr. Data Engineer will be responsible for developing curated data (data models, data ETL pipelines, views) in a cloud-based environment to support business needs for analytics and reporting. The engineer will assist an existing team with migration from on prem to cloud-based data delivery platform and should have experience in migration of environments. The candidate will provide guidance and support for the set-up of the new environment along with best practices and recommendations based on industry and hands on experience as a data engineer. In addition, the candidate should have experience with standardizing data modeling and design frameworks for analysis, design, building, testing and maintenance. Cloud based data engineering is required and experience using the Azure stack is highly preferred and recommended. Candidates must possess the technical capabilities to extract, retrieve and analyze data with SQL based tools. The engineer should possess strong interpersonal communication skills to be able to bridge the gap between business and technical users to understand and assess requirements and deliver data driven solutions. The role will also involve adhering to data governance standards and practices along with experience developing in an agile environment using Azure boards.
- Basically, a Software Engineer that is more focused on the Data aspect for both relational databases and document databases
- Needs to know Oracle, SQL, Mongo, Cosmos
- Azure focused (Azure Data Factory, Cosmos, Synapse, Azure SQL, ADLS)
- Nice to have - experience using canonicals to pass data between systems, ETL with Informatica
1. Design and architect end-to-end data platform solutions on the Azure cloud platform, considering scalability, reliability, performance, and security.
- Collaborate with stakeholders to understand business requirements and translate them into technical specifications and data architecture designs.
- Develop and implement data models, schemas, and database structures to ensure efficient data storage and retrieval.
- Design and implement data integration solutions, including data ingestion, transformation, and data pipeline orchestration using Azure data services (e.g., Azure Data Factory, Azure Databricks, Azure Logic Apps, Azure Functions).
- Optimize and tune data solutions for performance, ensuring efficient query execution and data processing.
- Implement data security and compliance measures, including data encryption, access controls, and data masking techniques.
- Work closely with data analysts, data scientists, and other stakeholders to understand their data requirements and provide guidance on data availability and accessibility.
- Collaborate with infrastructure teams to design and implement robust data storage and backup strategies, leveraging Azure storage services.
- Monitor and troubleshoot data platform solutions to ensure high availability, reliability, and performance.
- Stay up-to-date with the latest trends and advancements in Azure data services, data engineering, and data architecture, and provide recommendations for adopting new technologies and best practices.3. Strong knowledge of Azure data services, including Azure SQL Database, Azure Synapse Analytics, Azure Cosmos DB, Azure Data Lake Storage, and Azure Blob Storage.
Familiarity with data visualization and reporting tools, such as Power BI or Azure Analysis Services, is a plus
Relevant Microsoft Azure certifications, such as Azure Data Engineer Associate or Azure Solutions Architect, are highly desirable