Description:
This is a great opportunity to be a Azure Data Architect/Engineer across the compliance technology function. You will be responsible for design and build of a best-in-class data warehouse to support our business needs. You will work in a dynamic environment, partnering with data analyst, 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
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 Gen 2, Databricks
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
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.