girl looking into her desktop
Back to search results

Software Engineer III-SQL Server Database Architect/Developer

Addison, Texas

Job Description:

Position Summary

Responsible for designing and developing complex requirements to accomplish business goals. Ensures that software is developed to meet functional, non-functional, and compliance requirements. Ensures solutions are well designed with maintainability/ease of integration and testing built-in from the outset. Possess strong proficiency in development and testing practices common to the industry, and have extensive experience of using design and architectural patterns. At this level, specializations start to form in either Architecture, Test Engineering or DevOp. Contributes to story refinement/defining requirements. Participates and guides team in estimating work necessary to realize a story/requirement through the delivery lifecycle. Performs spike/proof of concept as necessary to mitigate risk or implement new ideas. Codes solutions and unit tests to deliver a requirement/story per the defined acceptance criteria and compliance requirements. Utilizes multiple architectural components (across data, application, business) in design and development of client requirements. Assists team with resolving technical complexities involved in realizing story work. Designs/develops/modifies architecture components, application interfaces, and solution enablers while ensuring principal architecture integrity is maintained. Designs/develops/maintains automated test suites (integration, regression, performance). Sets up and develops a continuous integration/continuous delivery pipeline. Automates manual release activities. Mentors other Software Engineers and coaches team on CI-CD practices and automating tool stack. Individual contributor.

Required Skills

  • Bachelor's Degree in Computer Science, Engineering/ related subject OR equivalent working experience.

  • 7+ years of experience in SQL development/administration/Performance Monitoring including but, not limited to MD_SQL queries, Procedures, Triggers, Indexes, UDFs, ER, Reporting, ETL, DB Design/Implementation, & Optimization/Reliability/Performance.

  • 7-+ years of experience in data security, migration and ETL tools to support Data feeds with third party business partners that provides Marketing and data solution services including but, not limited to: Data Transformation/Integration, HTML, XML, JavaScript, & JSON.

  • 7+ years of experience with Reporting and Analytics to support Marketing.

  • Experience in the Finance Industry.

  • Strong SQL Skills - Understanding of data modeling, database design and data warehousing.

  • Proficiency in T-SQL -  to design, develop, implement and optimize database solutions, as per business needs.

  • Knowledge in DB2, Oracle, and Teradata.

  • Experience in working on development methodologies (Agile/SDLC) and application maintenance tools such as BTconverge, AIT, Maximo , Nexus, ALM and RequestNet.

  • Team Player, Critical Thinker, Time & Pressure Management, Interpersonal &Communication skills.

  • Automation using shell scripting/BTEQ/Autosys to enhance ETL, data integrity and data processing to support the creation of Campaign and Marketing data marts.

  • Design and Architect solutions.

  • Advanced knowledge of Mortgage systems.

  • Create and Execute detail test plan.

  • Coordinate with external teams to assure data quality and conduct integration testing.

  • Perform data analysis and data validation.

  • Participate in design review sessions.

Desired Skills

  • Experience in reporting/data visualization tools Tableau, Business Objects and Qlikview.

  • Architect and SME(Subject matter Expert) for complex initiatives that can deliver end to end solutions.

  • Data Science certification or experience.

  • Experience in Data Modeling.

  • Knowledge of Java, .NET and UI.

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 designing and developing complex requirements to accomplish business goals. Ensures that software is developed to meet functional, non-functional, and compliance requirements. Ensures solutions are well designed with maintainability/ease of integration and testing built-in from the outset. Possess strong proficiency in development and testing practices common to the industry, and have extensive experience of using design and architectural patterns. At this level, specializations start to form in either Architecture, Test Engineering or DevOp. Contributes to story refinement/defining requirements. Participates and guides team in estimating work necessary to realize a story/requirement through the delivery lifecycle. Performs spike/proof of concept as necessary to mitigate risk or implement new ideas. Codes solutions and unit tests to deliver a requirement/story per the defined acceptance criteria and compliance requirements. Utilizes multiple architectural components (across data, application, business) in design and development of client requirements. Assists team with resolving technical complexities involved in realizing story work. Designs/develops/modifies architecture components, application interfaces, and solution enablers while ensuring principal architecture integrity is maintained. Designs/develops/maintains automated test suites (integration, regression, performance). Sets up and develops a continuous integration/continuous delivery pipeline. Automates manual release activities. Mentors other Software Engineers and coaches team on CI-CD practices and automating tool stack. Individual contributor.

Required Skills

  • Bachelor's Degree in Computer Science, Engineering/ related subject OR equivalent working experience.

  • 7+ years of experience in SQL development/administration/Performance Monitoring including but, not limited to MD_SQL queries, Procedures, Triggers, Indexes, UDFs, ER, Reporting, ETL, DB Design/Implementation, & Optimization/Reliability/Performance.

  • 7-+ years of experience in data security, migration and ETL tools to support Data feeds with third party business partners that provides Marketing and data solution services including but, not limited to: Data Transformation/Integration, HTML, XML, JavaScript, & JSON.

  • 7+ years of experience with Reporting and Analytics to support Marketing.

  • Experience in the Finance Industry.

  • Strong SQL Skills - Understanding of data modeling, database design and data warehousing.

  • Proficiency in T-SQL -  to design, develop, implement and optimize database solutions, as per business needs.

  • Knowledge in DB2, Oracle, and Teradata.

  • Experience in working on development methodologies (Agile/SDLC) and application maintenance tools such as BTconverge, AIT, Maximo , Nexus, ALM and RequestNet.

  • Team Player, Critical Thinker, Time & Pressure Management, Interpersonal &Communication skills.

  • Automation using shell scripting/BTEQ/Autosys to enhance ETL, data integrity and data processing to support the creation of Campaign and Marketing data marts.

  • Design and Architect solutions.

  • Advanced knowledge of Mortgage systems.

  • Create and Execute detail test plan.

  • Coordinate with external teams to assure data quality and conduct integration testing.

  • Perform data analysis and data validation.

  • Participate in design review sessions.

Desired Skills

  • Experience in reporting/data visualization tools Tableau, Business Objects and Qlikview.

  • Architect and SME(Subject matter Expert) for complex initiatives that can deliver end to end solutions.

  • Data Science certification or experience.

  • Experience in Data Modeling.

  • Knowledge of Java, .NET and UI.

Shift:

1st shift (United States of America)

Hours Per Week: 

40

Learn more about this role

Full time

JR-21065189

Band: H5

Manages People: No

Travel: Yes, 5% of the time

Manager:

Talent Acquisition Contact:

Jessica Kreiselmaier

Referral Bonus:

0

Street Address

Primary Location:
16001 N Dallas Pkwy, TX, Addison, 75001