Data Modeler

HSSSoft Open · verified Oct 24, 2026

On-site Edison Mid-level Data Architecture & Governance

At a glance

Mid-level Data Architecture & Governance role at HSSSoft. Edison · no salary stated · we estimate $97,988–$155,000 across the United States.

Estimated pay

HSSSoft has not published a salary for this role. The figure below is our estimate, not theirs.

$97,988 – $155,000

What the middle half of mid-level data architecture & governance roles in the United States paid, among postings that did state a salary.

Worked out from 312 postings that stated pay, median $126,351. Last updated Oct 24, 2026.

RoleData Architecture & Governance

SeniorityMid-level

LocationEdison

WorkplaceOn-site

PostedJul 28, 2015 · 11y ago

Role brief

dataroles summary, based on the employer's posting.

What you'll do

Shape target data models with other teams, then turn business needs into technical specifications for developers and QA
Map data from source applications through warehouses and marts to reports, tracing its origins and dependencies
Profile data, define transformation rules, and document metadata, quality, relationships, and flows
Use SQL to investigate data issues, identify root causes, and build complex analytical procedures
Capture requirements and acceptance test scripts, while flagging project risks and suggesting ways forward

What you bring

At least five years implementing business intelligence and data warehouse systems
Hands-on work with relational and dimensional models, complex record layouts, and relational databases such as Oracle or SQL Server
Strong SQL skills for analyzing data, diagnosing root causes, and creating complex analytical procedures
Strong English and technical writing, with clear analytical and problem-solving ability

Who this fits

This mid-level, onsite role in Edison suits a detail-focused analyst who can work independently and collaborate across teams. You’ll support development of a risk data warehouse and contribute to data modeling, governance, and documentation.

From the employer

TITLE: Data Modeler
STATUS: Open
LOCATION: Edison, NJ, United States
# of Openings: 3 Permanent

Requisition Details:
DATA MODELER
Looking for a creative, logical, inquisitive, assertive analyst with strong critical thinking skills to assist with the development of a Risk Data Warehouse.

- Minimum 5 years professional experience in Business Intelligence and Data Warehouse system implementation
- Solid knowledge of Data Warehousing principles and implementation methodologies
- Experience of designing and working with relational and dimension models and complex record layouts, both structured and unstructured
- Working knowledge in technical aspects of business intelligence including data modeling, relational database management systems, ETL, metadata / data management, and OLTP tools
- Solid analytical, problem solving and strategic thinking skills
- Proven experience as a quick learner and effective change agent
- Self-starting attitude and self-leading on problem solving.
- Consistent high attention to detail
- Has expert knowledge of applications systems analysis techniques.
- Able to rapidly learn technical/business techniques and disciplines of special value to the systems supported.
- Solid understanding of computers, programming, database tools/software, and Microsoft productivity applications (Excel, Word, PowerPoint, Visio, Project, Access)
- Moderate working knowledge of an ETL tool (Data Stage, etc) a plus
- Working experience with relational database, such as Oracle, SQLServer is required
- SAP Business Objects experience a plus
- Relational databases, filtering, aggregating data, joins
- Solid SQL skill and be able analysis the data and issue root cause, as well as create complex analytical procedures
- Source to target data mapping
- Ability to trace where data comes from
- Analysis of source systems that feed the data warehouse
- Source to target data mapping (application to data warehouse; data warehouse to data marts; data marts to reports)
- Work in collaboration with various teams to develop target models
- Develop transformation rules based on profiling results
- Developing user stories based on business and system requirements
- Support and improve business process, data management and governance standards
- Assist in the identification and assessment of potential new data sources
- Participate in meta data documentation, data profiling, and monitoring
- Strong English and technical documentation writing skill is required
- Perform impact and root cause analysis
- Drill into business processes, data quality, data relationships, and data flows to gain insight and understanding
- Partner with other team members to translate business requirements into technical specifications and ensure a smooth hand off to developers and quality assurance analysts
- Utilize existing artifact templates to capture requirements and proactively identify opportunities for improvements to existing standards or additional artifacts that will ensure high quality contents and delivery
- When applicable, create test conditions and test scripts as a basis for user acceptance testing
- Identify risks or barriers early in projects that would impede successful completion of tasks and make recommendations for approaches/solutions
- Promote a culture that values attention to detail, repeatability, traceability, in depth questioning and communication

Soft Skills:
Oracle
IBM Data Architect