Experience Level: 10+ years
Note: Only locals in California
Looking for a Technical Data Analyst who has hands on experience migrating Sales users and Sales data like Accounts, Opportunities, Contacts from Salesforce.com to Dynamics 365. He should also have strong experience in data profiling, data integration, transformations, understanding how data impacts downstream systems like Sales and Finance data warehouses/data lakes, reporting etc.
Responsibilities:
- Work with internal data teams and business teams to decipher the data related requirements for the project
- Need to have hands on experience in understanding the SFDC to Dynamics field mappings & data models.
- Design end to end strategy to stitch objects from various systems and financial KPIs
- Building integrations between SFDC, Dynamics, SAP ECC and DBX for Power BI reporting and financial metrics.
- Leverage data sources across the enterprise to build sophisticated and insightful analyses and data models for Sales, Finance and Marketing
- Need to have hands on experience with migrating Marketing and Sales data and users from Salesforce.com to Dynamics
- Work with the Product Managers to build detailed data requirements/specifications for Engineering teams to build the solution in downstream data management and reporting systems.
- Need to understand the migration challenges from similar experiences and build creative solutions to help with migrating data from SFDC to Dynamics.
Qualifications
- 4+ years of data analytics, ‘data BSA’ or data product management experience with solid understanding of how to deliver data solutions in an agile environment.
- Strong proficiency in SQL/SparkSQL/Python to query and manipulate large data sets. Experience with platforms like Databricks, Power BI and Tableau.
- You already know or can rapidly learn enterprise application capabilities in order to deliver transaction and event-driven data solutions (examples: SAP/HANA, MS Dynamics or Salesforce Data, ADLS/Hadoop/Databricks datalake/lakehouse solutions, and/or Kafka streams)