Posted 5 months ago
Enterprise Data Service - Member of Technical Staff
Salesforce, the Customer Success Platform and world's #1 CRM, empowers companies to connect with their customers in a whole new way. We are the fastest growing of the top 10 enterprise software companies, the World’s Most Innovative Company according to Forbes, and one of Fortune’s 100 Best Companies to Work For six years running. The growth, innovation, and Aloha spirit of Salesforce are driven by our incredible employees who thrive on delivering success for our customers while also finding time to give back through our 1/1/1 model, which leverages 1% of our time, equity, and product to improve communities around the world. Salesforce is a team sport, and we play to win. Join us!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, and Employee Success.Team also manages 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 developer 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.
Design data models, ETL mappings and associated objects of analytical solutions.
Design and development of analytical solutions including Business Objects based data marts and Salesforce analytics solution – Wave.
Review solution design 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 plan and cases are comprehensive to validate the solution thoroughly.
Support QA, UAT and performance testing phases of 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.
Bachelor's Degree in Computer Science, MIS, or related discipline, with 4+ years related information systems experience in Data Warehousing and delivery of BI solutions.
Deep understanding of data warehousing concepts, relational star-schema database designs and big data platforms and associated tools.
Deep understanding and hands-on experience of Business Objects, Informatica 9.x, Tableau and Oracle 11g system components, internal processes and architecture.
Experience and understanding of Python and AWS ecosystems.
Deep and strong knowledge of SQL and relational database models.
Hands-on experience with creating Unix shell scripts
Hands-on experience in data modeling
Experience working in an agile environment is required,must have clear understanding of the role and responsibility of a Scrum Master.
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 to 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.
Salesforce.com and Salesforce.org are Equal Employment Opportunity and Affirmative Action Employers. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender perception or identity, national origin, age, marital status, protected veteran status, or disability status. Headhunters and recruitment agencies may not submit resumes/CVs through this Web site or directly to managers. Salesforce.com and Salesforce.org do not accept unsolicited headhunter and agency resumes. Salesforce.com and Salesforce.org will not pay fees to any third-party agency or company that does not have a signed agreement with Salesforce.com or Salesforce.org.