Responsible for building ETL framework using SSIS as main tools to deal with different data file type on different server, including SQL server 2014, Access Database, Oracle 11g on remote server and local server, and Flat file, SAS file on AZURE cloud server and SFTP server. Also needs to generate ad-hoc view in SQL server for Tableau report and executable to generate proper back up files. Utilize statistical program to help other departments in business operational analysis.

Skills Required:

  • Thorough with IT concepts, strategies, methodologies, architectures and technical standards.

  • Ability to create, read and understand data mapping document.

  • Profound knowledge in ETL tools including SSIS, AWS.

  • Extended Experience in database management on SQL server.

  • Ability to create high performance view, function and stored procedures on SQL server.

  • Knowledge of utilizing business intelligence reporting tools including SSTS, Power BI and Tableau.

  • Knowledge in Power shell, C# and VB to finish ad-hoc tasks.

  • Familiar with statistical programs including SAS, R to perform analysis.

  • Understanding in business operation of insurance industry.

  • Knowledge in estimating and testing Actuarial modeling using Excel and other tools.

  • Ability to utilize Linux system.

  • Experience of working in Agile SDLC method.

  • Strong communication skills and ability to work in cross functional and competitive team



  • Master’s Degree in Business Analytics, Mathematics, Statistics,  etc.

  • 0-1 years of practical experience with Microsoft SQL Server preferred

  • Basic knowledge of Data Modeling preferred

  • Basic knowledge of SQL programming using Microsoft SQL-Server T-SQL, SSIS and SSRS in the 2005/2008/2012 environment is a plus

  • Basic knowledge on ETL development, SSIS, and SSRS preferred

  • Understanding of software engineering concepts, standard methodologies, and best practices preferred

  • Creative, flexible, and quick to learn

  • Excellent communication and analytical skills

  • Ability to work in a team environment


Work Authorization Status:

BeaconFire Solution is an equal opportunity employer. We will sponsor H1B for qualified candidates.


Job Type: Full-time

Salary: $60,000.00 to $75,000.00 /year