Bigquerycông việc

I am looking for a skilled data engineer with experience in dbt, Airflow and BigQuery to help optimize and enhance my existing data model. The main goal of this project is to improve the data transformation and modeling process. Key Requirements: - Experience with dbt, Airflow and BigQuery. - Ability to optimize query performance. - Skills in integrating new data sources. - Expertise in enhancing data accuracy. Your primary task will be to: - Use dbt for data transformation and modeling. - Schedule automated data pipeline using Airflow. - Store and query data in BigQuery. The ideal candidate would be a proactive problem-solver with a strong understanding of data engineering principles and practices. If you're able to deliver high-quality work under tight deadl...

I need a strong Oracle and PLSQL developer tor the Food Services INdustry and Supply Chain Management (SCM) software. Ideal Skills: - Strongin Oracle and PLSQL - Experience with Custom Application Development Desirable Skills: - Experience with BigQuery would be desirable

I'm looking for an expert who can create a Slack chatbot that connects with Python code to fetch data from my existing Google BigQuery dataset. Key Requirements: - The chatbot should be able to fetch data from BigQuery upon command. - It should be capable of executing pre-defined queries. Ideal Skills: - Proficient in Python and Slack API - Experienced with Google BigQuery - Capable of designing user-friendly chatbots Please note: The dataset is already set up. The queries will be pre-defined, so there's no need for the chatbot to handle user-defined queries.

...Manage data migration, data warehousing, and cloud integration processes. Oversee the implementation of BigQuery, Google Cloud SQL, Apache Airflow, and Dataproc services. Ensure the development of data warehousing layers and reporting dashboards for data visualization and analytics. Coordinate cross-functional teams and manage resources to ensure timely delivery of projects. Develop project plans, manage timelines, and provide regular updates to stakeholders. Ensure adherence to cloud security best practices and regulatory compliance. Requirements: Proven experience as an IT Project Manager in multi-cloud environments. Strong understanding of Google Cloud and Azure services, especially BigQuery, Google Cloud SQL, Apache Airflow, and Dataproc. Experience in data migration, ...

I am experiencing issues with data retrieval from Google BigQuery using Pentaho Report Designer. While I have successfully connected Pentaho to BigQuery, the data retrieval process is not functioning as expected. I have verified the SQL syntax and the validity of the query in BigQuery and confirmed that the SQL is correct. - Issue: I am encountering a 404 error with the query during execution. - Resolution Needed: I need an expert who can troubleshoot these connection errors during query execution and provide a solution.

I need a skilled data professional to help me analyze structured data using Talend, Spark, and Scala. Key Responsibilities: - Utilizing Talend for data integration and tr...data professional to help me analyze structured data using Talend, Spark, and Scala. Key Responsibilities: - Utilizing Talend for data integration and transformation - Employing Spark for big data processing - Applying Scala for data analysis Ideal Skills: - Proficiency in Talend, Spark, and Scala - Experience with structured data analysis - Familiarity with data warehouses like Redshift and BigQuery - Strong analytical skills to extract insights from data This project is focused on deriving insights from structured data stored in data warehouses. Your expertise will help convert raw data into meaningful in...

I'm looking for an experienced Python developer to create a chatbot for me. The chatbot will need to: - Interact with users via a web interface - Provide text-based replies - Fetch data from Google BigQuery, specifically custom data sets The ideal candidate will have: - Extensive experience with Python and chatbot development - Familiarity with Google BigQuery - Skills in web interface design and development Please provide examples of previous chatbot projects you've worked on, particularly those that utilized Google BigQuery.

...Project Goal: Build a data extraction workflow to create a database of information from insurance documents. The workflow should handle both initial policy documents and mid-term adjustments. Minimum Requirements: Document AI: Proficiency in using Google Cloud's Document AI to extract data from PDF documents. Data Storage: Experience with storing structured data in a database (e.g., Cloud SQL, BigQuery). Data Manipulation: Familiarity with data manipulation techniques (e.g., using Python, SQL, or data transformation services) to append data to existing entries or create new rows. Workflow Automation: Understanding of how to automate workflows using Google Cloud Functions or similar tools. Data Validation: Ability to implement data validation checks to ensure data consisten...

