ETL Developer

Robert Half - Greenville, SC

Full-time - Mid Level

Greenville, SC

Administrative and Support Services

About the position

Robert Half Technology is currently seeking an experienced ETL Developer for an exceptional opportunity with a cutting-edge company. The role involves the development and maintenance of database schema to support business requirements, utilizing SQL/T-SQL/Python programming, and creating ETL solutions to convert source data into line-of-business applications. The ETL Developer will also be responsible for implementing procedures to ensure data integrity and accuracy. This position requires taking a leadership role in the development and maintenance of the corporate data warehouse and Business Intelligence (BI) implementations. In addition to the above responsibilities, the ETL Developer will contribute to the development and maintenance of data warehouse, ETL processes, and Online Transaction Processing (OLTP) systems. The role includes creating and maintaining stored procedures, functions, and triggers to provide solutions to various business problems. The developer will be expected to develop solutions using Python and other suitable tools within a Cloud-based technology platform. Collaboration with a team of Analysts, Architects, and Database Administrators (DBAs) to promote best practices within the organization is also a key aspect of this role. Furthermore, the ETL Developer will plan ETL and Data Integration projects and communicate project status with management, as well as interact with vendors and data sources.

Responsibilities

• Development and maintenance of database schema to support business requirements.
• SQL/T-SQL/Python programming for ETL solutions to convert source data into line-of-business applications.
• Implement procedures to ensure data integrity and accuracy.
• Take a leadership role in the development and maintenance of corporate data warehouse and BI implementations.
• Contribute to the development and maintenance of data warehouse, ETL processes, and OLTP systems.
• Create and maintain stored procedures, functions, and triggers to provide solutions to business problems.
• Develop solutions using Python and other suitable tools in a Cloud-based technology platform.
• Work with a team of Analysts, Architects, and DBAs to promote best practices in the organization.
• Plan ETL and Data Integration projects and communicate project status with management.
• Vendor/data source interaction.

Requirements

• 3+ years of experience in a database developer role.
• 3+ years of experience in a software development, maintenance and/or support role.
• Bachelor Degree in IT, MIS or equivalent.
• Expert knowledge with SQL Server, T-SQL, SSIS, SSAS, SSRS, Maintenance plans and methods.
• Proficient with Python.
• Experienced with Application Integration.
• Knowledge of data file formats and transmission protocols.
• Experienced with Cloud Computing, AWS experience a plus!
• Experienced with source code version control, such as TFS, svn, git and/or Bitbucket.
• Excellent oral and written communication skills.
• Demonstrated ability to work in a high-paced environment while managing multiple projects/tasks.

Benefits

• Medical insurance
• Vision insurance
• Dental insurance
• Life insurance
• Disability insurance
• 401(k) plan