Data Engineer

OpTech LLC

Meridian charter Township, MI, United States

12 days ago

Apply on www.indeed.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Experienced

Experience required

3 years minimum

Compensation

$97,760.0 - $118,560.0

Working hours

Regular working hours

Job source

www.indeed.com

Tech stack

Cloud Computing Databases Information Engineering Extract Transform Load (ETL) Data Systems Data Warehousing Microsoft SQL Server Oracle (Applications) Salesforce.Com PL-SQL SQL Databases Transact-SQL

+5 more

Automated Data Processing (ADP) Cloud Platform System Delivery Pipeline Snowflake Data Pipelines

Job description

Move and Clean Data (ETL): Pull data from various sources, transform it into a usable format, and load it into central storage systems.
Maintain the Central Data Warehouse: Keep the main company database (on-premises) and smaller reporting databases running smoothly using tools like Informatica and PL/SQL.
Bridge On-Premises to Cloud: Set up automated pipelines that stream data in real-time from legacy internal servers up to cloud systems like Snowflake and apps like Salesforce.
Automate & Standardize: Write scripts so manual data processes run automatically, and help write best-practice guidelines for the team.
On-Call Duty: Participate in a 24/7 on-call rotation to fix data pipeline breaks or system issues.

Requirements

Experience: 3+ years in data engineering.
Clearance & Citizenship: Must be a U.S. citizen (native or naturalized) and eligible for ADP I or II clearance due to system access requirements.
Databases: Strong knowledge of Oracle and SQL Server.
Tools & Languages: Proficiency in SQL (PL/SQL, T-SQL) and Informatica (PowerCenter / IICS / IDMC).
Mindset: Strong problem-solving skills, focus on automation, and solid team communication.

Nice-to-Have

Hands-on experience building and managing data solutions directly inside Snowflake.

Benefits & conditions

OpTech is a woman-owned company that values your ideas, encourages your growth, and always has your back. When you work at OpTech, not only do you get health and dental benefits, but you also have training opportunities, flexible/remote work options, growth opportunities, 401K and competitive pay. Apply today!

By submitting your application, you acknowledge that recruiting technologies, including AI-assisted tools, may be used to support candidate evaluation, sourcing, matching, and communications.

OpTech is an Equal Opportunity Employer (EOE), all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

Pay: $47.00 - $57.00 per hour