Serigor Inc
Sr. Data Solutions Engineer (Hybrid)
Serigor Inc, Raleigh, North Carolina, United States, 27601
Job Title: Sr. Data Solutions Engineer (Hybrid)
Location: Raleigh, NC
Duration: 12+ Month
Job Description: The Sr. Data Solutions Engineer role will aid in the development of a new cloud environment by assisting the Client Modernization Team with the design, management, and maintenance of data flow as it pertains to cloud technology. Additionally, this role will also be responsible for data analysis, data profiling, data cleansing, data governance, in preparation for data conversion of the existing environment. The ideal candidate will be able to develop & maintain cloud data strategy, evaluate data elements and structure, and ensure the smooth integration of data internal and external to cloud initiatives. This position will direct a team two database programmers to complete the data analysis.
Leadership and Responsibilities:
Execution of cloud design and implementation strategies.
Evaluation and selection of the appropriate data frameworks.
Establishment of standards, best practices for data conversion, data mapping, data cleansing, and data migration as it evolves from legacy to cloud-based technologies.
Design of 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.
Responding to technical issues timely and effectively.
Leading and solicit database programmers, application teams, security, and infrastructure teams to monitor cloud privacy, performance, and load.
Capturing lessons learned and transitional knowledge to assist the Leadership Team in establishing a mentoring path that provides technical exposure and develops the next generation of the client leaders and technical staff.
Additional Roles and Responsibilities: The Sr. Data Solutions Engineer position will also serve in a lead role in the application support team’s quality assurance for operations and maintenance initiatives.
Subject Matter Expert (SME) Responsibilities:
Lead the design of data conversion, cleansing, migration, and frameworks while ensuring security and data integrity.
Design and enforce policies based on Data Quality, Data Security, Data retention, Data Stewardship.
Document the data model & data mapping, create a data dictionary, define columns and data relationships.
Maintain the end-to-end vision of the data flow diagram and develop logical data models into physical data repositories.
Use data 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 our business stakeholders as it relates to Software Development Lifecycle methodology.
Coordinate with all other solution architects to assist the Enterprise Services Team with the delivery of software solutions.
Skills:
Database Design – 10 Years Required
SQL Server, DB2 Experience – 10 Years Required
Database Backup and Table Partitions – 5 Years Required
Database Conversion, Cleansing, Migration – 10 Years Required
Application Development/Support/Testing – 10 Years Required
Software Development Lifecycle Methodologies – 10 Years Required
Documentation Creation and Maintenance – 10 Years Required
Team Leadership and Supervision – 5 Years Required
Communication – Clear, Concise, 10 Years Required
Problem Diagnosis and Troubleshooting – 10 Years Required
Test Case Writing and Technical Training – 10 Years Required
BS/BA in Computer Science, IT, or Equivalent – 5 Years Required
MS Azure or MS Cloud Certification – Highly Desired (2 Years)
SQL Server SSIS Management – Highly Desired (2 Years)
Parquet Text Maintenance Knowledge – Nice to Have (2 Years)
Must reside in North Carolina and can report on-site at short notice – Required
#J-18808-Ljbffr
Job Description: The Sr. Data Solutions Engineer role will aid in the development of a new cloud environment by assisting the Client Modernization Team with the design, management, and maintenance of data flow as it pertains to cloud technology. Additionally, this role will also be responsible for data analysis, data profiling, data cleansing, data governance, in preparation for data conversion of the existing environment. The ideal candidate will be able to develop & maintain cloud data strategy, evaluate data elements and structure, and ensure the smooth integration of data internal and external to cloud initiatives. This position will direct a team two database programmers to complete the data analysis.
Leadership and Responsibilities:
Execution of cloud design and implementation strategies.
Evaluation and selection of the appropriate data frameworks.
Establishment of standards, best practices for data conversion, data mapping, data cleansing, and data migration as it evolves from legacy to cloud-based technologies.
Design of 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.
Responding to technical issues timely and effectively.
Leading and solicit database programmers, application teams, security, and infrastructure teams to monitor cloud privacy, performance, and load.
Capturing lessons learned and transitional knowledge to assist the Leadership Team in establishing a mentoring path that provides technical exposure and develops the next generation of the client leaders and technical staff.
Additional Roles and Responsibilities: The Sr. Data Solutions Engineer position will also serve in a lead role in the application support team’s quality assurance for operations and maintenance initiatives.
Subject Matter Expert (SME) Responsibilities:
Lead the design of data conversion, cleansing, migration, and frameworks while ensuring security and data integrity.
Design and enforce policies based on Data Quality, Data Security, Data retention, Data Stewardship.
Document the data model & data mapping, create a data dictionary, define columns and data relationships.
Maintain the end-to-end vision of the data flow diagram and develop logical data models into physical data repositories.
Use data 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 our business stakeholders as it relates to Software Development Lifecycle methodology.
Coordinate with all other solution architects to assist the Enterprise Services Team with the delivery of software solutions.
Skills:
Database Design – 10 Years Required
SQL Server, DB2 Experience – 10 Years Required
Database Backup and Table Partitions – 5 Years Required
Database Conversion, Cleansing, Migration – 10 Years Required
Application Development/Support/Testing – 10 Years Required
Software Development Lifecycle Methodologies – 10 Years Required
Documentation Creation and Maintenance – 10 Years Required
Team Leadership and Supervision – 5 Years Required
Communication – Clear, Concise, 10 Years Required
Problem Diagnosis and Troubleshooting – 10 Years Required
Test Case Writing and Technical Training – 10 Years Required
BS/BA in Computer Science, IT, or Equivalent – 5 Years Required
MS Azure or MS Cloud Certification – Highly Desired (2 Years)
SQL Server SSIS Management – Highly Desired (2 Years)
Parquet Text Maintenance Knowledge – Nice to Have (2 Years)
Must reside in North Carolina and can report on-site at short notice – Required
#J-18808-Ljbffr