New

Azure Data Engineer (ADF Experience Needed) (Onsite Interview - Local Candidates Only)

TEKsystems
$70.00 - $95.00 / hr
life insurance, sick time, 401(k), retirement plan
United States, New Jersey, Jersey City
Mar 13, 2025
Description Overview This is a great opportunity to join as an Azure Data Engineer across the compliance technology function. You will be responsible for design and build of a best-in-class trade and data repository to support our business needs. You will work in a dynamic environment, partnering with data analysts, ETL developers, vendors and consultants while being a Subject Matter Expert (SME) in the areas of compliance surveillance data sets, transactional data sets, and bank related reference data. Responsibilities Perform detailed data analysis (i.e. determine the structure, content, and quality of the data through examination of source systems and data samples) Understand and transform technical specifications into a data model, and database deliverables for the build out of our compliance trade data warehouse and metrics data warehouse Solve complex data engineering problems and lead system design and development activities including understanding the business processes/requirements while adhering to the data quality control framework Work in the Agile framework (including JIRA and Bit Bucket (for code management)) and collaborate with business and technology teams on the delivery of our strategic data platforms Optimize database queries, build out complex stored procedures, database objects, indices, triggers, data import and export routines, support user and role management, grants, schema, object management and session monitoring and other logging capabilities Code, test, deploy and maintain your code while supporting team members with training, code reviews, developing dev best practices, code management processes and procedures Understanding and commitment to data governance standards and data management best practices Performance tune SQL and identify technical deficiencies in queries and resolve them Apply strong knowledge in Python and Shell Scripting required for file processing and database connections Lead the data engineering estimating effort related to new capabilities, defect fixes and enhancements Additional Skills & Qualifications Qualifications Bachelor's Degree in Computer Sciences or a related field 3+ AZURE experience: Azure Data Factory (ADF), ADLS 5+ years database/warehouse design, and development, prior experience with SQL Server SSIS packages, Transact SQL, and query optimization experience Experience with Python, AutoSys and Unix a plus* Database and data warehousing design and implementation as well as dimensional modeling required Self-starter with great skills in teamwork, partnership, and communications both verbal and written Direct experience within the Banking & Finance field and knowledge of Capital Markets, trading related data required Pay and Benefits* The pay range for this position is $70.00 - $95.00/hr. Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role may include the following: * Medical, dental & vision * Critical Illness, Accident, and Hospital * 401(k) Retirement Plan - Pre-tax and Roth post-tax contributions available * Life Insurance (Voluntary Life & AD&D for the employee and dependents) * Short and long-term disability * Health Spending Account (HSA) * Transportation benefits * Employee Assistance Program * Time Off/Leave (PTO, Vacation or Sick Leave) Workplace Type This is a hybrid position in Jersey City,NJ. Application Deadline This position is anticipated to close on Mar 26, 2025. About TEKsystems: We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company. The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.