...logging, and alerting solutions on GCP’s Operations suite - Automated Resource Deployment o Provide production-capable IaC scripts to support repeatable deployment of the GCP landing zone - Security o Provide recommended standard Organization Policy constraints - Phase 2 - Analytics Pipeline and Looker o Create pipeline to capture conversation history in Cloud Logging and BigQuery o Deliver four (4) pre-built, Looker analytics dashboards for Customer’s internal stakeholders (executive team) with visibility across the workflow. The dashboards will be created then handed over to the Customer for Customer’s use o Data and reports will be provided based on the virtual agent implemented by INI across three phases namely ...

I'm looking to develop a text-based chatbot that will interact with users on Slack, providing information from my GCP BigQuery tables. The chatbot should answer simple queries, handle complex questions with drill-down options, and present data visualizations when needed. Instead of users directly querying BigQuery, they will interact with this chatbot. Key Requirements: - Development of a text-based Slack chatbot. - Capable of simple query response and handling complex queries with drill-down options. - Able to present data visualizations. Ideal Skills: - Experience in chatbot development, particularly for Slack. - Proficiency in working with GCP BigQuery. - Skills in data visualization and making complex data understandable.

I'm looking for a skilled data analyst who can integrate data from our Warehouse Management, Sales, and Inventory systems into BigQuery. Key Responsibilities: - Data Integration: Combine data from the three specified systems into BigQuery for comprehensive analysis. - Performance Metrics Analysis: Utilize the integrated data to derive key performance metrics. The final reports generated will primarily be used by our Supply Chain team, so an understanding of supply chain dynamics will be beneficial. Ideal Skills and Experience: - Proficient in BigQuery and data integration. - Strong background in performance metrics analysis. - Familiarity with supply chain data and requirements. - Experience with warehouse management and sales system data.

I need a seasoned WebFocus Developer to facilitate a data migration from Teradata to BigQuery. Key Responsibilities: - Execute a seamless report transition from Teradata to BigQuery. - Utilize WebFocus for efficient migration processes. - Ensure report and dashboard integrity throughout the migration process. Ideal Skills and Experience: - Proficient in WebFocus, with a strong track record in data migration projects. - Extensive experience working with Teradata and BigQuery. - Excellent understanding of data integrity and quality assurance measures.

I am in need of a skilled GCP Cloud Engineer who can help manage and optimize my current GCP services. The key GCP services to focus on include Compute Engine, Cloud Storage, and BigQuery. Specific tasks for Compute Engine will encompass: - Instance management - Load balancing - Scaling and auto-scaling Ideal candidates should have solid experience with GCP, particularly with the aforementioned services. Strong knowledge of Compute Engine's instance management, load balancing, and scaling processes is crucial. Your main goal will be to ensure optimal performance and cost-efficiency of our cloud infrastructure.

I'm in need of a skilled data engineer who has good exposure to Kafka connect and its integration with Kafka (broker - schema registry) with security setup. I am doing real time data migration from Oracle -> Kafka -> BigQuery. USing No Authentication, Everything is working end to end for me (using PLAINTEXT) I am looking to advance the configuration to use SASL_PLAINTEXT or SASL_SCRAM. FYI: Using below connectors (Kafka connect) - OracleCDC Connector - BQSink Connector Evaluation Criteria (MUST) - Using SASL_PLAINTEXT/SASL_SCRAM the environment should be setup and data should sync end to end. Note: Without any security part, everything is working for me already. - Once above is done, I'll use Confluent cloud to host Broker and Schema Registry. Rest will be hosted ...

We are encountering some problems with our Power BI dashboard. The latest data we updated isn't showing up despite our best efforts to verify and ensure consistency in the formats used. Here's what you'll need for a successful project...you'll need for a successful project outcome: - Experience in troubleshooting data behavioural issues on Power BI dashboards. - Solid understanding of API Integration, as we are presently updating our data automatically. - Demonstrable skills in deciphering updates in data extraction scripts since we believe this could be a potential reason for our present struggles. - The ability to work with BigQuery and dbt, our current systems. If you're a problem-solver with skills in these areas, we'd love to talk to you about...

