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, architecture, and integration, with a strong focus on optimizing data flows and ensuring data accuracy. Proficient in SQL and experienced with cloud and on-premises architectures, as well as major data platforms.
Highest-signal resume keywords
Data Modeling ToolsData ArchitectureSQL SkillsData WarehousingCloud Architecture
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 ModelingData VaultDimensional ModelingSQLData AnalysisData ProfilingSystem Development Life CycleData IntegrationRDBMSBig Data
Soft Skills
CollaborationIndependent WorkConsulting
Tools & Technologies
ErwinERStudioPowerDesignerAzureAWSGCPSnowflakeMySQLOraclePostgreSQL
Certifications & Qualifications
Bachelor’s DegreeMaster’s Degree Preferred
Industry Keywords
Data ArchitectureData MartsData LakesOLTP SystemsData Integration Best PracticesReal-Time DataCloud TechnologiesBig Data TechnologiesData Query PerformanceSystem Efficiency
Tech Stack
Tools & technologiesAmazon RedshiftAWSAzureCloudGoogle Cloud PlatformHadoopMySQLNoSQLOraclePostgresRDBMSSQLVault
About the role
Key responsibilities & impact- Translate business needs into data models supporting long-term solutions
- Work with Application Development to implement data strategies, build data flows, and develop conceptual data models
- Create and maintain conceptual, logical, and physical data models and corresponding metadata
- Optimize and update data models for new and existing projects
- Develop naming conventions and coding practices for consistent data models
- Recommend reuse of data models in new environments
- Reverse-engineer physical data models from databases and SQL scripts
- Evaluate data models and physical databases for variances and discrepancies
- Validate business data objects for accuracy and completeness
- Analyze data-related system integration challenges and propose solutions
- Guide analysts, engineers, programmers, and others on project limitations, capabilities, performance requirements, and interfaces
- Review software modifications to improve efficiency and performance
- Examine application designs and recommend corrections
- Support data architecture direction, strategy, standards compliance, implementation, and technical developers
- Coordinate with project managers, client business and technical staff, and project developers on data architecture best practices
- Develop and govern RDBMS, ODS, data marts, and data lakes on SQL/NoSQL platforms
- Oversee expansion of existing data architecture and optimize data query performance
Requirements
What you’ll need- 7-10 Years industry implementation experience with one or more data modelling tools such as Erwin, ERStudio, PowerDesigner etc.
- Minimum of 8 years of data architecture, data modelling (Data Vault and Dimensional, 3NF) or similar experience
- 5-7 years of management experience required
- 5-7 years consulting experience preferred
- Experience working with dimensionally modelled data
- Bachelor’s degree or equivalent experience; Master’s Degree Preferred
- Understanding of cloud (Azure, AWS, GCP, Snowflake preferred) and on premises architectures
- Experience in data analysis and profiling
- Strong data warehousing and OLTP systems from an integration perspective
- Strong understanding of data integration best practices and concepts
- Strong SQL skills required; scripting preferred
- Strong knowledge of all phases of the system development life cycle
- Experience with major database and big data platforms, including RDS, Aurora, Redshift, Databricks, MySQL, Oracle, PostgreSQL, Hadoop, and Snowflake
- Understanding and experience with major data architecture philosophies, including Dimensional, ODS, and Data Vault
- Understanding of modern data warehouse capabilities and technologies such as real-time, cloud, and Big Data
- Ability to work independently and collaboratively