Current experience building data warehouses connecting multiple SQL databases and cloud-based databases.
Experience building a SQL data warehouse using various tools such as Solver.
Follow Port’s Information Security Policies and industry best practices on secure design.
Provide the port with complete documentation.
Proven experience using best of practices guidelines,
The port will provide VPN access to our Virtual SQL Servers and storage for configuring the warehouse.
After the warehouse is built, assist in policy or procedures as to managing it and using it.
Virtual meetings with the various software providers will be necessary in order to determine and database scheme of each database.
Assist port’s Report Analysis with creation of reports such as:
Tableau/Power BI reports
SSIS packages
Dashboards in SharePoint
Must be proficient in writing code for SQL and cloud databases, and have experience with Tableau, Power BI, SSRS, Crystal Reports, or any other report-writing tool.
Create queries to extract data from databases that can flow into Tableau/Power BI.
Create and execute jobs for applicable files to be converted to a . CSV file that can be easily imported into the data warehouse.
Pulling documents from SharePoint.
Finalists with interviews will receive a list of programs/software port utilizes and will be required to sign a Non-Disclosure Agreement (NDA).
Demonstrating not only the capability to excel in these services but the ability to maintain cost control and offer strategic methods for reducing project costs related to these services.
Job Type: Full-time
Pay: $50.00 - $60.00 per hour
Compensation package:
- 1099 contract
Experience level:
- 8 years
Schedule:
- 8 hour shift
- Monday to Friday
Ability to Relocate:
- Vancouver, WA: Relocate before starting work (Required)
Work Location: In person