I'm looking for a highly-skilled data scientist or AI expert who can develop an intelligent system for my solar energy setup. The system should be capable of id...based on both historical data and real-time measurements. Key concerns: - Equipment malfunctions - Consistent underperformance - Soiling The primary objective of this project is to optimize the energy output of my solar system. Therefore, the ideal candidate for this job will have: - Extensive experience in AI and machine learning - A strong background in data analysis - Background with Google BigQuery & Looker Studio or similar - Prior experience with solar energy systems is a plus - Ability to deliver a user-friendly system Your proposal should include examples of similar projects you've completed and ...

I'm seeking a professional with at least 3-5 years of experience in Google Cloud, particularly in Google BigQuery, Google Forms, and Vertex DB. The candidate should be able to assist with a broad range of tasks in these platforms. This is a support task and you will need to be available 4 hours from mon to fri. The timings will be 10 pm to 2 am IST . The ideal candidate for this role: - Should have a minimum of 5 years of experience working with Google Cloud, especially in Google BigQuery, Google Forms, and Vertex DB - Must be adept at troubleshooting and providing effective solutions - Should be able to carry out performance optimization tasks efficiently - Should be capable of supporting migration and integration tasks - Must be proactive in identifying and resolvin...

...interface. 10. **Compliance:** - Ensure compliance with relevant local and international regulations related to cryptocurrency trading and bank transfers. ### Google Services Integration: - **Google Cloud Platform (GCP):** - Hosting and server management. - Google Cloud Storage for storing user data and documents. - Google Firebase for authentication and real-time database. - Google BigQuery for advanced data analysis and reporting. - Google Kubernetes Engine (GKE) for container orchestration if needed. ### Scalability: - Ensure the website architecture is scalable to accommodate future growth and additional features. ### Additional Information: - The website should be built using modern web development technologies. - Please provide examples of similar projects ...

I'm looking for a skilled freelancer to connect PowerBI to Google Cloud data sources and ensure daily data refreshes. Key Responsibilities: - Connect PowerBI to Google Cloud Platform - Set up daily data refresh in PowerBI Ideal Skills and Experience: - Proficient in PowerBI - Experience with Google Cloud platform, Google Sheets, Google Analytics & Google BigQuery - Skilled in data integration and working with APIs - Prior experience in setting up scheduled data refreshes This project will involve close communication with me to ensure the successful integration of vital data sources and their consistent updates on a daily basis.

I need a skilled developer to connect my Salesforce and API data with Google BigQuery. Specifically, the focus is on 'Leads' and 'Opportunities' from Salesforce, along with 'Medical record data MRN system' from the Lightning Step API. This project demands a thorough understanding of working with APIs, Salesforce, and Google BigQuery. Furthermore, because I plan to utilize Looker for reporting, proficiency with this platform is key. The final deliverable I'm looking for is a robust and efficient data schema in Google BigQuery, which enables easy report generation in Looker. Key skills and experience: - Expertise in Salesforce - Experience with Google BigQuery - Proficiency in using APIs - Understanding of data schemas - Pr...

...experienced professional to assist with various tasks in Google Cloud, specifically Google BigQuery, Google Forms, and Vertex DB. The ideal candidate should have over 5 years of experience in the field. Key Responsibilities: - Data Analysis and Querying: Your primary task will be to perform robust data analysis and querying, potentially identifying patterns and trends to help improve business operations. - Form Creation and Integration: You will also be responsible for creating and integrating Google Forms as required. - Database Management and Optimization: Lastly, you should be adept at managing and optimizing Vertex DB. Skills and Experience: - Over 5 years of hands-on experience with Google Cloud, Google BigQuery, Google Forms, and Vertex DB. - Expertise in data anal...

