Data Analyst with Data Modeling (DM) expertise

CCM Consulting
New York, NY, United States
about 1 month ago
Apply on www.indeed.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
5 years minimum
Compensation
$124,800.0 - $145,600.0
Working hours
Regular working hours
Job source

Tech stack

Bash Shell Computer Programming Data Architecture Data Dictionary Data Integration Data Integrity Extract Transform Load (ETL) Data Mapping Relational Databases Database Design Python (Programming Language) Mainframes
+6 more
Microsoft SQL Server Oracle (Applications) SQL Databases Talend Database Optimization Vba Programming Language

Job description

  • Develop and maintain robust data models using best practices in database design, ensuring scalability and performance across SQL databases such as Microsoft SQL Server and Oracle.
  • Design and implement ETL (Extract, Transform, Load) processes utilizing tools like Talend, Python, Bash scripts, or VBA to streamline data integration from diverse sources.
  • Extract business rules from the existing Legacy code and create Source-to-Target mappings.
  • Transform business rules and data quality rules into ETL and/or SQL technical specifications.
  • Develop complex SQL data validations based on STTMs and target Data Models.
  • Provide technical and analytical support to clients data integrity and quality initiatives.

Requirements

We are seeking a dynamic and detail-oriented Data Analyst with specialized expertise in Data Modeling (DM) to join our innovative analytics team. Must have source-to-target data mapping experience in a mixed Mainframe and Relational Database environments, * Proven experience as a Data Analyst or Data Modeler with a strong understanding of database design principles and data architecture best practices.

  • Demonstrated proficiency in SQL programming for query management, report development, and database optimization.
  • Minimum of five (5) years of source-to-target data mapping experience in a mixed Mainframe and Relational Database environments.
  • Experience creating data dictionary documentation with business terms, valid values, and definitions.

Benefits & conditions

$60 - $70 an hour - Contract

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.indeed.com
Prepare application

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

4:40 min

Analyzing COBOL mainframe migration challenges with AI

Michael Friedrich Michael Friedrich · World Congress 2026 Europe

3:52 min

Avoiding remote code execution from unsanitized inputs

Alexander Pirker · World Congress 2022

2:36 min

Integrating business experts and conceptualizing analytical use cases

Stefan Donsa Stefan Donsa +1 · LIVE

6:35 min

Modernizing legacy COBOL mainframe systems using AI agents

Chris Heilmann +2 · LIVE

1:28 min

Building shared Java modules and analyst targeting platforms

Chris Heilmann +2 · LIVE

54 sec

Interpreting complex terminal commands safely using external explanation utilities

Dan Cranney +2 · LIVE

Videos

See all

Related articles

See all