DATA DESIGNER SKILLS, EXPERIENCE, AND JOB REQUIREMENTS

Published: October 3, 2024 - The Data Designer excels in data modeling and management within the housing construction domain. Demonstrates adeptness in various IT project methodologies and data warehousing technologies, including MS SQL DW and Oracle. Possesses comprehensive experience in stakeholder management and developing meta-models in an analytical setting.

Essential Hard and Soft Skills for a Standout Data Designer Resume
  • Data Modeling
  • Physical Data Modeling
  • Logical Data Modeling
  • MS SQL DW
  • Oracle Database Management
  • ETL Tools Proficiency
  • MS SQL Server Expertise
  • Data Warehouse Development
  • Meta-Model Creation
  • IT Project Methodologies Knowledge
  • Stakeholder Management
  • Analytical Thinking
  • Problem Solving
  • Effective Communication
  • Attention to Detail
  • Team Collaboration
  • Adaptability
  • Project Management
  • Strategic Planning
  • Creativity

Summary of Data Designer Knowledge and Qualifications on Resume

1. BA in Computer Science with 5 Years of Experience

  • Working knowledge of Cloud-based data and analytics solutions potentially using Microsoft Azure, Databricks, Informatica and PowerBI
  • Hands-on SQL/Python experience for the purposes of interrogating data
  • Solid experience with data warehouse and business intelligence
  • Previous experience as a Data Designer working independently within a data and analytics solution to deliver low level ETL design and physical data models
  • Excellent knowledge of Data Warehousing Design Methodologies must have Kimball dimensional models
  • Experience in bringing critical insights and suggestions for continual improvement into process and solution design
  • Ability to understand and relay complex data-related issues
  • Proven experience in Data Modelling tools such as ER Studio
  • Working knowledge of ETL technology and tools, such as Databricks
  • Working knowledge of data quality, cleanse and standardisation methods, techniques and tools
  • Experience in working as part of data delivery teams using multiple delivery methodologies
  • Hands-on experience with relational, dimensional, and/or analytic data management tools, including RDBMS, dimensional, NoSQL data platform technologies, and ETL and data ingestion protocols

2. BA in Information Systems with 3 Years of Experience

  • Knowledgeable in big data and No SQL
  • Experienced in modeling and data mapping skills
  • Prior experience as a data designer and data engineer 
  • Understanding and experience in Cloud Computing - AWS preferably (S3/KMS/EC2/EMR/Redshift/IAM)
  • Experience in programming and shell scripting eg. SQL/ PLSQL/Python /Unix Shell/CICD-Jenkins/Airflow DAGs
  • Experience on AWS Redshift/ Snowflake and loading from S3 to database and vice versa, Data Modelling/Data Designing/ETL (extract transform and Load).
  • Experience in building stream ingestion or batch ingestion and transformation pipelines
  • Experience in understanding microservices 
  • Ability to work in a high-performing team environment.
  • Ability to accept and handle change.
  • Has a learn-and-grow attitude
  • Understanding of the Financial Services Industry 
  • Experience working with data warehouses, data lakes, and enterprise big data platforms in multi-data-centre contexts

3. BA in Data Science with 4 Years of Experience

  • Must have a basic knowledge of structural components and design methods.
  • Must be familiar with proper engineering layout techniques.
  • Excellent written and oral communication skills.
  • Ability to develop and produce structural modification drawings and be accurate and detail oriented.
  • Proficient in Microsoft Office suite.
  • Excellent time management and organizational skills. 
  • Familiarity with detailed permitting.
  • Familiarity with NERC & NESC guidelines
  • Experience in the Power Distribution industry. 
  • Proven problem-solving skills to identify the root cause of defects/issues and translate business requirements into technical designs
  • Able to work in a matrix structure in a highly collaborative manner
  • Experience reverse engineering data models based on existing relational schemas or application models.

4. BA in Statistics with 3 Years of Experience

  • Experience in working in a data modeling/ management position
  • Strong stakeholder management experience
  • Experience working within the domain of construction of housing
  • Experience working as a data designer/modeler in an analytics environment
  • Extensive Logical and Physical Data Modelling experience
  • Understanding of a range of data modeling approaches
  • Experience creating abstract meta-models
  • MS SQL DW (Synapse) experience
  • Strong knowledge in one or more Data Warehouse environments and ETL Tools (MS SQL Server, Oracle, SSIS, etc.)
  • Knowledge of various types of IT project methodologies and life cycles (e.g., traditional waterfall Agile, DevOps, etc)
  • Good knowledge of metadata management, data modeling, and related tools.
Relevant Information
Data Lead Skills, Experience, and Job Requirements
Data Collector Skills, Experience, and Job Requirements
Data Consultant Skills, Experience, and Job Requirements
Data Controller Skills, Experience, and Job Requirements