I need an experienced PHP developer to help fix a specific bug in CSV parsing functionality. Creating synthetic data is a process used to balance an ML/AI model for a specific purpose. Thi...can be produced in various ways. Even though the synthetic data represents genuine scenarios, there are multiple methods to create these datasets. This flexibility allows for the generation of numerous true variants of data batches, each suitable for different aspects of model training and validation. - CSV Parsing: - I need some help un Bigquery integration CSV parsing functionality. The data that needs to be parsed is in CSV format. we use Bigquery for log data analisys . The freelancer should be proficient in php data parsing and have experience in handling such data for machine l...

...over 6 years of experience in BigQuery, GCP and SQL. The ideal candidate must be able to work onsite full-time. Key Objectives: - Data Analysis & Reporting: You will be responsible for analyzing and reporting on our data, providing insights and actionable information for the business. - Data Integration & Transformation: Your role will involve integrating and transforming data from various sources, ensuring a smooth flow and consistency in data usage. - Database Optimization & Performance Tuning: You will also be responsible for optimizing our databases, ensuring they perform efficiently and meet the necessary performance standards. Duration: This is a full-time onsite permanent role. ONSITE IS A MUST. Ideal Qualifications: - 6+ years of experience in BigQuery...

I need something built to emulate the YouTube home feed. I'd like it built on the Google Cloud Platform. I'd like control over the model and to be able to provide it with content that influences my recommendations. There may be YouTube data available on BigQuery or something similar, or you may need to crawl YouTube. If we need to crawl YouTube, you should use whatever tools are available in the cloud to minimize the effort required. If YouTube uses open models for it's home feed, we should use the same. I'm looking for your expertise on the details. Thank you.

The objective of this project is to set up a Kafka ecosystem on Google Kubernetes Engine (GKE) to facilitate Change Data Capture (CDC) from MySQL and PostgreSQL databases. The captured data will be pushed to Kafka topics, and from there, it will be ingested into Google BigQuery for analytics and reporting purposes. Components Kafka: A distributed streaming platform for building real-time data pipelines and streaming applications. Kafka Connect: A tool for scalably and reliably streaming data between Apache Kafka and other systems. Debezium: A CDC tool that captures row-level changes in databases and streams them to Kafka topics. GKE: Google Kubernetes Engine, a managed Kubernetes service that simplifies deploying, managing, and scaling containerized applications. Setup Steps 1. Cre...

I need an ETL developer who is well versed in Google Cloud Platform. This individual should have: Skills & Experience: - Extensive experience in BigQuery. - Proven expertise in Dataflow. - Familiarity with Cloud Storage. Project Details: - The project involves processing data, approximately less than 1 GB. - The task will involve both data transfer and transformation. The right candidate should highlight their prior experience handling equivalent tasks. Fluent Spanish will be a bonus, as it is the preferred language for this project.

...summarize the unstructured fields for the returned speakers and answer questions based on information given in the unstructured fields. We would like to test the bot in a local environment (like just a jupyter notebook or a streamlit application), but it should be possible to transfer the bot to a web-based interface. Possible technologies/framework could be: - OpenAI API - Google Cloud Platform / BigQuery / Vertex AI - ElasticSearch - langchain If you know another tech stack that can solve this problem you can use it as well, of course! When you apply to this job, briefly outline what tech stack you would use and why and give us a short summary of existing projects you worked on that might be relevant or similar to this project...

I need a seasoned data engineer who is proficient in Google Cloud Platform's suite of tools, encompassing BigQuery, Dataproc, Composer, Pubsub, Dataflow, GCS, and BigTable. Key Requirements: - You should have extensive experience in implementing data ingestion and processing pipelines with the Google Cloud Platform tools. - A strong understanding of data modeling, transformation, and database design is essential. - Experience with GCP's various storage solutions like GCS and BigTable. The ideal candidate should be able to work independently and proactively to help optimize our data processing and storage systems, making them more efficient and scalable. The goal is to improve our overall data management and processing capabilities. If you're skilled in these areas...

