Must perform complex (journey-level) data analysis and data research work. Work involves analyzing complex systems and designing/developing reports utilizing SQL in SSRS or SSIS. This requires the ability to access data stored in a variety of database management systems (such as DB2, SQL Server, and Oracle) which satisfy customer business requirements.
- Writing SQL reports that access data stored in databases such as SQL Server, DB2, and Oracle.
- Developing procedures and views on SQL Server and Oracle databases
- Using dynamic grouping fields, dynamic group sorting, on-demand sub reports, drill down and summary reports, and creating crosstab reports highlighting key summary information.
- Manipulating large data sets through statistical software or other methods.
- Functional expertise developing front-end reporting solutions
- Manipulating large data sets through statistical software or other methods. Developing front-end reporting solutions. Knowledge of Microsoft Office Suite; with considerable knowledge of Excel pivot tables, formulas, formatting, and VLOOKUPS.
- Knowledge with SQL, Python, or similar language.
- Graduation from an accredited four-year college or university with major course work in Computer Science, Statistics, MIS, IST or a related field.