SQL/ETL BI Developer
(Junior Level)
Responsibilities:
-
Help write and optimize in-application SQL statements.
-
Ensure performance, security, and availability of databases.
-
Prepare documentations and specifications.
-
Handle common database procedures such as upgrade, backup, recovery, migration, etc.
-
Write TSQL scripts and objects such as stored procedures, user-defined functions, views, indexes per business requirements.
-
Create ETL SSIS packages to migrate data from OLTP sources to OLAP destinations through available tasks and transformations in SSIS.
-
Design and create user interactive reports in SSRS, Power BI and Tableau.
-
Profile server resource usage, and optimize and tweak as necessary.
-
Collaborate with other team members and stakeholders.
Qualifications :
-
BS or MS of degree in Computer Science, Information Technology, Engineering or related field is required
-
Proficiency with SQL and its variation among popular databases
-
Skilled at optimizing large complicated SQL statements
-
Capable of configuring popular database engines and orchestrating clusters as necessary
-
Ability to plan resource requirements from high level specifications
-
Good communication skills