Back to search results

Data Engineer II

Charlotte, North Carolina;

Job Description:

Position Summary

Responsible for developing and delivering data solutions to accomplish technology and business goals. Codes design and delivery tasks associated with the integration, cleaning, transformation and control of data in operational and analytics data systems. Works with stakeholders, Product Owners, and Software Engineers to aid in the implementation of data requirements, performance analysis, research and troubleshooting. Familiar with the data engineering practices of the bank. Contributes to story refinement/defining requirements. Participates in estimating work necessary to realize a story/requirement through the delivery lifecycle. Understands and utilizes basic architecture components in solution development. Codes solutions to integrate, clean, transform and control data in operational and/or analytics data systems per the defined acceptance criteria. Works across development teams to understand and aid in the delivery of data requirements Assembles large, complex data sets that meet functional / non-functional requirements. Builds processes supporting data transformation, data structures, metadata, data quality controls, dependency and workload management. Defines and builds data pipelines that enable faster, better, data-informed decision-making within the business. Contributes to existing test suites (integration, regression, performance), analyzes test reports, identifies any test issues/errors, and triages the underlying cause. Documents and communicates required information for deployment, maintenance, support, and business functionality. Adheres to team delivery/release process and cadence pertaining to code deployment and release Identifies gaps in data management standards adherence and works with appropriate partners to develop plans to close gaps.

Required Skills

  • Strong & extensive experience with SQL Development, SQL Studio Manager, SQL Agent Jobs, Stored Processes, & Jobs, etc.

  • Strong knowledge on DB concepts Stored Procedures, Triggers, Functions to perform data transactions on databases.

  • Responsible for supporting Database production issues and providing immediate solutions.

  • Worked intensively on Performance Tuning and Query Optimization.

  • Migration experience from any RDBMS to Hadoop/HDFS environment.

  • Should have knowledge of development using MS SQL Server & above or any RDBMS.

  • Good experience in design and development.

  • Excellent troubleshooting skills.

  • Excellent verbal and written communication skills.

  • DBA experience.

Desired Skills

  • Have knowledge Microsoft SQL Server 2012 & above.

  • Hands-on in Agile methodologies will be an added advantage.

  • Working knowledge of Tableau or any reporting tool.

  • Should have worked on cross platform reporting.


 

Job Band:

H5

Shift: 

1st shift (United States of America)

Hours Per Week:

40

Weekly Schedule:

Referral Bonus Amount:

0

Job Description:

Position Summary

Responsible for developing and delivering data solutions to accomplish technology and business goals. Codes design and delivery tasks associated with the integration, cleaning, transformation and control of data in operational and analytics data systems. Works with stakeholders, Product Owners, and Software Engineers to aid in the implementation of data requirements, performance analysis, research and troubleshooting. Familiar with the data engineering practices of the bank. Contributes to story refinement/defining requirements. Participates in estimating work necessary to realize a story/requirement through the delivery lifecycle. Understands and utilizes basic architecture components in solution development. Codes solutions to integrate, clean, transform and control data in operational and/or analytics data systems per the defined acceptance criteria. Works across development teams to understand and aid in the delivery of data requirements Assembles large, complex data sets that meet functional / non-functional requirements. Builds processes supporting data transformation, data structures, metadata, data quality controls, dependency and workload management. Defines and builds data pipelines that enable faster, better, data-informed decision-making within the business. Contributes to existing test suites (integration, regression, performance), analyzes test reports, identifies any test issues/errors, and triages the underlying cause. Documents and communicates required information for deployment, maintenance, support, and business functionality. Adheres to team delivery/release process and cadence pertaining to code deployment and release Identifies gaps in data management standards adherence and works with appropriate partners to develop plans to close gaps.

Required Skills

  • Strong & extensive experience with SQL Development, SQL Studio Manager, SQL Agent Jobs, Stored Processes, & Jobs, etc.

  • Strong knowledge on DB concepts Stored Procedures, Triggers, Functions to perform data transactions on databases.

  • Responsible for supporting Database production issues and providing immediate solutions.

  • Worked intensively on Performance Tuning and Query Optimization.

  • Migration experience from any RDBMS to Hadoop/HDFS environment.

  • Should have knowledge of development using MS SQL Server & above or any RDBMS.

  • Good experience in design and development.

  • Excellent troubleshooting skills.

  • Excellent verbal and written communication skills.

  • DBA experience.

Desired Skills

  • Have knowledge Microsoft SQL Server 2012 & above.

  • Hands-on in Agile methodologies will be an added advantage.

  • Working knowledge of Tableau or any reporting tool.

  • Should have worked on cross platform reporting.


 

Shift:

1st shift (United States of America)

Hours Per Week: 

40

Learn more about this role

Full time

JR-21080791

Band: H5

Manages People: No

Travel: Yes, 5% of the time

Manager:

Talent Acquisition Contact:

Jessica Kreiselmaier

Referral Bonus:

0