Senior Data Modeler in Atlanta, GA at Pyramid Consulting, Inc

Date Posted: 9/9/2019

Job Snapshot

  • Employee Type:
    Full-Time
  • Location:
    Atlanta, GA
  • Job Type:
  • Experience:
    Not Specified
  • Date Posted:
    9/9/2019

Job Description

Immediate need for a talented Senior Data Modeler with experience in the Transportation Industry.
This is a 06+ Months Contract opportunity with long-term potential and is located in Atlanta, GA. Please review the job description below.
 
Job ID: 19-16749

Key Responsibilities: 
  • Experience Business Intelligence (BI) and Data Warehouse (DW) solutions. 
  • Excellent communicator, both written and verbal, and have experience working with business areas to translate their business data needs and data questions into project requirements.
  • Data Analysis and Data Modeling. 
  • Involved in new BI and DW solutions, such as Dashboards and Reports, and to work with many different business areas within the company. 
  • BI/DW development life cycle and will independently and collaboratively write project/enhancement requirements and perform data modeling duties.
  • Coordinate with technical BI/DW development staff through design, construction and implementation as a business area liaison, consultant and UAT tester.
  • 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
Key Requirements and Technology Experience:
  • Strong Data Relational & Dimensional modeling (5+ years) on the following platforms: Teradata and either Oracle 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 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 skill.
  • Data Relational & Dimensional modeling  on the following platforms:
  • Oracle, DB2, SQL Server, MS Access.
  • Knowledge of CA Erwin Data Modeler.
  • Knowledge of DataStage development techniques.
  • Knowledge of Unix/Linux platform and shell scripting.
  • Experience with Teradata or Oracle/Exadata database performance tuning.
  • Experience with ChangeMan MVS code versioning software.
  • Experience with Zeke MVS/Zeke Agent Job scheduler.
  • Proficiency with Microsoft Office Suite.
  • Railroad knowledge and experience.
  • Apache Hadoop ecosystem.
  • Bachelor's Degree preferred.  
  • Preferably in Information Systems, Computer Science, Computer Information Systems or related field.
Our client is a leading Transportation Industry and we are currently interviewing to fill this and other similar contract positions. If you are interested in this position, please apply online for immediate consideration.