I'm looking for a skilled SQL develo...developer with specific experience in converting data from Shopify's API to Google Cloud Storage (GCS) for querying in BigQuery. Key requirements include: - Converting Shopify's API data to BigQuery. - Extracting following data: 1. Daily orders, revenue, and discounts. 2. SKU-wise sales, revenue, inventory, and Days on Hand (DOH). Additional details: - Data has already been imported to GCS. - The final reports should be formatted in BigQuery tables. - The goal is to analyze both historical and ongoing/new data. Ideal candidates for this project would have: - Profound expertise in SQL. - Prior experience with Shopify's API. - Proven track record of working with BigQuery. - Understand the ret...

...to filter and export data by polygon, zip code, city, etc. This project is for development only; no ongoing maintenance required. Business Context: We work with construction companies targeting storm-damaged areas. We need the ability to draw polygons to pull data from specific storm paths, ensuring we can efficiently target affected areas. Requirements: Proven experience with Google Cloud, BigQuery, Google Maps API, or similar tools. Ability to handle and process large datasets efficiently. Strong skills in SQL and geospatial functions. Experience in developing web applications with data visualization capabilities. Additional Information: We have the data ready and just need help creating a management tool. ******************************* I'm looking for a skilled devel...

Tengo una base de datos en BigQuery donde importo datos de ventas periódicamente. Necesito que los datos estén bien conectados con Looker Studio y reflejen la información más reciente con precisión. Requisitos clave: La base de datos en cuestión importa datos de ventas periódicamente. Los datos deben integrarse en tiempo real con Looker Studio. El Freelancer Ideal: Competente en la gestión e integración de datos desde BigQuery. Experimentado en configurar la integración de datos en tiempo real con Looker Studio. Hábil en mantener la precisión de los datos y asegurarse de que se reflejen correctamente en Looker Studio.

...settings to point to our server. Looker Studio Setup: Task: Set up Looker Studio for data visualization. Details: Sign up for Looker Studio (free for creators and viewers), configure connections to our database where Excel data will be stored, set up user roles, and permissions. Database Configuration: Task: Configure a database to store imported Excel data. Details: Choose a database (e.g., Google BigQuery, PostgreSQL), create schema/table structures, ensure the database is accessible to Looker Studio, and set up necessary permissions. OpenAI API Key: Task: Obtain an API key for GPT integration. Details: Sign up for an API key on the OpenAI website and keep it secure for use in our scripts. Development Environment Setup: Task: Set up a Python development environment. Details...

