Data Engineer

Data Engineer

Job#: 3010944

Location:

Hybrid - 2 days/week onsite in Greater Lansing, MI area

Duration:
Long-term contract

Job Description:

We are looking for a Data Engineer to join our Data Engineering Team. The ideal candidate should have a minimum of 3 years of experience with excellent analytical reasoning and critical thinking skills. The candidate will be a part of a team that creates data pipelines that use change data capture (CDC) mechanisms to move data from on-premises to cloud-based destinations and then transform data to make it available to Customers to consume.

The Data Engineering Team also does general extraction, transformation, and load (ETL) work, along with traditional Enterprise Data Warehousing (EDW) work.

• Participates in the analysis and development of technical specifications, programming, and testing of Data Engineering components.
• Participates in creating data pipelines and ETL workflows to ensure that design and enterprise programming standards and guidelines are followed. Assist with updating the enterprise standards when gaps are identified.
• Follows technology best practices and standards and escalates any issues as deemed appropriate. Follows architecture and design best practices (as guided by the Lead Data Engineer, BI Architect, and Architectural team).
• Responsible for assisting in configuration and scripting to implement fully automated data pipelines, stored procedures, and functions, and ETL workflows that allow data to flow from on-premises data sources to cloud-based data platforms (e.g. Snowflake) and application platforms (e.g. Salesforce), where data may be consumed by end customers.
• Follows standard change control and configuration management practices.
• Participates in 24-hour on-call rotation in support of the platform.

• Database Platforms:
  Snowflake, Oracle, and SQL Server
• OS Platforms:
  Red Hat Enterprise Linux and Windows Server
• Languages and Tools: PL/SQL, Python, T-SQL, Stream Sets, Snowflake Cloud Data Platform, and Informatica Power Center, Informatica IICS or IDMC.
• Experience creating and maintaining ETL processes that use Salesforce as a destination.
• Drive and desire to automate repeatable processes.
• Excellent interpersonal skills and communication, as well as the willingness to collaborate with teams across the organization.

• Experience creating and maintaining solutions within Snowflake that involve internal file stages, procedures and functions, tasks, and dynamic tables.
• Experience creating and working with near-real-time data pipelines between relational sources and destinations.
• Experience working with Stream Sets Data Collector or similar data streaming/pipelining tools (Fivetran, Striim, Airbyte etc...).

Apex offers a range of supplemental benefits, including medical, dental, vision, life, disability, and other insurance plans that offer an optional layer of financial protection. We offer an ESPP (employee stock purchase program) and a 401K program which allows you to contribute typically within 30 days of starting, with a company match after 12 months of tenure. Apex also offers a HSA (Health Savings Account on the HDHP plan), a Support Linc Employee Assistance Program (EAP) with up to 8 free counseling sessions, a corporate discount savings program and other discounts.

In terms of professional development, Apex hosts an on-demand training program, provides access to certification prep and a library of technical and leadership courses/books/seminars once you have 6+ months of tenure, and certification discounts and other perks to associations that include CompTIA and IIBA. Apex has a dedicated customer service team for our Consultants that can address questions around benefits and other resources, as well as a certified Career Coach.

Apex Systems is a world-class IT services company that serves thousands of clients across the globe. Apex is the Commercial Segment of ASGN Incorporated. 4400 Cox Road, Suite 200, Glen Allen, Virginia 23060. NYSE: ASGN.

Mid-Senior level

Contract

Information Technology

IT Services and IT Consulting

Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law.

Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you…