Team Trailhead at Salesforce is looking for a Data Engineer (LMTS) to join our Learning Technology team.This position requires an individual with strong Salesforce platform knowledge, technical prowess, especially in migrating data into Salesforce cloud and establishing data pipeline into data warehouse. In this role, you will work closely with engineering teams, operations teams, and vendor teams to implement data migration from 3rd party system to Salesforce cloud and warehouse data pipelines.

Responsibilities

• A Data Engineer will be responsible for designing, developing & maintaining all parts of the data pipeline to migrate data from 3rd party systems to Salesforce cloud.
• A Data Engineer will be responsible for implementing data pipelines to drive insights through data science, reporting & analytics.
• Demonstrating exceptional analytical, troubleshooting, and problem-solving expertise
• Quickly develop and maintain technical and domain expertise in assigned areas of product functionality.
• Take ownership of issues that may arise and see through them until completion.
• Demonstrate ability to meet deadlines, handle and prioritize simultaneous requests, and manage laterally and upwards
• Collaborate with the Applications team to support changes and enhancements in Salesforce
• Be responsible for the technical solution design, lead the technical architecture and implementation of data acquisition and integration projects, both batch and real time.
• Communicate with product owners and analysts to clarify requirements. Craft technical solutions and assemble design artifacts (functional design documents, data flow diagrams, data models, etc.).
• Identify incomplete data, improve quality of data, and integrate data from several data sources. Proactively identify performance & data quality problems and drive the team to remediate them.
• Advocate architectural and code improvements to the team to improve execution speed and reliability.
• Clearly articulate pros and cons of various technologies and platforms in open source and proprietary products. Implement proof of concept on new technology and tools to help the organization pick the best tools and solutions.
• Harness operational excellence & continuous improvement with a can do leadership demeanor.
• Strong SQL optimization and performance tuning experience in a high volume data environment that uses parallel processing.
  
  

Professional Experience/Skills Required

• Experience will be evaluated based on alignment to the core competencies for the role (e.g. extracurricular leadership roles, military experience, volunteer work, etc.)
• Minimum 7 years of relevant hands-on experience in various Salesforce cloud products such as Sales Cloud, Service Cloud, Experience Cloud, Data Cloud
• Experience migrating data from 3rd party systems to Salesforce could.
• Experience building programmatic ETL pipelines with SQL based technologies and platforms.
• Solid understanding of databases, and working with sophisticated datasets. Data governance, verification and data documentation.
• Work with different technologies (Python, shell scripts) and translate logic into well-performing SQL, automate data pipelines using scheduling tools like Airflow.
• Experience in Snowflake, MySQL, Postgres, Salesforce data loader, SQL, SSQL, Python, Airflow, AWS,, Tableau,
• Knowledge of data modeling techniques and high-volume ETL/ELT design.
• Experience developing in an enterprise environment such as source code control, IDE, continuous deployment, release management (Git, Eclipse, CircleCI, link VSCode)
• Experience supporting Salesforce integrations with external systems and ETL tools.
• Ability to work under pressure, highly adaptable, and well-organized
• Experience working scrum/agile project management methodologies and SDLC.
• Hands-on on Salesforce.com knowledge of product and functionality a plus.
• Strong problem solving with acute attention to detail and ability to meet tight deadlines and project plans.
• Ability to research, analyze, interpret, and produce accurate results within reasonable turnaround times with an iterative mentality with rapid prototyping designs.
• Ability to work effectively in an unstructured and fast-paced environment both independently and in a team setting, with a high degree of self-management with clear communication and commitment to delivery timelines.