Data Warehousing Jobs

15 were found based on your criteria {{|number:0 }} were found based on your criteria

show all
  • Hourly ({{ jobTypeController.getFacetCount("0")|number:0}})
  • Fixed Price ({{ jobTypeController.getFacetCount("1")|number:0}})
Hourly - Expert ($$$) - Est. Time: Less than 1 week, 30+ hrs/week - Posted
We need to write a technical proposal for the attached RFP. The National Geospatial Information Platform Technical Foundation. Infrastructure Foundation for the Geospatial Data management, Exchange, Synchronization, and Dissemination
Skills: Data Warehousing Geospatial
Hourly - Intermediate ($$) - Est. Time: 3 to 6 months, 30+ hrs/week - Posted
We want to build a DWH that unifies our main business data in one database. We will need the following tool (this is always subject to changes and adding info might be required as we go) to push data to the DWH: High Priority 1.1) Magento (Orders, Customers, Carts/Quotes, Products, Categories) - MySQL DB 1.2) (Magento) Browsing Data 2) Mailchimp (Mailing Lists, Deliveries, Opens, Bounces, Subscribes/Unsubscribes) 3) Zendesk (Tickets, Tags, Satisfaction, Solution Time, Response Time, Tickets by Status) 4) Google Analytics (Users, Sessions, Pageviews, Events, etc.) 5) Google Adwords 6) Facebook 7) WMS - Standalone Warehouse Management System we have built 8) Delivery Database (our 3rd party agent for deliveries) Lower Priority 8) Twitter/Facebook/Social Media 9) Accounting - SAGE 10) Euphoria - Telephony Software On top of the Data Warehouse we want to build a reporting interface that lets us gather insights into what drives business over several platforms. We are happy with a Database that we can address via SQL queries but for a V2: Might also interested in visualizing data so that we can create graphs and dashboards that combine data from several sources within or on top of the DWH via a web interface.
Skills: Data Warehousing Data Analytics Data Backup Data mining
Hourly - Intermediate ($$) - Est. Time: 3 to 6 months, Less than 10 hrs/week - Posted
We are looking for professionals who: -> Have excellent communication skills (verbal and written); -> Can take responsibility of promoting IT Product and Services in the local as well as international markets; -> Has done sales in Software Service in Big Data technologies, Analytics, Business Intelligence, Data-warehousing, etc.; -> Has a flair to identify business opportunities and drive profitable new business with client mapping, cold-calling, focused email campaigns, presentations, social-marketing, etc.; -> Ideally has experience managing the entire sales life-cycle; If you think your knowledge, marketing-skills as well as your passion for software sales and marketing matches up with the requirements, do get in touch at the earliest.
Skills: Business Development Email Marketing Information Management Internet Marketing Lead generation Sales
Fixed-Price - Expert ($$$) - Est. Budget: $1,000 - Posted
We are using a mysql and mariadb sql system hosted on AWS that is connected to remote industrial automation systems over the internet. We need a tool for developing and then automating the regular system production and compliance reports from the data archive. This might include summarizing data over a period of time (month, week or day), creating a chart or table, performing some analysis of of the data to remove outliers and create summary statistics. There could be boiler plate text that goes with each report and the report might be sent as a file to someone for review and then posted from a public repository with links provided automatically to a web index of reports. There may be existing tools for this, or something that needs to be modified... perhaps we have to build from scratch, but I hope not! Other IoT tools such as Thingwork, Periscope etc. seem to be more tied to data presentation that report writing, but we may be overlooking options in those new IoT solutions. This projects first phase would be to help us evaluate existing solutions and review the functional requirements of this tool that could be installed in each Amazon Web Services instance to allow a user to design reports and have them setup for scheduled running. It might be initially we have a designer installation that provides a service to create the reports so the instances only have the released reports and just a run time package. Over time we'd like to have a system that would make it easy for an end user to access the data and modify or create their own reports, but we expect that initially the complexity of the data dictionary will make it more practical to have a designer create and maintain the reports. An additional element of this project is to anticipate that some of the data needed for the reports will be in another sql database, might need to be entered at the time the report is run, might need to have attachments from a file directory. This is all additional data that would not be in the primary scada system historical database repository but we'd like the system to be able to integrate or attach and bring with the main report. So deliverables for this project are: 1. Down load, install and review the system we are using. (Mango from infinite automation) and determine the issues related to record locking and access to the database for report generation... can we work with the live data base or do we need to replicate the data we want and create a data warehouse for report writing. 2. Consider the integration of other data, files or records that not part of the main database of process data. 3. Develop a short list of 3-5 available tools that might address our need for a report writing system we can deploy in each cloud AWS instance we have running where the customer has elected to pay for the option of report writing system. This list would include pricing (developer and run time AWS installations), key features, strengths and limitations and major investments required to bring the system up to the functionality we need. 4. Alternative configurations we should consider to build data warehouses for each instance and approach this differently. 5. A recommendation for whether we move forward with an off the shelf system or customer system and approximate effort and list of tasks required to develop a production system for deployment. Thank you! Ky
Skills: Data Warehousing Analytics Internet of Things report writing
Hourly - Expert ($$$) - Est. Time: Less than 1 month, 10-30 hrs/week - Posted
We need an expert with SQL query writing, ad tech and data analysis/visualization. We have 3 GB of data in Amazon Redshift and will share the schema and our questions with you when the job begins. The ideal candidate: ⁃Has worked with large data sets and Amazon Redshift ⁃Can write very expressive SQL queries ⁃Is an expert with parsing and understanding schemas We want to start right away, so please reply with the word "APPLES" in the subject line and send over some examples of work that you've done.
Skills: Data Warehousing SQL
Hourly - Intermediate ($$) - Est. Time: More than 6 months, 10-30 hrs/week - Posted
We are looking for a person who is good in mentoring people. Essentially, this position is about providing mentorship, guidance and training in area of Business and System Analysis. Skills you should have: 1. Data Warehousing 2. Business Intelligence, Reporting 3. You should know a good Tool like - Informatica, Tableau 4. Data Analysis 5. Visual and Verbal Communication Skills 6. Enthusiasm to work with people 7. SQL Programming This will be an ongoing position and you will be basically running a practice of Business & System Analyst in domain of Data/BI. If you have technical/functional experience of working in Fortune 500 clients on complex systems and you are great in working with people and mentoring people over phone/webex, please reach out. We need skilled, humble, positive, team player and team builders only. It will be your on-going part time (8-10 hours a week) job. Please share your skype id and phone number.
Skills: Data Warehousing Analytics Business Analysis Business intelligence