ATLANTA, Georgia
Job Type: Contract
Rate: DOE
Senior Data Modeler/Business Analyst Job Opening in ATLANTA, Georgia - Job Description
Senior Data Modeler/Business Analyst for a contract position located in Atlanta, GA. The successful candidate must have solid data modeling and business analyst experience and must demonstrate an affinity for working with others to create successful Business Intelligence (BI) and Data Warehouse (DW) solutions. He/She must be an 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. He/she must have a solid background in Data Analysis and Data Modeling as well as on the job experience as a data modeler. This position provides the opportunity to be involved in new BI and DW solutions, such as Dashboards and Reports, and to work with many different business areas within the company. The candidate will participate in all phases of the BI/DW development life cycle and will independently and collaboratively write project/enhancement requirements and perform data modeling duties. He/She will coordinate with technical BI/DW development staff through design, construction, and implementation as a business area liaison, consultant and UAT tester.
Skills and Experience:
Required:
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 the 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 skills
Preferred:
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
|
