Required:
- Strong Data Modeling/Architect experience and knowledge (Relational & Dimensional models ) on any of the following platforms (5+ years):
- Teradata, Oracle, SQL Server or DB2
- Experience in using data modeling techniques and tools (focused on Dimensional design), Entity Relationship diagrams, Erwin, etc.
- Exceptional SQL skills with ability to write complex queries
- Experience in translating business requirements to SQL-based ETL
- Strong analytical and problem solving skills
- Proficient data testing skills – unit, system and integration
- Strong business analyst and requirements gathering/writing skills
- Experience in developing according to SDLC and accustomed to working with technical documents (flowcharts, programming specifications, etc.)
- Excellent verbal/written communication and presentation skills
Preferred:
- Data Relational & Dimensional modeling on the following platforms:
- Teradata, Oracle, DB2, SQL Server
- Knowledge of CA Erwin Data Modeler
- Knowledge of DataStage ETL development techniques
- Experience with Teradata or Oracle/Exadata database performance tuning
- Proficiency with Microsoft Office Suite
- Railroad knowledge and experience
- Big Data / Data Lake experience
- Data Virtualization experience
Analyst Attitude Profile:
- Self-starter, responsible, professional, accountable
- A ‘finisher’, seeing a project or task through to completion in spite of challenges
- Strong team ethic and customer-support focus
- Ability to contribute knowledge by sharing business & technology skills with peers
- Good troubleshooting and problem-solving skills and instincts