Data Analytics Salesforce Specialist - Remote

Overview

The role involves supporting the development of the Client 360 project by providing assistance in building and understanding the connections between databases and Salesforce, as well as extracting relevant information for the project.

In Short

• Manage relational databases: modeling, optimization, and maintenance.
• Deploy and manage resources in Azure (SQL Database, Data Factory, Storage).
• Extract data from Salesforce using SOQL/SOSL and generate reports.
• Develop ETL scripts in Python (pandas, requests, sqlalchemy).
• Create Dataflows and Datasets in Power BI (Back-end) and design interactive dashboards (Front-end).

Requirements

• Proven experience with SQL Server, MySQL, PostgreSQL, or others.
• Intermediate knowledge of Azure Portal, CLI, and ARM Templates.
• Proficient in Salesforce queries.
• At least 1 year of experience in Python for ETL.
• Intermediate experience with Power BI.

Benefits

• Experience with Azure Data Factory, Synapse Analytics, or Databricks is desirable.
• Knowledge of CI/CD with Git and Azure DevOps.
• Experience consuming REST/JSON APIs.
• Collaborative work under agile methodologies.