Vacancy expired!
- Strong understanding of SQL databases and queries as well as programmability concepts such as stored procedures and functions.
- Ability to write SQL queries by hand without an external tool or query designer.
- Minimum two years' experience as a Data Analyst/Report Writer or other roles heavily utilizing SQL.
- Write SQL queries, views or stored procedures to extract data from SQL Servers in a consistent and efficient manner that follows industry best practices.
- Interpret existing complex SQL queries and stored procedures to reverse engineer existing code.
- Create and automate or increase the efficiency of existing reports
- Assist in data analysis functions.
- Elicit requirements from stakeholders to better define report content.
- Document the results of work activities.
- Support the generation of standard reports as well as ad hoc queries.
- Ensure effective communication to the management team and business clients.
- Make recommendations for improvements in reporting tools, techniques and processes.
- Database CI/CD
- Visual Studio Database Projects.
- Knowledge of Data Warehousing.
- Database Performance Tuning
- Database Backups, Administration & Unit Testing
- Azure or Amazon Web Services experience
- Markdown for documentation creation
- Experience with Git or similar version control solution
- Sample data generation
Vacancy expired!