At Regions, the Software Engineer oversees application development, modification, and maintenance of applications. This position monitors system applications, ensures systems run smoothly, and creates reports and other documentation outlining findings/solutions.
Primary Responsibilities
Design, implement, and maintain robust Datamart using Hive and SQL to support business analytics and reporting.
Optimize and troubleshoot complex queries for large datasets to ensure performance and accuracy Develop ETL processes to ingest, transform, and store data from various sources- Implement data validation and quality checks to ensure the integrity of data.
Write clean, efficient and maintainable code, adhering to industry best practices Develops and implements strategies to improve systems Troubleshoot, debug, and optimize automation processes for maximum efficiency Measures effectiveness and efficiency of existing systems Monitors and tests system performance Oversees the training of junior engineers to improve job skills and work efficiency Typically has full ownership of a process May act as a procedural expert
Requirements
Bachelor's degree in computer science, Computer Engineering or a related field Four (4) years of experience
Skills and Competencies
5+ years of experience in data engineering with a strong focus on SQL, Hive and Snowflake.
Expertise in writing and optimizing SQL queries for large dataset.
Hands-on experience with ETL tools and frameworks Knowledge of performance tuning and query optimization techniques in distributed systems
Proficiency in Python and .NET programming languages for scripting and automation tasks
Experience with Hadoop ecosystem and Snowflake ecosystem is a plus
Deep understanding of automation concepts and tools, with the ability to design scalable solutions
Strong expertise in CI/CD leveraging tools such as Harness Strong communication, analytical and problem solving skills
Strong executional capabilities
Thorough understanding of software structures, computing systems and how to integrate them