Description

You will translate business requirements into fit-for-purpose data solutions by designing logical and physical data models.

Responsibilities

• Design system-specific logical and physical data models using ER/Studio.
• Develop data ingestion and integration pipelines, managing incremental loads and slowly changing dimensions.
• Execute data profiling on source data to drive harmonization and contextualization of disparate datasets.
• Design data movement, curation, transformation procedures, and consumption views or APIs.
• Address data quality issues by providing technical remediation plans in partnership with architects and SMEs.

Required Skills

• 5+ years of experience in data modeling and analysis.
• Proficiency in SQL and advanced database handling languages.
• Expertise in creating logical and physical database models with ER/Studio.
• Deep understanding of data integration patterns and (de-)normalization for transactional and warehousing solutions.
• Hands-on experience with SQL, Azure, Snowflake, or Cloudera.
• Experience with data integration/replication tools such as ADF, Qlik Replicate, or Fivetran.
• Experience working with data dictionaries, maps, and taxonomies.
• Knowledge of Data Governance and Management concepts, including MDM and Data Quality.
• Experience with data manipulation tools such as SSMS, SSIS, TOAD, Access, or Excel.

Preferred Skills

• Experience building databases, data lakes, or data warehouses in on-prem or cloud environments.

Key Skills

Education

Any Graduate