About This Role
Designing, building, and optimizing databases and business intelligence solutions are the main focus of this role. The SQL Developer will ensure database performance and security, translate business needs into technical specifications, and collaborate with various teams to integrate systems and deliver data-driven insights.
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
- 5 years of SQL experience
- Strong experience in SSIS and SSRS
- 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
- 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
- Bachelor's degree in a relevant field
Nice to have:
- Industry experience is preferred
Important Details
- Supervisory responsibilities: No
