
Open since Jul 2015
Data ModelerHsssoft · Edison
Data Modeler
EdisonOn-site
AI Summary
A Data Modeler designs and implements relational and dimensional data models for a Risk Data Warehouse, collaborating with teams to translate business requirements into technical specifications and supporting data governance.
About this role
- 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
All your information will be kept confidential according to EEO guidelines.
Skills
Business IntelligenceData ModelingData ProfilingData StageData Warehouse ImplementationDimensional ModelingETLExcelMetadata ManagementMicrosoft VisioOLTPOracleRelational DatabasesSAP Business ObjectsSource-to-target MappingSQLSQL Server
Explore related jobs
More jobs at Hsssoft
Similar Business Intelligence jobs
- G
Business IntelligenceGlobal Channel Management, Inc. · Mason, OH - G
Business IntelligenceGomezLee Marketing · Ciudad de Guatemala, Guatemala - P
Business Intelligence SpecialistPrysmian Cables and Systems Usa LLC · Slatina Olt - M
Business Intelligence SpecialistMacLean-Fogg · Mundelein, United States - N
Business IntelligenceNext Level Business Services, Inc. · Philadelphia, PA - O
Business Intelligence EngineerOh · Europe (Remote)
Jobs in Edison
- B
Pediatric Trach and Vent Home Care - Licensed Practical NurseBAYADA Home Health Care · Edison, NJ 08818 | 40.527439307 | -74.372833799 - PFitness TrainerPlanet Fitness · Edison, NJ
- R
Mammography Tech Trainee (Must have Radiology license)RadNet Careers | Home · Edison, New Jersey - D
CDL B - Straight Truck DriverDomino's · Edison, NJ - T
BartenderTriple T Hospitality Group · Edison, New Jersey - T
ServerTriple T Hospitality Group · Edison, New Jersey
Browse these categories
Market data for this role
All reports →- SeriesRole reportsOne role family at a time: how many openings, what changed this week, who is hiring, what it pays.
- SeriesSalary reportsWhat employers publish in job postings, by level and workplace. Not self-reported pay.
- Market overviewState of tech hiring, September 2026: up 4.8%Tech hiring rose 4.8% month over month in September 2026, with 411,122 new listings. Customer support and account executive roles led the growth.