Bigquerytrabajos

Hola! Busco a un experto en BigQuery para impartir una formación presencial de 15 horas en 3 dias en Barcelona. El contenido de la misma ya esta estructurado. Gracias

Buscamos desarrollador JAVA con 2 años de experiencia, si con...· Conocimientos sobre pruebas unitarias. · Conocimientos en base de datos SQL y NoSQL. · Experiencia en desarrollo de Rest Api. · Conocimientos en GIT. · Habilidad para trabajar independientemente sin supervisión. · BigTable experto · Conocimientos básicos de comunicación serial Deseable · Conocimientos en GCP Bigtable, GCP CloudSQL, GCP Bigquery. · Conocimientos en GCP CloudRun. · Conocimientos en GCP Cloud Task. Se requiere realizar la creación de las BD para la solución, garantizar la ingesta de datos, realizar la logica del proyecto pa...

Necesito ayuda para realizar un código basado en SQL para gestionar y optimizar bases de datos

Proyecto para una empresa automotriz para 5 semanas, home office. Conocimientos: Google Cloud Platform, Dataproc, DataFlow, BigQuery.

Se trata de tres proyectos de una automotriz importante en México para la creación de dashboards y reportes para posventa (Data Studio), la recolección de información desde diferentes fuentes, el procesamiento en BigQuery, Dataproc y un proyecto de ciencia de calidad de datos.

Necesito que desarrollen un software para mí. Me gustaría que este software sea desarrollado para Mac utilizando Python.

Actualizar scripts para asegurar la subida de datos en particiones a BigQuery. Asegurarse que los scripts tambien funcionan con un PubSub trigger y los unit tests tienen una covertura superior al 80%.

Buscamos desarrollador con experiencia en extracción y transformación de datos con las plataformas y BigQuery para mostrar la información en dashboards / reportes en Google Data Studio. Las fuentes para la extracción de datos mediante StitchData son: * Facebook Ads. * Klaviyo. * Woocommerce. Además de la información de las plataformas anteriores en Google Data Studio mostraremos información de Google Analytics.

...idear e implementar una estructura de base de datos en BigQuery que se alimente de información actualmente almacenada en hojas Google Sheets. La conexión entre las hojas de Google Sheets y BigQuery será preferentemente via la herramienta Stitch Data, pero puede evaluarse otra herramienta o un desarrollo propio del freelancer. La información dentro de las hojas de Google Sheets tiene una estructura compatible con la integración a BigQuery. En todo caso, la estructura es flexible en pos de amoldarse con los requisitos. Tenemos un recurso que se encargará de la parte de preparación de datos desde el lado de Google Sheets, pero necesitamos un recurso adicional temporal (freelance) que nos facilite la puesta a punto de l...

Buenos días Ismael, Estamos buscando un desarrollador con características similares a las que describes en tu perfil, para integrarlo a nuestro proyecto. Nuestro proyecto es una aplicación web de distribución de música. Las principales tecnologías utilizadas en base de código son React, Redux, Firebase (realtime database, hosting y cloud functions), Google Cloud Storage y BigQuery. Hay hay más cosas pero eso es lo fundamental. Gracias y saludos hasta Culiacán. Gerardo

Necesito un experto en BigQuery capaz de crear un proceso dentro de BigQuery para enviar datos a un FTP. Ese FTP es interno de una herramienta de Marketing Cloud (Salesforce)

Somos una empresa de marketing digital y busco a un google cloud Arquitect certificado que maneje Apigee y diseñar una aplicacion en el entorno de GSuite. El objetivo es capturar información y enviar entre GSuite y Bigquery.

Trabajando con Google BigQuery queremos realizar multitud de queries en sql para ordenar los datos generados por los usuarios de aplicaciones.

...consideraciones: + Implementar un servicio web en Google Cloud Platform con Python API y BigQuery. + Permitir consultas dinámicas con BigQuery. + Tiempo de respuesta de menos de 10 segundos al ejecutar consultas en BigQuery. + Servicio web implementado con protocolos de seguridad GCP y autenticación de usuario. + Cuando el servicio web no responde en un tiempo específico o no está activo, debe enviar una respuesta con un mensaje de error. EN Implement a web service on Google Cloud Platform with the following considerations: + Deploy a Web Service on Google Cloud Platform with Python API and BigQuery. + Allow dynamic queries with BigQuery. + Response Time of less than 10 seconds when executing queries on BigQue...

