This site uses cookies. To find out more, see our Cookies Policy

SQL Database Architect in Detroit, MI at VisionPRO

Date Posted: 6/24/2018

Job Snapshot

Job Description

Data Warehouse Developer SQL Server

  • Extensive experience in designing Databases, Data Warehouse/Marts using best practices such as dimensional modelling, Inmon and Kimball methodologies.
  • Extensive experience with Microsoft’s DW, BI, and reporting tools, SQL Server and complex SSIS packages, including knowledge of best practices and techniques for logging, auditing, error handling and performance tuning.
  • Deep expertise in data architecture, data modeling and data operations.
  • Ability to extract, merge and analyze data from a wide variety of sources (e.g., relational databases, text and unstructured files, real time and sensor data).
  • Experience designing, coding and automating moderately to complex data extraction, transformation and loading (ETL/ELT) process.
  • Proficient in writing complex SQL scripts and stored procedures to create, update and maintain application database.
  • Experience recognizing, investigating, and resolving data discrepancies and anomalies.
  • Exposure to web services like REST API or SOAP.
  • Some programming experience using XML,, C#, Python is preferred.
  • Experience providing data support, serving as a technical resource in resolving client issues related to database or other data issues and 0ther duties assigned.
  • Ability to work independently as well as within a team and ability to handle multiple priorities. Must be able to act as Team Lead with onshore & offshore technical groups
  • Ability to communicate with non-technical staff and translate their needs into appropriate systems, processes and reports.

    •         Project management

    •         Strong analytic, problem solving, and collaborative skills

    •         Knowledge and understanding of relational and dimensional data models

    •         Experience in business requirements gathering

    •         Strong knowledge of MS Office Suite (e.g. Project, PowerPoint, Excel, etc.)

    •         Excellent written and verbal communication skills

    •         Willingness to learn new technologies

    •         Ability to work off-hours when necessary to handle support requirements

    Technical skills

    •         SQL Server tools: Profiler / Performance Monitor/ Execution Plan

    •         SQL Server Performance Tuning & Query optimization

    •         Strong T-SQL development: Stored Procedures/views/Triggers/Functions

    •         SSIS (2012) : Visual Studio Data Tools, Data Flow tasks, Package configuration , ETL heterogeneous data sources setup, Deployment models, SSIS Data Catalog management, Environment setup

    •         SQL Server Agent (Jobs handling)

    •         SQL Server DBA (junior-level) functions: Backups/Restore/User Account management

    •         C#/.NET ( we use C# scripts inside SSIS script task)

    •         MS Excel

    •         JSON/ REST API


    •         Bachelor’s degree in technical discipline

    •         Microsoft Certification is a plus

  • About VisionIT: VisionIT is where integration and innovation intersect. We are a global software development company and a preferred systems integrator, operating throughout the U.S., Canada, and Latin America. Our 20 years of experience supporting Fortune 500 companies has earned us the trust of CIOs and C-Level executives, because we have a track record of providing business value. In our Detroit-based Innovation Studio, we showcase the latest technologies being developed by VisionIT and our partners across cloud, IoT, mobile, infotainment systems, and virtual/augmented reality. Learn more about our company by visiting