Presupuesto 25dolares hacer mejoras en un tablero de base de datos hecho en bigquery Estimado Enderson, revisando el tablero confeccionado tengo algunos comentarios: Hoja “Resultados Acumulados 2024”: Respecto al indicador “Cantidad de pedidos” el primero debe ser el total y el segundo deben ser SOLO los pedidos de fulfillment, en este momento el total está dos veces. El Precio Promedio está arrojando un numero extraño, si te fijas es mayor a la venta y eso no debiese ser ya que debiese mostrar la VENTA promedio de cada pedido (es decir Venta dividido por Cantidad de Pedidos y otro que sería la Venta promedio por unidad vendida, es decir Venta Dividido por cantidad. En El Gráfico de Evolutivo de Ventas vs años a...

Presupuesto 25dolares hacer mejoras en un tablero de base de datos hecho en bigquery Estimado Enderson, revisando el tablero confeccionado tengo algunos comentarios: Hoja “Resultados Acumulados 2024”: Respecto al indicador “Cantidad de pedidos” el primero debe ser el total y el segundo deben ser SOLO los pedidos de fulfillment, en este momento el total está dos veces. El Precio Promedio está arrojando un numero extraño, si te fijas es mayor a la venta y eso no debiese ser ya que debiese mostrar la VENTA promedio de cada pedido (es decir Venta dividido por Cantidad de Pedidos y otro que sería la Venta promedio por unidad vendida, es decir Venta Dividido por cantidad. En El Gráfico de Evolutivo de Ventas vs años a...

Presupuesto 25dolares hacer mejoras en un tablero de base de datos hecho en bigquery Estimado Enderson, revisando el tablero confeccionado tengo algunos comentarios: Hoja “Resultados Acumulados 2024”: Respecto al indicador “Cantidad de pedidos” el primero debe ser el total y el segundo deben ser SOLO los pedidos de fulfillment, en este momento el total está dos veces. El Precio Promedio está arrojando un numero extraño, si te fijas es mayor a la venta y eso no debiese ser ya que debiese mostrar la VENTA promedio de cada pedido (es decir Venta dividido por Cantidad de Pedidos y otro que sería la Venta promedio por unidad vendida, es decir Venta Dividido por cantidad. En El Gráfico de Evolutivo de Ventas vs años a...

Presupuesto 25dolares hacer mejoras en un tablero de base de datos hecho en bigquery Estimado Enderson, revisando el tablero confeccionado tengo algunos comentarios: Hoja “Resultados Acumulados 2024”: Respecto al indicador “Cantidad de pedidos” el primero debe ser el total y el segundo deben ser SOLO los pedidos de fulfillment, en este momento el total está dos veces. El Precio Promedio está arrojando un numero extraño, si te fijas es mayor a la venta y eso no debiese ser ya que debiese mostrar la VENTA promedio de cada pedido (es decir Venta dividido por Cantidad de Pedidos y otro que sería la Venta promedio por unidad vendida, es decir Venta Dividido por cantidad. En El Gráfico de Evolutivo de Ventas vs años a...

Presupuesto 35 dolares hacer mejoras en un tablero de base de datos hecho en bigquery Perfecto, sería entonces: 1) Dejar configurado el nuevo tablero de Looker con los indicadores a detallar (Te enviaré un correo con ese detalle). 2) Permitir que el nuevo tablero se pueda compartir a usuarios externos con acceso filtrado. Idealmente que estos tableros se puedan configurar (ante futuros cambios) para controlarlos de forma centralizada 3) Ver si podemos agregar para la sheet importadora de Datos a Bigquery algún método para evitar poblar de forma duplicada la base de datos (ejemplo considerar un campo llave que no se pueda repetir). Cuéntame como lo ves.

Presupuesto 35 dolares hacer mejoras en un tablero de base de datos hecho en bigquery Perfecto, sería entonces: 1) Dejar configurado el nuevo tablero de Looker con los indicadores a detallar (Te enviaré un correo con ese detalle). 2) Permitir que el nuevo tablero se pueda compartir a usuarios externos con acceso filtrado. Idealmente que estos tableros se puedan configurar (ante futuros cambios) para controlarlos de forma centralizada 3) Ver si podemos agregar para la sheet importadora de Datos a Bigquery algún método para evitar poblar de forma duplicada la base de datos (ejemplo considerar un campo llave que no se pueda repetir). Cuéntame como lo ves.

We have a bigquery database connected to Grafana already and some metrics we want to track. But we want someone who's experienced in creating sales dashboards to create a grafana board for our team to optimise. Strong SQL experience is required and sales experience is desired. Add 888mm to your proposal and why your sales experience gives you a good understanding of what's required (perhaps some examples of important metrics that should be on a sales dashboard?). Thanks!

Presupuesto 35 dolares hacer mejoras en un tablero de base de datos hecho en bigquery Perfecto, sería entonces: 1) Dejar configurado el nuevo tablero de Looker con los indicadores a detallar (Te enviaré un correo con ese detalle). 2) Permitir que el nuevo tablero se pueda compartir a usuarios externos con acceso filtrado. Idealmente que estos tableros se puedan configurar (ante futuros cambios) para controlarlos de forma centralizada 3) Ver si podemos agregar para la sheet importadora de Datos a Bigquery algún método para evitar poblar de forma duplicada la base de datos (ejemplo considerar un campo llave que no se pueda repetir). Cuéntame como lo ves.

