Back 

Job Details


SQL Server Database Developer




Job Number: 119776
Offered Through: Brilliant Technology Staffing
Job Location: Chicago, IL
Job Type: Direct Hire
Degree:
Job Post Date: 12/03/2018
Job Description:

Our client is looking for a SQL Server Database Developer. This client is a home improvement and home furnishing company, specializing in installed carpet, flooring, and window treatments. The company operates in more than 75 metropolitan areas in the United States. Founded in 1959, they have been named the country&39;s 1 or 2 Specialty Flooring Retailer (in total dollar amount of sales). The SQL Server Database Developer is a direct hire role located in Chicago, IL

SQL Server Database Developer Requirements:

  • Demonstrate expertise in all areas of SQL Server database design and development.
  • Design tables with foreign key relationships, understand schema design best practices. Relational database design and normalization.
  • Create complex stored procedures, functions and views to extract and transform data prior to loading into our enterprise data warehouse. Understand how to use each join type, group by statements, common table expressions, sub-queries.
  • Understand how to work with bulk data operations for moving large amounts of data in the shortest time possible.
  • Optimize SQL for performance, understand how to read and tune SQL/joins based on query plans, design and implement the correct indexes to achieve optimal SQL performance.
  • Work with Business Intelligence Project Manager to translate business requirements into ETL specifications that will be used to transform and load data from our ERP application (Dynamics D365) to our Azure SQL Database.
  • Have a strong understanding of SSIS package development.
  • How to efficiently move data between multiple different data sources (including to/from Azure SQL database)
  • How to create and use variables, package configurations and expression-based properties.
  • Understanding data flow and control flow tasks including precedence constraints.

 

SQL Server Database Developer Qualifications:

  • 3 years’ previous experience in similar SQL Server Developer position.
  • Bachelors Degree. Equivalent combination of experience, education and training/certification will be considered.
  • Knowledge of data warehouse modeling.
  • Understanding of Azure SQL Database configuration.
  • Prior hands-on working knowledge with ERP applications and data models, particularly D365 for Operations, D365 for Sales and/or Dynamics AX
  • Must have strong experience with SQL managing bulk data operations, creating functions, stored procedures, queries, design tables

Apply Now Back to Opportunities





Submit           




Need More Info? Call Us 312.582.1800

Announcements

Brilliant Reports a New Five-Year High for Open Accounting and Finance Positions Going into Q1 2019
Brilliant Reports a New Five-Year High for Open Accounting and Finance Positions Going into Q1 2019
Thursday, December 13, 2018
Chicago-Based Brilliant Publishes 2019 Salary Guides for Accounting, Finance and Information Technol
Chicago-Based Brilliant Publishes 2019 Salary Guides for Accounting, Finance and Information Technol
Tuesday, November 27, 2018
Brilliant™ Named One of the Fastest-Growing US Staffing Firms for Fourth Straight Year
Brilliant™ Named One of the Fastest-Growing US Staffing Firms for Fourth Straight Year
Tuesday, August 28, 2018

Brilliant Weekly

Stay up to date with the latest information affecting accounting and finance professionals in today’s market.

Check out the latest blog here »

SUBSCRIBE

Sign up for our weekly emails to receive the latest information and news about Brilliant and other industry content.

Sign Up Now »