Software Engineering SMTS (DW/BI)
4d ago

Job Category

Products and Technology

Job Details

Enterprise Data Service - Senior Member of Technical Staff

The BT Enterprise Data Service (EDS) team 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.

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 predominantly used by the data science teams.

Team also manages all aspects of rolling out Salesforce’s analytics tool Wave to internal business partners.

The Salesforce BT EDS team is looking for an experienced BI Engineer who will work on designing, developing and implementing new analytical capabilities to support various internal business users.

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 :

  • Lead design and development of analytical solutions design data models,design and develop ETL mappings and associated objects required for analytical solutions.
  • 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.
  • Provide technical leadership and oversee the delivery of solutions developed by vendors.
  • Ensure quality assurance plan and test 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.
  • Required Skills :

  • Bachelor's Degree in Computer Science, MIS, or a related discipline, with 7+ years related information systems experience in Data Warehousing and delivery of BI solutions.
  • Experience working as a BI technical lead / solution architect in a customer-focused IT EDW team
  • Deep understanding of data warehousing concepts, relational star-schema database designs ,big data platforms and associated tools.
  • Deep understanding and hands-on experience on Informatica 9.x,Business Objects, Tableau and Oracle 11g system components, internal processes and architecture.
  • 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 a 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 the ability to present complex ideas in a clear, concise fashion to technical and nontechnical audiences.
  • Excellent interpersonal skills in order to build strong relationships that will be critical for the success in this role.
  • Prior experience in AWS, GCP or cloud based datawarehousing is a plus
  • Desired Skills :

  • Basic Knowledge of Hadoop - HDFS , Hive, Pig , Sqoop , Kafka etc.
  • Salesforce, ERP solutions and Data Analysis
  • Data visualization tool experience like Tableau, QlikView and Spotfire is a plus.
  • 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.
  • Nice to have any of the following skills - Understanding of Artificial Intelligence capabilities / Machine learning, statistical modeling and Python scripting
  • 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!

    Accessibility - If you require accessibility assistance applying for open positions please contact the Recruiting Department.

    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Application form