Data Modeller Job at Prolim Global, Plano, TX

RXVWRDJEYU1XMVIwdGNnMWRZNUg3WEdBV0E9PQ==
  • Prolim Global
  • Plano, TX

Job Description

Job Title: Data Warehouse Developer / Data Modeler

Location: San Antonio/Plano

Job Summary

We are seeking an experienced Data Warehouse Developer / Data Modeler with a strong background in data architecture, data modeling, and building enterprise-level data warehouses and middleware interfaces. The ideal candidate will be responsible for analyzing business requirements, designing scalable data models, performing data profiling and integration, and supporting both OLTP and OLAP systems.

Key Responsibilities

  • Design, develop, and maintain data warehouse and data mart solutions to support analytical and reporting needs.
  • Create and maintain conceptual, logical, and physical data models that align with business and technical requirements.
  • Perform data profiling, analysis, and quality assessment to ensure data integrity and consistency.
  • Develop and optimize ETL / data integration processes to move and transform data between systems.
  • Work closely with business analysts, data architects, and application teams to understand data flow and interface requirements.
  • Implement star schema, snowflake schema , and dimensional models for business intelligence and reporting environments.
  • Support database re-engineering initiatives, optimizing performance and scalability.
  • Ensure proper documentation of data models, data dictionaries, and data lineage.

Required Skills & Experience

  • 6+ years of experience in data warehouse development and data integration / middleware solutions.
  • 4+ years of experience in data modeling - including relational , dimensional , conceptual , logical , and physical modeling.
  • Strong knowledge of OLTP and OLAP systems, data marts , and data warehouses .
  • Hands-on experience with ERD/ER diagrams , granularity , cardinality , and database design concepts.
  • Proficiency in SQL and experience with databases like Oracle, SQL Server, Teradata, Snowflake, or Redshift .
  • Familiarity with data profiling , data quality , and data validation techniques.
  • Excellent analytical, problem-solving, and communication skills.

Job Tags

Similar Jobs

Classboxes Technologies

UI UX Designer Job at Classboxes Technologies

 ...Were looking for a creative and detail-oriented **UI/UX Designer** who can transform complex ideas into intuitive and visually appealing digital experiences. Youll collaborate closely with product managers, developers, and marketing teams to design user-friendly interfaces... 

Sunday

US Finance Intern Job at Sunday

 ...QR code. The coolest thing is we are growing quickly and possibly have the perfect position for you. sunday is looking for a Finance Intern with previous experience in financial operations, strategic finance and FP&A. This is a unique opportunity to join a dynamic,... 

Seasoned Recruiter

Automotive Multi-Store Controller Job at Seasoned Recruiter

1. This is a Houston onsite role, how many years of experience as controller for auto dealership multi-store do you have?2. Do you have 10 years as a controller in the auto dealership industry? Yes 3. How many years experience in the public sector do you have... 

Terran Orbital Corporation

Staff Flight Software Engineer Job at Terran Orbital Corporation

 ...Together lets redefine what is possible in orbit and beyond! Summary Terran Orbital is seeking an experienced Staff Flight Software Engineer to join our growing team. Reporting to the Flight Software Engineering Manager the Staff Flight Software Engineer will... 

Riverside Insights

Sr. Partnership Specialist, Clinical Job at Riverside Insights

 ...Company paid Employee Assistance Program (EAP)~ Retirement plan with discretionary company matching ~ Flexible Spending Account (FSA) and Health Savings Account (HSA) options ~ Premium subscription to Calm for employee and dependents ~ Company paid time off (PTO...