ETL Developer

Are you looking to accelerate your career without having to hide your authentic self - a place where you can be you? A career that’s making a bigger impact on the world?  At OneDigital, we are on a mission to help people do their best work and live their best lives.  From the services we offer to the way we show up for each other each day, we are fueling dreams, achieving big goals, and embracing each other’s truest selves.

We understand that pursuing a new job is a big deal.  Maybe you’re afraid you won’t fit in.  Well, here’s the good news.  For us, the days of “fit in to get in” are over and being different is not a barrier to getting ahead. Greatness comes in all shapes, sizes, colors, and experience levels. If you are looking for a people-first culture that is wired for growth, driven to serve, and totally committed to having your back, give us a shot. Your best life awaits.

Our Newest Opportunity: 

The ETL / ELT 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 / ELT 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.

Qualifications, Skills and Requirements:

Key Responsibilities:

· ETL/ELT Development: Design, develop, and maintain ETL/ELT 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/ELT 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/ELT 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/ELT processes, data integration,

and database performance.

· Experience: 5+ years of experience in ETL/ELT development with a strong background in SQL Server and Snowflake.

· Technical Skills: Proficiency in SQL, T-SQL, and Snowflake SQL. Hands-on experience with ETL tools such as SSIS (SQL Server Integration Services) or equivalent.

· Data Warehousing: Understanding of data warehousing concepts, data modeling, and dimensional modeling.

· Scripting Languages: Experience with scripting languages (e.g., Python, PowerShell) is a plus.

· Cloud Platforms: Familiarity with cloud platforms (e.g., AWS, Azure, Google Cloud) and their data services.

· Problem-Solving: Strong analytical and problem-solving skills with attention to detail.

· Communication: Excellent communication skills with the ability to collaborate effectively with technical and non-technical stakeholders.

Education: Bachelor’s degree in Computer Science, Information Technology, Data Science, or a related field. Relevant certifications are a plus.

Preferred Skills:

· Big Data Technologies: Knowledge of big data technologies (e.g., Hadoop, Spark) and their integration with Snowflake.

· Data Visualization: Experience with data visualization tools (e.g., Tableau, Power BI) is a plus.

· Agile Methodologies: Familiarity with Agile development methodologies.

Your base pay is dependent upon your skills, education, qualifications, professional experience, and location. In addition to base pay, some roles are eligible for variable compensation, commission, and/or annual bonus based on your individual performance and/or the company’s performance.  We also offer 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.

To learn more, visit: www.onedigital.com/careers

OneDigital is an equal opportunity employer. Not only as a matter of standard, but to honor and celebrate our differences. We believe that the power of ONE starts with you. We are committed to cultivating and preserving a culture that celebrates diversity, insists on equity and inclusion, and connects us. Ensuring our people feel seen, valued, respected, and supported is fundamental to our core values and business goals.

OneDigital provides equal employment opportunities to all employees and applicants for employment regardless of their: veteran status, uniformed servicemember status, race, color, religion, sex, sexual orientation, gender identity, age (40 and over), pregnancy (including childbirth, lactation and related medical conditions), national origin or ancestry, citizenship or immigration status, physical or mental disability, genetic information (including testing and characteristics) or any other category protected by federal, state or local law (collectively, “protected characteristics”). A copy of the Federal EEO poster is linked here.

Pursuant to local Fair Chance Ordinances, we will consider qualified applications with arrest or conviction records for employment. For applicable candidates, the following ordinances are linked here to inform you of your rights as an applicant:

City and County of San Francsico

City of Los Angeles

County of Los Angeles

Employment decisions shall comply with all other applicable federal, state and city/county laws prohibiting discrimination in employment. OneDigital complies with all criminal history inquiry [or ‘ban the box’] laws in California, Connecticut, Colorado, Hawaii, Illinois, Maine, Maryland, Massachusetts, Minnesota, New Jersey, New Mexico, Oregon, Rhode Island, Vermont and Washington.

In short, we believe in hiring the most qualified applicant for the position, regardless of background.

If you have questions about our hiring policies and practices, we would be happy to discuss upon receiving your application. We hope to welcome you to OneDigital and look forward to hearing from you.

Thank you for your interest in joining the OneDigital team!