Engineer II – Big Data / ETL Engineer (Apptio)

About US: We are a company that provides innovative, transformative IT services and solutions. We are passionate about helping our clients achieve their goals and exceed their expectations. We strive to provide the best possible experience for our clients and employees. We are committed to continuous improvement and innovation, and we are always looking for ways to improve our services and solutions. We believe in working collaboratively with our clients and employees to achieve success. DS Technologies Inc is looking for Engineer II – Big Data / ETL Engineer (Apptio) role for one of our premier clients. Job Title: Engineer II – Big Data / ETL Engineer (Apptio) Location: New York, NY (NYC Metro Area only)(Hybrid) Position Type: Contract Only W2 Job Summary: We are looking for a highly skilled Big Data / ETL Engineer who can work as a standalone developer and write production-ready code from scratch. The ideal candidate has strong expertise in Python, SQL, ETL development, and data warehousing, with hands-on experience building scalable data pipelines in enterprise environments. Key Responsibilities: Design, develop, and maintain ETL pipelines using Python from scratch Write efficient, reusable, and scalable code following OOP principles Develop and optimize complex SQL queries, stored procedures, and database objects Perform data modeling including schemas and entity relationships Build and manage Airflow DAGs Ingest, cleanse, govern, and report data from Big Data platforms Work with multiple SQL dialects (SQL Server, Oracle, DB2, PostgreSQL) Collaborate with stakeholders while operating independently Required Skills & Qualifications: Strong Python (ETL pipeline development from scratch) Expert SQL and RDBMS concepts MS SQL Server (SSIS, SSRS) Oracle PL/SQL Solid understanding of OOP principles Apptio experience Airflow (DAG development) Experience with Data Warehousing & Big Data Node.js, JSON, and NoSQL databases Ability to work as an independent contributor Must be local to NYC metro area Nice to Have: PySpark / Apache Spark Databricks Delta Lakehouse or BigQuery Exposure to cloud-based business tools and platforms Flexible work from home options available. Compensation: $53.00 per hour We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, or any other characteristic protected by law.