SQL Data Engineer, Azure Synapse, Data Platform Modernization
Employment Information
Report this job
Job expired or something wrong with this job?
Job Description
Data Engineer specializing in SQL for modernization of data platforms. Focused on migrating legacy processes from SAS to SQL on Azure Synapse in São Paulo.
Responsibilities:
- Develop and optimize Stored Procedures in SQL.
- Participate in the migration of SAS processes to Azure Synapse.
- Interpret business rules embedded in SAS code.
- Validate the consistency and equivalence of data between legacy and modern environments.
- Perform data quality analysis, reconciliation, and identification of inconsistencies.
- Collaborate with technical and business teams throughout the modernization process.
- Contribute to performance improvements and optimization of implemented solutions.
Requirements:
- Strong experience with SQL Server and T-SQL.
- Development of Stored Procedures.
- Experience with Views, CTEs, Window Functions, temporary tables, and transactions.
- Knowledge of relational data modeling.
- Experience handling large volumes of data.
- Performance tuning and execution plan analysis.
- Experience with ETL processes.
- Experience in data validation and data quality (Data Quality).
- Analytical ability to interpret business rules and investigate discrepancies between databases.
- Knowledge of SAS (DATA STEP and PROC SQL) to interpret legacy code.
- Experience with Azure Synapse Analytics.
- Knowledge of Git and code versioning.
- Experience with PySpark and Spark SQL.
- Experience in Data Warehouse migration, ETL, or data platform modernization projects.
- Experience using AI tools to assist development, such as GitHub Copilot, Microsoft Copilot, Cursor, or ChatGPT.
Benefits:
- Analytical and investigative mindset.
- Organized and detail-oriented.
- Proactive and collaborative.
- Communicative and able to work well in a team.
- Committed to quality and excellence in deliverables.
- Able to work autonomously to solve complex problems.
Similar Jobs
Lead Engineer, Azure
Lead Engineer (Azure) for a top 20 CPA firm, serving clients with cybersecurity solutions. Collaborate on Zero Trust strategies and client delivery for security compliance.
Data Engineer – Azure, Snowflake
Data Engineer at Mindex creating scalable data pipelines and integrating data solutions. Collaborating with stakeholders to support analytics, reporting, and AI initiatives.
Lead Cloud & Data Platform Engineer
Lead Cloud and Data Platform Engineer developing automated data ecosystems for healthcare provider. Designing, provisioning, and optimizing the full data ecosystem on Azure and Snowflake.
Cloud Data Architect – DBT
Cloud Data Architect at Muttdata designing large-scale data platforms for a banking project using Big Data and Machine Learning technologies.
Software Engineer, Java, AWS
Software Engineer developing Java and AWS solutions for Sophos, a cybersecurity leader defending 600,000 organizations globally. Designing and building foundational toolset for developers.
Administrador Cloud – AWS
Cloud Administrator specializing in AWS to collaborate on full-remote projects at IRIUM. Ideal for experienced professionals with strong English skills and relevant AWS knowledge.
Senior Cloud Data Engineer, GCP Data Fabric
Senior Cloud Data Engineer spearheading data migration initiatives to Google Cloud Platform. Focused on optimizing cloud data pipelines, data integrity, and implementing modern data architectures.
Cloud Security Engineer
Cloud Security Engineer improving cloud security across Oracle, AWS, GCP, and Azure environments. Engaging clients by implementing security controls and compliance initiatives.
Senior Data Engineer – Databricks, Azure Data Platform
Senior Data Engineer responsible for building and maintaining a scalable data platform on Databricks. Supporting key processes in the insurance and reinsurance environment with multiple data sources integration.
Consultant – Cloud Infrastructure Services
Consultant for Cloud Infrastructure Services at Red Hat delivering customer cloud projects and improving customer experiences. Engaging in design, implementation, and support of Red Hat cloud solutions.
Senior SAP Business One Consultant – Cloud Migration, Future Architecture
SAP Business One Consultant at Cloudiax focusing on cloud migration from SQL Server to SAP HANA. Collaborating with partners and clients to ensure their migration strategies succeed.
Senior Data Engineer – Azure Cloud
Engenheiro de Dados SR atuando na construção e sustentação de pipelines de dados em Azure. Contribuindo para soluções escaláveis e eficientes em projetos de Data & AI.
Senior Cloud Platform Engineer – Tech Cloud Development
Senior Python Cloud Platform & Full-Stack Engineer at EY building scalable cloud-native solutions and automation frameworks. Focus on improving operational efficiency through engineering tools and dashboards.
Principal Cloud Architect
Principal Cloud Architect leading multi-cloud infrastructure design and optimization at Banner Health. Collaborating with cross-functional teams to ensure scalability, security, and innovation across cloud systems.
Back-End Python Engineer, AWS – Desktop
Back-End Python Engineer designing scalable RESTful APIs and microservices at Miratech. Focused on cloud technologies and backend development in a global IT services context.
Back-End Python Engineer – AWS
Back-End Python Engineer developing scalable AWS applications for Miratech. Collaborating across teams to design and maintain secure backend systems using cloud technologies and Python.
Lead Java Developer – Azure
Lead Java Developer for Satalia creating enterprise quality optimisation and ML solutions. Collaborate with data science teams, ensuring robust and high-quality cloud solutions for customers.
Data Engineer, Snowflake, dbt, Azure
Data Engineer developing data pipelines and transformations using Snowflake and Azure Data Factory. Working remotely with an expert team in Data & AI at Logicalis Spain.
Cloud Architect
Cloud Architect at Techmahindra responsible for designing scalable enterprise solutions. Collaborating cross-functionally and ensuring architecture alignment with standards and practices.
Cloud Security Engineer
Join Periferia IT Group as a Cloud Security Engineer managing security for applications and microservices. Work fully remote with opportunities for professional growth in a tech-driven environment.