Accurate Background LLC

  • BI Lead Engineer

    Job Locations US-CA-Irvine
    Job ID
    # of Openings
    Posted Date
    5 months ago(2/7/2019 2:15 PM)
    810 - Engineering
  • Overview

    As BI Lead Engineer, you will be leading 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 both traditional and modern Data Warehouse concepts. 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 or similar visualization tools. The candida should also be familiar with integration of analytics with different web portals using API.


    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!


    • Works on highly complex and cross-functional BI solutions.
    • Works with BSA or product owners to understand customer needs and help in translating business requirements to technical stories.
    • Participates in work stream planning process including inception, technical design, development, testing and delivery of BI solutions.
    • Participates in project management estimation process.
    • May participates in the development of business cases to support IT projects.
    • Explores the data and discovers patterns, meaningful relationships, anomalies, and trends.
    • Performs programming analyses for a wide range of requests using data in different formats and from various platforms.
    • Ensures documentation is created and maintained.
    • Interfaces with Architects to recommend new technology opportunities that will have an impact on BI systems.
    • 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.
    • Ability to create dashboards using Tableau or similar tools
    • Ability to choose and implement right API for integration with web portal
    • Responsible for unit, string, and system testing and assisting in development of UAT test plans


    Requirements, Skills, and Education


    • 5+ years-experience implementing ETL for Data Warehouse and Business Intelligence Solution
    • 10+ years-experience in RDBMS design, development and performance tuning
    • 3+ years-experience with ETL/ELT on AWS environment.
    • 3+ years-experience using Tableau or similar tools
    • 5+ years working experience as team lead
    • Deep familiarity with the Scrum process
    • 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 NoSQL databases such as Mongo DB 



    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


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


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