Data Warehousing Jobs

5 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}})
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
Fixed-Price - Expert ($$$) - Est. Budget: $600 - Posted
Relational Database and SQL language Extraction, Transformation and Loading (ETL) (Microsoft SSIS) Data Warehouse/Solution Design Dimensional Modeling (Kimball Methodology) Analytics/OLAP Cube Development (Microsoft SSAS and MDX) Report Development (Microsoft SSRS) TFS
Skills: Data Warehousing "Extract, Transform and Load (ETL)" Microsoft SQL SSAS Microsoft SQL SSRS
Fixed-Price - Intermediate ($$) - Est. Budget: $250 - Posted
Looking for a strong data warehouse designer and implementation engineer for short-term assignment. ***If you don't have this skill, please don't apply. **** You will be required to provide specific examples from prior work and might be required to attend a technical interview. Please read the job description thoroughly before applying. In order to be successful, you must have #1. Strong data warehouse design and implementation background. #2. intimate knowledge of implementing ETLs using SQL Server 2012 is essential. Task #1: You will be required to review and finalizing our data warehouse design strategy, data model and star schema (dimensional model) resulting from a data transformation ( from AS/400 system data being brought into SQL server 2012. You don’t need to know AS/400, but if you do it will be great.) Task #2: You will create, and enhance our ETL, using SQL server 2012 SSIS. We are running SQL server 2012 platform, So, prior knowledge in either SQL server 2012 or 2005 with complex SSIS work would be a great plus. SQL development in SQL stored procedures, T-SQL, SSIS Expression builder will be critical to have.
Skills: Data Warehousing Microsoft SQL Server Programming SQL Server Integration Services (SSIS)
Fixed-Price - Expert ($$$) - Est. Budget: $30 - Posted
If you think you can do any job at cheap rate and with A grade then contact me asap with your Skype id and your expertise language from below or skill needed box. It's long-term work. I am looking EXPERIENCED EXPERT for homework help in below languages - - C++(Advanced), Java(Advanced), Php, Python, Asp.Net, C#, Database, ERD, Oracle, Software Engineering, Networking, SQL, VISUAL BASIC, Excel, Ms Access, almost all languages expert needed and many more, See in Skill needed box If you are experienced with tutoring online via Skype that will be advantageous for applying. Shoot an email with your expertise language and Skype id. I need experienced expert who can do each homework with A grade and at Cheap rate only as compare to others
Skills: Data Warehousing AJAX Artificial Intelligence ASP.NET