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