חברות הייטק בישראל ‹ Datonics ‹ Technical Data Analyst
Technical Data Analyst
Herzliya, Tel-Aviv District, IsraelFULL_TIME
כישורים מהמשרה
SQLETLELTBigQueryData IntegrationData AccuracyData OptimizationData StreamingAutomationGitCI/CDPub/SubGoogle FunctionsAWS LambdaBashPython
תיאור המשרה
We are looking for a technically strong SQL developer with a deep expertise in advanced SQL and experience working with cloud SQL ecosystems.
This role focuses on development and maintenance of complex ETL/ELT procedures in a cloud SQL ecosystem, reliable datasets, and S2S data transfer pipelines within our cloud data ecosystem (AWS/GCS).
We work in hybrid model, 2-3 days in the office.
Role Description
Write advanced SQL queries to transform and stream large datasets in BigQuery cloud ecosystem
Work with system and data streaming applications to ensure accurate data integration pipelines
Troubleshoot data issues and ensure data accuracy, consistency and reliability
Optimize queries and data processes while maintaining integrity, flexibility and cost efficiency
Contribute to improving data workflows, automation and pipelines
Develop and optimize robust processes of data streaming, transformations and structures
Qualifications
At least 3 years as a Data Analyst or a similar role
Hands-on advanced SQL, including complex transformations, ETL/ELT processes, automations and optimizations
Experience with BigQuery, Snowflake or similar cloud ecosystems
Understanding of data structures, system infrastructures and integration protocols
Familiarity with Git & CI/CD - preferred
Experience with Pub/Sub, Google Functions and/or AWS Lambda - preferred
Nice to have:
Up to 2 years of hands-on experience as a Data Engineer
Familiarity with BI tools (Looker, Power BI)
Bash/Python/Pandas/NumPy
Personal skills:
Attention to details & communication skills
Team player and open-minded creative attitude
Strong analytical and problem-solving skills
Proactive and curious state of mind
על Datonics
Datonics, a subsidiary of AlmondNet, is the Internet's leading independent aggregator and distributor of highly granular and proprietary search, purchase-intent, life-stage, B2B, demographic and premium data. Datonics' 1,300+ pre-packaged segments and unlimited number of custom segments facilitate the delivery of highly relevant, privacy-sensitive ads to consumers on all of their devices.