Presupuesto 35 dolares hacer mejoras en un tablero de base de datos hecho en bigquery Perfecto, sería entonces: 1) Dejar configurado el nuevo tablero de Looker con los indicadores a detallar (Te enviaré un correo con ese detalle). 2) Permitir que el nuevo tablero se pueda compartir a usuarios externos con acceso filtrado. Idealmente que estos tableros se puedan configurar (ante futuros cambios) para controlarlos de forma centralizada 3) Ver si podemos agregar para la sheet importadora de Datos a Bigquery algún método para evitar poblar de forma duplicada la base de datos (ejemplo considerar un campo llave que no se pueda repetir). Cuéntame como lo ves.

Presupuesto 35 dolares hacer mejoras en un tablero de base de datos hecho en bigquery Perfecto, sería entonces: 1) Dejar configurado el nuevo tablero de Looker con los indicadores a detallar (Te enviaré un correo con ese detalle). 2) Permitir que el nuevo tablero se pueda compartir a usuarios externos con acceso filtrado. Idealmente que estos tableros se puedan configurar (ante futuros cambios) para controlarlos de forma centralizada 3) Ver si podemos agregar para la sheet importadora de Datos a Bigquery algún método para evitar poblar de forma duplicada la base de datos (ejemplo considerar un campo llave que no se pueda repetir). Cuéntame como lo ves.

Need assistance with Dataform documentation to orchestrate SQL workflows in Google Bigquery

...source to Google's BigQuery utilizing KafkaConnect. I need to use connectors (Kafka connect) - OracleCDC Connector - BQSink Connector Evaluation Criteria (MUST) - BigQuery: Upsert and Auto-table creation - Kafka Topic: Avro for schema registry and Auto-Topic creation Note: My Environment is already setup. (Zookeeper, Broker, Connect including the connectors, Control center, SchemaRegistry, ORacle, GCP) Key Responsibilities: - Implementing a robust data pipeline using KafkaConnect. - Ensuring real-time data migration from Oracle to GCP BigQuery. - Troubleshooting and resolving any issues that may arise during migration. Ideal skills for this project: - Proficiency with KafkaConnect and Oracle databases. - Proven expertise in Google Cloud Platform, specific...

...to be transferred to BigQuery to enhance efficiency and optimization of data processing. The current Google Sheets are becoming slow and unresponsive. The result of the processing needs to be transferred back to Google Sheets. You can see the sheets and calculations here, this folder contain dummy data: Deliverable: A system that: 1. Imports all 7 Google Sheets in the Import folder to BigQuery at scheduled intervals 2. Uses BigQuery to perform the calculations that are in the Export 1 and Export 2 Sheets. 3. Exports the results from the calculations above as values back into two Google Sheets. Ideal skills and experience include: -Excellent command over Google Sheets and BigQuery -Experience in migrating

Мы - продуктовая компания. Решаем сложные задачи в области веб-разработки ПО для автоматизации бизнес-процессов. В связи с расширением команды, ищем Senior Backend Developer (PHP), готового к работе удаленно на Full-time. Мы занимаемся увлекательной и нестандартной работой с Database storage, такими как Google Cloud Spanner, Google Cloud BigQuery, Amazon Aurora, а также с несколькими десятками Enterprise Service, такими как Pusher, LaClase и многими другими. Твоя роль Разработка веб-приложений, систем CRM и ERP с использованием PHP фреймворков в соответствии с техническим заданием Проектирование, кодирование и тестирование ПО Участие в командных мероприятиях и аудите архитектурных решений Участие в командных мероприятиях для сбора требований и технической экспертизы. Технолог...

Seeking a skilled and experienced Data Analyst to sift through unspecified data sources. As the data type, desired insights, and current storage system have not been specified, I am looking for someone highly flexible and adept at handling all types of data, formats, and analysis needs. Ideal Skills and Experience: * Proficiency with Excel, database, BigQuery, JSON, and CSV file formats * Experience working with sales data, financial data, and customer data * Ability to identify sales trends, perform customer segmentation, and analyze profitability Please note that the specifics will be provided upon project commencement. We look forward to hearing from data analysts who can adapt to different data types and uncover valuable insights.

Google big query - for writing sql queries for the complex data

...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 ...