Job description
Norfolk Southern Corporation is currently seeking a Senior Data Modeler/Architect for a contract position (fully remote). The successful candidate must have solid data modeling and data architecture 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/Architecture as well as on the job experience in this area. This position provides the opportunity to be involved in new BI and DW solutions and to work with many different business areas within the company. The candidate will perform data modeling and will participate in all phases of the BI/DW development life cycle. They will also independently and collaboratively write data modeling/architecture 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.
Required:
- Strong Data Modeling/Architect experience and knowledge (Relational & Dimensional) on any of the following platforms (5+ years):
- 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
- Data Relational & Dimensional modeling on the following platforms:
- 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
- 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
Education
Bachelor’s Degree preferred. Preferably in Information Systems, Computer Science, Computer Information Systems or related field
jjbodyshop.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, jjbodyshop.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, jjbodyshop.com is the ideal place to find your next job.