Job Title: Salesforce Data Engineering Lead
We are seeking a Salesforce Data Engineering Lead to design, implement, and manage data-intensive applications related to Salesforce for the company. This role provides subject matter expertise for our integrated Informatica CC360 Master Data Management solution within Salesforce and works closely with the company's Global Technology (GT) teams to deliver innovative data solutions using a range of technologies. The Salesforce Data Engineering Lead also collaborates with vendors and managed service providers (MSPs) for project development and process optimization, while providing level 3 support for incidents and service requests. You will also mentor level 1 and level 2 associates and MSP teams.
Key Responsibilities:
General Contributions:
- Support team, department, and business objectives by conducting detailed quantitative and qualitative analysis of business processes and projects. You may also manage small-scale projects or elements of larger ones.
- Solve complex business requests and make decisions for non-routine issues with moderate risk, ensuring smooth business operations.
- Assist senior associates in achieving business results by identifying areas for business process improvement, contributing to operating plan development, and ensuring budget adherence.
- Show personal awareness of strengths and areas for growth, proactively working to enhance skills and knowledge.
- Perform additional duties as required.
Role-Specific Contributions:
- Partner with Business Analysts and Architects to understand business requirements for new features or capabilities.
- Convert business requirements and architectural guidance into technical solution documentation and diagrams to support supplier bids. These documents will outline the technical details for the supplier's development work.
- Design scalable, high-performance data solutions within the Salesforce ecosystem, ensuring alignment with enterprise data management goals, and applying expertise in data sourcing, integration, governance, and security.
- Develop and document strategies for data migration and integration, ensuring data accuracy, consistency, and traceability during migration and ongoing operations.
- Lead the development of reporting and dashboard solutions leveraging Salesforce data, meeting business and GT team requirements.
- Review supplier bids and proposed work orders, providing guidance on technical designs and solutions.
- Oversee supplier-developed designs and test plans to ensure compliance with approved specifications and company's application development standards.
- Collaborate with project management roles to set delivery requirements and oversee project execution.
- Review supplier work products to ensure they meet design specifications and company's best practices.
- Provide advanced (Level 3) support during production incidents, resolving outages and sharing knowledge to enable suppliers to handle similar issues independently in the future.
- Contribute to company's Best Practices Library by enhancing technical standards.
- Perform other relevant tasks as assigned.
Candidate Profile:
General Requirements:
- Professional background with expertise in specific disciplines (e.g., Information Technology, Accounting). A college degree or equivalent work experience is required.
Specific Requirements:
Education:
- Bachelor's degree in Information Technology or a related field, or equivalent work experience.
Preferred Certifications:
- Database-related certifications (e.g., Azure Data Engineer, Oracle Database SQL Certified Associate).
- Master Data Management (MDM) certifications (e.g., Informatica Master Data Management Developer).
- Relevant Salesforce certifications (e.g., Admin, Platform Developer, Integration Architect).
Experience:
- 5-8 years of experience in developing data solutions using integration and transformation tools such as Informatica IDMC or similar platforms (e.g., Microsoft SSIS).
- 2+ years of experience supporting Master Data Management processes in a highly integrated environment. Informatica CC360 experience is ideal, but other tools (e.g., IBM Infosphere, SAP MDM) are also relevant.
- Experience with globally sourced operating models and working with suppliers for application development services.
- Familiarity with project management tools such as Atlassian Jira.
- Experience with Salesforce application design, delivery, and extension is desirable.
Skills and Attributes:
- Analytical & Strategic Thinking: Strong analytical skills for troubleshooting and identifying system issues, with a proactive approach to resolving potential future challenges.
- Technical Expertise:
- Experience in designing and developing data solutions using Informatica CC360, Salesforce Apex & Flows, Heroku Connect, and similar tools.
- Ability to support Master Data Management (MDM) processes and leverage SQL for data querying and modification.
- Experience in enterprise reporting and analytics tools.
- Proficient in debugging and troubleshooting data-related applications (Splunk experience is a plus).
- Familiarity with Salesforce data processing, integration, and customization is highly advantageous.
- Project Management Skills: Ability to gather business requirements, plan, execute, and deliver Salesforce solutions on time and within budget.
- Interpersonal Skills:
- Effective communication to explain technical concepts to non-technical stakeholders.
- Strong customer service focus to understand and meet client needs.
- Collaborative mindset to work with Global Technology teams, vendors, and MSPs to drive successful project outcomes.
- Leadership capabilities to inspire and guide teams in the successful implementation of data solutions.
- Additional Attributes:
- Adaptability to change within a dynamic, matrixed environment.
- Curiosity and commitment to continuous learning, staying up-to-date with Salesforce and industry advancements.
This role provides an opportunity to play a key part in delivering impactful data solutions that support company's growth and operational excellence.
