Extract Transform And Load Etl Projects
Looking for freelance Extract Transform And Load Etl jobs and project work? PeoplePerHour has you covered.
Power BI Developer
Key Responsibilities: Develop functional & operational reports & dashboards. Build automated reports and dashboards with the help of Power BI and other reporting tools. Understand business requirements to set functional specifications for reporting applications. Be experienced in tools and systems on MS SQL Server BI Stack, including SSRS and TSQL, Power Query, MDX, Power BI, and DAX Be able to quickly shape data into meaningful reports and analytics solutions. Have knowledge of database fundamentals such as multidimensional database design, relational database design, and more. Analyse data sources and ensure data quality and integrity. Design and develop efficient data models in Power BI, ensuring optimal performance and scalability. Transform raw data into meaningful insights by implementing appropriate data transformations. Develop visually appealing and user-friendly dashboards, reports, and interactive visualizations in Power BI. Implement complex calculations and custom measures to meet business requirements. Leverage DAX (Data Analysis Expressions) to create advanced calculations. Integrate data from various sources into Power BI, ensuring seamless connectivity and data refresh. Utilize Power Query to clean, transform, and shape data for reporting purposes. Collaborate with cross-functional teams, including business analysts, data engineers, and IT teams, to ensure alignment with overall business goals. Conduct regular stakeholder meetings to gather feedback and make necessary adjustments to BI solutions. Provide training and documentation for end-users to ensure effective use of Power BI reports and dashboards. Monitor and optimize the performance of Power BI reports and dashboards. Ability of learning new tools to enhance the data quality and visualizations. Qualifications and Skills: Bachelor’s degree in computer science, Information Systems, or a related field. Proven experience as a Power BI Developer or similar role. Strong knowledge on Azure Data Lake, Data Factory and other data services Strong proficiency in Power BI, including data modelling, DAX, and Power Query. Solid understanding of relational databases and SQL. Experience in ETL processes and data integration. Excellent analytical and problem-solving skills. Strong communication and collaboration skills. Ability to work independently and as part of a team. Preferred Qualifications: Microsoft Power BI certification. Experience with other BI tools (Tableau, QlikView, etc.). Knowledge of data warehousing concepts. Familiarity with cloud platforms (Azure, AWS) for BI solutions.
10 days ago19 proposalsRemote
Past "Extract-transform-and-load-etl" Projects
Python ETL Expert Needed for Data Transformation Project
Hello We're looking for a skilled Python ETL expert to assist us with a data transformation project. Our goal is to extract, transform, and load data from various sources into a structured format for analysis. We need someone with experience in automating ETL pipelines, handling data quality issues, and ensuring seamless integration. Key Responsibilities: Retrieve data from all sorts of places – databases, APIs, and flat files. Work on raw data, making it clean, consistent, and accurate. Handle missing values, normalize data, and some feature engineering. Load the transformed data where it belongs, ensuring it gets along with our storage solution. Test and validate, ensuring our data stays true to its transformed self. Proven experience in Python development with a focus on ETL processes Strong understanding of data extraction, transformation, and loading best practices. Previous success in automating ETL pipelines for efficient data processing. Excellent problem-solving skills and attention to detail. Python Expertise: Proven experience in Python development with a focus on ETL processes. A deep understanding of data extraction, transformation, and loading best practices. A track record of successfully automating ETL pipelines for efficient data processing. Excellent problem-solving skills and meticulous attention to detail. Delivarbles: structured and organized CSV files, each containing accurately transformed, structured data. An automated and efficient ETL pipeline that can be easily maintained. Regular updates on project progress, ensuring we're always on the same page. If you're a Python ETL expert looking for an engaging project, we'd love to hear from you! Please send a propsal detailing your relevant experience, a brief overview of your approach to ETL projects, and any examples of past work.
I need an excel document collated- 2/3 hour turnaround
I require assistance collating data from multiple Excel worksheets into a single master file for reporting purposes. There are 9 separate but similarly formatted source files, each containing basic data that needs extracting and compiling into one cohesive document. The source files contain nominal information organized across several columns which must be extracted row-by-row and copied verbatim into the target document. Structural formatting such as column headers and row ordering should be preserved to maintain data integrity. Textual content need not be altered or summarized during transferral. Due to pressing reporting deadlines, swift completion within a timeframe of 2-3 hours is imperative. Based on preliminary assessments, the work involved should require no more than 30 minutes for an experienced operator to complete. The task does not entail complex manipulations or transformations and is of a elementary extracts-and-pastes nature. Familiarity with Excel is a prerequisite and the ability to meticulously consolidate information from multiple sheets into one centralized record in a short turnaround while ensuring accuracy will be valued. Responsiveness is also important as I need the compiled data without delay. Interested professionals with openings within the stipulated timeframe are encouraged to submit proposals.
pre-funded
2 wordcloud infographics created for powerpoint slides
I require the creation of two word clouds to enhance the information design of two PowerPoint slides. The source material for the word clouds has been provided as attachments to the slides, with lists of terms for each that need to be artfully arranged at multiple hierarchical levels both horizontally and vertically. A predefined color palette situated within the slide decks should be followed to establish stylistic coherence across the visual elements. As non-conforming word placement is permitted, creative liberty can be taken to craft aesthetically pleasing compositions that effectively showcase the terms. While the source material provides a starting point, expert manipulation of size, directionality and proximity of the words may yield more impactful representations of the underlying data. The deliverables should be integrated directly into the supplied PowerPoint files to showcase how extracted key points from the source material can be transformed into engaging infographics. Skillful word cloud generation following Best practices in information design within the given timeframe will help communicate complex topics simply and memorably.
Application Development Architect for 2 page technical writeup
We're looking for a skilled Technical or Solution Architect to create a 2 page solution design document. Yes exactly 2 pages! Your task will involve designing a solution to integrate EPC Open Source data with our business website, focusing on extracting and displaying Energy Performance Certificate (EPC) ratings for UK properties. You'll draft a comprehensive technical document detailing the process flow, API integration, data fetching, and presentation. Experience with RESTful APIs, data parsing, and security measures is essential. If you're adept at creating scalable, efficient solutions and can transform complex requirements into actionable plans, we'd love to hear from you. The EPC data is available via OpenSource - https://epc.opendatacommunities.org/docs/api/domestic . I need it done urgently so please apply if you have good ENGLISH written and oral skills ( for meetings with me). No Chat Gpt relies.
opportunity
Electrical systems designer
Hello, I am looking to work with someone who can design the electrical system for a web take-up and vacuum conveyor system. Currently, each product line and the waste web comes off the printer and falls into a tray for the operator to sort into bags. The end goal of this project is to automate the whole process. What does this look like. Automating the process involves an operator loading the material roll onto the machine, feeding the roll onto the bed and the take-up, and letting the machine do the rest. The web will travel along the cutting belt, onto the vacuum conveyor, the waste material is then extracted onto a take-up and the finished stickers travel down the vacuum conveyor to a bagging station. The initial take-up design consists of the web feeding through a load cell and onto the take-up mandrel fixed to a motor. I require someone who can produce an electrical load list, cable sizing, breaker sizing and finally, produce a wiring diagram for all the components. I will attach a few images below to give you an idea of the work involved, however, I would be happy to talk you through a 3d model, and all the documents we have. Thank you
Graphic Assets for Branding
I have a load of brand assets that have been, and I need some of the elements extracting, and placing in separate file of their own, so that I have additional brand graphics that I can use. - Circle on its own - Brand pattern outlined instead of block colour - Shapes from the icons just on their own, not in an icon - Avatar 300x300 - Anymore graphics you can extract that would be good - All the above need to be shared as jpg, png, ai and SVG and this folder needs to be called "web" - I need another folder for each element called "print" and need to have .ai, .eps and PDF version for each too. - Each graphic should be in its own folder labelled > Print/web > then individual file Will share full design folder with all files, to successful candidate. Must be completed within 24hrs.
opportunity
Electrical systems designer and control engineer
Hello, We're looking to work with someone to help design and program a waste web take-up system as well as program a vacuum conveyor to move in sync with our flatbed cutter. The skills required would be in electrical design and control systems programming. Currently, each product line and the waste web comes off the printer and falls into a tray for the operator to sort into bags. The end goal of this project is to automate the whole process. What does this look like. Automating the process involves an operator loading the material roll onto the machine, feeding the roll onto the bed and the take-up, and letting the machine do the rest. The web will travel along the cutting belt, onto the vacuum conveyor, the waste material is then extracted onto a take-up and the finished stickers travel down the vacuum conveyor to a bagging station. The initial take-up design consists of the web feeding through a load cell and onto the take-up mandrel fixed to a motor. I see this project being broken into 3 phases. Phase 1 Electrical load list Wiring diagram Cable sizing Breaker sizing Phase 2 Software simulations. Phase 3 Programming. This is only phase 1 of a long project. We would ideally like to find someone that we can work with in years to come. I'll attach photos and a video below of our current system, as well as a preliminary design for a new system. More images are available. Thank you
AI/ML Engineer
Job Description: AI/ML Engineer Join the NextSapien Team: NextSapien is at the forefront of technological innovation, where AI and computer vision are not just theories but essential tools transforming the tech landscape. We are on a mission to push the boundaries of AI and machine learning, and we need like-minded individuals to join our journey. Task Overview: This assignment will involve developing an innovative auto-swiping feature for online platforms like Tinder.com, using tools akin to Selenium. This is a chance to apply your technical expertise in a real-world scenario and make a tangible impact. Your Journey with NextSapien: Your journey will be divided into three exciting milestones: Initial Assignment (Unpaid, < 3 hours): Develop a Python script using Selenium or a similar automation tool to facilitate automated interactions with Tinder.com. This script will serve as the foundation for more advanced features in subsequent milestones. Ensure robust error handling for common issues such as element loading delays or changes in the website's layout. Write clean, well-documented code following best practices. The script should prompt the user for credentials and perform tasks as specified. Developing the Auto-Swiping Feature (Compensated, 20-30 hours): For this task, a Python script and user preferences JSON will be provided once you complete the first milestone. The Python script can correctly predict personal attributes from images. Your task will be to Integrate this script with your Selenium tool to automate swiping on Tinder.com based on user preferences. Here are a few resources that you can take reference from Tinder-Swiper-AI TinderBotz Auto Swiper Extension Enhancing the scripts (Compensated, 40-50 hours): Further, enhance the scripts to automate account creation and user preference-based swiping on Tinder.com. More details about this task will be disclosed once you complete the above milestones. Securing Your Position: Completing these tasks with precision will lead to a formal offer to join NextSapien as a full-time AI/ML Engineer. This role involves ongoing collaboration, integration of third-party models, and continuous learning in the field of AI and computer vision. Ongoing Duties: Collaborate on integrating third-party models and libraries. Elevate script precision and processing speed. Stay abreast of the latest computer vision and AI breakthroughs. Enrich our team's knowledge base and operational practices. Candidate Profile: A strong foundation in AI, computer vision, and machine learning. Proficiency in Python, Selenium, TensorFlow, and related technologies. Deep understanding of neural networks, deep learning, and evaluation techniques. Independent work ethic with effective team collaboration skills. Exceptional problem-solving ability and a commitment to lifelong learning. NextSapien awaits your expertise. Step into a future where your work propels the boundaries of AI and transforms the technological landscape. Apply today!
Structural analysis and Design of RCC and Steel structura
I'm seeking a skilled professional who can deliver comprehensive structural drawings and calculations for an industrial facility project. Given the complexity and scale of this project, precision and expertise are paramount. Below are my specific requirements and preferences: - **Software Preference**: The structural calculations should be done using STAAD. I have a particular interest in how this software handles calculations for industrial facilities. Therefore, familiarity and expertise with STAAD are crucial. Additionally, the provision of the STAAD file post-calculation is required to review the calculations done. - **Architectural Drawings**: I have the architectural drawings for the industrial facility, which will be provided. The freelancer should be able to interpret these drawings accurately to create detailed structural designs and perform quantity take-offs efficiently. - **Project Scale and Details**: - The project is for an industrial facility, which means the structures will be subject to various loads and stresses. - The creation of AutoCAD structural drawings focusing on both Reinforced Cement Concrete (RCC) and Steel structures. - Bar Bending Schedule (BBS) and quantity take-off of materials are essential. These should be accurate to ensure cost-effectiveness and proper planning. - Steel sections need to be precisely chosen and detailed in the drawings. - All calculations must adhere to BS codes, a critical requirement for this project. This not only assures compliance but also ensures international structural integrity and safety standards. **Ideal Skills and Experience**: - Profound knowledge in structural engineering with a strong portfolio in industrial projects. - Advanced proficiency in AutoCAD and STAAD for structural calculations and drawing creation. - Experience in working with BS codes for structural calculations and designs. - Capability to interpret architectural drawings accurately and transform them into detailed structural plans. - Excellent attention to detail, ensuring all aspects of the steel and RCC designs are covered. This project is a significant step towards the completion of an industrial facility designed to meet high operational
opportunity
CSS and Mobile App Development
Project Overview: We are seeking a highly skilled freelancer with expertise in web design and mobile app development to revamp our existing website and create a companion mobile app for both iOS and Android platforms. Our website is fully functional and serves the transportation industry, but it needs a modern makeover to improve user experience and aesthetic appeal. In addition to the redesign, we aim to extend our digital presence through a mobile application that mirrors some of the functionality and content of our website, optimized for mobile users. Key Responsibilities: Website Redesign: Evaluate the current website design and propose a comprehensive redesign plan that enhances visual appeal, user engagement, and accessibility. Implement the redesign without disrupting the existing website functionalities. Ensure the new design is responsive and optimized for various devices and screen sizes. Improve navigation, loading speed, and SEO performance. Mobile App Development: Develop a mobile application for iOS and Android platforms that integrates seamlessly with our website's backend. Ensure the app replicates the website's functionality and content while offering a smooth, native mobile user experience. Implement features such as push notifications, user accounts, and any device-specific capabilities. Test the app for bugs, usability, and performance issues on various devices and OS versions. Assist with the app's deployment to the App Store and Google Play, including meeting all requirements and guidelines. Skills and Qualifications: Proven experience in web design and mobile app development, with a portfolio of previous projects. Expertise in UI/UX design principles, especially for mobile platforms. Strong knowledge of HTML, CSS, JavaScript, and responsive design techniques for web projects. Proficiency in iOS and Android development environments, including Xcode, Swift, Android Studio, and Kotlin/Java. Familiarity with integrating web services and APIs for backend communication. Excellent problem-solving skills and attention to detail. Strong communication and project management abilities to meet deadlines and deliverables. Project Timeline: The project is expected to start as soon as the right candidate is found, with a tentative completion timeline of 60 days. Please provide an estimated timeline and quote based on the project description. Application Process: Interested candidates are invited to submit a proposal that includes: A brief introduction and why you are a good fit for this project. Your portfolio showcasing relevant web and mobile app projects. An estimated timeline and budget breakdown. Any questions or clarifications you may need about the project. We are looking forward to transforming our digital presence with your expertise. Thank you for considering this opportunity.
Website Audit to improve Conversion Rates for B2B SaaS company
Job Description: - We seek a detail-oriented freelancer to conduct a comprehensive audit of a client's website and landing pages. The objective is to pinpoint opportunities for enhancing conversion rates and elevating the overall user experience. Key Responsibilities: - In-depth Website and Landing Page Analysis: Examine the website's structure, design, and content. Assess user flow and the effectiveness of the layout in guiding visitors towards conversion. - Page Load Speed Assessment: Utilize Google PageSpeed Insights and other tools to analyze page loading times and recommend optimizations. - Adherence to Best Practices: Ensure landing pages follow best practices, including clear and compelling CTAs, trust elements (like reviews/testimonials), and consistent branding. - Conversion Pathways Evaluation: Analyze the paths users take to convert and identify any friction points or areas for improvement. - Mobile Optimization Check: Ensure the website and landing pages are fully optimized for mobile users, considering layout, navigation, and load times. - Competitor Analysis: Conduct a thorough review of competitor websites and landing pages, extracting successful strategies and potential areas for differentiation. - User Experience (UX) Assessment: Evaluate the overall UX, focusing on ease of navigation, clarity of information, and call-to-action effectiveness. - Lead Generation Elements Review: Examine lead capture forms and other lead generation elements for optimization opportunities. - Detailed Reporting: Compile a comprehensive report with findings, including actionable recommendations for performance enhancement. Skills and Qualifications: - Extensive experience in website analysis, focusing on CRO. - Proficiency with Google PageSpeed Insights and other CRO tools. - Strong understanding of UX principles and how they relate to CRO. - Ability to perform thorough competitor analysis and derive strategic insights. - Exceptional analytical and report-writing skills. Project Details: - This is something we do very often for our clients so this has the potential to turn into a long term gig. Application Process: - Interested candidates are requested to submit a portfolio demonstrating relevant experience, along with a brief strategy outline for this project.
opportunity
New upcoming aspiring video editor wanted
THIS ADD IS FOR PEOPLE NEW TO WORK & NEW TO FREELANCING I want to give someone a chance, someone who is struggling to find work. WHY? I need a video editor, I don't need someone who is 20 years time served in video editing, i cant really afford it. So I see it as a fair exchange. I work with someone for a good price, who wants to practise their skills of video editing, get a job, get paid on a lot of projects, and in return, they get experience and a shot at making a loads of content for their portfolio. Ive been a freelancer in the past and I know how hard it is. so im trying to approach this from a different point of view. Most our calls are zoom based, about 3 hours a month. from that, Im wanting to extract 1-10 minute videos, circa 10-15 a month. I wont go into it in more detail than that. I think its enough to either interest you or not. You ABSOLUTELY need video editing experience. please begin your proposal with your favourite type of food in the first line (so that I can tell you actually read this post) and proposals without this will just be deleted. then let me know what exp you have in video editing, why you like it. i dont mind if you use AI to help to sift through the vids, you can use whatever tools you want its 2024, the world has changed a lot and I Know video editing has got easier but ultimately its a human who is doing the final editing COMMUNICATION is important, you need to have good SPOKEN and LISTENING english please as we will speak on calls every month. The budget I have provided is to cover 2 months as a trial. The sort of community we have that the videos are about is Financial Sovereinty You can see us here https://www.sovereignsoul.network/ ideally you will find it more enjoyable if you like the look and feel of what we do. Thanks D
opportunity
Experienced eBook Formatter and Designer Needed for Hiking Guide
I am seeking a talented eBook formatter and designer to bring a visual edge to a comprehensive hiking guide. This project requires someone with a keen eye for design, proficiency in eBook formatting, and the ability to incorporate photos, links and elements that resonate with the adventure and hiking community. About the Book: • Title: Pack like a pro • Genre: Non-fiction / Hiking & Adventure Travel • Length: 38,000 words • Audience: Hikers, adventurers, and outdoor enthusiasts – from beginners to experienced trekkers • Topic – it gives a list of all the gear items needed for a multiday hike, like Everest Base Camp, or climbing Kilimanjaro. It also gives advice of when to buy how to maintain the gear, and loads of other interesting stuff related to gear. It’s based on experience that the author has gained through years of climbing mountains. Requirements: • Experience: Proven track record in ebook design and formatting, preferably in travel, outdoor, or adventure genres. • Portfolio: A portfolio showcasing previous work, especially with similar content. • Software Proficiency: Must be adept with ebook formatting and design software, ideally inDesign (unless you recommend other?) • Communication: Open to collaboration and regular updates. • Timeline: • First sample to ensure right theme is selected – 18th Feb • Project completion by 1st March. What You’ll Do: • Formatting: Ensure the ebook is perfectly formatted for various digital platforms; divices (phones, tables, laptops, computers) and different operating systems (MacOS, Microsoft, ChromOS, Linux etc) • Design: Enhance the visual appeal of the ebook - transform the manuscript into a visually stunning ebook that is easy to navigate and read. • Photo Integration: Incorporate and arrange photos in a way that complements and elevates the text. A bunch of images will be provided, you’ll need to choose those most suitable, plus some must be downloaded online (e.g. a link to a gear item will be provided and you’ll need to copy that image from there to visually show what an item really is because some items may not be obvious for unexperienced hiker) • Integrating links: Each item of gear will have 3 links provided (some may have <3 but majority will have 3) – these will need to be integrated into the ebook, • Layout: Create an engaging and reader-friendly layout that reflects the book’s adventurous spirit. • Table of content must be functional • First sample expected by 18th February, to ensure the theme of the ebook is what the author expects • Ensure the final product is compatible with major ebook platforms. • Ensure the final format is delivered together with row file that can be easily edited by the author at a later day – inDesign file Application: Interested candidates, please submit the following: 1) a portfolio of your previous work. Highlight any experience with outdoor or adventure-themed content. I need to see more than just a cover of an ebook you’ve done, need to see some inside content too. 2) A sample page you would do for a hiking boots – put 200 random words and 3 random (but operational) links. It can be gibberish (i.e. meaningless words, and unrelated links) as I only want to see what style you can deliver, and that the links would work 3) Are you ok with inDesign? Or specify other platform you would want to work with. Looking forward to collaborating on making this guide a visually captivating resource for hikers and adventurers!
Data Extraction Specialist
Position Description: We are seeking a dedicated Data Extraction Specialist to join our team at Clearview AI. This role is critical in supporting our mission to transform emergency 911 call data into structured, actionable insights. Our innovative software and AI technology convert unstructured call information into comprehensive tables, charts, and graphs, aiding in the understanding and response to emergencies. Key Responsibilities: -Daily or weekly logging into a secure portal to access recordings of emergency 911 calls, segmented by day and in 30-minute intervals. -100% - coverage of each 30 minute interval, every 30 min interval must be checked, not all with have audio files. -Efficiently copy and paste audio file URL links into word document -Running a script (we have developed) to organize this URL link information into a structured table format. -Converting the collected links in the Word document to an Excel document with an accompanying JSON file (we have a script created to do this) -Ensuring that the Excel document and audio files are meticulously organized by date and 30-minute segments, resulting in 48 entries for a 24-hour day. Required Skills and Qualifications: -Proficiency in basic computer operations, particularly in using web portals, Microsoft Word, and Excel. -Ability to execute simple scripts (training provided) to convert data formats. -Strong attention to detail and accuracy in data handling. -Ability to work independently and adhere to a regular schedule, whether daily or weekly. -Basic understanding of file management and data organization. -Use of Command line or Bash Code (trainng provided) Estimated Time Commitment: The task for one day's worth of recording is estimated to take approximately 5 to 8 minutes. The primary actions required are simple copy and paste operations. Work Environment: This role can be performed remotely, requiring a stable internet connection and a computer capable of running the necessary software. You will be part of a dynamic team committed to leveraging AI for public safety and emergency response efficiency. As a Data Extraction Specialist at Clearview AI, you will play a pivotal role in our process of converting raw emergency data into a format that is accessible and useful for analysis and decision-making. Your precision and reliability in performing these tasks will directly contribute to our broader mission of enhancing emergency response capabilities through technology.
urgent
Single Webpage with data filtering
I have small project for you. I want a single page HTML with data filtering based on Location, Price range and no of workspaces. I am attaching a sample html ( which is not fully working). And what I want it to look like - pdf and source csv which I want to load to a html table. Its a small school project for my kid. Few conditions: 1. No external css/js, all needs to be in a single html file ( hence no webserver required) 2. No 3rd party Js ( so jQuery etc not allowed, unless you can extract specific piece of code you need or include in the HTML itself). 3. The search field should search City/Location/Address 4. Price Range should filter data based on Price range 5. No of desk should filter on Workspaces All the filtering should be individual java script actions. 6. The table data should be loaded using a java script which converts the csv data into html table [ as the data is likely to change in future, we want to make it dynamic] 7. Table headers should be fixed/frozen should also have a filtering option for City/Location/Name and sorting option on Workspaces and List Price. Your portfolio is impressive. Looking forward to work with you. Thanks Aszad
On-chain Analyst (with finance background)
Openmesh is a full-stack, decentralized data cloud infrastructure built on a global network of bare metal servers. It is the largest open data lake, covering approximately 80% of the entire crypto and web3 ecosystem today. Our vision is to democratize data and address information asymmetry at a scale. Data & information is the most valuable commodity in the world. Without quality, reliable data, all webpages, apps, and the entire internet will stop working. We believe access to reliable unedited information is a fundamental right, an aspect of a free and democratic society. The Core Principles of Openmesh, by design, has no single authority that can alter its data, how the information is distributed or controlled, or who can see what and when. The infrastructure and entire technology stack is open-source and governed by an open-source community. Overview of the Role: As an On-chain Analyst with a finance background at Openmesh, you will assume a pivotal role in our mission to build a petabyte-scale decentralized data infrastructure for crypto and Web 3.0 technologies. Your primary focus will be on harnessing blockchain data to extract valuable financial insights. We believe in empowering individuals with unrestricted access to immutable data and consider this role essential in achieving that vision. Responsibilities: As an On-chain Analyst with a finance background at Openmesh, you will play a critical role in analyzing blockchain data and financial transactions. Your responsibilities will involve: - On-chain Analysis: Conduct a comprehensive analysis of blockchain data, focusing on transactions, smart contracts, and token movements. - Financial Insights: Apply your finance background to extract financial insights from on-chain data, including tracking flows, trends, and anomalies. - Risk Assessment: Assess and identify potential risks associated with on-chain activities, providing valuable insights for decision-making. - Reporting: Generate clear and concise reports, sharing your findings with internal and external stakeholders. - Model Development: Collaborate with the team to develop financial models and metrics based on on-chain data. - Data Visualization: Create data visualizations to communicate complex on-chain insights effectively. - Market Research: Stay updated on crypto and Web 3.0 market trends and developments, providing strategic insights. Qualifications: To excel in this role, you should possess the following qualifications: - Finance Background: A strong educational background in Finance, Economics, or a related field. - Blockchain Knowledge: A solid understanding of blockchain technology, cryptocurrencies, and smart contracts. - Data Analysis: Proficiency in data analysis techniques and tools, including data visualization. - Financial Acumen: A keen interest in financial markets and the ability to apply financial principles to on-chain data. - Attention to Detail: A meticulous approach to data analysis and the ability to spot anomalies and patterns. - Communication Skills: Strong written and verbal communication skills to present findings effectively. - Team Player: Ability to collaborate with cross-functional teams and adapt to a dynamic environment. What You’ll Get By joining Openmesh as an On-chain Analyst, you will enjoy the following benefits: - Competitive compensation package. - Opportunities for professional growth and development within a pioneering industry. - Engagement in an open-source community that values data integrity and innovation. - A collaborative work environment where your contributions are valued. - The opportunity to be at the forefront of transformative developments in the crypto and Web 3.0 landscape.
opportunity
Expert in Tableau
I need an EXPERT in Tableau who can take data concepts and transform them into Tableau design based on scope of the project. Please DO NOT apply if you have ONLY worked on basic drag & drop designs. We would like a partner who we can call upon on a regular basis. Your skills: Tech: understand ETL process, understand sql db, able to extract data using custom sql, Design: Tableau skill sets to create calculations, Immediate need: We have a 1-2 day project to take data that needs transforming via custom SQL and design, custom calcs
opportunity
Update PHP based Paypal Integration to new methods
I have been using a slightly modified Paypal Payment Gateway script from the website below for a little while now https://phppot.com/php/paypal-payment-gateway-integration-in-php/ It has been working great, but the over a period of 48 hours i started to get infrequent reports of users who have paid (I can see their payment in PayPal) but don’t appear to have their payment recorded into my MySQL database due to issues with the script getting payment verification from PayPal. Because the transactions don’t get recorded in the database, the triggers don’t function to add credits to their account and i have unhappy users. In short, the system has become unreliable and i have pulled it from the server. I have checked the server logs and i do see this error. 2254443#0: *102962 FastCGI sent in stderr: "ww/vhosts/dankdronedownloader.com/httpdocs/DDD2/payment_processor/notify.php on line 43PHP message: PHP Warning: Undefined variable $get_magic_quotes_exists in /var/www/vhosts/dankdronedownloader.com/httpdocs/DDD2/payment_processor/notify.php on line 43 I have been advised by the script creator that I could add one line of code to work around this, however I do keep getting emails from PayPal telling me "its time to update your integration" which links me to this website below, so I want to take this opportunity to upgrade the integration to the new standard as the current method will eventually be retired. https://developer.paypal.com/docs/checkout/standard/upgrade-integration/?utm_source=paypal&utm_medium=email&utm&_ga=2.207277395.1389730440.1696410198-2139970517.1695896604 Goals Attached in a zip file (renamed as a .txt) is my current (sanitised) code structure so you can load this up and see how it works. In short, I want nothing visible to change, the page has to look and function how it does, however the PayPal payment side of things needs to be updated to use the new payments system. I am happy to provide sandbox API keys/whatever you need to accomplish this. The payments MUST be recorded in the MySQL database 100% of the time and ideally either alert me or the user if this fails. I want 0% chance of a user paying, but things not being recorded. An important factor is a value on index.php called ‘id’. For me to associate payments to a user of the app, when users click on a button in the associated app (out of scope for this project) they are taken to a URL like “payment_processor/index.php?id=ID_Goes_Here”. This is stored as a PHP variable on line 165 of index.php and is used thought the script, this MUST get recorded in the database to allow my other triggers and functions to detect this and assign credits. How this works is also out-of -scope, just assume that if you place valid data in the database, the triggers deal with the credit association The database structure also cannot be altered as the same database table is used by Stripe and is integral to the app function, changes would require additional work in many other areas incurring other time and cost. Any new/additional code should be well commented to allow for future modifications. Credits are sold in quantities of 1,5,15 or 30, it needs to at least allow for these values with a clear way to allow alternate values to be added in the future (maybe even freeform where the user could purchase 7 credits for example). I am looking to start this project immediatly. NOTE: The attached source code is a zip file, but PPH doesn't allow these. Please rename the file to a .zip and extract it.
Social Media Reels
We are looking for someone to make us social media reels. 1. These reels have to be extract from what is already available 2. These has to revolve around the idea of our website. 3. Will have to edit and make these worth while to get loads of views on social media. 4. You have to be creative and thoughtful. 5. 4 reels a week Please visit our website before you apply for this www.lyfeindex.com.