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]
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]
Want to be your own boss? With the Spark Driver™ app, you can make some extra cash by shopping and delivering for customers of Walmart and other local businesses.
Available in more than 3,650 cities...[show_more]
Compensation : Varies per assignment.Location : Remote (USA) Company : ProductReviewJobs Thank you for your interest in becoming a Paid Product Tester.
This opportunity is for completing market res...[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] Want to be your own boss? With the Spark Driver™ app, you can make some extra cash by shopping and delivering for customers of Walmart and other local businesses.
Available in more than 3,650 cities...[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]
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] 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] 
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] 
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]
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])
Mechanical Insulation Project Manager / Estimator.Ziegler Industries is seeking a Mechanical Insulation Project Manager / Estimator to join our team in Des Moines, IA.
This role combines estimating and ...[show_more]
Data Center Break-Fix Technician
Tekfortune Inc • Altoona, IA, United States
[job_card.permanent]
[last_updated.last_updated_variable_days] • [promoted]
Remote Product Tester – $45 / hr + Free Products – Start Now!
OCPA • Union Vale, New York, us
[filters.remote]
[job_card.part_time] +1
[last_updated.last_updated_30] • [promoted]
Flexible Remote Work – Get Paid to Share Your Opinions on Top Brands
OCPA • Wayne, 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]
Spark Driver Delivery Driver.
Spark Driver • Colfax, IA, United States
[job_card.full_time]
[last_updated.last_updated_variable_hours] • [promoted] • [new]
Paid Product Tester
Product Review Jobs • CARLISLE, IA, United States
[job_card.full_time]
[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]
Grocery Delivery Driver for Walmart, Sam's Club and other retailers.
Spark Driver • Bondurant, IA, United States
[job_card.full_time]
[last_updated.last_updated_variable_hours] • [promoted] • [new]
Travel Nurse RN - Medical-Surgical in Chariton, IA
TravelNurseSource • Chariton, IA, US
[job_card.full_time]
[last_updated.last_updated_30] • [promoted]
Builder Sales Manager
Gpac • Bondurant, Iowa, United States
[job_card.full_time]
[filters_job_card.quick_apply]
[last_updated.last_updated_variable_days]
CDL OTR Team Drivers
TRIANGLE SOURCING LLC DBA LONGISTICS • Altoona, IA, US
[job_card.full_time]
[last_updated.last_updated_variable_days] • [promoted]
In-Home Product Tester – No Fees, No Experience, $25-$45 / hr
OCPA • Altoona, Iowa, us
[job_card.part_time] +1
[last_updated.last_updated_30] • [promoted]
Mechanical Insulation PM / Estimator
Ziegler Industries • Altoona, Iowa, United States
[job_card.full_time]
[filters_job_card.quick_apply]
[last_updated.last_updated_30]
Work From Home Product Tester – $25-$45 / hr – No Experience Needed
OCPA • Bondurant, Iowa, us
[filters.remote]
[job_card.part_time] +1
[last_updated.last_updated_30] • [promoted]
Entry Level Remote Recruiter
Gpac • Altoona, Iowa, United States
[filters.remote]
[job_card.full_time]
[filters_job_card.quick_apply]
[last_updated.last_updated_30]
Data Entry Product Support - No Experience
GLOCPA • Union, New York
[job_card.full_time]
[last_updated.last_updated_30] • [promoted]
UX Designer
InstantServe LLC • Hartford, IA, United States
[job_card.full_time]
[last_updated.last_updated_variable_days] • [promoted]
Mechanical Insulation PM / Estimator
New Age Industrial (NAI) • Altoona, Iowa, United States
[job_card.full_time]
[filters_job_card.quick_apply]
[last_updated.last_updated_30]