Overview
HybridHydrid -3 days onsite per week
$40 - $45
Contract - W2
Contract - 12 Month(s)
Skills
Business Intelligence
Dashboard
Data Integrity
Data Manipulation
Data Migration
Data Modeling
Data Visualization
Data Warehouse
Database
Database Design
ER/Studio
Extract
Transform
Load
Good Clinical Practice
Google Cloud
Google Cloud Platform
Layout
Microsoft Power BI
Microsoft SQL Server
Microsoft SQL Server Management Studio (SSMS)
Microsoft SSIS
Microsoft SSRS
Microsoft Visual Studio
Packaging Design
Performance Tuning
Relational Databases
SQL
Scripting
Job Details
- Google Cloud:Managed resources within BigQuery, designed and built scalable data pipelines, and developed infrastructure to ingest and transform ETL data from diverse sources into BigQuery. Implemented robust processes to ensure data accuracy, consistency, and reliability within the BigQuery environment.
- Database Design:Create and modify database schemas, tables, views, indexes, and relationships based on business requirements.
- Data Modeling: Design and implement data models to organize and structure data effectively.
- Data Manipulation:Write SQL queries to insert, update, delete, and retrieve data from the database.
- Data Migration and Deployments:Migrate data from one database to another, often during deployments.
- Performance tuning:Analyze query performance and optimize SQL queries, indexes, and database configurations.
- SQL Querying:write SQL queries and scripts to extract, transform, and analyze data from relational databases.
- Data Visualization (Dashboards): Develop dashboards that gather data from various sources, such as relational databases, spreadsheets, and APIs, to facilitate analysis.
- SSRS Reports:Design, develop, and deploy reports using SQL Server Reporting Services (SSRS), including layout design, data visualization, and parametrization.
- SSIS Package:Design and develop ETL (Extract, Transform, Load) processes using SQL Server Integration Services (SSIS). Additionally, deploy SSIS packages to transfer and load data between different systems and databases. Develop and maintain SSIS packages for data migration, data warehousing, and business intelligence initiatives, ensuring data integrity.
- Experience in Relevant Tools and Technologies:MS Visual Studio SSDT Tools, SSMS, E/R Studio, Stylus Studio, Microsoft PowerBI, SQL Reporting Services, and SQL Integration Services
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.