Senior Data Engineer

Predictive Strategies Inc

Senior Data Engineer

Bloomfield Hills, MI
Full Time
Paid
  • Responsibilities

    Benefits:

    401(k)

    401(k) matching

    Competitive salary

    Dental insurance

    Health insurance

    Paid time off

    Parental leave

    Vision insurance

    Overview

    We are seeking a skilled Data Engineer to join our team. The ideal candidate will be responsible for designing and implementing data solutions to support our organization's data needs.

    Responsibilities

    Design, construct, install, test, and maintain highly scalable data management systems including ETL processes, stored procedures, etc.

    Develop and implement databases, data collection systems, data analytics, and other strategies that optimize statistical efficiency and quality

    Design, develop, and maintain SSIS packages in an Azure environment

    Work with management to prioritize business and information needs

    Locate and define new process improvement opportunities

    Work with the team to implement new technologies such as Azure Fabric/Data Factory/Databricks

    Qualifications

    Strong experience in database design and management

    Knowledge of Data warehouse concepts and technology such as Azure Synapse

    Strong problem-solving and communication skills

    5+ years of demonstrable ability to write complex, high-performant SQL queries in Transact-SQL (T-SQL)

    5+ years of experience in the design, development and management of SSIS ETL packages

    2+ years of experience in working in Azure SQL database environments

    Experience with large-scale databases (500m+ records)

    Bachelor’s degree or better

    Applicants must reside within the United States

    This is a remote position.