Previous Job
Ref No.: 18-04522
Location: San Francisco, California
Diversant is seeking a talented Technical Business Analyst that bring data analytics experience to our client in the financial services industry.  This opportunity has to potential to go 24 months and is based in San Francisco.  We are working directly with the hiring manager who is moving forward immediately.

Client is Unable to sponsor employment visas for this position. Candidates with unrestricted authorization to work in the United States are encouraged to apply.

Job Details:
  • The ideal candidate is someone who can work closely with business partners to understand their needs translate that into data capabilities that are required in a data system intended to drive campaign life-cycle, enable model development, and customer profiling.
  • This project requires a candidate with strong critical thinking, consulting, and technical skills. Ideally someone that has experience with product categorizations in the financial industry
  • Analyze system of record data to develop and maintain categorization schemes rationalized with existing processes as most of the client's data warehouses are Teradata and most of current work the team does is in Unix.
  • Project requires a very strong candidate both technically as well consulting skills.
    Ideally someone who has worked with financial data warehouses and understands what a marketing data mart consists of and ideally experience building and leveraging one to
    • Create customer profiles that aggregate metrics such a how many account a customer has by type
    • Create campaign sizings, looking for customers that don’t have targeted products
    • Create data sets for lead list generation
    • Perform campaign performance tracking connecting the products targeted to accounts opened
  • Candidate will need to work closely with business partners to understand their needs
  • Identify the available options from universe of client’s data warehouses to source required data points  communicate those requirements to the ETL team that is building the system
  • Create test cases and perform UAT to confirm system meets those needs
  • Ability to dig into existing ETL processes from different lines of business; translate the sourcing of metrics/data points into technical documentation
Required Skills:
  • Experience with data discovery and decoding system documentation
  • Test case development and test execution
  • Ideal technical proficiencies in : SQL - Teradata - Hadoop - Unix shell scripting - BTEQ