Data Modeler

Charlotte, North Carolina 28202

Post Date: 05/18/2018 Job ID: 29320 Industry: Information Technology

Data Modeler / Data Architect with strong SQL Server experience. This candidate needs to have mastered Relational DBMS data modeling concepts and also possess Dimensional data modeling skills. The position will provide back-end database development support to our web application development team as well as support the data architecture needs of our team of data scientists and data analysts. This candidate will also play a central role in migrating data and processes from SQL Server to SAP HANA, so prior experience working with SAP HANA is critical. 

Responsibilities: 
•     Create logical and physical data models using ERWIN and produce Entity Relationship Diagrams to document designs 
•     Manage data structures, data ingestion into the databases, and performance management and tuning 
•     Construct SQL scripts to deploy database changes into the various DTAP environments 
•     Provide technical support to Scrum, BI Reporting, and Analytics teams, including user interface design based on data consumption patterns 
•     Analyze existing data models, processes and architecture to make recommendations for improvement 
•     Author complex SQL queries and views for usage in BI Reporting 
•     Establish foundational procedures, guidelines, and standards for data modeling, processing, and analytics 

Requirements: 
•     Bachelor degree in Computer Science, Information Systems, or similar field 
•     Minimum 5 years of hands-on data modeling experience with SQL Server and ERWIN 
•     Mastery of T-SQL and advanced programming functionality 
•     Significant hands-on experience with SAP HANA 
•     Demonstrated ability to work collaboratively in a fast-paced environment 
•     Strong work ethic, positive outlook, and responsiveness to internal and external customers 
•     Solid analytical and problem resolution skills, ability to analyze business problems and opportunities 

Desired Skills: 
•     Experience with data integration / ETL tools, specifically SSIS, Informatica, and CA Workload Automation (ESP) 
•     Experience working in an Agile software development framework with DevOps tools such as JIRA, SVN, and BitBucket 
•     Experience with Hadoop and/or Cassandra a plus 
Apply Online

Not ready to apply?

Send an email reminder to:

Share This Job:

Related Jobs: