What are the responsibilities and job description for the Senior Data Engineer (Full Time) - Sugar Land, East Lawn position at Prosperity Bank?
POSITION PURPOSE
Will work closely with our BI team and IT Management to help derive internal business intelligence reporting & development to create, improve and maintain ad hoc & automated reporting and dashboards. Will have Hands-on experience with SQL. Will be familiar with predictive analysis and data visualization techniques using relevant tools (e.g., Tableau, Power BI)
Essential Functions And Basic Duties
This role has no supervisory duties.
Qualifications
Education/Certification: Bachelor’s degree in Computer Science, Information systems or equivalent
Required Knowledge: Working knowledge of ETL using SSIS or comparable tool
Knowledge of MS Access, MS Visual Studio, Crystal Reports or Datawatch Monarch is a plus.
Experience Required: Experience with Data management standards such as data governance is a plus 7 years of experience Database Analysis and/or Development experience with SQL Server, writing SQL statements and generating reports 3-5 years of experience in financial/banking industry a plus Skills/Abilities: Excellent understanding of Relational Database Design Strong technical experience in database development, performing DDL operations, writing queries and stored procedures, and optimizing database objects Solid reporting skills preferably using SSRS Establishment and implementation of reporting tools to create reports and dashboards using SSRS, Power BI, Tableau, or similar analytic tool Effective analyst able to work closely with non-technical users. Proficiency in interpersonal communication, presentation, problem solving and analytical skills
Must be flexible and willing to adapt to changes and can establish and maintain effective working relationships with staff and other departments/agencies. Be self-driven with the desire to achieve measurable, specific results within tight time frames Excellent written and verbal communication and presentation skills Must be willing to work after-hours Must work well in a team environment Must be able to interface with users and vendors Must have sense of urgency and ownership to support financial applications, with architectural and system component knowledge preferred
Proficiency in interpersonal communication, presentation, problem solving, and analytical skills
Ability to manage multiple tasks and projects simultaneously with attention to detail and accuracy.
Must be a self-starter that is driven to understand and complete tasks within the guidelines and timeframes assigned.
PHYSICAL ACTIVITIES AND REQUIREMENTS OF THIS POSITION Talking: Especially where one must frequently convey detailed or important instructions or ideas accurately, loudly, or quickly. Average Hearing: Able to hear average or normal conversations and receive ordinary information. Repetitive Motion: Movements frequently and regularly required using the wrists, hands, and/or fingers. Average Visual Abilities: Average, ordinary, visual acuity necessary to prepare or inspect documents or products, or operate machinery. Physical Strength: Sedentary work; sitting most of the time. Exerts up to 10 lbs. of force occasionally. (Almost all office jobs.)
WORKING CONDITIONS None: No hazardous or significantly unpleasant conditions (such as in a typical office).
MENTAL ACTIVITIES AND REQUIREMENTS OF THIS POSITION Reasoning Ability: Ability to apply logical or scientific thinking to define problems, collect data establish facts and draw conclusions. Able to interpret a variety of technical instructions and can deal with multiple variables. Mathematics Ability: Ability to compute discount, interest, profit, and loss; commission markup and selling price; and ratio, proportion, and percentage. Able to perform very simple algebra. Language Ability: Ability to read periodicals, journals, manuals, dictionaries, thesauruses, and encyclopedias. Ability to prepare business letters, proposals, summaries, and reports using prescribed format and conforming to all rules of punctuation, grammar, diction, and style. Ability to conduct training, communicates at panel discussions, and make professional presentations.
Hours: Monday - Friday 8:00 AM - 5:00 PM.
Will work closely with our BI team and IT Management to help derive internal business intelligence reporting & development to create, improve and maintain ad hoc & automated reporting and dashboards. Will have Hands-on experience with SQL. Will be familiar with predictive analysis and data visualization techniques using relevant tools (e.g., Tableau, Power BI)
Essential Functions And Basic Duties
- Help teams on the technical design and implementation of applications using existing and emerging technology platforms
- Help align with firm data management standards and ensure applications within the portfolio are in line with those standards
- Write SQL queries, stored procedures and utilize SQL Server to generate reports and respond to requests from users for data
- Work closely with other technology members to ensure quality of monitoring
- Clearly communicate problem/resolution process to users or management
- Contribute technical documentation and application procedures
- Assure compliance to change management and security policies The above statements describe the general nature and level of work only. They are not an exhaustive list of all required responsibilities, duties, and skills. Other duties may be added, or this job description amended at any time.
This role has no supervisory duties.
Qualifications
Education/Certification: Bachelor’s degree in Computer Science, Information systems or equivalent
Required Knowledge: Working knowledge of ETL using SSIS or comparable tool
Knowledge of MS Access, MS Visual Studio, Crystal Reports or Datawatch Monarch is a plus.
Experience Required: Experience with Data management standards such as data governance is a plus 7 years of experience Database Analysis and/or Development experience with SQL Server, writing SQL statements and generating reports 3-5 years of experience in financial/banking industry a plus Skills/Abilities: Excellent understanding of Relational Database Design Strong technical experience in database development, performing DDL operations, writing queries and stored procedures, and optimizing database objects Solid reporting skills preferably using SSRS Establishment and implementation of reporting tools to create reports and dashboards using SSRS, Power BI, Tableau, or similar analytic tool Effective analyst able to work closely with non-technical users. Proficiency in interpersonal communication, presentation, problem solving and analytical skills
Must be flexible and willing to adapt to changes and can establish and maintain effective working relationships with staff and other departments/agencies. Be self-driven with the desire to achieve measurable, specific results within tight time frames Excellent written and verbal communication and presentation skills Must be willing to work after-hours Must work well in a team environment Must be able to interface with users and vendors Must have sense of urgency and ownership to support financial applications, with architectural and system component knowledge preferred
Proficiency in interpersonal communication, presentation, problem solving, and analytical skills
Ability to manage multiple tasks and projects simultaneously with attention to detail and accuracy.
Must be a self-starter that is driven to understand and complete tasks within the guidelines and timeframes assigned.
PHYSICAL ACTIVITIES AND REQUIREMENTS OF THIS POSITION Talking: Especially where one must frequently convey detailed or important instructions or ideas accurately, loudly, or quickly. Average Hearing: Able to hear average or normal conversations and receive ordinary information. Repetitive Motion: Movements frequently and regularly required using the wrists, hands, and/or fingers. Average Visual Abilities: Average, ordinary, visual acuity necessary to prepare or inspect documents or products, or operate machinery. Physical Strength: Sedentary work; sitting most of the time. Exerts up to 10 lbs. of force occasionally. (Almost all office jobs.)
WORKING CONDITIONS None: No hazardous or significantly unpleasant conditions (such as in a typical office).
MENTAL ACTIVITIES AND REQUIREMENTS OF THIS POSITION Reasoning Ability: Ability to apply logical or scientific thinking to define problems, collect data establish facts and draw conclusions. Able to interpret a variety of technical instructions and can deal with multiple variables. Mathematics Ability: Ability to compute discount, interest, profit, and loss; commission markup and selling price; and ratio, proportion, and percentage. Able to perform very simple algebra. Language Ability: Ability to read periodicals, journals, manuals, dictionaries, thesauruses, and encyclopedias. Ability to prepare business letters, proposals, summaries, and reports using prescribed format and conforming to all rules of punctuation, grammar, diction, and style. Ability to conduct training, communicates at panel discussions, and make professional presentations.
Hours: Monday - Friday 8:00 AM - 5:00 PM.