Build an inbound and outbound inventory application to run on iPhone or iPad. The application would track inbound and outbound shipments of hay, assign a lot number to the inbound or outbound shipment, allow the ability to upload images of weight or scales tickets from our scales, ability to upload images of the hay, will track lot number, date, vendor, customer, price per ton, trucking per ton, fixed trucking cost, price per bale, weight per bale, number of bales, type of hay, cut of hay, quality of hay. This is a general description, I can put a workflow together for successful candidate.

Project Description: We are seeking a skilled data scientist or data engineer to help us build a comprehensive database of companies in a specific industry. The goal of this project is to gather, process, and analyze data from various sources to create a unified database that will enable us to understand the competitive landscape and identify potential investment opportunities. Key Responsibilities: -- Design and implement a scalable data architecture using MySQL as the primary database. -- Collect and integrate data from multiple sources, including public records, financial datasets, and other relevant sources. -- Develop data cleaning, matching, and reconciliation processes to ensure data accuracy and consistency, handling challenges such as data deduplication and fuzzy matching. -- Enrich the database with additional information using APIs and data enrichment techniques. -- Implement incremental data loading processes to accommodate the continuous addition of new data sources and ensure the database remains up to date. -- Collaborate with our team to identify and incorporate relevant alternative datasets that can enhance our understanding of the industry and target companies. -- Develop data visualization and reporting solutions to present key insights and metrics to stakeholders. -- Provide recommendations for future data architecture enhancements to support advanced analytics and decision-making. Required Skills and Experience: -- Strong expertise in SQL (MySQL) -- Proficiency in data manipulation, cleaning, and transformation using Python (pandas, NumPy) -- Experience with data matching, deduplication, and reconciliation techniques -- Knowledge of data integration best practices and ETL processes -- Familiarity with APIs and data enrichment techniques -- Understanding of data modeling and database design principles -- Excellent problem-solving and communication skills -- Ability to work independently and collaborate effectively with a team Preferred Skills: -- Experience with data visualization tools like Tableau or PowerBI -- Knowledge of data warehousing concepts and platforms -- Familiarity with advanced analytics and machine learning techniques -- Experience working with large datasets and optimizing query performance If you are a skilled data scientist or data engineer with a passion for turning data into actionable insights, we'd love to hear from you. Please submit your proposal, including your experience with similar projects, proposed approach, and estimated timeline. We look forward to working with you to build a robust database that will drive our investment decisions and help us identify promising opportunities in the target industry.

We have a small App development team and need a specialist in designing a structure to gather information and generate reports for both internal needs and customers. This a project-based assignment that will have multiple projects over the next 2 years. The initial project is to update and improve design and format of several existing reports generated by our Apps using AWS cloud structure and Dynamo DB. Must be an expert in using AWS tools and Dynamo DB Will work with existing team and AWS developer. Must have good communication skills and be able to work independently after given direction.

Upright’s current intranet system built within Notion serves as a central repository for internal communications, resources, and employee services. The goal of this project is to transform our existing intranet into a more engaging, intuitive, and user-friendly platform. This redesign will focus on improving the usability of the intranet to ensure that staff members can find and utilize information with greater ease and efficiency. Key Responsibilities: - Develop a more intuitive navigation system that allows users to find information quickly and easily. - Enhance the visual appeal of the intranet and incorporate interactive elements to boost user engagement. I am looking for something well versed in the Notion platform that can take the text heavy pages and databases in our system, and turn it into a tool our staff can easily use to find the information relevant to them.

We are seeking a highly skilled PostgreSQL Data Architect to design our database infrastructure on AWS. You will be responsible for ensuring data integrity, performance, and security across multiple systems. Your role will involve creating efficient data models and design scalable solutions. For this phase of the project, you will be asked to create a data pipeline between salesforce and an Amazon RDS Postgres instance. It will connect the client journey from various Salesforce reports, including connecting Lead and Opportunity data. The database needs to be updated whenever a new lead or opportunity is created in salesforce, either real-time or in batch processes. It will use client MRN (medical record number) as the primary key, so that the data can be matched and cross-referenced with our EHR data. More details will be provided over the phone during the introductory call and once the job is accepted. Relevant skills: - Database design - Data modeling - Performance optimization - Database security - PostgreSQL - ETL

I’m an Executive Director for a non-profit who uses airtable as an additional layer for grants and program budgeting. The primary piece of data/source of truth is our transaction details exported from quickbooks. There are linked tables for many things but specifically I’m looking for support on building out functionality for our Chart of Accounts related to our Programs and Staff tables. From Transactions Details all transactions are linked to the tables: -Chart of accounts (i.e. Wages, Taxes, Benefits etc…) -Programs (i.e. Events, Residencies) -Staff (i.e. Joe Shmo, Jimmy John) Specifically to figure out the budget for a program we need to take Staff - within the Staff table, and assign a percentage of time to a program (i.e. Joe Shmo spends 50% of their FTE on Events). Because we have many programs its easier to sum Wages, Taxes, and Benefits and then multiple them by the relative FTE %. However, an issue comes into play if two Staff members work different FTE % on a program. So lets say Joe Shmo spends 50% FTE on Events and Jimmy John spends 25% FTE on Events. This is easy enough to sum with a formula in the staff table, but now we want to bring the cost of staff back into the chart of accounts. So ultimately we’d like a column in chart of accounts to reflect - 2024 Events Actuals. But to get those actuals from Taxes, Wages, Benefits we have to pull in many lookup or roll up fields again, all of which copy the same value over and over. I can’t figure out how to elegantly pull in the respective Staff Actuals from the staff table but back into the chart of accounts.

We're a leading marketing and web application firm looking for experienced Java developers for a variety of work on several online web SaaS systems. We have a steady amount of work and are looking for reliable developers over the long term.

I have been working on an "e4473" program for my business but I don't have the time to finish it. I am looking for someone to take the project on for me. I have a lot of other projects in mind but figured I would start with this one. This would be a completely custom program. I have started it with html/php/css/javascript, but i'm not an expert and want this to be done right. It could be an app on a phone or tablet possibly, i'm open to suggestions. If you google 4473 you will see the basics of what i'm talking about.

Evrloop (www.evrloop.com) is launching as the first fully circular baby products company, introducing a zero-waste solution for parents. When parents are done with an evrloop product, evrloop plans to buy the product back so it can be properly recycled into a new product. Evrloop aims to build a custom ERP system that will track all costs (shipping, labor, parts, etc) associated with this return and recycling program, as well as track the cost of goods extracted and reused for new manufacturing and the carbon impact of this system. This system will be consumer-facing, will need to connect to Evrloop's existing manufacturing ERP system, and also connect with a QC system at Evrloops 3rd party manufacturing facility. This project is expected to start on or around June 1st, we are hoping to finalize our development plan with the software engineer awarded this project.

We are seeking a highly skilled WordPress Developer to design and build custom employee and client portals for our company. The successful candidate will be responsible for creating user-friendly, secure, and functional portals that can handle specific business workflows and provide a seamless experience for both employees and clients. We already have a fully built out site, we are just needing a database to create employee only sites and client portals. Responsibilities: - Design and develop custom WordPress themes and plugins tailored to the needs of our employee and client portals. - Ensure high-performance and manageability of the portals while maintaining a strong focus on user experience. - Implement security measures to protect data and manage user access. - Collaborate with our IT team to integrate the portals with other business applications and services. - Conduct thorough testing and troubleshooting to ensure robustness and reliability. - Provide training and support to staff on using the portals effectively.