Associate Data Engineer, Enterprise Data Warehouse - Software Engineer AMTS

Key Skills

SQL, Machine learning techniques, Business Intelligence, ETL/ELT technologies, Tableau, Data Modelling

Job Description

Job Category

Products and Technology

Job Details

Business Technology blazes the trail of enterprise IT. Built on the foundation of our core values, we own more than the traditional IT components with a heavy focus on working closely with our business partners for amazing outcomes. Our goal is to deliver technology that is centered around our business and our collective success. We oversee technology strategy, Salesforce on Salesforce, customer and partner enablement, applications engineering, infrastructure, collaboration, enterprise operations, architecture, and program enablement. We own the world’s foremost Salesforce implementation and enable our global Ohana to do their best work by leveraging our platform.

The IT Enterprise Data Warehouse (EDW) function is responsible for the delivery of operational reporting and performance metrics to various business domains including Sales and Sales Operations, Marketing, Finance, Customer success and Employee Success.

This platform also includes management of a Big Data Hadoop platform to store unstructured application log data that is generated by the Salesforce product offerings, this data is predominately used by the data science teams. Team also leads all aspects of rolling out Salesforce’s analytics tool Wave to internal business partners.

The Salesforce IT EDW team is looking for an experienced BI designer who will work on designing, developing and implementing new functionality and increasing test coverage of systems that support various internal business processes at Salesforce.com. This requires the candidate to be able to learn quickly, work in a fast paced environment, and have the ability to communicate well with technical and non-technical personnel.

Responsibilities:

• Experience in designing and development of analytical solutions including Salesforce analytics solution – Wave and Tableau
• Contribute towards designing data models, ETL mappings and associated objects of analytical solutions.
• Review solution design with Lead members and ensure that the defined EDW standards and framework are followed.
• Review and validate logical and physical design to ensure alignment with the defined solution architecture.
• Create/review technical documentation for all new and modified objects.
• Ensure quality assurance plans and cases are comprehensive to validate the solution thoroughly.
• Follow standard practises for QA in the organization
• Support QA, UAT and performance testing phases of the development cycle.
• Understand and incorporate required security framework in the developed data model and ETL objects.
• Define standards and procedures; refine methods and techniques for data extraction, transformation and loading (ETL) both in batch and “near real time” modes.
• Evaluate, determine root cause and resolve production issues.
• Work closely with other IT development groups to deliver coordinated software solutions

Required Skills:

• 1+year of experience working as a BI technical resource in a customer-focused IT EDW team
• 2+years of experience in the data warehousing domain as a technical resource
• Deep understanding of data warehousing concepts, relational star-schema database designs and big data platforms and associated tools.
• Basic understanding and hands-on experience of Informatica 9.x, Tableau and snowflake system components, internal processes and architecture.
• Good knowledge of SQL and relational database models.
• Hands-on experience creating Unix shell scripts
• Data visualization tool experience like Tableau
• Good understanding of data modeling
• Basic working experience in an agile environment
• Excellent team player able to work with virtual and global across functional teams at all levels.
• Self-starter, highly motivated, able to shift directions quickly when priorities change, think through problems to come up with innovative solutions and deliver against tight deadlines.
• Excellent spoken and written communication as well as receptive listening skills, with ability to present complex ideas in a clear, concise fashion towards technical and nontechnical audiences.
• Excellent interpersonal skills will be needed in order to build strong relationships that will be critical for success of this role.

Desired Skills:

• Salesforce, Data Warehousing, customer success and Data Analysis
• Working experience on Data science or Python scripting is a plus
• Working experience of snowflake
• Excellent analytical, problem solving and debugging skills, with strong ability to quickly learn and solve problems in order to effectively develop technical solutions to their requirements

This role is Office-Flex (~1-3 days/wk in office) or Fully Remote