Intellibee Inc
Sr. Data Solutions Engineer – NC DMV Modernization
Senior level database architect responsible for designing, managing and maintaining cloud data strategy for the North Carolina Division of Motor Vehicles (NC DMV) Modernization initiatives.
Responsibilities
Assist NCDIT DMV Modernization Team with design, management, and maintenance of data flow as it pertains to cloud technology.
Analyze, profile, cleanse data and prepare for data conversion of existing environment.
Develop & maintain cloud data strategy, evaluate data elements and structure, and ensure smooth integration of internal and external data.
Direct two database programmers in completing data analysis.
Execute cloud design and implementation strategies.
Evaluate and select appropriate data frameworks.
Establish standards and best practices for data conversion, mapping, cleansing, and migration as legacy moves to cloud-based technologies.
Design system integration containing database permissions, keys, and access for authorized data usage and reporting.
Process instruction of infrastructure movement techniques and data transfers using multiple ETL/ELT sources.
Respond to technical issues timely and effectively.
Lead and solicit database programmers, application teams, security, and infrastructure teams to monitor cloud privacy, performance, and load.
Capture lessons learned and transitional knowledge to assist leadership in mentoring path.
Additional Roles & Responsibilities
Lead design of data conversion, cleansing, migration, and frameworks while ensuring security and data integrity.
Design and enforce policies based on Data Quality, Security, Retention, Stewardship.
Document data model & mapping, create data dictionary, define columns and relationships.
Maintain end-to-end vision of data flow diagram and develop logical data models into physical repositories.
Use cleansing & governance tools to administer, manage and script database functions based on user inputs and data quality principles.
Design and deliver data integration solutions based on current DB2 and future Microsoft SQL Server systems.
Identify project impacts on Business Process Models for stakeholders as it relates to SDLC methodology.
Coordinate with solution architects to assist Enterprise Services Team with delivery of software solutions.
Skill Matrix
Database Design – 10+ years
SQL Server, DB2 – 10+ years
Backup, table partitions – 5+ years
Conversion, cleansing, migration – 10+ years
Application development, support, testing – 10+ years
SDLC methodologies – 10+ years
Documentation – 10+ years
Team lead or supervisor – 5+ years
Communications – 10+ years
Problem diagnosis – 10+ years
Test case creation/execution, technical training – 10+ years
BS/BA in CS, IT, CE; MS CS or MBA – 5+ years
MS Azure or MS Cloud certification – 2+ years (desired)
SSIS management/framework – 2+ years (desired)
Parquet text maintenance knowledge – 2+ years (nice to have)
Must reside in North Carolina and be able to report on-site at short notice – required
Seniority Level Mid-Senior level
Employment Type Full-time
Job Function Information Technology
#J-18808-Ljbffr
Responsibilities
Assist NCDIT DMV Modernization Team with design, management, and maintenance of data flow as it pertains to cloud technology.
Analyze, profile, cleanse data and prepare for data conversion of existing environment.
Develop & maintain cloud data strategy, evaluate data elements and structure, and ensure smooth integration of internal and external data.
Direct two database programmers in completing data analysis.
Execute cloud design and implementation strategies.
Evaluate and select appropriate data frameworks.
Establish standards and best practices for data conversion, mapping, cleansing, and migration as legacy moves to cloud-based technologies.
Design system integration containing database permissions, keys, and access for authorized data usage and reporting.
Process instruction of infrastructure movement techniques and data transfers using multiple ETL/ELT sources.
Respond to technical issues timely and effectively.
Lead and solicit database programmers, application teams, security, and infrastructure teams to monitor cloud privacy, performance, and load.
Capture lessons learned and transitional knowledge to assist leadership in mentoring path.
Additional Roles & Responsibilities
Lead design of data conversion, cleansing, migration, and frameworks while ensuring security and data integrity.
Design and enforce policies based on Data Quality, Security, Retention, Stewardship.
Document data model & mapping, create data dictionary, define columns and relationships.
Maintain end-to-end vision of data flow diagram and develop logical data models into physical repositories.
Use cleansing & governance tools to administer, manage and script database functions based on user inputs and data quality principles.
Design and deliver data integration solutions based on current DB2 and future Microsoft SQL Server systems.
Identify project impacts on Business Process Models for stakeholders as it relates to SDLC methodology.
Coordinate with solution architects to assist Enterprise Services Team with delivery of software solutions.
Skill Matrix
Database Design – 10+ years
SQL Server, DB2 – 10+ years
Backup, table partitions – 5+ years
Conversion, cleansing, migration – 10+ years
Application development, support, testing – 10+ years
SDLC methodologies – 10+ years
Documentation – 10+ years
Team lead or supervisor – 5+ years
Communications – 10+ years
Problem diagnosis – 10+ years
Test case creation/execution, technical training – 10+ years
BS/BA in CS, IT, CE; MS CS or MBA – 5+ years
MS Azure or MS Cloud certification – 2+ years (desired)
SSIS management/framework – 2+ years (desired)
Parquet text maintenance knowledge – 2+ years (nice to have)
Must reside in North Carolina and be able to report on-site at short notice – required
Seniority Level Mid-Senior level
Employment Type Full-time
Job Function Information Technology
#J-18808-Ljbffr