Data Analyst with Data Modeling (DM) expertise
CCM Consulting
New York, NY, United States
about 1 month ago
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Apply on www.indeed.com
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
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
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Talks and stories from around this role — technically off-topic, practically not.
Moments
Explore playlistsVideos
See allRelated articles
See all
BB
Benedikt Bischof
about 4 years ago
EM
Eli McGarvie
Data Analyst Salary in the UK
about 3 years ago
DS
Dhannush Subramani
Top Big Data Technologies That You Need to Know
about 4 years ago
MH
Michael Hunger
Everything a Developer Needs to Know About MCP with Neo4j
about 1 year ago
CH
Chris Heilmann
Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production
almost 2 years ago
EM
Eli McGarvie
Data Analyst Salary Germany
about 3 years ago