Apex Systems ยท 4 days ago
Solutions Engineer III
Jersey City, NJ
Full-time
Onsite
Senior Level, Lead/Staff
$70/hr - $73.68/hr
10+ years expApex Systems is a world-class IT services company that serves thousands of clients across the globe. They are seeking a Data Engineer to build and maintain robust data pipelines and analytics platforms, ensuring data integrity and performance across various systems.
Human ResourcesInformation TechnologyRecruiting
Responsibilities
Developing an understanding of stakeholders needs to help create a solution, envisions the solution to solve a problem (manually or through software
Analyzes the stakeholder process to build efficiencies and analyzes the software to improve or implement that process
Gathers and catalogs functional, non-functional, and technical requirements for stakeholder requests
Analyzes functional and data requirements. Answers the questions: What does the software do and how does it store information?
Assists users and development team with application testing and troubleshooting
Identifies, documents and troubleshoots application related problems
Documents process, procedures and workflows associated with applications
Creates and maintains training materials for end-users
Demonstrate exceptional analytical skills and problem-solving skills; excellent organizational, communication skills
A good team-player who seeks input and involves others in his/her communications; a person who values and cultivates relationships
Assist team with resolving technical complexities involved in realizing story work
Collaborate with other development teams to manage interdependency, set up test cases, debug and maintain data quality
Ensure software stability via documentation, code reviews, regression, unit and user acceptance testing
Hands on logical and physical data modeling and database design responsibilities
Perform data analysis and data profiling. Identify data quality issues
Qualification
Required
Experience with large data sets using big data solutions such as Hadoop, Spark etc
10+ years non-relational and relational DB's ETL looks like Informatica or others
Design and implement ETL (Informatica) process using SQL, ETL tool and Linux shell scripting to deliver high quality solutions
Experience automating ETL with job scheduling tools. Autosys Preferred- Should understand scheduler (Autosys)
10+ years of professional experience with SQL/PLSQL
Contribute to story refinement/defining requirements
Participating in and guiding teams in estimating work is necessary to realize a story/requirement through the delivery lifecycle
Perform spike/proof of concept as necessary to mitigate risk or implement new ideas
Code solutions and unit test to deliver a requirement/story per the defined acceptance criteria and compliance requirements
Utilize multiple architectural components (across data, application, business) in design and development of client requirements
Good understanding of Dimensional modeling
Be able to lead and develop Informatica PowerCenter ETL complex flows connecting to heterogenous database such as oracle/MS SQL server
Develop complex oracle procedures, functions, and packages to support database applications (API calls / DW reporting)
Conduct both proactive and reactive performance tuning activities during course of development of new applications and existing legacy applications
Hands on experience to develop and support Unix Shell Scripting
Preferred
Hadoop- good to have it, not mandatory for now
Benefits
Medical
Dental
Vision
Life
Disability
Other insurance plans
ESPP (employee stock purchase program)
401K program
HSA (Health Savings Account on the HDHP plan)
SupportLinc Employee Assistance Program (EAP) with up to 8 free counseling sessions
Corporate discount savings program
On-demand training program
Access to certification prep and a library of technical and leadership courses/books/seminars
Certification discounts and other perks to associations that include CompTIA and IIBA
Dedicated customer service team for our Consultants
Certified Career Coach
Company
Apex Systems
Apex Systems, a division of On Assignment, provides organizations with IT staffing solutions to address gaps in their current workforce.
1001-5000 employees
H1B Sponsorship
Apex Systems has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (28)
2024 (21)
2023 (35)
2022 (26)
2021 (29)
2020 (38)
Funding
Current Stage
Late StageLeadership Team
Roger Wahman
Chief Technology Officer - SVP
Andrea Schiola
Global Head of Technology Partnerships, SVP, Principal
Recent News
Company data provided by crunchbase