Salary National Average
Low
Medium
High
96870.0000
118740.0000
152240.0000
Change from Previous Year:
+4%
Supply and Demand
Candidate Supply: 974
Job Openings: 5,539
0
50
100
More Difficult
Less Difficult
Short Description:
Establish and maintain an Enterprise Data Model that describes how data is processed, stored, and utilized. Manage the data structures required to support the enterprise through the BI program. Provide the means of system integration by understanding the source and target data and building the data mapping. Determine architectural approaches for data environments and help ensure that the data needs of the enterprise are met. Responsible for developing and maintaining a formal description of the data and data structures, including data definitions and models. Build strategy and design for managing data history.
Duties / Responsibilities:
Understand and translate business needs into data models supporting long-term solutions.
Work with the Application Development team to implement data strategies, build data flows and develop conceptual data models.
Create logical and physical data models using best practices to ensure high data quality and reduced redundancy.
Optimize and update logical and physical data models to support new and existing projects.
Maintain conceptual, logical, and physical data models along with corresponding metadata.
Develop best practices for standard naming conventions and coding practices to ensure the consistency of data models.
Recommend opportunities for the reuse of data models in new environments.
Perform reverse engineering of physical data models from databases and SQL scripts.
Evaluate data models and physical databases for variances and discrepancies.
Validate business data objects for accuracy and completeness.
Analyze data-related system integration challenges and propose appropriate solutions.
Develop data models according to company standards.
Guide system analysts, engineers, programmers, and others on project limitations, capabilities, performance requirements, and interfaces.
Review modifications to existing software to improve efficiency and performance.
Examine new application design and recommend corrections if required.
Skills / Requirements / Qualifications
Database Management System Software: Amazon DynamoDB; Elasticsearch; MongoDB; Oracle PL/SQL
Database User Interface and Query Software: Apache Hive; Blackboard software; IBM DB2; Transact-SQL
Development Environment Software: Apache Kafka; Apache Maven; Go; Oracle SQL Developer
Metadata Management Software: CA Erwin Data Modeler; Informatica software; SAP PowerDesigner; Talend Data Fabric
Web Platform Development Software: Django; Google Angular; React; Spring Framework
Job Zones
Education: Most of these occupations require a four-year bachelor's degree, but some do not.
Related Experience: A considerable amount of work-related skill, knowledge, or experience is needed for these occupations. For example, an accountant must complete four years of college and work for several years in accounting to qualify.
Job Training: Employees in these occupations usually need several years of work-related experience, on-the-job training, or vocational training.
Job Zone Examples: Many of these occupations involve coordinating, supervising, managing, or training others. Examples include accountants, sales managers, database administrators, teachers, chemists, art directors, and cost estimators.
Specific Vocational Preparation in years: 2-4 years of preparation (7.0 to < 8.0)
Share Role Details
Share Data Modeler Role Description
Print Data Modeler Role Description
Return to job listings
Print Data Modeler Role Description
[{"VarianceId":1,"CountryId":1,"City":"Jacksonville","RegionCode":"FL","Geocode":"30.3321838,-81.6556510","SalaryVariance":93,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":2,"CountryId":1,"City":"Birmingham","RegionCode":"AL","Geocode":"33.520290374755859,-86.8115005493164","SalaryVariance":97,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":3,"CountryId":1,"City":"Mobile","RegionCode":"AL","Geocode":"30.686389923095703,-88.053237915039062","SalaryVariance":94,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":4,"CountryId":1,"City":"Montgomery","RegionCode":"AL","Geocode":"32.3668052,-86.2999689","SalaryVariance":92,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":5,"CountryId":1,"City":"Anchorage","RegionCode":"AK","Geocode":"61.2180556,-149.9002778","SalaryVariance":121,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":6,"CountryId":1,"City":"Huntsville","RegionCode":"AL","Geocode":"34.729129791259766,-86.584976196289062","SalaryVariance":100,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":7,"CountryId":1,"City":"Fairbanks","RegionCode":"AK","Geocode":"64.8377778,-147.7163889","SalaryVariance":115,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":8,"CountryId":1,"City":"Phoenix","RegionCode":"AZ","Geocode":"33.4483771,-112.0740373","SalaryVariance":101,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":9,"CountryId":1,"City":"Tucson","RegionCode":"AZ","Geocode":"32.2217429,-110.9264790","SalaryVariance":96,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":10,"CountryId":1,"City":"Fayetteville","RegionCode":"AR","Geocode":"36.0625795,-94.1574263","SalaryVariance":95,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":11,"CountryId":1,"City":"Fort Smith","RegionCode":"AR","Geocode":"35.3859242,-94.3985475","SalaryVariance":82,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":12,"CountryId":1,"City":"Little Rock","RegionCode":"AR","Geocode":"34.7464809,-92.2895948","SalaryVariance":94,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":13,"CountryId":1,"City":"Anaheim","RegionCode":"CA","Geocode":"33.8352932,-117.9145036","SalaryVariance":117,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":14,"CountryId":1,"City":"Bakersfield","RegionCode":"CA","Geocode":"35.3732921,-119.0187125","SalaryVariance":108,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":15,"CountryId":1,"City":"Fresno","RegionCode":"CA","Geocode":"36.7468422,-119.7725868","SalaryVariance":111,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":16,"CountryId":1,"City":"Los Angeles","RegionCode":"CA","Geocode":"34.0522342,-118.2436849","SalaryVariance":117,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":17,"CountryId":1,"City":"Oakland","RegionCode":"CA","Geocode":"37.8043637,-122.2711137","SalaryVariance":141,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":18,"CountryId":1,"City":"Oxnard-Thousand Oaks-Ventura","RegionCode":"CA","Geocode":"34.1843916,-118.8935620","SalaryVariance":110,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":19,"CountryId":1,"City":"Riverside","RegionCode":"CA","Geocode":"33.9533487,-117.3961564","SalaryVariance":107,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":20,"CountryId":1,"City":"Sacramento","RegionCode":"CA","Geocode":"38.5815719,-121.4943996","SalaryVariance":117,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":21,"CountryId":1,"City":"Salinas","RegionCode":"CA","Geocode":"36.6777372,-121.6555013","SalaryVariance":119,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":22,"CountryId":1,"City":"San Diego","RegionCode":"CA","Geocode":"32.7153292,-117.1572551","SalaryVariance":114,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":23,"CountryId":1,"City":"San Francisco","RegionCode":"CA","Geocode":"37.7749295,-122.4194155","SalaryVariance":141,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":24,"CountryId":1,"City":"San Jose","RegionCode":"CA","Geocode":"37.3393857,-121.8949555","SalaryVariance":147,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":25,"CountryId":1,"City":"Santa Barbara","RegionCode":"CA","Geocode":"34.4208305,-119.6981901","SalaryVariance":109,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":26,"CountryId":1,"City":"Santa Rosa","RegionCode":"CA","Geocode":"38.4404674,-122.7144314","SalaryVariance":121,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":27,"CountryId":1,"City":"Stockton","RegionCode":"CA","Geocode":"37.9577016,-121.2907796","SalaryVariance":111,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":28,"CountryId":1,"City":"Boulder","RegionCode":"CO","Geocode":"40.0149856,-105.2705456","SalaryVariance":125,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":29,"CountryId":1,"City":"Colorado Springs","RegionCode":"CO","Geocode":"38.8338816,-104.8213634","SalaryVariance":106,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":30,"CountryId":1,"City":"Denver","RegionCode":"CO","Geocode":"39.7375670,-104.9847179","SalaryVariance":117,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":31,"CountryId":1,"City":"Greeley","RegionCode":"CO","Geocode":"40.4233142,-104.7091322","SalaryVariance":103,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":32,"CountryId":1,"City":"Bridgeport","RegionCode":"CT","Geocode":"41.1865478,-73.1951767","SalaryVariance":124,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":33,"CountryId":1,"City":"Hartford","RegionCode":"CT","Geocode":"41.7637111,-72.6850932","SalaryVariance":119,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":34,"CountryId":1,"City":"New Haven","RegionCode":"CT","Geocode":"41.3081527,-72.9281577","SalaryVariance":118,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":35,"CountryId":1,"City":"Washington","RegionCode":"DC","Geocode":"38.8951118,-77.0363658","SalaryVariance":121,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":36,"CountryId":1,"City":"Dover","RegionCode":"DE","Geocode":"39.1581680,-75.5243682","SalaryVariance":97,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":37,"CountryId":1,"City":"Wilmington","RegionCode":"DE","Geocode":"39.7458333,-75.5466667","SalaryVariance":94,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":38,"CountryId":1,"City":"Clearwater","RegionCode":"FL","Geocode":"27.9658533,-82.8001026","SalaryVariance":98,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":39,"CountryId":1,"City":"Fort Lauderdale","RegionCode":"FL","Geocode":"26.1223084,-80.1433786","SalaryVariance":97,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":40,"CountryId":1,"City":"Miami","RegionCode":"FL","Geocode":"25.7889689,-80.2264393","SalaryVariance":97,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":41,"CountryId":1,"City":"Orlando","RegionCode":"FL","Geocode":"28.5383355,-81.3792365","SalaryVariance":91,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":42,"CountryId":1,"City":"Tallahassee","RegionCode":"FL","Geocode":"30.4382559,-84.2807329","SalaryVariance":91,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":43,"CountryId":1,"City":"Tampa","RegionCode":"FL","Geocode":"27.9505750,-82.4571776","SalaryVariance":96,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":44,"CountryId":1,"City":"West Palm Beach","RegionCode":"FL","Geocode":"26.7153424,-80.0533746","SalaryVariance":100,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":45,"CountryId":1,"City":"Atlanta","RegionCode":"GA","Geocode":"33.7489954,-84.3879824","SalaryVariance":101,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":46,"CountryId":1,"City":"Honolulu","RegionCode":"HI","Geocode":"21.3069444,-157.8583333","SalaryVariance":118,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":47,"CountryId":1,"City":"Boise","RegionCode":"ID","Geocode":"43.6137390,-116.2376510","SalaryVariance":95,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":48,"CountryId":1,"City":"Chicago","RegionCode":"IL","Geocode":"41.8781136,-87.6297982","SalaryVariance":108,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":49,"CountryId":1,"City":"Peoria","RegionCode":"IL","Geocode":"40.6936488,-89.5889864","SalaryVariance":98,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":50,"CountryId":1,"City":"Rockford","RegionCode":"IL","Geocode":"42.2711311,-89.0939952","SalaryVariance":99,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":51,"CountryId":1,"City":"Springfield","RegionCode":"IL","Geocode":"39.7817213,-89.6501481","SalaryVariance":101,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":52,"CountryId":1,"City":"Evansville","RegionCode":"IN","Geocode":"37.9715592,-87.5710898","SalaryVariance":92,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":53,"CountryId":1,"City":"Fort Wayne","RegionCode":"IN","Geocode":"41.0792730,-85.1393513","SalaryVariance":93,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":54,"CountryId":1,"City":"Indianapolis-Carmel","RegionCode":"IN","Geocode":"39.9783710,-86.1180435","SalaryVariance":98,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":55,"CountryId":1,"City":"Des Moines","RegionCode":"IA","Geocode":"41.6005448,-93.6091064","SalaryVariance":102,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":56,"CountryId":1,"City":"Overland Park","RegionCode":"KS","Geocode":"38.9822282,-94.6707917","SalaryVariance":103,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":57,"CountryId":1,"City":"Bowling Green","RegionCode":"KY","Geocode":"36.9903199,-86.4436018","SalaryVariance":84,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":58,"CountryId":1,"City":"Lexington","RegionCode":"KY","Geocode":"38.0405837,-84.5037164","SalaryVariance":95,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":59,"CountryId":1,"City":"Louisville","RegionCode":"KY","Geocode":"38.2526647,-85.7584557","SalaryVariance":96,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":60,"CountryId":1,"City":"New Orleans","RegionCode":"LA","Geocode":"29.9510658,-90.0715323","SalaryVariance":98,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":61,"CountryId":1,"City":"Shreveport","RegionCode":"LA","Geocode":"32.5251516,-93.7501789","SalaryVariance":84,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":62,"CountryId":1,"City":"Portland","RegionCode":"ME","Geocode":"43.6614710,-70.2553259","SalaryVariance":105,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":63,"CountryId":1,"City":"Baltimore","RegionCode":"MD","Geocode":"45.6002421,-122.6796316","SalaryVariance":113,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":64,"CountryId":1,"City":"Boston","RegionCode":"MA","Geocode":"42.3584308,-71.0597732","SalaryVariance":124,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":65,"CountryId":1,"City":"Springfield","RegionCode":"MA","Geocode":"42.1014831,-72.5898110","SalaryVariance":63,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":66,"CountryId":1,"City":"Ann Arbor","RegionCode":"MI","Geocode":"42.2808256,-83.7430378","SalaryVariance":114,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":67,"CountryId":1,"City":"Detroit","RegionCode":"MI","Geocode":"42.3314270,-83.0457538","SalaryVariance":108,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":68,"CountryId":1,"City":"Flint","RegionCode":"MI","Geocode":"43.0125274,-83.6874562","SalaryVariance":96,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":69,"CountryId":1,"City":"Grand Rapids","RegionCode":"MI","Geocode":"42.9633599,-85.6680863","SalaryVariance":98,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":70,"CountryId":1,"City":"Lansing","RegionCode":"MI","Geocode":"42.7325350,-84.5555347","SalaryVariance":105,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":71,"CountryId":1,"City":"Minneapolis-St. Paul-Bloomington","RegionCode":"MN","Geocode":"44.8407980,-93.2982799","SalaryVariance":112,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":72,"CountryId":1,"City":"Jackson","RegionCode":"MS","Geocode":"32.2987573,-90.1848103","SalaryVariance":96,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":73,"CountryId":1,"City":"Kansas City","RegionCode":"MO","Geocode":"39.0997265,-94.5785667","SalaryVariance":101,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":74,"CountryId":1,"City":"Springfield","RegionCode":"MO","Geocode":"37.2089572,-93.2922989","SalaryVariance":101,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":75,"CountryId":1,"City":"St. Louis","RegionCode":"MO","Geocode":"38.6270025,-90.1994042","SalaryVariance":104,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":76,"CountryId":1,"City":"Billings","RegionCode":"MT","Geocode":"45.7832856,-108.5006904","SalaryVariance":98,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":77,"CountryId":1,"City":"Lincoln","RegionCode":"NE","Geocode":"40.8068620,-96.6816790","SalaryVariance":98,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":78,"CountryId":1,"City":"Omaha-Council Bluffs","RegionCode":"NE","Geocode":"41.2619444,-95.8608333","SalaryVariance":102,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":79,"CountryId":1,"City":"Las Vegas","RegionCode":"NV","Geocode":"36.1146460,-115.1728160","SalaryVariance":97,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":80,"CountryId":1,"City":"Reno","RegionCode":"NV","Geocode":"39.5296329,-119.8138027","SalaryVariance":105,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":81,"CountryId":1,"City":"Manchester","RegionCode":"NH","Geocode":"42.9956397,-71.4547891","SalaryVariance":109,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":82,"CountryId":1,"City":"Paramus","RegionCode":"NJ","Geocode":"40.9445428,-74.0754189","SalaryVariance":126,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":83,"CountryId":1,"City":"Trenton-Ewing-Princeton","RegionCode":"NJ","Geocode":"40.2337550,-74.7589760","SalaryVariance":122,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":84,"CountryId":1,"City":"Edison","RegionCode":"NJ","Geocode":"40.5187154,-74.4120953","SalaryVariance":122,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":85,"CountryId":1,"City":"Albuquerque","RegionCode":"NM","Geocode":"35.0844909,-106.6511367","SalaryVariance":101,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":86,"CountryId":1,"City":"Las Cruces","RegionCode":"NM","Geocode":"32.3199396,-106.7636538","SalaryVariance":90,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":87,"CountryId":1,"City":"Albany","RegionCode":"NY","Geocode":"42.6525793,-73.7562317","SalaryVariance":94,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":88,"CountryId":1,"City":"Buffalo","RegionCode":"NY","Geocode":"42.8864468,-78.8783689","SalaryVariance":105,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":89,"CountryId":1,"City":"New York","RegionCode":"NY","Geocode":"40.7143528,-74.0059731","SalaryVariance":126,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":90,"CountryId":1,"City":"Charlotte","RegionCode":"NC","Geocode":"35.2270869,-80.8431267","SalaryVariance":103,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":91,"CountryId":1,"City":"Raleigh","RegionCode":"NC","Geocode":"35.7720960,-78.6386145","SalaryVariance":104,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":92,"CountryId":1,"City":"Fargo","RegionCode":"ND","Geocode":"46.8771863,-96.7898034","SalaryVariance":104,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":93,"CountryId":1,"City":"Akron","RegionCode":"OH","Geocode":"41.0814447,-81.5190053","SalaryVariance":100,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":94,"CountryId":1,"City":"Cincinnati","RegionCode":"OH","Geocode":"39.1031182,-84.5120196","SalaryVariance":105,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":95,"CountryId":1,"City":"Cleveland","RegionCode":"OH","Geocode":"41.4994954,-81.6954088","SalaryVariance":80,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":96,"CountryId":1,"City":"Columbus","RegionCode":"OH","Geocode":"39.9611755,-82.9987942","SalaryVariance":89,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":97,"CountryId":1,"City":"Dayton","RegionCode":"OH","Geocode":"39.7589478,-84.1916069","SalaryVariance":104,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":98,"CountryId":1,"City":"Toledo","RegionCode":"OH","Geocode":"41.6639383,-83.5552120","SalaryVariance":99,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":99,"CountryId":1,"City":"Oklahoma City","RegionCode":"OK","Geocode":"35.4675602,-97.5164276","SalaryVariance":96,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":100,"CountryId":1,"City":"Tulsa","RegionCode":"OK","Geocode":"36.1539816,-95.9927750","SalaryVariance":95,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":101,"CountryId":1,"City":"Eugene","RegionCode":"OR","Geocode":"44.0520691,-123.0867536","SalaryVariance":102,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":102,"CountryId":1,"City":"Portland","RegionCode":"OR","Geocode":"45.5234515,-122.6762071","SalaryVariance":108,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":103,"CountryId":1,"City":"Salem","RegionCode":"OR","Geocode":"44.9428975,-123.0350963","SalaryVariance":105,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":104,"CountryId":1,"City":"Harrisburg","RegionCode":"PA","Geocode":"40.2737002,-76.8844179","SalaryVariance":105,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":105,"CountryId":1,"City":"Philadelphia","RegionCode":"PA","Geocode":"39.9523350,-75.1637890","SalaryVariance":109,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":106,"CountryId":1,"City":"Pittsburgh","RegionCode":"PA","Geocode":"40.4406248,-79.9958864","SalaryVariance":102,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":107,"CountryId":1,"City":"King of Prussia","RegionCode":"PA","Geocode":"40.1012856,-75.3835525","SalaryVariance":106,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":108,"CountryId":1,"City":"San Juan","RegionCode":"PR","Geocode":"18.4663338,-66.1057217","SalaryVariance":65,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":109,"CountryId":1,"City":"Providence","RegionCode":"RI","Geocode":"41.8239891,-71.4128343","SalaryVariance":116,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":110,"CountryId":1,"City":"Charleston","RegionCode":"SC","Geocode":"32.7765656,-79.9309216","SalaryVariance":91,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":111,"CountryId":1,"City":"Columbia","RegionCode":"SC","Geocode":"34.0007104,-81.0348144","SalaryVariance":93,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":112,"CountryId":1,"City":"Greenville","RegionCode":"SC","Geocode":"34.8526176,-82.3940104","SalaryVariance":93,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":113,"CountryId":1,"City":"Rapid City","RegionCode":"SD","Geocode":"44.0805434,-103.2310149","SalaryVariance":90,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":114,"CountryId":1,"City":"Sioux Falls","RegionCode":"SD","Geocode":"43.5499749,-96.7003270","SalaryVariance":96,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":115,"CountryId":1,"City":"Knoxville","RegionCode":"TN","Geocode":"35.9606384,-83.9207392","SalaryVariance":94,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":116,"CountryId":1,"City":"Memphis","RegionCode":"TN","Geocode":"35.1495343,-90.0489801","SalaryVariance":95,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":117,"CountryId":1,"City":"Nashville","RegionCode":"TN","Geocode":"36.1666667,-86.7833333","SalaryVariance":96,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":118,"CountryId":1,"City":"Austin","RegionCode":"TX","Geocode":"30.2671530,-97.7430608","SalaryVariance":103,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":119,"CountryId":1,"City":"Dallas-Fort Worth-Arlington","RegionCode":"TX","Geocode":"32.7356870,-97.1080656","SalaryVariance":101,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":120,"CountryId":1,"City":"Houston","RegionCode":"TX","Geocode":"29.7601927,-95.3693896","SalaryVariance":103,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":121,"CountryId":1,"City":"Edinburg","RegionCode":"TX","Geocode":"26.3017374,-98.1633432","SalaryVariance":85,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":122,"CountryId":1,"City":"Midland","RegionCode":"TX","Geocode":"31.9973456,-102.0779146","SalaryVariance":91,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":123,"CountryId":1,"City":"San Antonio","RegionCode":"TX","Geocode":"29.4241219,-98.4936282","SalaryVariance":94,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":124,"CountryId":1,"City":"Logan","RegionCode":"UT","Geocode":"41.7369803,-111.8338359","SalaryVariance":83,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":125,"CountryId":1,"City":"Provo","RegionCode":"UT","Geocode":"40.2338438,-111.6585337","SalaryVariance":94,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":126,"CountryId":1,"City":"Salt Lake City","RegionCode":"UT","Geocode":"40.7607793,-111.8910474","SalaryVariance":102,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":127,"CountryId":1,"City":"Burlington","RegionCode":"VT","Geocode":"44.4758825,-73.2120720","SalaryVariance":87,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":128,"CountryId":1,"City":"Arlington","RegionCode":"VA","Geocode":"38.8799697,-77.1067698","SalaryVariance":114,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":129,"CountryId":1,"City":"Chesapeake","RegionCode":"VA","Geocode":"36.7682088,-76.2874927","SalaryVariance":98,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":130,"CountryId":1,"City":"Newport News","RegionCode":"VA","Geocode":"37.0870821,-76.4730122","SalaryVariance":97,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":131,"CountryId":1,"City":"Reston","RegionCode":"VA","Geocode":"37.4315734,-78.6568942","SalaryVariance":114,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":132,"CountryId":1,"City":"Richmond","RegionCode":"VA","Geocode":"37.5407246,-77.4360481","SalaryVariance":101,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":133,"CountryId":1,"City":"Seattle-Tacoma-Bellevue","RegionCode":"WA","Geocode":"47.4393448,-122.2613242","SalaryVariance":130,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":134,"CountryId":1,"City":"Charleston","RegionCode":"WV","Geocode":"38.3498195,-81.6326234","SalaryVariance":91,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":135,"CountryId":1,"City":"Huntington","RegionCode":"WV","Geocode":"38.4192496,-82.4451540","SalaryVariance":91,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":136,"CountryId":1,"City":"Green Bay","RegionCode":"WI","Geocode":"44.5191590,-88.0198260","SalaryVariance":87,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":137,"CountryId":1,"City":"Madison","RegionCode":"WI","Geocode":"43.0730517,-89.4012302","SalaryVariance":107,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":138,"CountryId":1,"City":"Milwaukee","RegionCode":"WI","Geocode":"43.0389025,-87.9064736","SalaryVariance":106,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":139,"CountryId":1,"City":"Wausau","RegionCode":"WI","Geocode":"44.9591352,-89.6301221","SalaryVariance":97,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":140,"CountryId":1,"City":"Casper","RegionCode":"WY","Geocode":"42.8666320,-106.3130810","SalaryVariance":98,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":141,"CountryId":1,"City":"Cheyenne","RegionCode":"WY","Geocode":"41.1399814,-104.8202462","SalaryVariance":98,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":208,"CountryId":1,"City":"National","RegionCode":"US","Geocode":"0,0","SalaryVariance":100,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":210,"CountryId":1,"City":"Rochester","RegionCode":"NY","Geocode":"43.161030,-77.610924","SalaryVariance":106,"CountryCountryId":0,"CountryName":null,"CountryCode":null},{"VarianceId":211,"CountryId":1,"City":"Temecula","RegionCode":"CA","Geocode":"33.487007,-117143784","SalaryVariance":118,"CountryCountryId":0,"CountryName":null,"CountryCode":null}]