Jobs · Information Technology · New York

Senior Data Engineer & BI Developer - Contract to Hire

iPostal1 · Suffern, NY · 3 mo 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 Software Engineer

HaystackAustin, Texas Metropolitan Area· 1 mo ago
Information Technology$168k–$227k/yrapply on haystack.cv

Senior Software Engineer

ETAP SoftwareHouston, TX· 3 mo ago
Information Technology$105k–$175k/yrapply on aveva.wd3.myworkdayjobs.com

Senior Software Engineer

Global Technical Talent, an Inc. 5000 CompanyFort Mill, SC· 3 mo ago
Information Technology$50–$70/hrapply on www1.jobdiva.com