Apex Systems, a World-Class Technology Solutions Provider, is seeking applicants for the below position on behalf of our client. Please apply if interested and qualified. Please note that only qualified candidates will be contacted.
Role / Title: Software Engineer II
Location: Must go in office 3 days a week in either Birmingham, AL, Atlanta, GA, Dallas, TX or Nashville, TN
Duration : 3 month contract to hire
Pay : $40-$45 an hour
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
- 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