Cloud Data Engineer - Information Technology - Analysts

MassGenics, Inc.; Woodbridge Township (NJ); On-site; USD 110,000 - 117,000; Full time

Benefits offered by this job

Medical & pharmacy coverage

401(k)

HSA and FSA

Job summary

Innova Solutions is seeking a Cloud Data Engineer for a 12+ month contract in Iselin, NJ (onsite). You will design, build and maintain scalable data pipelines and Azure cloud platforms, handling large datasets with Delta Lake and Databricks.

Responsibilities include developing PySpark ETL, optimizing Databricks jobs, and implementing data governance. Requires 5+ years in Python/SQL Server and cloud data warehousing experience. Referral bonus offered.

Qualifications

• 5+ years Python coding experience.
• 5+ years SQL Server based development of large datasets
• 5+ years with ETL pipelines using Databricks PySpark.
• Experience in cloud data warehouses like Synapse, BigQuery, Redshift, Snowflake.
• Experience in Data warehousing - OLTP, OLAP, Dimensions, Facts, and Data modeling.
• Leadership in enterprise-wide Cloud Data Platform migration.
• Cloud based data architecture, messaging, and analytics.
• Cloud certifications.
• Experience with Airflow is a plus.

Responsibilities

• Build and optimize data pipelines for ingestion, transformation and loading with data quality.
• Design, develop, and deploy Spark programs in Databricks to process large data volumes.
• Leverage Delta Lake, DWH, data integration, cloud design and data modeling.
• Proficient in Python and SQL programming.
• Develop data warehouse dimensional models.
• Work with streaming/integration technologies for data ingestion.
• Handle structured, semi-structured and unstructured data.
• Optimize Databricks jobs for performance and scalability.
• Monitor and troubleshoot Databricks jobs and bottlenecks.
• Implement data management, security and governance in Databricks; design enterprise DWH solutions.
• Write SQL queries and stored procedures; reverse engineer processes.
• Perform code reviews to ensure requirements alignment and standards.

Skills

Python

SQL

Databricks PySpark

Cloud data warehouses

Data warehousing modelling

Azure Cloud

ETL pipelines

Airflow

Data governance

SQL + stored procedures

Education

BA degree in engineering or computer science

Tools

Databricks

Spark

SQL Server

Azure Synapse

BigQuery

Redshift

Snowflake

Airflow

Job description

Job Description

A client of Innova Solutions is immediately hiring for a Cloud Data Engineer

Position type: Contract Duration: 12+ months Location: Iselin, NJ 08830(Onsite)

As a Cloud Data Engineer, you will: The Cloud Data Engineer is responsible for designing, building, and maintaining scalable data pipelines and Azure cloud platforms. This role involves working with large datasets, optimizing data workflows, and ensuring secure, efficient data storage and processing in cloud environments.

Major Responsibilities:

• Build and optimize data pipelines for efficient data ingestion, transformation and loading from various sources while ensuring data quality and integrity.
• Design, develop, and deploy Spark program in Databricks environment to process and analyze large volumes of data.
• Experience of Delta Lake, DWH, Data Integration, Cloud, Design and Data Modelling.
• Proficient in developing programs in Python and SQL
• Experience with Data warehouse Dimensional data modeling.
• Working with event based/streaming technologies to ingest and process data.
• Working with structured, semi structured and unstructured data.
• Optimize Databricks jobs for performance and scalability to handle big data workloads.
• Monitor and troubleshoot Databricks jobs, identify and resolve issues or bottlenecks.
• Implement best practices for data management, security, and governance within the Databricks environment. Experience designing and developing Enterprise Data Warehouse solutions.
• Proficient writing SQL queries and programming including stored procedures and reverse engineering existing process.
• Perform code reviews to ensure fit to requirements, optimal execution patterns and adherence to established standards.

Skills:

• 5+ years Python coding experience.
• 5+ years - SQL Server based development of large datasets
• 5+ years with Experience with developing and deploying ETL pipelines using Databricks PySpark.
• Experience in any cloud data warehouse like Synapse, Big Query, Redshift, Snowflake.
• Experience in Data warehousing - OLTP, OLAP, Dimensions, Facts, and Data modeling.
• Previous experience leading an enterprise-wide Cloud Data Platform migration with strong architectural and design skills.
• Experience with Cloud based data architecture, messaging, and analytics.
• Cloud certification(s).
• Any experience with Airflow is a Plus.

