Apex Systems
Join to apply for the
Data Engineer
role at
Apex Systems .
Job #: 3010944
Role:
Data Engineer
Location:
Hybrid - 2 days/week onsite in Greater Lansing, MI area
Duration:
Long-term contract
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. The Data Engineering Team also performs extraction, transformation, and load (ETL) work, along with traditional Enterprise Data Warehousing (EDW) functions.
Responsibilities
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. Assists 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, 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) for end‑customer consumption.
Follows standard change control and configuration management practices.
Participates in a 24‑hour on‑call rotation in support of the platform.
Required Skills/Qualifications
Database platforms: Snowflake, Oracle, and SQL Server.
OS platforms: RedHat Enterprise Linux and Windows Server.
Languages and tools: PL/SQL, Python, T‑SQL, StreamSets, Snowflake Cloud Data Platform, and Informatica PowerCenter, 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, and willingness to collaborate with teams across the organization.
Desired Skills/Qualifications
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 with StreamSets Data Collector or similar data streaming/pipelining tools (Fivetran, Striim, Airbyte, etc.).
Apex Benefits Overview Apex offers a range of supplemental benefits, including medical, dental, vision, life, disability, and other insurance plans. Additionally, there is an ESPP (employee stock purchase program) and a 401(k) program with company matching after 12 months of tenure. Other benefits include a Health Savings Account (HSA), a SupportLinc Employee Assistance Program (EAP) with up to 8 free counseling sessions, corporate discount savings, and professional development resources such as on‑demand training, certification prep, and discounts on industry certifications.
Equal Opportunity Employment Apex Systems is an equal opportunity employer. We do not discriminate 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 applicable law.
If you require accommodation in using our website for a job search or application, please contact our Benefits Department at
ApexBenefits@apexsystems.com
or 804-523-8228. (Do not submit resumes or solicit consultants to this email address).
#J-18808-Ljbffr
Data Engineer
role at
Apex Systems .
Job #: 3010944
Role:
Data Engineer
Location:
Hybrid - 2 days/week onsite in Greater Lansing, MI area
Duration:
Long-term contract
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. The Data Engineering Team also performs extraction, transformation, and load (ETL) work, along with traditional Enterprise Data Warehousing (EDW) functions.
Responsibilities
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. Assists 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, 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) for end‑customer consumption.
Follows standard change control and configuration management practices.
Participates in a 24‑hour on‑call rotation in support of the platform.
Required Skills/Qualifications
Database platforms: Snowflake, Oracle, and SQL Server.
OS platforms: RedHat Enterprise Linux and Windows Server.
Languages and tools: PL/SQL, Python, T‑SQL, StreamSets, Snowflake Cloud Data Platform, and Informatica PowerCenter, 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, and willingness to collaborate with teams across the organization.
Desired Skills/Qualifications
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 with StreamSets Data Collector or similar data streaming/pipelining tools (Fivetran, Striim, Airbyte, etc.).
Apex Benefits Overview Apex offers a range of supplemental benefits, including medical, dental, vision, life, disability, and other insurance plans. Additionally, there is an ESPP (employee stock purchase program) and a 401(k) program with company matching after 12 months of tenure. Other benefits include a Health Savings Account (HSA), a SupportLinc Employee Assistance Program (EAP) with up to 8 free counseling sessions, corporate discount savings, and professional development resources such as on‑demand training, certification prep, and discounts on industry certifications.
Equal Opportunity Employment Apex Systems is an equal opportunity employer. We do not discriminate 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 applicable law.
If you require accommodation in using our website for a job search or application, please contact our Benefits Department at
ApexBenefits@apexsystems.com
or 804-523-8228. (Do not submit resumes or solicit consultants to this email address).
#J-18808-Ljbffr