Responsibilities :

- Help write and optimize in-application SQL statements

- Ensure performance, security, and availability of databases

- Prepare documentations and specifications

- Profile server resource usage, and optimize and tweak as necessary

- Collaborate with other team members and stakeholders

- Translate business needs to technical specifications

- Design, build and deploy BI solutions (e.g. reporting tools)

- Maintain and support data analytics platforms (e.g. MicroStrategy)

- Create tools to store data (e.g. OLAP cubes)

- Conduct unit testing and troubleshooting

- Evaluate and improve existing BI systems

- Collaborate with teams to integrate systems

- Develop and execute database queries and conduct analyses

- Create visualizations and reports for requested projects

- Develop and update technical documentation

Requirements :

- Strong proficiency with SQL and its variation among popular databases

- Experience with some of the modern relational databases

- Skilled at optimizing large complicated SQL statements

- Knowledge of best practices when dealing with relational databases

- Capable of configuring popular database engines and orchestrating clusters as necessary

- Proven experience as a BI Developer or Data Scientist

- Industry experience is preferred

- Background in data warehouse design (e.g. dimensional modeling) and data mining

- In-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework

- Familiarity with BI technologies (e.g. Microsoft Power BI, Oracle BI)

- Knowledge of SQL queries, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS)

- Proven abilities to take initiative and be innovative

- Analytical mind with a problem-solving aptitude