Education

• Minimally a BA degree within an engineering and/or computer science discipline

The ideal candidate will have:

• 5+ years Python coding experience.
• Experience in Azure Cloud.
• 5+ years - SQL Server based development of large datasets
• 5+ years with Experience with developing and deploying ETL pipelines using Databricks PySpark.
• Experience in any cloud data warehouse like Synapse, Big Query, Redshift, Snowflake.
• Experience in Data warehousing - OLTP, OLAP, Dimensions, Facts, and Data modeling.

This position is only open to applicants who can be engaged on a W-2 basis. 1099 contractors and Corp-to-Corp arrangements will not be considered for this position.

REFERRAL PROGRAM:

This position qualifies for a Referral Bonus amount of $250-$1000 dollars. Please email your referral details along with their resume to [e-mail]

PAY RANGE AND BENEFITS:

Pay Range*: $ 80 - $85/per hour

*Pay range offered to a successful candidate will be based on several factors, including the candidate's education, work experience, work location, specific job duties, certifications, etc.

Benefits:

• Medical & pharmacy coverage
• Dental/vision insurance
• 401(k)
• Health saving account (HSA) and Flexible spending account (FSA)
• Life Insurance
• Pet Insurance
• Short term and Long term Disability
• Accident & Critical illness coverage
• Pre-paid legal & ID theft protection
• Sick time
• and other types of paid leaves (as required by law)
• Employee Assistance Program (EAP)

ABOUT INNOVA SOLUTIONS: Founded in 1998 and headquartered in Atlanta, Georgia, Innova Solutions employs approximately 50,000 professionals worldwide and reports an annual revenue approaching $3 Billion. Through our global delivery centers across North America, Asia, and Europe, we deliver strategic technology and business transformation solutions to our clients, enabling them to operate as leaders within their fields.

Recent Recognitions:

• Named One of America’s Best Employers for New Grads by Forbes (2024)
• Named One of the Best Companies to Work for by U.S. News & World Report (Private Companies List, 2024-2025)
• One of the Largest IT Staffing Firms in the US – Ranked #3 by Staffing Industry Analysts (SIA, 2024)
• One of the Largest Staffing Firms in the US – Ranked #13 by Staffing Industry Analysts (SIA, 2024; includes Innova Solutions, Volt, & HireGenics)
• Named One of the Top Ten Private Companies in Atlanta by the Atlanta Business Chronicle (2023)
• One of the Largest Certified Minority Business Enterprises (MBEs) in the United States (NMSDC, 2024)
• AWS Advanced Tier Services Partner with 100+ certifications

Website: https://www.innovasolutions.com/

Innova Solutions is an Equal Opportunity Employer and prohibits any kind of unlawful discrimination and harassment. Innova Solutions is committed to the principle of equal employment opportunity for all employees and to providing employees with a work environment free of discrimination and harassment on the basis of race, color, religion or belief, national origin, citizenship, social or ethnic origin, sex, age, physical or mental disability, veteran status, marital status, domestic partner status, sexual orientation, or any other status protected by the statutes, rules, and regulations in the locations where it operates. If you are an individual with a disability and need a reasonable accommodation to assist with your job search or application for employment, please contact us at [e-mail] or [phone]. Please indicate the specifics of the assistance needed. Innova Solutions encourages all interested and qualified candidates to apply for employment opportunities. Innova Solutions (HireGenics/Volt) does not discriminate against applicants based on citizenship status, immigration status, or national origin, in accordance with 8 U.S.C. § 1324b. The company will consider for employment qualified applicants with arrest and conviction records in a manner that complies with the San Francisco Fair Chance Ordinance, the Los Angeles Fair Chance Initiative for Hiring Ordinance, and other applicable laws. By applying for this job, I agree to receive calls and emails (including automated or AI-generated calls or emails) from Innova Solutions, Inc.and its identified recruiting partners regarding this job and future recruiting and job-placement opportunities. I understand that my consent is not a condition of employment or services, and that I may revoke my consent at any time by following the Opt Out Instructions. I confirm that I have read and agree to the Terms of Service and acknowledge that I have received and reviewed the Privacy Notice.