This website uses cookies to ensure you get the best experience.

First Factory and our selected partners use cookies and similar technologies (together “cookies”) that are necessary to present this website, and to ensure you get the best experience of it. If you consent to it, we will also use cookies for analytics purposes.

See our Cookie Policy to read more about the cookies we set.

You can withdraw and manage your consent at any time, by clicking “Manage cookies” at the bottom of each website page.

Select which cookies you accept

On this site, we always set cookies that are strictly necessary, meaning they are necessary for the site to function properly.

If you consent to it, we will also set other types of cookies. You can provide or withdraw your consent to the different types of cookies using the toggles below. You can change or withdraw your consent at any time, by clicking the link “Manage Cookies”, that is always available at the bottom of the site.

To learn more about what the different types of cookies do, how your data is used when they are set etc, see our Cookie Policy.

These cookies are necessary to make the site work properly, and are always set when you visit the site.

Vendors Teamtailor

These cookies collect information to help us understand how the site is being used.

Vendors Teamtailor
Skip to main content
Software Engineering · Heredia · Hybrid

Data Modeler

We are seeking a highly skilled Data Modeler to work closely with Data Engineers, Data Architects, and Application Development teams to translate business needs into scalable and practical data models. This role will design and maintain complex data models and data architectures that enhance data accessibility, efficiency, governance, and data quality, driving measurable business impact.

About First Factory

We are a software development company with over two decades of experience, boasting a dynamic team of 175+ professionals actively engaged in diverse projects across various industries. We invite you to join us on this journey as we thrive and embrace fresh challenges.

Key Responsibilities

  • Understand and translate business needs into data models supporting long-term solutions.

  • Create logical and physical data models using best practices to ensure high data quality and reduced redundancy.

  • Work with the Application Development team to implement data strategies, build data flows, and develop conceptual data models.

  • Optimize and update logical and physical data models to support new and existing projects.

  • Analyze data-related system integration challenges and propose appropriate solutions.

  • Create and maintain Conceptual, Logical, and Physical Data Models for our reporting layer and DataMarts.

  • Define and communicate data standards, industry best practices, technologies, and architecture.

  • Support development teams with application database design and mentoring.

  • Contribute policies and guidelines for the governance of Data Management standards and best practices.

  • Create complex SQL statements to profile data, optimize performance, and perform data analysis for database design input.

  • Create DDL/DML to deploy database structures and perform data loads.

Requirements

  • 10 years minimum experience with at least 8 years designing data models for Enterprise Data

  • Warehouses & Data Marts.

  • Knowledge of relational databases (SQL Server, Redshift), NoSQL, and data architecture.

  • Database design experience across data warehousing and analytic data stores.

  • Strong SQL skills with performance tuning experience.

  • Bachelor’s degree in computer science, data science, information technology, or data modeling.

  • Experience with ER modeling, big data, enterprise data, and physical data models.

  • Experience developing and maintaining Enterprise Canonical Models.

  • Familiarity with data modeling software such as Microsoft Visio or Erwin Data Modeler.

  • Experience with AWS Cloud.

  • Excellent communication and organizational skills.

  • Ability to work in a fast-paced environment.

  • Experience translating Conceptual models into Logical and Physical Data Warehouse models, leveraging Canonical standards.

  • Ability to work independently and collaboratively on large-scale data projects.

  • Ability to lead sessions with stakeholders to determine data rules and review data models.

  • Ability to coach and mentor members of the data engineering team

Nice to have

  • Exposure to Business Intelligence tools such as PowerBI, Sisense, and Tableau.

  • Software Development experience with Python and PySpark.

  • Experience in Enterprise Reference and Master Data Management strategies.

Department
Software Engineering
Role
Data Modeler
Locations
Heredia
Remote status
Hybrid

About First Factory

For over 25 years, First Factory ​has been a place where collaborative excellence meets ​modern technologies. We’re a strong team building exceptional software solutions from Costa Rica​ and LATAM for ​primarily US-based clients. With industry-low turnover, top eNPS globally, and 5 consecutive Inc. 5000 awards, we foster an environment where talented engineers thrive on challenging projects using modern tech stacks.​

Founded in 2000
Coworkers 180+
Software Engineering · Heredia · Hybrid

Data Modeler

Loading application form

Applicant tracking system by Teamtailor