Senior Data Engineer - Azure Synapse

accel bi corporation

Accel Bi Corporation is looking for a seasoned Senior Synapse Data Engineer to develop and maintain data pipelines and analytics on Microsoft Azure Synapse. This pivotal role involves optimizing data assets to ensure performance and security, driving data-driven decisions across the organization.

In this role you can expect to have the responsibilities:

• Design and manage data models in Azure Synapse Analytics for reporting.
• Build and optimize ETL/ELT pipelines for Salesforce data using Azure Synapse.
• Analyze systems to create effective data ingestion workflows.
• Configure Azure Synapse Analytics workspace, managing linked services and datasets.
• Monitor and optimize cloud infrastructure and data pipelines.
• Collaborate to enhance Azure services and cost management.
• Partner with stakeholders to develop Power BI dashboards.
• Enable self-service BI and user training.
• Optimize Power BI datasets for performance.
• Integrate Salesforce and Azure Synapse using APIs and tools.
• Develop solutions using Salesforce APIs and Lightning Web Components.
• Ensure seamless data flow using integration tools like MuleSoft.
• Enforce data governance, security, and compliance best practices.
• Maintain comprehensive data documentation.

This role requires you to have:

• 4+ years of Azure Synapse Analytics experience.
• 4+ years in Azure Data Platform development.
• 4+ years in ETL/ELT processes and data modeling.
• 5+ years of SQL and T-SQL expertise.
• 1+ year in Salesforce integrations.
• 3+ years using integration tools like MuleSoft.
• 3+ years in DevOps and CI/CD practices.
• 5+ years with Infrastructure as Code tools like Terraform.
• 3+ years with cloud platforms such as AWS and Azure.
• 2+ years with Lightning Web Components in Salesforce.
• 1+ year in Power BI development.

You would benefit from having:

• Familiarity with Azure Event Hubs and Functions.
• Understanding of data security and compliance.
• Experience with cloud computing and containerization.
• Strong problem-solving and communication skills.