FREE ACCESS
5,000–10,000 jobs/day
See all jobs on Scoutfield
Search thousands of fresh jobs every day.
Discover
- Fresh listings
- Fast filters
- No subscription required
Create a free account and start exploring right away.
Core Competencies
Role fitCore Competencies
Use this summary to align your resume positioning with the role.
Demonstrates expertise in data modeling, including logical and physical data models, and proficiency in SQL for data analysis and validation. Collaborates effectively with cross-functional teams to translate business requirements into structured data definitions and supports data warehouse development.
Highest-signal resume keywords
Data ModelingSQL ProficiencyDimensional ModelingData Modeling ToolsAnalytical Skills
ATS Keywords
Tailor your resumeApplicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills
Data ModelingDatabase DesignData ProfilingData ValidationData Quality ReviewsData IntegrationData MappingEntity Relationship DiagramsChange TrackingData Standards
Soft Skills
Analytical SkillsProblem-SolvingCommunication SkillsCollaborationIndependent Work
Tools & Technologies
ER/StudioERwinPostgreSQLRedshiftAthenaSnowflake
Industry Keywords
Information SystemsComputer ScienceAnalytics EngineeringRelational Database DesignCloud Database Technologies
Tech Stack
Tools & technologiesAmazon RedshiftCloudPostgresSQL
About the role
Key responsibilities & impact- Design and maintain logical and physical data models for operational, analytics, and reporting use cases
- Develop dimensional, normalized, and relational models under guidance from senior team members
- Translate business and technical requirements into structured data definitions, entities, relationships, and model components
- Apply enterprise naming conventions, data standards, and modeling practices
- Maintain model documentation, metadata, versioning, and change tracking
- Create and maintain entity relationship diagrams, data mappings, model definitions, and supporting documentation
- Perform data profiling, validation, and quality reviews
- Assist in troubleshooting data structure, lineage, mapping, and integration issues
- Support data warehouse development and data integration initiatives across multiple systems
- Collaborate with data engineers, analysts, architects, and business stakeholders to clarify data requirements
Requirements
What you’ll need- Bachelor’s degree in Information Systems, Computer Science, Business, or a related field
- 2 to 4 years of experience in data modeling, database design, analytics engineering, or a related data discipline
- Working knowledge of logical and physical data modeling concepts
- Knowledge of dimensional modeling and relational database design principles
- Experience using SQL for querying, validation, and data analysis
- Experience using data modeling tools such as ER/Studio, ERwin, or similar platforms
- Familiarity with cloud database or warehouse technologies such as PostgreSQL, Redshift, Athena, Snowflake, or similar platforms
- Strong analytical, problem-solving, and communication skills
- Ability to manage assigned work independently while collaborating effectively within a team environment
- Applicants must be authorized to work for any employer in the U.S.; employment visa sponsorship is unavailable, including CPT/OPT
- Reliable high-speed internet with a wired connection and an adequately equipped home workspace for remote work
Benefits
Comp & perks- Medical, dental, vision and life insurance
- Retirement savings – 401(k) plan with generous company matching contributions (up to 6%), financial advisory services, potential company discretionary contribution, and a broad investment lineup
- Tuition reimbursement up to $5,250/year
- Business-casual environment that includes the option to wear jeans
- Generous paid time off upon hire – including a paid time off program plus ten paid company holidays and three floating holidays each calendar year
- Paid volunteer time — 16 hours per calendar year
- Leave of absence programs – including paid parental leave, paid short- and long-term disability, and Family and Medical Leave (FMLA)
- Business Resource Groups (BRGs) facilitating inclusion and collaboration
- Bonus program opportunity for non-sales positions
- Necessary computer equipment provided
- Flexible work environment
- Reliable high-speed internet and home workspace support for remote/hybrid work
