Lead Data Engineer

MassGenics; Raleigh (MN, NC); Remote; USD 106,000 - 125,000; Full time

Job summary

A leading company is seeking a Lead Data Engineer to design and develop data pipelines and ETL processes. This remote position requires strong experience in Google BigQuery and Informatica tools, along with excellent problem-solving and communication skills. Join a dynamic team to drive data solutions and insights.

Benefits

Medical & pharmacy coverage

Dental / vision insurance

401(k)

Health saving account (HSA)

Flexible spending account (FSA)

Life Insurance

Pet Insurance

Short term and Long term Disability

Employee Assistance Program (EAP)

Qualifications

• 7+ years of experience as a Data Engineer.
• Strong proficiency in SQL and ETL development.
• Relevant certifications in Informatica or Google Cloud technologies are a plus.

Responsibilities

• Design and develop data pipelines and ETL processes.
• Collaborate with stakeholders to define data models.
• Monitor and troubleshoot data integration jobs.

Skills

SQL

Data modeling

ETL development

Data governance

Data quality checks

Data profiling

Data cleansing

Problem-solving

Communication

Education

Bachelor's degree in Computer Science

Master's degree (preferred)

Tools

Google BigQuery

Informatica PowerCenter

Informatica Intelligent Cloud Services (IICS)

Google Cloud Platform

Tableau

Job description

Innova Solutions is immediately hiring for a Lead Data Engineer

Position type : Remote in US

Duration : 10 Weeks

Location : Arlington, VA (USA)

As a Lead Data Engineer you will :

• Design and develop data pipelines and ETL processes using Google BigQuery, Informatica PowerCenter, and Informatica Intelligent Cloud Services (IICS) to extract, transform, and load data from various sources into data warehouses.
• Collaborate with data architects, business analysts, and stakeholders to understand data requirements, define data models, and design data integration solutions that meet business needs.
• Implement data quality checks, data profiling, and data cleansing processes to ensure data accuracy, completeness, and consistency across data sources.
• Optimize and tune data pipelines for performance, scalability, and reliability, leveraging best practices and industry standards.
• Develop and maintain data warehouse schemas, data marts, and data models to support reporting, analytics, and business intelligence (BI) initiatives.
• Monitor and troubleshoot data integration jobs, identify and resolve data processing issues, and implement proactive monitoring and alerting mechanisms.
• Document data integration processes, data lineage, and metadata to support data governance, compliance, and regulatory requirements.
• Stay updated with emerging data technologies, tools, and trends, and evaluate and recommend new solutions to enhance data engineering capabilities.
• Provide technical guidance, mentorship, and support to junior data engineers, fostering a culture of continuous learning and knowledge sharing.
• Collaborate with cross-functional teams, including data scientists, BI developers, and business users, to deliver end-to-end data solutions that drive business insights and decision-making.

Duties and responsibilities

• Bachelor's degree in Computer Science, Information Systems, or related field; Master's degree is a plus.
• Minimum of 7 years of experience as a Data Engineer, with expertise in Google BigQuery, Informatica PowerCenter, and Informatica Intelligent Cloud Services (IICS).
• Strong proficiency in SQL, data modeling, and ETL development, with hands-on experience in designing and implementing complex data integration solutions.
• Solid understanding of data warehousing concepts, data architecture principles, and data governance best practices.
• Experience with cloud platforms such as Google Cloud Platform (GCP) or similar cloud environments is highly desirable.
• Excellent analytical, problem-solving, and troubleshooting skills, with a focus on delivering high-quality data solutions.
• Strong communication and interpersonal skills, with the ability to collaborate effectively with cross-functional teams and stakeholders.
• Relevant certifications in Informatica or Google Cloud technologies are a plus.

Good to have skills : Tableau / any BI tool experience, SSRS, Healthcare Domain

Qualified candidates should APPLY NOW for immediate consideration! Please hit APPLY to provide the required information, and we will be back in touch as soon as possible.

Thank you!

Manager

PAY RANGE AND BENEFITS :

Pay Range

• 106,000 - $ 124,500 Per annum
• 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 : Innova Solutions offers benefits( based on eligibility) that include the following : 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 :

• One of Largest IT Consulting Staffing firms in the USA – Recognized as #4 by Staffing Industry Analysts (SIA 2022)
• ClearlyRated Client Diamond Award Winner (2020)
• One of the Largest Certified MBE Companies in the NMSDC Network (2022)
• Advanced Tier Services partner with AWS and Gold with MS

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 [emailprotected] 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.