Duties and responsibilities:

• Must be able to develop complex views and stored procedures.
• Understanding of a wide range of interpretive analysis tools (e.g. trend analysis, spreadsheets, comparisons, graphs, summary versus detail charts, drill down, correlations, exception analysis)
• Analyse existing SQL queries for performance improvements.
• Developing reports in SQL, reporting tools (such as Crystal Reports, Business Objects, Cognos, Access) and Excel.
• Developing complex SQL scripts, views, and stored procedures.
• Developing requirements and delivering projects in a direct working relationship with solution specialists and MIS drivers.
• Suggest new queries.
• Develop procedures and scripts for data analysis.
• Develop, implement and optimize stored procedures and functions using T-SQL.
• Review and interpret ongoing business report requirements.
• Research required data.
• Build appropriate and useful reporting deliverables.
• Provide timely scheduled management reporting.
• SQL tuning & data profiling.
• Interest in becoming a content expert in Emergency response and Aviation and BCP Solutions reporting databases and warehouses.
• Development of high quality database solutions

Requirements and qualifications:

Professional:

• 2-3 years of experience as a SQL Querry Writer / Analyst or similar role.
• BS/MS degree in Computer Science, Engineering or a related subject.
• Excellent understanding of Microsoft SQL Server *Experience with Transparent Data Encryption (TDE).
• Experience with SQL Server Reporting Services and SQL Server Analysis Services.
• Familiarity with the practical application of NoSQLNewSQL databases.

General:

• Sense of ownership and pride in your performance and its impact on company’s success.
• Analytical, problem-solving and conceptual skills.
• Team player.
• Good time-management skills.
• Ability to question and eyeball data quality in reports.
• Excellent oral and written communication skills and the ability to communicate effectively with non-technical people.