Azure SQL Server Developer

This is a great opportunity to work as a lead data engineer/SQL Server developer across the compliance technology function at our client. The qualified candidate 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 trade compliance, transactional and bank related reference data sets.

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 a 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

Required Skills & Qualifications:

• Bachelor’s Degree in Computer Sciences or a related field

• 7+ years of MS SQL Server database development

• 3+ years of database design, SSIS packages, Transact SQL, and query optimization experience

• 2+ years AZURE experience with Azure Data Factory (ADF) and Databricks required

• 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

• Candidates mush have experience or understanding of trading data

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.