...profesional de al menos 4 años como Senior Software Engineer. Excelentes conocimiento de programación en JavaSólidos conocimientos de JVM, Tomcat, Linux (Deseable)Dominio del protocolo con herramientas de de Play Framework (Deseable)Experiencia con las siguientes tecnologías (Deseable): Elastic Search, Redis, Oracle, MySQL, MongoDB, Memcached, Cassandra, Google BigQuery, AWS DynamoDBExperiencia con Sistemas distribuidos en cloud (AWS, Google App Engine) (Deseable) Lugar de trabajo: Capital FederalJornada Laboral: Lunes a viernes de 9 a 18 enviar CV a *******@ con asunto: Software Engineer 102/16, sin omitir la remuneración pretendida.-...

...profesional de al menos 4 años como Senior Software Engineer. Excelentes conocimiento de programación en JavaSólidos conocimientos de JVM, Tomcat, Linux (Deseable)Dominio del protocolo con herramientas de de Play Framework (Deseable)Experiencia con las siguientes tecnologías (Deseable): Elastic Search, Redis, Oracle, MySQL, MongoDB, Memcached, Cassandra, Google BigQuery, AWS DynamoDBExperiencia con Sistemas distribuidos en cloud (AWS, Google App Engine) (Deseable) Beneficios: Cobertura médica prepaga para el grupo en cadena de gimnasios de primer de por graduación, cumpleaños, nacimiento de hijos, casamiento, de trabajo: Capital FederalJornada Laboral: Lunes a viernes de 9 a 18 enviar CV

Eco...profesional de al menos 4 años como Senior Software Engineer. Excelentes conocimiento de programación en JavaSólidos conocimientos de JVM, Tomcat, Linux (Deseable)Dominio del protocolo con herramientas de de Play Framework (Deseable)Experiencia con las siguientes tecnologías (Deseable): Elastic Search, Redis, Oracle, MySQL, MongoDB, Memcached, Cassandra, Google BigQuery, AWS DynamoDBExperiencia con Sistemas distribuidos en cloud (AWS, Google App Engine) (Deseable) Beneficios: Cobertura médica prepaga para el grupo en cadena de gimnasios de primer de por graduación, cumpleaños, nacimiento de hijos, casamiento, de trabajo: Capital FederalJornada Laboral: Lunes a viernes de 9 a 18 hs.-

Eco...profesional de al menos 4 años como Senior Software Engineer. Excelentes conocimiento de programación en JavaSólidos conocimientos de JVM, Tomcat, Linux (Deseable)Dominio del protocolo con herramientas de de Play Framework (Deseable)Experiencia con las siguientes tecnologías (Deseable): Elastic Search, Redis, Oracle, MySQL, MongoDB, Memcached, Cassandra, Google BigQuery, AWS DynamoDBExperiencia con Sistemas distribuidos en cloud (AWS, Google App Engine) (Deseable) Beneficios: Cobertura médica prepaga para el grupo en cadena de gimnasios de primer de por graduación, cumpleaños, nacimiento de hijos, casamiento, de trabajo: Capital FederalJornada Laboral: Lunes a viernes de 9 a 18 hs.-

Necesito apoyo para la extracción, transformación y carga de datos en un spreadsheet desde una base de datos (en BigQuery) así como en la visualización y protección del front-end del tablero de control que se va a desarrollar.

