SQL Report Writer / Analyst

• 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 NoSQL\NewSQL 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.