Jobs · Information Technology · New York

Senior Data Engineer & BI Developer - Contract to Hire

iPostal1 · Suffern, NY · 3 wk ago
On-siteInformation Technology$150k–$175k/yrContract

Responsibilities

  • Engineer robust ELT solutions: Design, build, test, and document efficient data pipelines using cutting-edge tools to ensure seamless data integration.
  • Satisfy business requirements: Leverage your advanced SQL skills to design and implement robust data transformations that directly address business objectives and drive decision-making.
  • Stay ahead of the curve: Eager to explore and embrace new technologies and algorithms to continuously optimize data solutions.
  • Deliver results with a user-centric approach: Driven to achieve targets and consistently prioritize user experience in every solution. Meet commitment deadlines.

Qualifications

  • 8+ years of data expertise: Proven track record in ETL/ELT, data modeling, data warehouse design, development, and population from diverse data sources (databases, unstructured data, APIs).
  • 2+ years with Snowflake: Hands-on experience developing and optimizing within the Snowflake cloud data warehouse environment. Snowpro certification is a plus.
  • SQL mastery: Advanced-level SQL programming skills with a focus on query and ELT optimization for performance and knowledge of window functions.
  • Analytical problem solver: Data-driven mindset with sharp analytical skills, comfortable with ambiguity, able to identify and resolve inconsistencies and root causes. Strong business acumen to validate the accuracy of data.
  • Excellent verbal and written communication skills.
  • Exceptional grammar, spelling, and attention to detail
  • Use of ETL/ELT Tools like Five Tran, Matillon, Kettle, Abinitio, Informatica, SSIS or similar.
  • Use of Visualization tools such as Tableau, PowerBI, Looker (LookML) or Sigma
  • Good knowledge of RDBMS like MySQL, Oracle, Postgres, SQL Server
  • Other Technical know-how: Proficient in software engineering best practices, adept across Unix/Linux/Windows platforms, and experienced with Agile workflows.
  • Collaboration tools: Basic familiarity with Git for version control and Jira for project tracking.
  • Education: Proven track record in a technical field, ideally supported by a BS/MS in Computer Science, Information Systems, or similar experience. Strong technical and business skills are key.

Pluses

  • Experience with: Low code data extraction tools like FiveTrans, Matillion or Rivery
  • Semantic layer or data virtualization tools
  • Data Governance
  • Agile
  • Scripting languages like Python, Shell or JavaScript
  • AWS services (S3, RDS, etc) and networking knowledge
  • Google Analytics and Facebook Ads data
  • Data Quality (we use Monte Carlo Data)
  • Job orchestration tools (Airflow or proprietary)

Benefits

  • Equal Opportunity Employer

Pay

$150,000 - $175,000 yearly

Schedule

Contract role that can potentially lead to full-time employment

Similar jobs

Senior Data Engineer, BI

UNFCUQueens, NY· 1 mo ago
Information Technology$115k–$160k/yrapply on careers-unfcu.icims.com

Senior BI Engineer, Data

WebstaurantStoreLititz, PA· 3 wk ago
RemoteBusiness Developmentapply on careers.clarkassociatesinc.biz

Data Engineer (Senior)

Full Visibility LLCHuntsville, AL· 1 wk ago
Information Technologyapply on fullvisibility.zohorecruit.com