SR. SQL Developer

Role & 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

QUALIFICATIONS:

• 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