SQL Report Writer (PT2) - Part Time
Budget: £9 – £24 GBP
Looking for an experienced part time resource to catch up on outstanding tasks and be able to tackle ad hoc and periodic needs. Estimate 2-3 days per week but workload may vary.
ESSENTIAL JOB FUNCTIONS:
• 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)
• Ability to question and eyeball data quality in reports.
• Analytical, problem-solving and conceptual skills.
• Excellent oral and written communication skills and the ability to communicate effectively with non-technical people.
• Supporting electronic records from an application analyst or analytics / reporting perspective.
• Developing reports in SQL, reporting tools (such as JReport, Crystal Reports and Excel).
• Developing complex SQL scripts, views, and stored procedures.
• SQL data queries, tuning & data profiling.
QUALIFICATIONS:
• Three or more years of SQL reporting experience as detailed above.
• Must be able to develop complex views and stored procedures.
• Advanced knowledge of company supported applications. Work with staff requires interpersonal skills.
• Database knowledge (MySQL, Oracle)
• Experience with Crystal Reports, Tableau, PowerBI is a desired asset.
DUTIES AND TASKS:
• Create Dashboard Components
• Create Aliases for Database Fields
• Create Sub-Reports
• Create and Implement ‘Skins’ CSS
• Test and Update Reports to get Ready for Upgrade (Logi)
• Close Current Report Cases (about 10)
• Create Custom Customer Reports as needed
• Implement Date Preferences Customizability
• Fix Excel Exports for Cleaner Rows/Columns Presentation
ESSENTIAL JOB FUNCTIONS:
• 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)
• Ability to question and eyeball data quality in reports.
• Analytical, problem-solving and conceptual skills.
• Excellent oral and written communication skills and the ability to communicate effectively with non-technical people.
• Supporting electronic records from an application analyst or analytics / reporting perspective.
• Developing reports in SQL, reporting tools (such as JReport, Crystal Reports and Excel).
• Developing complex SQL scripts, views, and stored procedures.
• SQL data queries, tuning & data profiling.
QUALIFICATIONS:
• Three or more years of SQL reporting experience as detailed above.
• Must be able to develop complex views and stored procedures.
• Advanced knowledge of company supported applications. Work with staff requires interpersonal skills.
• Database knowledge (MySQL, Oracle)
• Experience with Crystal Reports, Tableau, PowerBI is a desired asset.
DUTIES AND TASKS:
• Create Dashboard Components
• Create Aliases for Database Fields
• Create Sub-Reports
• Create and Implement ‘Skins’ CSS
• Test and Update Reports to get Ready for Upgrade (Logi)
• Close Current Report Cases (about 10)
• Create Custom Customer Reports as needed
• Implement Date Preferences Customizability
• Fix Excel Exports for Cleaner Rows/Columns Presentation