SQL Data Engineer
Pyramid Consulting Inc.
Alpharetta, United States of America
1 month ago
Role details
Contract type
Temporary contract Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
English Experience level
Intermediate Compensation
$ 146KJob location
Alpharetta, United States of America
Tech stack
Google BigQuery
Business Software
Databases
Data Architecture
ETL
Data Transformation
Data Systems
Data Warehousing
Data Flow Control
Hadoop
Hive
PostgreSQL
Metadata
Microsoft SQL Server
Oracle Applications
Reference Data
SAP Applications
SQL Databases
SQL Server Integration Services
Teradata
T-SQL
Google Cloud Platform
Spark
Looker Analytics
Alteryx
Job description
Immediate need for a talented SQL Data Engineer. This is a 12+months contract opportunity with long-term potential and is located in Alpharetta, GA (Hybrid). Please review the job description below and contact me ASAP if you are interested., * Data acquisition and ingestion - Identify data sources and build pipelines using various ETL tools such as but not limited to, SSIS, and Alteryx.
- Data sources including but not limited to SQL Server, GCP, SAP, Teradata, HadoopHive, PostgreSQL, Oracle and flat files.
- Identifying ways to improve data reliability, efficiency and quality by various data solution techniques.
- Expertise in GCP and BigQuery data transformation and View/assets creation.
- Assist in defining the data architecture framework, standards and principles, including modeling, metadata, security and reference data.
- Create and optimize data models to support various business applications.
- Reviewing modifications of existing data systems for cross-compatibility.
- Automate and support workflows to ensure timely delivery.
Requirements
- Key Skills: SQL, T-SQL, Alteryx.
- 5+ years of SQL Server development experience.
- 3+ years in GCP BigQuery with DataFlow, Data Form, DataStudio and Looker.
- 5+ years data modeling experience.
- 5+ years of ETL experience.
- 5+ years of experience in working on more than one database technologies Microsoft SQL server, Teradata or GCP BQ.
- 2+ years big data experience, Hadoop, Hive, Spark
- Expert knowledge of data warehousing.
Benefits & conditions
Pay Range: $65 - $70/hour. Employee benefits include, but are not limited to, health insurance (medical, dental, vision), 401(k) plan, and paid sick leave (depending on work location).
About the company
Our client is a leading Telecom Industry, and we are currently interviewing to fill this and other similar contract positions. If you are interested in this position, please apply online for immediate consideration.