Data Engineer W2 ONLY - NO AGENCIES

SQL, PYTHON, JAVA, SCALA, SSIS, INFORMATICA, INTEGRATION, SNOWFLAKE, REDSHIFT, BIG QUERY, BIGQUERY, AWS, AZURE, GOOGLE, GCP, ETL, ELT, DATA
Contract W2, Contract Independent, 8+ mos
$80 - $92 hr

Job Description

Data Engineer

Must have:

  • Experience with one or few ETL tools and frameworks (MS SSIS, Pentaho, Talend, Informatica etc)
  • Experience with any of the following DWH: AWS Redshift, Snowflake, BigQuery
  • Experience with AWS/Azure/Google Cloud Platform Cloud Platforms (Preferably with Analytical services)
  • Proficiency in object-oriented/object function : Python (Preferred) or Java/Scala
  • Strong analytic skills related to working with unstructured datasets
  • Build processes supporting data transformation, data structures, metadata, dependency and workload management
  • Remote team leadership skills (for US-based positions)
  • Experience with Github

Would be a plus:
  • Snowflake experience
  • Experience with BI tools (Tableau, Looker etc)
  • Experience with NoSQL databases: Cassandra, MongoDB, DynamoDB, Neo4J
  • Understanding CI/CD concepts
  • Big Data concepts and experience with Hadoop, Spark, Kafka
  • Experience in Media industry and its standards
  • Good understanding of REST technologies (REST design, RESTful services)
  • Knowledge of OOP, OOD and design patterns

Tasks:
  • Assemble large, complex data sets that meet functional / non-functional business requirements
  • Define architectural and implementation design of metadata and data pipelines
  • Requirements analysis, communication with Product Managers and other stakeholders
  • Prepare designs for database systems and recommend improvements for performance.
  • Create data pipelines (ETL/ELTs) using SQL, Python and various AWS services
  • Writing analytical SQL queries for end-user apps/services
  • Evaluate all proposals requests and assist to improve structure of DWH.
  • Perform troubleshoot on all ETL processes and resolve issues effectively.
  • Code reviews and bug fixing.
For more information please contact Janice DiCicco ator

Since 1995, iTech Solutions Inc., has been providing IT Consulting and Direct Hire Services to the Insurance, Financial, Communications, Manufacturing and Government sectors with local offices in Connecticut, Minnesota, Colorado, Massachusetts, Tennessee, North Carolina, and New Jersey / Pennsylvania area.

Our recruiting strategy is simple, if you want to find qualified IT professionals then use IT professionals to find them. So at iTech Solutions, our personnel are all career IT professionals with a wide range of IT experience. We can honestly say our staff understands the technologies, the complexities of finding and selecting the appropriate personnel and the pressures of running successful IT projects.

Employer will not sponsor applicants for any employment visas, at hiring or in the future, including but not limited to H-1B visas. Corp-to-Corp or subcontract personnel will not be considered for this position.

Dice Id : 10111560
Position Id : 20-18296
Originally Posted : 2 months ago
Have a Job? Post it