Description
Responsibilities- Responsible for end-to-end ownership of projects and project planning activities in area of expertise and/or concurrent multiple for assigned team.
- Participate in program design and walkthroughs.
- Review test plans and results.
- Assist with the resolution of test incidents.
- May provide guidance with the development of test plans as well as assist the business with development of user acceptance criteria.
- Report out project status and impact analysis on an ongoing basis.
- Demonstrates an informed knowledge of business area to resolve problems on an ongoing business.
- Negotiate agreements and commitments by facilitating communication between business unit and IT from initial requirements to final implementation.
Required Skills: Excel modelling skills, including the following: Experience writing and auditing the vlookup() & hlookup() functions; Experience writing and auditing conditional functions such as If(), Countif(), Countifs, Sumif, Sum ifs, etc; Experience constructing and auditing Pivot tables; Experience with the linear programming and iterative calculation functions and add-ins such as Solver, What-If Tables, and Goal Seek; Experience with the Data Analysis tool pack add-in, especially the Regression tool; PowerPoint skills; Experience creating tables and graphs in native PowerPoint and ThinkCell.
Database skills: Familiarity with the use or relational databases; Ability to write and run basic SELECT, INSERT, UPDATE, and DELETE queries in Access; Ability to write and run basic SELECT, INSERT, UPDATE, and DELETE queries in SQL; SAAS Database skills
Analytic skills: Familiarity with and experience calculating basic descriptive statistics such as mean, median, variance, standard deviation, and correlation; Experience constructing and running basic hypothesis tests such as T-tests and P-test; Experience constructing and running single and multivariate linear regressions and interpreting the results of those regressions.
Desired skills: Advanced Excel and Access database skills with ability to write Excel macros in VBA, ability to implement conditional formatting, ability to implement controls using the Development tab. Ability to construct and maintain relational databases in Access and SQL. Ability to construct and run complex queries in Access and SQL.
Experience: Minimum of 3+ years IT experience with focus on process methodologies and analytics. Knowledge of project management methodologies and tools. Ability to produce concise, clear, and complete business requirements. Ability to prepare and deliver organized and understandable presentations to medium or large groups. General expertise in the functional aspects of the processing system.
Education: Bachelor's degree in Computer Science or similar is preferred.
Synectics is an Equal Opportunity Employer.