Se precisa programador JavaScript para crear una extensión multi-navegador (Chrome, Firefox, Safari, IE) que se ocupará de salvaguardar la privacidad de los usuarios que se la instalen. Se requiere: * Amplia experiencia desarrollando con JavaScript (patrones de diseño, buenas prácticas, uso de prototipos/herencia,...jQuery * Conocimiento de alguna tecnología web de servidor (java, php, python, ruby…) para gestionar altas de usuarios y hacer un registro muy simple de cierta actividad. * Inglés avanzado Se valorará: * Conocimientos de HTML5 y CSS3 * Experiencia portando extensiones a otros navegadores: , Kango, … * Diseño y maquetación web * Experiencia con motores de búsqueda de Big Data: Hadoop, Goo...

Se precisa programador JavaScript para crear una extensión multi-navegador (Chrome, Firefox, Safari, IE) que se ocupará de salvaguardar la privacidad de los usuarios que se la instalen. Dicha extensión se desarrollaría en modo open source a partir de la ya existente Se requiere: * Amplia experiencia desarrol...Conocimiento de alguna tecnología web de servidor (java, php, python, ruby…) para gestionar altas de usuarios y hacer un registro muy simple de cierta actividad. * Inglés avanzado Se valorará: * Conocimientos de HTML5 y CSS3 * Experiencia portando extensiones a otros navegadores: , Kango, … * Diseño y maquetación web * Experiencia con motores de búsqueda de Big Data: Hadoop, Google Big...

...Recommendations: Provide clear report on insights and suggest changes to team composition, drop spots, in-game decisions. **Project Deliverables** * Structured dataset in Google BigQuery with our team's gameplay stats + relevant opponent data. * SQL queries designed for meaningful performance insights. * Analysis reports with visualizations focused on: * Player performance over time * Our strengths and weaknesses * How we compare to top teams * Map rotation analysis with suggested changes * Final presentation summarizing key findings & action plan. **Required Skills** * Expert SQL and querying, especially Google BigQuery. * Strong analytical skills with statistics experience. * Passionate about PUBG Mobile - understand gameplay and competitive...

...well-known analytical databases - specifically Cassandra, BigQuery, Snowflake, and Redshift. Key Responsibilities: - Research, understand, and articulate the distinct approaches of and the other specified databases - Translate complex concepts into clear, concise, and reader-friendly articles Ideal Candidate Should Have: - You need to have very deep expertise in databases and distributed systems. - Ideally, a Ph.D. or some deep research writing experience. Any conference publications in top conferences are a plus. - An understanding of database architectures - Prior experience writing technical articles for a technical audience - The ability to explain complex topics in an easy-to-understand manner - Knowledge about Cassandra, BigQuery, Snowflake, and Redshift will be ...

I have an AI restaurant recommendations platform and looking for a developer to take on work as required. I am a full stack engineer and built the platform on my own so this request is more for bringing in a partner to take on some new work. Status updates will be expected everyday and tracked via JIRA. The ...front end and backend of the platform. Please provide your strategy to implement these in the application as well as how long it would take. This role while not in consideration for full time might be a long term engagement. Please provide links to your repo if available. My ideal candidate must have experience in the following: Java Springboot React Typescript Styled Components CSS GCP Pub Sub, BigQuery, Vertex AI, PostGreSql, Cloud Armor, GCS Google APIs Gitlab Docker Node...

I need someone to create the dag and trigger it I am working on a migration project from hadoop to bigquery....more details will be shared via chat

I'm looking for an expert in GCP & Airflow who understands the intricacies of cre...intricacies of creating an Airflow DAG in Project-A (cloud composer) and triggering it via Project-B's service account. Work encompasses: - Crafting an Airflow DAG implementing Python script to create BigQuery tables. - Making the DAG operative within the confines of Project-A. - Leverage the service account of Project-B to trigger the DAG. - The BigQuery tables need to be created within Project-C. Ideal skills and experience: - Proficient in Python Scripting. - Experience in creating and managing workflows using Airflow. - Extensive knowledge of Google Cloud Platform. - Familiarity with BigQuery is a must. - Proven ability to script and manage service account interac...

Develop a real-time data integration and processing system that synchronizes data from a MongoDB database to Google BigQuery using Google Cloud Dataflow, ensuring that any new collections added to MongoDB are automatically transmitted to BigQuery without manual intervention.

I'm looking for an expert to assist me in analyzing sensor/IoT data using BigQuery on Google Cloud Platform. Key Responsibilities: - You will be responsible for conducting data analysis on our sensor and IoT data. - Experience in Google Cloud Platform and BigQuery is a necessity for this project. - I am looking for someone with a strong background in data analysis, specifically with sensor and IoT data. Ideal Candidate: - Proficient in Google Cloud Platform, specifically BigQuery - Previous experience with sensor and IoT data - Strong data analysis skills - Ability to communicate results effectively We're looking for someone who can not only analyze our data effectively but also communicate the results in a way that is easily understood by non-techn...

The Data Engineer contractor role will be a project based role focused on migrating data pipelines from legacy infrastructure and frameworks such as Scalding...migration process, working collaboratively with cross-functional teams to resolve them quickly. Communicating progress, challenges, and timelines to stakeholders on a regula Requirements The ideal candidate is a Data Engineer with considerable experience in migrations and Big Data frameworks. Must-Haves Scala programming language expertise Spark framework expertise Experience working with BigQuery Familiarity scheduling jobs in Airflow Fluency with Google Cloud Platform, in particular GCS and Dataproc Python programming language fluency Scalding framework fluency Pyspark framework fluency Dataflow(Apache Beam) framewor...

Hi, Please apply only individual. Agency can apply but budget should not be more than mentioned. Role : GCP Engineer (OTP) Exp : 7 + yrs SHIFT: IST Cloud Storage Buckets, BigQuery (SQL, Data Transformations and movement) Airflow (python, DAGs), DBT IAM Policies PyCharm Databricks (pySpark), Azure DevOps Clear and confident communication

I'm seeking a developer to create a Bigquery dashboard. Unfortunately, I haven't identified the specific data sources, metrics, or KPIs yet, but these details will be provided as we progress. Also, the dashboard visualization style will be decided over time. Ideal skills include: • Experience with Google Bigquery • Strong understanding of KPIs and metrics • Proficient in designing engaging data visualizations • Background working with diverse data sources. • Adaptability as specifics will be determined along the way.

The Data Engineer contractor role will be a project based role focused on migrating data pipelines from legacy infrastructure and frameworks such as Scalding...migration process, working collaboratively with cross-functional teams to resolve them quickly. Communicating progress, challenges, and timelines to stakeholders on a regula Requirements The ideal candidate is a Data Engineer with considerable experience in migrations and Big Data frameworks. Must-Haves Scala programming language expertise Spark framework expertise Experience working with BigQuery Familiarity scheduling jobs in Airflow Fluency with Google Cloud Platform, in particular GCS and Dataproc Python programming language fluency Scalding framework fluency Pyspark framework fluency Dataflow(Apache Beam) framewor...

...agency to elevate our current Google Sheets-based systems into a robust SQL or BigQuery database framework. The objective is to create a user-friendly web dashboard that seamlessly interacts with the database, ensuring smooth data updates and retrieval. .Collaborate with cross-functional teams to understand current Google Sheets systems and user requirements. .Design and develop a web dashboard for user interaction with the SQL or BigQuery database. .Implement user authentication and authorization protocols for secure access to the system. .Create a system where users can create unique usernames and perform tasks associated with their roles. .Establish data synchronization between the web dashboard and the SQL/BigQuery database. .Optimize database performance and...

I'm seeking a skilled freelancer to convert a geojson file to New Line json format. The purpose of this conversion is specifically for use within Looker Studio. The file will be stored in BiGQuery. The file has to be accepted in BigQuery and be useable in Looker Studio

I need a proficient Google Cloud engineer to assist in the verification of my Google Cloud project application with external Google accounts. Key Responsibilities: - Rigorous understanding and use of Compute Engine, Cloud Storage and BigQuery. - Verification of my Google Cloud project specifically on the OAuth Consent Screen. - Integration of the Google Cloud project with external Google accounts. - Signature of non-disclosure agreement. - Complete project within 16-30 hours. Ideal candidate must be Google Cloud certified, with extensive experience in application integration and account setup. Proven problem-solving skills would be beneficial.

...Engineering, or a related field. - Proven experience as a data engineer or similar role, with a strong understanding of data modeling, ETL processes, and database technologies. - Proficiency in at least one programming language commonly used in data engineering (e.g., Python, Java, Scala). - Hands-on experience with cloud platforms (e.g., AWS, Google Cloud, Azure) and related services (e.g., S3, GCP BigQuery, Azure Data Lake). - Familiarity with containerization and orchestration tools such as Docker and Kubernetes. - Excellent problem-solving and communication skills. - Ability to work independently and collaborate effectively in a remote team environment. *Preferred Qualifications:* - Advanced degree in a relevant field. - Experience with real-time data processing frameworks (...

I need a skilled developer to build a responsive, cloud-based application using React for frontend and Python Flask for backend. Interactivity, real-time updates, and effective user authentication are critical. Key Features: - User Authentication: Incorporate secure login/logout provisions in the design. - Interactive Forms: Develop engaging forms for optimal user...Real-Time Updates: Implement real-time updates to enhance user experience. Backend Development: - The backend's primary aim would be to handle data storage and retrieval efficiently. Use third party apis The platform is expected to host less than 100 concurrent users; thus, the design should accordingly accommodate this traffic. Ideal candidates would have experience in Google Cloud Platform and BigQuery for op...

...programmer who is proficient in Node.js and SQL to support a data segmentation project. Scope of work: - You will be connecting to BigQuery using Node.js - You will fetch the schema of the dataset/tables - the dimensions, fields will be stored in a datastore - you will create a service that allows querying bigquery with optimized SQL given that the user creates segment rules Ideal Skills: • Node.js - You should have extensive experience in this language as this will be the primary tool for the project. • SQL - You should be an experienced SQL coder because you will be writing queries for segmentation. • BigQuery - You must have previous experience with BigQuery for data access and management. • Data Analysis - Experience in data se...

I'm looking for someone to only guide me to use Google Cloud Platform (GCP) to design and create end-to-end an architecture that utilizes Compute Engine, Cloud Storage, and BigQuery to bring new data into cloud. This is not a physical project but quick training requirement. Key Requirements: - Expertise in GCP Compute Engine - Knowledge in Cloud Storage and BigQuery - Ability to design innovative cloud architectures with potential scalability and high availability in mind - Ability to explain end to end steps involved - Ability to design and implement security

I'm currently facing an issue in one of my Python scripts, which has been running flawlessly for months, but now encounters an authentication error when attempting to connect to Google BigQuery. For context, I'm using Python 3 and the error seems to originate when establishing the connection. Furthermore, the script uses service account authentication to connect to BigQuery. For this project, I would ideally prefer someone with the following skills and experience: - Proficient in understanding and debugging connection issues - Extensive experience with Google BigQuery, especially in authentication using service accounts - Familiarity with resolving errors in established scripts Your task will be to diagnose the issue and ultimately, resolve the authenticat...

...an experienced Google Cloud Looker Dashboard professional to help configure visualizations and configure user access for my Dashboard. My primary needs include: - Being proficient in Google Cloud Platform, Looker Studio, and BigQuery. - Skilled in creating different types of visualizations such as bar charts, line charts, and pie charts. - Specifically, I require a connection to BigQuery as my data source. The right person for this project should have considerable experience with Google's data visualization tools, specifically Looker, and be familiar with BigQuery. The dashboard and data sources already exist, I need some time with a professional so he/she can guide me through how to configure the existing dashboard, how to give access to users, etc. Be...

...in synthesizing data from diverse sources including QuickBooks, Airtable, BigQuery, and our CRM system Follow Up Boss. This position is crucial for monitoring, analyzing, and reporting on the effectiveness of our marketing efforts, particularly focusing on texting and voicemail campaigns. The ideal candidate will possess strong skills in SQL, experience with BigQuery and Dataform, and proficiency in data visualization tools. Familiarity with Airtable is a plus. This role demands a combination of technical expertise, analytical thinking, and a keen understanding of marketing dynamics to provide actionable insights that drive strategic decision-making. RESPONSIBILITIES: -Integrate data from QuickBooks, Airtable, BigQuery, and Follow Up Boss into a cohesive analytics ...

I'm in need of a skilled programmer proficient in Google BigQuery, specifically its Standard SQL version. Recently, I encountered an error while working with a partitioned table, stating: "The query cannot be executed because the table involuted-alpha-377603:cargoaim_main_db.agent_basic requires partition filter and contains unapplied upsert data that is stale based on the max_staleness setting." Here's what I'm aiming for: - *Resolve the current error*: To continue our operations without disruptions. - *Enable new data analysis capabilities*: After fixing the error, I want to explore and utilize more advanced data analysis features that BigQuery offers.

I'm in need of a skilled programmer proficient in Google BigQuery, specifically its Standard SQL version. Recently, I encountered an error while working with a partitioned table, stating: "The query cannot be executed because the table involuted-alpha-377603:cargoaim_main_db.agent_basic requires partition filter and contains unapplied upsert data that is stale based on the max_staleness setting." Here's what I'm aiming for: - **Resolve the current error**: To continue our operations without disruptions. - **Enable new data analysis capabilities**: After fixing the error, I want to explore and utilize more advanced data analysis features that BigQuery offers. **Required Skills and Experience**: - Proficiency in Google BigQuery (Standard SQL) -...

...amazing python dev to take over work on an a Python Flask container - mainly responsible for ETL and data analysis. You: - A strong developer with experience in data pipeline and data analysis work. - Expert in libraries like Pandas, NumPy, and other python data manipulation libs. - A familiarity with networking protocols such as Websockets, HTTP, and FTP. - Familiarity with Data Warehouses like BigQuery - Familiarity with Looker - Ability to support US West Coast hours Do you do your own coding, or do you coordinate development through an agency? Can you describe a recent project where you utilized Pandas and NumPy for data analysis or manipulation? What challenges did you face and how did you overcome them? Can you explain a scenario where you had to use Websockets, HTTP, o...

I'm launching an extensive project that needs a proficient expert in Google Cloud Platform (including BigQuery, GCS, Airflow/Composer), Hadoop, Java, Python, and Splunk. The selected candidate should display exemplary skills in these tools, and offer long-term support. Key Responsibilities: - Data analysis and reporting - Application development - Log monitoring and analysis Skills Requirements: - Google Cloud Platform (BigQuery, GCS, Airflow/Composer) - Hadoop - Java - Python - Splunk The data size is unknown at the moment, but proficiency in managing large datasets will be advantageous. Please place your bid taking into account all these factors. Your prior experience handling similar projects will be a plus. I look forward to working with a dedicated and know...

I'm seeking an AI expert to develop a generative AI system specifically for answering and synthesizing energy...A proficiency in AI-based synthesis • Deep understanding and experience with time-series data • Familiarity with DataWarehousing Key Responsibilities: • Design and implement a system that effectively synthesizes time-series data using generative AI • Leverage structured data from our DataWareHouse in Bigquery • Ensure synthesized data retains accurate, reliable, and relevant financial metrics Being equipped to handle and understand the complexity and nuance of Bigquery data will be instrumental for this project. As we will be working with significant amounts of structured data, having a solid foundation in working with re...

Subject/Topic: big query standard and guidelines Word Count: 10,000 words Deadline: 2 weeks Skills and Experience: - Strong research skills in the field of technology - Experience in writing research papers - Proficiency in conducting literature reviews and analyzing data - Knowledge of various research methodologies and citation styles - Attention to detail and ability to meet deadlines Project Description: I am looking for a skilled researcher with expertise in the field of technology to help me write a articles paper. The paper should have a word count of 10,000 words and should be completed within 2 weeks. Articles should not be copied from anywhere and it has to be written on own words with good examples and should have good conclusions etc The ideal candidate should have a str...

Subject/Topic: big query standard and guidelines Word Count: 10,000 words Deadline: 2 weeks Skills and Experience: - Strong research skills in the field of technology - Experience in writing research papers - Proficiency in conducting literature reviews and analyzing data - Knowledge of various research methodologies and citation styles - Attention to detail and ability to meet deadlines Project Description: I am looking for a skilled researcher with expertise in the field of technology to help me write a articles paper. The paper should have a word count of 10,000 words and should be completed within 2 weeks. Articles should not be copied from anywhere and it has to be written on own words with good examples and should have good conclusions etc The ideal candidate should have a str...

Hello, Wanting to discuss pulling data from Leaflink to BigQuery automatically.