As Senior BI engineer 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 in cloud. The ideal candidate will have extensive experience on 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.
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 medium to complex and cross-functional BI solutions.
May participate in or supports work stream planning process.
May participate in project management estimation process.
Explores the data and discovers patterns, meaningful relationships, anomalies, and trends.
Troubleshoot BI tools, systems, and software.
Build reusable components for a scalable ETL methodology such as error handling, logging and recoverability
Track’s performance and production issues.
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 and SSRS
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
5+ years-experience in RDBMS design, development and performance tuning
2+ years-experience with ETL/ELT on AWS or other cloud environments with working experience on Redshift or Snowflake
2+ years-experience using Tableau
Experience with 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
Experience with data manipulation languages such as Python and R
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.