Data ModelerCTC • Dallas, Iowa, USA
[error_messages.no_longer_accepting]
Data Modeler
CTC • Dallas, Iowa, USA
[job_card.30_days_ago]
[job_preview.job_type]
- [job_card.full_time]
[job_card.job_description]3 years of hands-on data modeling experience in enterprise environments. Expert proficiency with Erwin Data Modeler (version 9.x or higher preferred) including subject areas model templates and DDL generation. Advanced SQL skills and deep understanding of Oracle (11g / 12c / 19c / 21c) and Microsoft SQL Server (2016). Strong command of DDL creating and modifying tables indexes constraints sequences synonyms and materialized views. Solid grasp of database internals : indexing strategies partitioning clustering and query execution plans. Experience with data modeling best practices : normalization denormalization surrogate keys slowly changing dimensions (SCD) and data vault (a plus). Familiarity with version control (e.g. Git) and model comparison / diff tools. Excellent communication skills ability to document models clearly and present to technical and non-technical audiences. Self-Motivated with an ability to multi-task Capable of presenting to all levels of audiences Works well in a team environment Experience with Hadoop / MongoDB a plus
Primary responsibilities of the Data Modeler include designing developing and maintaining enterprise-grade data models that support critical business initiatives analytics and operational systems. The ideal candidate is proficient in industry-standard data modeling tools (with hands-on expertise in erwin Data Modeler) and has deep experience with Oracle and SQL Server databases. The candidate will also translate complex business requirements into robust scalable and normalized data models while ensuring alignment with data governance performance and integration standards.
Responsibilities
- Design and develop conceptual logical and physical data models using erwin Data Modeler (required).
- Generate review and optimize DDL (Data Definition Language) scripts for database objects (tables views indexes constraints partitions etc.).
- Perform forward and reverse engineering of data models from existing Oracle and SQL Server databases.
- Collaborate with data architects DBAs ETL developers and business stakeholders to gather and refine requirements.
- Ensure data models adhere to normalization standards (3NF / BCNF) data integrity and referential integrity.
- Support dimensional modeling (star / snowflake schemas) for data warehousing and analytics use cases.
- Conduct model reviews impact analysis and version control using erwin or comparable tools.
- Participate in data governance initiatives including metadata management naming standards and lineage documentation.
- Optimize models for performance scalability and maintainability across large-scale environments.
- Assist in database migrations schema comparisons and synchronization between environments (Dev / QA / Prod).
- A ssist in optimizing existing Data Solutions
- Follow Oncors Data Governance Policy and Information Classification and Protection Policy.
- Participate in design reviews and take guidance from the Data Architecture team members.
Qualifications
Key Skills
Atl,CMMS,ABAP,Community Support,CRM,Fleet
Employment Type : Full Time
Experience : years
Vacancy : 1
[job_alerts.create_a_job]
Data Modeler • Dallas, Iowa, USA
[internal_linking.similar_jobs]
Tekfortune is a fast-growing consulting firm specialized in permanent, contract & project-based staffing services for world's leading organizations in a broad range of industries.In this quickly ch...[show_more]
We’re looking for Customer Support Product Testers across the US to work from home and help top brands improve their products before they hit the market.[show_more]
Habitat for Humanity Positions-Statewide Are you passionate about making a tangible difference in your community? Eager to be part of a team that not only builds homes but also builds futures? Hab...[show_more]
Product Testers are wanted to work from home nationwide in the US to fulfill upcoming contracts with national and international companies.
We guarantee 15-25 hours per week with an hourly pay of bet...[show_more] Product Testers are wanted to work from home nationwide in the US to fulfill upcoming contracts with national and international companies.
We guarantee 15-25 hours per week with an hourly pay of bet...[show_more] Product Testers are wanted to work from home nationwide in the US to fulfill upcoming contracts with national and international companies.
We guarantee 15-25 hours per week with an hourly pay of bet...[show_more] 
Data Scientist Job Duties : Formulates and leads guided, multifaceted analytic studies again...[show_more]
West Des Moines, IA – Seeking CRNAs.Become a Valued Member of Your Anesthesia Team.As a CRNA, you play a critical role in our mission to improve lives in Anesthesiology and are a valued membe...[show_more] Bring your energy to the role of Walmart Data Entry Clerk (Remote) to manage daily responsibilities with a focus on quality and efficiency, assist with processing returns and exchanges, and adapt t...[show_more] 
Registered Nurse (RN) | Medical-Surgical.Competitive weekly pay (inquire for details) .TravelNurseSource is working with TNAA | TotalMed to find a qualified Med / Surg RN in Chariton, Iowa, 50049!.Tr...[show_more]
Starting at $80,000+, commensurate with experience.The Builder Sales Manager is responsible for leading and developing a team focused on managing and expanding relationships with builder and contra...[show_more] Product Testers are wanted to work from home nationwide in the US to fulfill upcoming contracts with national and international companies.
We guarantee 15-25 hours per week with an hourly pay of bet...[show_more] 
CDL A Teams Drivers Average $4,000 Per Week, Split Between Drivers.FREE INSURANCE, FLEXIBLE HOMETIME OPTIONS!!.WE ARE A PRIVATE FLEET LOOKING FOR OTR TEAM DRIVERS.
ALL MILES PAID (most of our teams ...[show_more]
Mechanical Insulation Project Manager / Estimator.Ziegler Industries is seeking a.Mechanical Insulation Project Manager / Estimator.
The right candidate will have strong technical knowledge, attention t...[show_more] Product Testers are wanted to work from home nationwide in the US to fulfill upcoming contracts with national and international companies.
We guarantee 15-25 hours per week with an hourly pay of bet...[show_more] Gpac has grown from a small, family-owned company into a top recruiting firm in the nation over our 30+ years in business.
With a reputation for excellence, we are dedicated to providing the best se...[show_more] 
The retail industry continues to see unprecedented dynamics as it pivots to a true omni-channel shopping experience.Informed retailers are succeeding, and RDSolutions is providing them with the con...[show_more]
My name is Ella Albert and I am with InstantServe LLC.We're currently recruiting for a role that we think would be a great fit for someone with your skills and experience.Would you be open to learn...[show_more]
Data Center Break-Fix Technician
Tekfortune Inc • Altoona, IA, United States
[job_card.permanent]
[last_updated.last_updated_variable_days] • [promoted]
Data Entry Product Support - No Experience
GLOCPA • Altoona, Iowa
[job_card.full_time]
[last_updated.last_updated_30] • [promoted]
25 / 26 Habitat for Humanity Positions-Statewide
Americorps • Altoona, IA, United States
[job_card.full_time]
[last_updated.last_updated_variable_hours] • [promoted] • [new]
Flexible Remote Work – Get Paid to Share Your Opinions on Top Brands
OCPA • Altoona, Iowa, us
[filters.remote]
[job_card.part_time] +1
[last_updated.last_updated_30] • [promoted]
In-Home Product Tester – No Fees, No Experience, $25-$45 / hr
OCPA • Bondurant, Iowa, us
[job_card.part_time] +1
[last_updated.last_updated_30] • [promoted]
Work From Home Product Tester – $25-$45 / hr – No Experience Needed
OCPA • Union Vale, New York, us
[filters.remote]
[job_card.part_time] +1
[last_updated.last_updated_30] • [promoted]
Data Scientist
TradeJobsWorkforce • 50062 Melcher-Dallas, IA, US
[job_card.full_time]
[last_updated.last_updated_30] • [promoted]
CRNA - Anesthesiology job available in Milo, Iowa
Vituity • Milo, IA, US
[job_card.full_time] +1
[last_updated.last_updated_30] • [promoted]
Walmart Data Entry Clerk (Remote)
TradeJobsWorkforce • 50238 Russell, IA, US
[filters.remote]
[job_card.full_time]
[last_updated.last_updated_30] • [promoted]
Travel Nurse RN - Medical-Surgical in Chariton, IA
TravelNurseSource • Chariton, IA, US
[job_card.full_time]
[last_updated.last_updated_variable_days] • [promoted]
Builder Sales Manager
Gpac • Bondurant, Iowa, United States
[job_card.full_time]
[filters_job_card.quick_apply]
[last_updated.last_updated_variable_days]
Remote Product Tester – $45 / hr + Free Products – Start Now!
OCPA • Wayne, New York, us
[filters.remote]
[job_card.part_time] +1
[last_updated.last_updated_30] • [promoted]
CDL OTR Team Drivers
TRIANGLE SOURCING LLC DBA LONGISTICS • Altoona, IA, US
[job_card.full_time]
[last_updated.last_updated_variable_hours] • [promoted] • [new]
Mechanical Insulation PM / Estimator
Ziegler Industries • Altoona, Iowa, United States
[job_card.full_time]
[filters_job_card.quick_apply]
[last_updated.last_updated_30]
Product Tester (Work From Home) – Keep Free Products + Weekly Pay
OCPA • Altoona, Iowa, us
[filters.remote]
[job_card.part_time] +1
[last_updated.last_updated_30] • [promoted]
Entry Level Remote Recruiter
Gpac • Carlisle, Iowa, United States
[filters.remote]
[job_card.full_time]
[filters_job_card.quick_apply]
[last_updated.last_updated_variable_days]
Field Representative
RDSolutions formerly RetailData • Chariton, IA, US
[job_card.part_time]
[last_updated.last_updated_variable_days] • [promoted]
UX Designer
InstantServe LLC • Hartford, IA, United States
[job_card.full_time]
[last_updated.last_updated_variable_days] • [promoted]