Description

You will manage data profiling, analysis, cleansing, and governance for DMV datasets under the direction of a data architect.

Responsibilities

• Create logical and physical data models, ERDs, and data dictionaries to ensure data integrity.
• Design database schemas, application objects, and data maps including tables, indexes, and views.
• Execute ETL processes by extracting, transforming, and loading data from various sources.
• Perform data profiling and cleansing to identify and resolve data quality issues.
• Conduct database implementation, data conversion, and performance tuning.

Required Skills

• 5+ years of experience in database administration or database programming.
• Working knowledge of DB2 and SQL Server DBMS.
• Experience creating and executing test cases.
• Proficiency with at least one data cleansing tool.
• Ability to dissect complex problems and derive insights from large datasets.
• Experience managing multiple streams of work and meeting strict deadlines.
• Ability to work on-site in Raleigh, NC, and attend in-person interviews.

Preferred Skills

• Ability to communicate technical information to both technical and non-technical audiences.
• Experience managing highly complex work efforts.

Key Skills

Education

Any Gradute