Data Engineer

Tides - San Francisco, CA

Full-time - Mid Level

Hybrid - San Francisco, CA

Social Assistance

About the position

The Data Engineer at Tides plays a crucial role in ensuring seamless data flow across various sources to storage and analysis systems. This position is responsible for designing, developing, and managing data integration solutions that leverage data as a strategic asset, ultimately driving innovation and operational efficiency within the organization.

Responsibilities

• Create and implement data integration solutions using a range of tools and technologies.
• Work with business units and Data Architects to define data requirements and create technical specifications.
• Partner with teams on data-centric projects and document integration processes and procedures in line with organizational standards.
• Analyze data to identify patterns and relationships crucial for integration.
• Maintain security of confidential and proprietary information.
• Develop jobs that interact with APIs or SFTP sites.
• Design and manage ETL (extract, transform, load) processes to consolidate data into a centralized repository.
• Configure and maintain data integration tools and platforms.
• Oversee data integration jobs and resolve issues as they arise.
• Enhance integration processes for better performance and scalability.
• Stay updated on new technologies and methodologies in data integration.

Requirements

• Strong capability to analyze data, identify patterns, trends, and relationships, and translate findings into actionable data integration strategies.
• Exceptional analytical skills with the ability to troubleshoot and resolve issues related to data integration processes, ETL sessions, workflows, and logs.
• Competence in designing, developing, testing, and deploying data integration solutions that meet business needs and technical specifications.
• Experience in developing and managing ETL processes to ensure efficient data movement from disparate sources to centralized repositories.
• Skills in configuring and maintaining data integration tools and platforms to ensure their optimal performance.
• Ability to optimize data integration processes for better performance and scalability.
• Ability to work effectively with business stakeholders, Data Architects, and other teams on data-related projects.
• Strong verbal and written communication skills to document processes, present findings, and collaborate with subject matter experts and team members.
• Keep abreast of new data integration technologies and approaches to continuously improve integration processes.
• Demonstrated aptitude for quickly learning and adapting to new software and systems as required by evolving data needs.
• Strong attention to detail in both data analysis and documentation to ensure accuracy and completeness.
• Adherence to organizational standards and best practices for data management and integration.

Nice-to-haves

• Bachelor's degree in Computer Science, Engineering, or a related field.
• At least 3 years of hands-on experience with data integration tools and processes.
• Practical experience with data integration tools (e.g., Talend, SSIS, etc.).
• Proficiency with SQL and at least one major relational database (e.g., Oracle, MySQL, MS SQL Server).
• Strong programming skills in Java, Python, or similar languages relevant to data integration and manipulation.
• Experience with data visualization tools such as Tableau or Power BI.

Benefits

• Competitive compensation package
• Hybrid work model
• Support for employee talent and well-being