Accurate Background LLC

  • Senior ETL/Tableau Developer

    Job Locations US-CA-Irvine
    Posted Date 2 months ago(9/17/2018 2:11 PM)
    Job ID
    2018-1045
    # of Openings
    1
    Category
    810 - Engineering
  • Overview

    As Senior ETL/Tableau Developer on the team, you will be working with BI team to design, develop, implement and document data integration processes, as well as influence the long-term evolution of our analytics capability. The ideal candidate will have extensive experience with traditional Data Warehouse concept. The candidate should have excellent communication skills and able to work with product owner to develop and define technical requirements. The candidate should have good knowledge and working experience with Tableau.

     

    Accurate Background is a fast-growing organization, focused on providing employment background screenings and building trustful relationships with our clients.  Accurate Background continues to exceed expectations by offering an array of innovative and cutting-edge background check and credentialing products to meet the needs of human resource, loss prevention, and security/legal professionals in employment screening and vendor certification.

     

    We offer a fun, fast-paced environment, with lots of room for growth.  If this sounds good to you, join our team!

    Responsibilities

    • Ability to create ETL specifications, unit, and system integration test cases
    • Build reusable components for a scalable ETL methodology such as error handling, logging and recoverability
    • Ability to read and write effective, modular, dynamic (parameterized) and robust code, establish and follow already established code standards, and ETL framework
    • Ability to capture and research SSIS issues and bugs, build sample test jobs that recreate a bug, and troubleshoot the ETL until successful issue resolution.
    • Responsible for unit, string, and system testing and assisting in development of UAT test plans

    Qualifications

    Requirements, Skills, and Education

     

    • 5+ years-experience implementing ETL for Data Warehouse and Business Intelligence Solution
    • 7+ years-experience in RDBMS design, development and performance tuning
    • Deep familiarity with MS SQL Server 2008 R2 to MS SQL Server 2014 database technologies and ETL best practices with MS SQL Server environment
    • Deep familiarity with MS SQL Server 2008 R2 to MS SQL Server 2014 database technologies and ETL best practices with MS SQL Server environment
    • Experience using Business Intelligence Development Studio to build SSIS packages
    • Excellent troubleshooting & optimization skills: interpreting ETL logs, performing data validation, dissecting SSIS code, understanding the benefits and drawbacks of parallelism, experience with change data capture, using expressions, scoping of variables, commonly used transforms, event handlers and logging providers, ability to understand and optimize the surrogate key generation and inconsistent data type handling.
    • Experience in performance tuning of the SSIS packages,  deploying and administering SSIS packages, proficient in utilizing scripting in SSIS, and replacing ActiveX script tasks in DTS with the script task in SSIS.
    • Experience with creating data sources for Tableau
    • Experience with creating visuals with Tableau is a plus
    • Experience with NoSQL databases such Mongo DB is a plus

    Working Conditions:

     

    • The company environment is dynamic and reflective of rapid growth.
    • Friendly, helpful, open, and all inclusive.
    • Fast paced with frequent changes.
    • Sits and works at desk computer-keyboard for extended periods of time.
    • Works with others.
    • Hours may exceed 40 hours per week.
    • Some noise level within the office.

     

    Accurate Background offers competitive compensation, a comprehensive employee benefits package, supplemental benefit options, generous paid time off, and 401(k) employer contribution. 

     

    Our company uses E-Verify to confirm the employment eligibility of all newly hired employees.  To learn more about e-Verify, including your rights and responsibilities, please visit www.dhs.gov/E-Verify.

     

    All qualified applicants will receive consideration of employment without regard to race, color, religion, gender, national origin, or other status protected by applicable law.

    Options

    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed