13 days old
2018-05-142018-06-11

Data Modeler/Architect

Charlotte, NC 28285
  • Job Code
    620663
  • Payrate
    $50 To $60

Job Summary:


We are seeking an energetic, hands-on 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:


- Work closely with business stakeholders and the software development team to understand their needs and construct efficient and scalable data models to achieve their goals


- 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 (optional):


- 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

Categories

Featured Jobs

Career News

Before you go...

Our free job seeker tools include alerts for new jobs, saving your favorites, optimized job matching, and more! Just enter your email below.

Share this job:

Data Modeler/Architect

Randstad Technologies
Charlotte, NC 28285

Share this job

Data Modeler/Architect

Randstad Technologies
Charlotte, NC
US

Separate email addresses with commas

Enter valid email address for sender.

Join us to start saving your Favorite Jobs!

Sign In Create Account
th -
Overall Rating: /199
Median Salary:

Work Environment
Stress
Growth
Powered ByCareerCast