Sr Database Engineer with Data Warehousing/Data Modeling (SK)

The pay rate is $85 to $100 per hour.

Seeking a highly skilled and experienced Database Engineer with Data Warehousing/Data Modeling. The ideal candidate should have a strong background in SQL Server database Engineering and possess 7 to 20 years of relevant experience in the field. As a Database Engineer, you will play a crucial role in the design, development, and maintenance of our databases, ensuring optimal data organization, performance, and integrity.

Responsibilities:

1. SQL Server Database Development: Develop and maintain SQL Server databases, ensuring data accuracy, security, and performance. Implement best practices for database design and optimization.

2. Query Writing: Create efficient and well-structured database queries, stored procedures, functions, and other database objects to support application requirements and data processing needs.

3. Data Warehousing: Possess good experience in Data Warehousing, including designing and building data warehouses to facilitate effective data reporting and analysis.

4. Data Modeling: Participate in data modeling activities to design and optimize database structures, ensuring data is appropriately structured for efficient retrieval and storage.

5. ETL (Extract, Transform, Load): Develop ETL processes to extract data from various sources, transform it into the required format, and load it into the databases.

6. Requirement Translation: Work closely with business analysts and stakeholders to translate business requirements into detailed database specifications and data models.

7. Financial Services Industry Experience: Prior experience in the Financial Services industry is required.

Plusses:

1. Snowflake Cloud Database: Experience with Snowflake cloud database is a strong advantage, as we embrace cutting-edge technologies to enhance our data infrastructure.

2. Front Office Experience: Familiarity with Front Office operations and data requirements is a plus, as it will enable the candidate to better align database development with business needs.

3. Oracle: While SQL Server expertise is the primary requirement, additional experience with Oracle database would be advantageous.