ETL Developer w/ Power BI, Azure Synapse

Job Description

We are seeking an experienced Senior ETL Developer to join our client's data engineering team. The ideal candidate will design, develop, and maintain robust ETL pipelines, leveraging advanced analytics and visualization tools to support business intelligence initiatives. This role requires strong technical expertise, problem-solving skills, and the ability to collaborate with cross-functional teams to deliver scalable data solutions.

Key Responsibilities

Design, develop, and optimize complex ETL processes to extract, transform, and load data from various sources into data warehouses and data lakes.

Build and maintain interactive dashboards and reports using Power BI to support business decision-making.

Implement and manage data pipelines in Azure Synapse Analytics, ensuring performance, scalability, and reliability.

Write and maintain scripts in scripting languages (e.g., Python, PowerShell, or Bash) to automate data workflows and processes.

Manage and utilize code repositories (e.g., Git, Azure DevOps) for version control, code collaboration, and deployment.

Collaborate with data architects, analysts, and business stakeholders to understand requirements and deliver data solutions.

Ensure data quality, integrity, and security across all ETL processes and platforms.

Monitor and troubleshoot ETL pipelines, identifying and resolving performance bottlenecks.

Stay updated with industry trends and emerging technologies to enhance data engineering practices.

Must-Have Skills and Qualifications

ETL Development: 3+ years of experience designing and implementing ETL pipelines using tools like Informatica, Talend, SSIS, or Azure Data Factory.

Power BI: Proficiency in creating interactive dashboards, reports, and data visualizations using Power BI.

Azure Synapse Analytics: Hands-on experience with Azure Synapse for building and managing data pipelines, data lakes, and analytics solutions.

Scripting Languages: Strong programming skills in at least one scripting language (e.g., Python, PowerShell, or Bash) for automation and data processing.

Code Repositories: Experience with version control systems like Git, Azure DevOps, or Bitbucket for managing codebases and collaborating with teams.

Bachelor’s degree in Computer Science, Information Systems, or a related field (or equivalent experience).

Strong understanding of data warehousing concepts, data modeling, and database technologies (e.g., SQL Server, Azure SQL).

Excellent problem-solving skills and attention to detail.

Ability to work independently and in a team-oriented environment.

Preferred Skills

Experience with other Azure services (e.g., Azure Data Lake, Azure Databricks).

Knowledge of big data technologies (e.g., Hadoop, Spark).

Familiarity with CI/CD pipelines and DevOps practices.

Certification in Azure, Power BI, or relevant ETL tools.