Job Description :
The primary role of this position is to provide data analysis support to ITPM development project teams.
This position will analyze business requirements to identify and document all data needs, definitions around all data elements and all business rules associate with any data element.
This position will help to identify data redundancies, where appropriate provide options to reduce data redundancy.
This position will be responsible for the creation of a data dictionary for each project he/she assigned to.
This position will be responsible for developing data flow diagrams and logical data models.
This position will assist with the identification of information flow, content issues and the transformation of business requirements into logical data and system models.
This position is eligible for telework and/or a flexible work schedule. Up to 2 days telework can be considered.
This position is not eligible for over-time and will be capped at 40 hours a week.

What knowledge, skills, abilities, experiences, certifications are needed for this position?
Data Modeling and Database Design (strong knowledge of relational database concepts)
SQL (PL/SQL is a plus)
Data Integration Practices
Strong analytical skills, attention to detail and logical thinking
Ability to understand the business data needs and translate into data models (DFDs, DSDs and/or ERDs)
Ability to create ETL specifications and develop data mappings
Ability to engage in detailed analysis of data discrepancies to determine the source and resolution of errors
Clear and concise documentation skills
High level knowledge of programming practices
Aptitude for learning new technologies/applications/businesses
Excellent presentation, communication and customer service skills while maintaining a professional manner
Self-motivated team player – able to work cooperatively in a team environment
Ability to work under pressure, prioritize and meet deadlines when required
Remain flexible on changing workloads and priorities
Ability to communicate with diversified stakeholders
Data Warehousing is a plus
Business Intelligence is a plus
ITIL certification is a plus
Industry specific knowledge regarding asset inventory systems is a plus
Industry specific knowledge regarding service portfolio management systems is a plus

Essential Skills/Competencies:
5+ years of data requirements gathering experience
5+ years of logical Data Modeling
5+ years of experience in data-centric positions or roles
3+ years of SQL (PL/SQL is a plus)
Hands-on experience with ETL Tools is a plus
Public Sector background/experience is a plus
*Experience with Microsoft Dynamics CRM and/or RSA Archer a plus

Skill Required / Desired Amount of Experience
Data Modeling and Database design (strong knowledge of relational database concepts) Required 5
Data requirements gathering Required 5
SQL (PL/SQL a plus) Required 5
Create ETL specifications and develop data mappings Required 5
Data Integration Practices Required 5
Understand data needs and translate into data models (DFDs, DSDs and/or ERDs) Required 5
Detailed analysis of data discrepancies to determine source and resolution of errors Required 5
Microsoft Dynamics CRM and/or RSA Archer Nice to have 1
Data Warehousing Nice to have 1
Business Intelligence Nice to have 1
ITIL certification Nice to have 1
Asset inventory systems Nice to have 1
service portfolio management systems Nice to have 1