Contract Data Engineer
Job ID: CER 1899
Location: Iselin, NJ, 08830
Schedule: Hybrid
Terms: 1099 or W2
Compensation: Hourly Rates listed on SkillsMatrix
Instructions to Apply Online:
- Look for the above Job ID & Click on it to find Job Details
- You will find an URL to SkillsMatrix within the Job Description
- Click on SkillsMatrix URL go to File > Select Download option > Select .doc version, Fill it & Save it
- Now Click on "Apply Now" on the same Job Description page and fill all the required details (Mandatory: Resume, SkillsMatrix, LinkedIn)
Note: Applications via certecinc.com/jobs ONLY will be reviewed
We'll cut off considering resumes on 11/25 at Noon CST.
Responsibilities:
- Hands on experience designing, modeling and developing Enterprise Data Warehouse solutions.
- Hands on experience coordinating and executing SIT and UAT testing for Enterprise Data Warehouse solutions.
- Proficient writing SQL queries and programming including stored procedures and reverse engineering existing process
- Leverage SQL, programming language (Python or similar) and/or ETL Tools (Azure Data Factory, Data Bricks, Talend, SSIS etc) to develop data pipeline solutions to ingest and exploit new and existing data sources.
- Proficient on data analysis and complex problems resolution
- A significant contribution to an enterprise-wide Cloud Data Platform migration.
- Participate in the improvement of our DevOps initiatives
Nice to Have:
- Azure Cloud platform experience.
- Azure Data Factory or similar ETL tool.
- Azure Data Bricks experience.
- Columnar Data Warehouse solution like Snowflake, RedShift, Vertica, Greenplum.
- Any capital markets industry knowledge or experience.
- Snowflake development experience
- SQL Server development experience
Qualifications:
- The right candidate will be able to work independently in a fast-paced environment with minimal direction
- As a key contributor, you will be expected to perform detailed analysis, develop and foster key operational relationships with stakeholders, and understand all facets of our technology planning, delivery and operational sustainment capability
- Understands and/or performs physical modeling and metadata analysis efforts
- Provides database design guidance and work with DBAs in Enterprise Database Management group to troubleshoot problems and optimize performance
- Provides support for ongoing data management efforts in Development, QA and Production environments
- Experience designing, modeling and developing Enterprise Data Warehouse solutions.
- Proficient writing SQL queries and programming including stored procedures and reverse engineering existing process
- Provides guidance and direction to less experienced staff in resolution of escalated issues and/or complex production, application or system problems
- Develops new documentation
- Assures quality, security and compliance requirements are met for supported area and oversees updating and testing of the business continuation plan
- 6+ years of experience in development of high-availability, high volume transactional processing systems
- Proficiency in working with systems required to effectively process large volumes of both real-time and batch transactions
- Perform activities in order to sustain enhancements and release activities for Snowflake platform
- Complex data analysis across all Software inventories with emphasis on understanding the financial and operational risks in order to drive recommendations and change
Education:
- Minimally a BA degree within an engineering and/or computer science discipline
