Job Description
Job#: 1326216
Job Description:
Data Engineer 2:
Summary:
Responsibilities Include:
Typical Day:
Education:
Technical Skills Required:
Soft Skills Required:
Position's Contributions to Work Group:
The PSLD Transformation Analytics group engages with various stakeholders across the organization to help solve their business problems. The individual will run the entire project end to end, so strong skills in gathering/understanding customer requirements, creating and maintaining optimal data pipeline architecture, choosing appropriate tools/techniques and delivering actionable insights are must. They will also learn all relevant BU specific data and often combine them with relevant enterprise data domains to bring insights that are not possible if BU data alone is analyzed.
EEO Employer
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 require an accommodation in using our website for a search or application, please contact our Employee Services Department at or .
EEO Employer
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 require an accommodation in using our website for a search or application, please contact our Employee Services Department at or .
Job Description:
Data Engineer 2:
Summary:
- The main function of a data engineer is to ensure that the data assets of an organization are supported by an architecture that supports the organization in achieving its strategic goal.
- A typical data engineer is responsible for setting enterprise standards for databases, data integration, and the means to get to the data.
Responsibilities Include:
- Test programs or databases, correct errors and make necessary modifications.
- Modify existing databases and database management systems or direct programmers and analysts to make changes.
- Write and code logical and physical database descriptions and specify identifiers of database to management system or direct others in coding descriptions.
- Extract large, complex data sets that meet business requirements. Work to build the on-prem /cloud infrastructure for optimal extraction, transformation, and loading of a wide variety of complex business data from on-prem/cloud databases.
- Identify ways to improve data reliability, efficiency, and quality.
- Work with internal and external stakeholders to assist with data-related technical issues and support data needs.
- Own the design and development of ongoing business metrics/KPI, reports and dashboards to drive key business decisions.
- Prepare data for predictive and prescriptive modeling.
Typical Day:
- 7:30- 4pm workday
- Hybrid- 2 days in office, 3 days remote
- Work is typically directed by a direct supervisor, project or team lead.
- Decisions on routine, medium risk issues that may affect the project team, suppliers or internal customers may be made by this position.
- Challenges include meeting expectations in delivering results, learning to refine solutions to better fit complex situations, making timely decisions, and communicating effectively with all project stakeholders.
Education:
- Bachelor's degree in computer science or related field.
- 5-7 years of experience required.
Technical Skills Required:
- Familiarity with database such as Snowflake, DB2, SQL Server, Oracle (2-3 of these are required)
- Programming languages - SQL(required), Python(required) and SAS(preferred)
- Experience working with large data sets, preferably in several GB or millions of transactions.
- Visualization - PowerBI(required), Tableau(preferred)
- Experience working with platform integration tool like Snaplogic is preferred
- Experience working with AWS (required)
- Verbal and written communication skills, problem solving skills, customer service and interpersonal skills.
- Basic ability to work independently and manage one's time.
- Basic knowledge of logical data modeling and physical data modeling.
- Basic knowledge of computer software, such as SQL, Visual Basic, Oracle, etc.
Soft Skills Required:
- Communication
- Teamwork
- Problem Solving
- Customer Focus
Position's Contributions to Work Group:
The PSLD Transformation Analytics group engages with various stakeholders across the organization to help solve their business problems. The individual will run the entire project end to end, so strong skills in gathering/understanding customer requirements, creating and maintaining optimal data pipeline architecture, choosing appropriate tools/techniques and delivering actionable insights are must. They will also learn all relevant BU specific data and often combine them with relevant enterprise data domains to bring insights that are not possible if BU data alone is analyzed.
EEO Employer
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 require an accommodation in using our website for a search or application, please contact our Employee Services Department at or .
EEO Employer
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 require an accommodation in using our website for a search or application, please contact our Employee Services Department at or .
