ETL Developer - Hybrid (Atlanta, GA)

OneDigital • Atlanta, GA

2d • Hybrid

About The Position

No other company in our industry is supercharging the way they work and serve their clients like OneDigital. Fresh thinking has always been the core of OneDigital’s vision and growth strategy. It’s how we stand out in our industry, it’s how we stay competitive and resilient in a changing world. Most importantly, our innovative approach is helping more people do their best work and live their best lives. Innovation fuels our employee experience by making it easier to do your best work anytime, anywhere and from any device. And our tech-based products for clients are a game changer in our industry. If you thrive on change and innovation, OneDigital is the career choice for you. Our Newest Opportunity: Summary: The ETL developer is responsible for creating and maintaining the Source-to-Target data mappings. This is done through extracting data from heterogeneous source systems, including databases, CRM, ERP, flat files, web services etc. Upon extracting the data, the ETL developer will be responsible for transforming the data. The data can be transformed through data cleansing, aggregation, mapping and converting data based on business / data system requirements. Along with the extraction, transformation, and loading of data the ETL Developer will also assist in developing data pipelines to ensure ongoing data collection, consolidation and management. The core responsibility will be to combine large volumes of disparate complex data, conduct quality checks on the data, manipulate the data and ensure continues access to a clean format of the operational data for reporting, data scientists and other stakeholders.

Requirements

• 5+ years of experience in ETL development with a strong background in SQL Server and Snowflake.
• Proficiency in SQL, T-SQL, and Snowflake SQL.
• Hands-on experience with ETL tools such as SSIS (SQL Server Integration Services) or equivalent.
• Understanding of data warehousing concepts, data modeling, and dimensional modeling.
• Experience with scripting languages (e.g., Python, PowerShell) is a plus.
• Familiarity with cloud platforms (e.g., AWS, Azure, Google Cloud) and their data services.
• Strong analytical and problem-solving skills with attention to detail.
• Excellent communication skills with the ability to collaborate effectively with technical and non-technical stakeholders.
• Bachelor’s degree in Computer Science, Information Technology, Data Science, or a related field.
• Relevant certifications are a plus.

Nice To Haves

• Knowledge of big data technologies (e.g., Hadoop, Spark) and their integration with Snowflake.
• Experience with data visualization tools (e.g., Tableau, Power BI) is a plus.
• Familiarity with Agile development methodologies.

Responsibilities

• ETL Development: Design, develop, and maintain ETL processes to efficiently extract, transform, and load data from various sources into SQL Server and Snowflake.
• Data Integration: Integrate data from diverse sources, including on-premises databases, cloud-based services, and third-party applications.
• Database Management: Create and optimize SQL queries, stored procedures, and functions in SQL Server and Snowflake to support data processing and reporting.
• Data Modeling: Collaborate with data architects and analysts to design and implement data models that meet business requirements and optimize performance.
• Performance Tuning: Monitor and optimize ETL processes for performance and scalability, addressing any bottlenecks or inefficiencies.
• Data Quality: Implement data validation and cleansing processes to ensure data accuracy and integrity.
• Documentation: Maintain comprehensive documentation for ETL processes, data flows, and system architecture.
• Collaboration: Work closely with business stakeholders, data analysts, and other team members to understand data needs and deliver solutions that meet those needs.
• Troubleshooting: Diagnose and resolve issues related to ETL processes, data integration, and database performance.

Benefits

• eligible employees health, wellbeing, retirement, and other financial benefits, paid time off, overtime pay for non-exempt employees, and robust learning and development programs
• You will receive reimbursement of job-related expenses per the company policy and may receive employee perks and discounts.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 1,001-5,000 employees