Data Modeler

  • location: Charlotte, NC
  • type: Contract
  • salary: $50 - $55 per hour

job description

Data Modeler

Data Modeler/Data Visualization Expert


We are seeking an energetic, hands-on Data Modeler / Data Visualization expert with strong SQL Server experience to join our Analytics team! This candidate needs to have mastered OLTP data modeling concepts and also possess significant OLAP data modeling skills. In addition to the data modeling skillset, the successful candidate will also possess solid Business Intelligence and data visualization experience. This position will provide database development support to our web application development team as well as support the data architecture needs of our data scientists and data analysts. The position will also be leveraged to produce BI dashboards and interactive reports for numerous internal stakeholders.


- 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

- Construct DDL scripts in T-SQL to deploy database changes to the various Dev/Test/Prod environments

- Manage data structures, data ingestion into the databases, and performance management and tuning

- Author complex T-SQL queries and views for use in BI dashboards and reports

- Design, develop and support intricate BI dashboards and reports

- Analyze existing data models, processes and architecture to make recommendations for improvement

- Establish foundational procedures, guidelines, and standards for data modeling, processing, data visualization, and analytics


- Bachelor degree in Computer Science, Information Systems, or similar field

- Minimum 5 years of data modeling / data architecture experience with SQL Server and ERWIN

- Mastery of T-SQL and advanced programming functionality

- Minimum 3 years of experience with industry-leading BI tool (MS Power BI, Tableau, Qlikview/Qliksense, etc)

- Proficient with SQL Server Reporting Services (SSRS)

- 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 SQL Server Integration Services (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, Cassandra, MongoDB, and/or SAP HANA is a plus

get jobs in your inbox.

sign up

related jobs

    Materials Planner

  • location: Charlotte, NC
  • job type: Temporary
  • salary: $25 - $30 per hour
  • date posted: 5/31/2018

    Senior Project Manager

  • location: Charlotte, NC
  • job type: Contract
  • salary: $46.37 - $57.96 per hour
  • date posted: 6/4/2018