Job Title: Engineer II – Big Data / Apptio / ETL
Location: New York, NY (Onsite)
Position Type: Contract
Only W2
Job Description:
We are seeking a highly motivated Engineer II (Big Data Engineer) with strong technical expertise in Apptio, Big Data, MS SQL, Oracle PL/SQL, Python, PySpark, and ETL/Data Warehousing. The ideal candidate will support data engineering, analytics, reporting, and financial/IT cost transparency initiatives leveraging Apptio and enterprise data platforms.
Key Responsibilities:
- Develop and maintain Big Data pipelines using PySpark, Python, and other data engineering tools.
- Work with Apptio for IT financial management, cost modeling, and reporting.
- Perform ETL development for large-scale Data Warehousing and analytics systems.
- Develop and optimize MS SQL Server objects (queries, stored procedures, SSIS packages, SSRS reports).
- Write efficient Oracle PL/SQL code for RDBMS-based applications.
- Analyze, transform, and process structured/unstructured data for reporting and insights.
- Collaborate with business teams to gather requirements and deliver analytical solutions.
- Troubleshoot data issues, improve data quality, and ensure system performance.
- Document data flows, technical specs, and operational processes.
Required Skills:
- Hands-on experience with Apptio (cost transparency, reporting, ITFM tools).
- Strong knowledge of Big Data technologies (Hadoop, Spark, PySpark).
- Proficiency in MS SQL Server, including SSIS and SSRS.
- Strong SQL coding with RDBMS (MS SQL, Oracle).
- Experience with Oracle PL/SQL programming.
- Good command of Python for scripting and automation.
- Strong understanding of ETL processes and Data Warehousing concepts.
- Experience working in Data Analytics environments.
Preferred Skills:
- Experience with cloud platforms (AWS, Azure, GCP).
- Knowledge of visualization tools (Tableau, Power BI).
- Familiarity with IT cost modeling and financial analytics.
- Understanding of Agile methodologies and CI/CD workflows.