Jobs
>
Troy

    Data Engineer/ Architect - Troy, United States - Softtek

    Default job background
    Manufacturing / Mechanical
    Description

    Data Engineer/ Architect

    Direct Hire

    Troy, MI / REMOTE

    Actively seeking a Data Engineer/Database Architect who possesses talent, passion and expertise to help design and implement highly scalable and available database solutions to support our growing business needs. Insights team is a new team with an exponential growth opportunity - both in terms of technology and personnel, and we are looking for someone to share our mission that will transform our company's future. As a Data Engineer/Database Architect, we expect this role to be critical in ensuring that our data solutions and architecture are designed to be scalable, reliable, and high-performance. This position offers excellent career growth and promotional opportunities, stellar compensation, and an opportunity to work with the world's premier provider of aftermarket automotive data. This company could very well be your best and last position in a rewarding and fulfilling career

    Primary Responsibilities

    Manage and administer databases, research, architect, and develop innovative multi-tiered solutions using modern tools and methodologies with a goal for technical excellence.

    Design and implement highly scalable and available database solutions.

    Perform database performance tuning and optimization.

    Design and develop ETL processes to integrate data from various sources.

    Collaborate with developers, architects, data scientists, and other stakeholders to understand data requirements and design appropriate data models.

    Develop and maintain backup and disaster recovery strategies.

    Ensure architecture and design of the solution is in alignment with overall enterprise architecture.

    Solve problems and proactively look for ways to improve our products and platform.

    Required Experience (must have)

    Expert SQL Server Development experience (Minimum 8 years' experience).

    Strong AWS Experience (Minimum 2+ years' experience) with AWS lambda functions (Python preferred), AWS databases (Aurora, DynamoDB, or Redshift preferred) and AWS storage services (EC2, S3 preferred).

    Strong ETL experience, with emphasis on complex transformations and large data sets.

    Multiple versions (MS SQL 2000 through MS SQL 2019 preferred).

    Expert backend designer, capable of managing high-level architecture while adding or optimizing components.

    Adept at optimizing and refactoring and upgrading legacy systems.

    Excellent performance tuning skills regarding data models and SQL code.

    Proven experience in designing and implementing highly scalable and available database solutions.

    Relentless troubleshooter and investigator, proficient with SQL Profiler, Extended Events, Query Store etc.

    Octopus Deploy, Red Gate SQL Change Automation, Red Gate SQL Toolbelt, or equivalent CI/CD.

    Quick learner: astute and perceptive; keeps up to date on new and emerging technologies

    Technical evangelist who can educate and mentor other SQL developers and strong automated testing experience.

    Excellent communicator -- articulate, persuasive, professional.

    Helpful Experience (nice to have)

    Bachelor's or Master's degree in Computer Science or related field.

    Data Lake experience or similar (AWS preferred).

    Experience in designing architecture to support future Big data technology solutions (nice to have).

    Graph Data Base and Graph Modeling experience (Neo4j- nice to have).

    TFS, Azure DevOps, or Jira project management/requirements management.



  • Ricardo plc Troy, United States

    Ricardo Defense has an opening for an experienced Systems Engineering Architect to join our engineering team. This Systems Engineering Architect position will primarily be remote with occasional travel possible to our office or customer sites. · The Systems Engineering Architect ...


  • Softtek Troy, United States

    Data Engineer/ Architect · Direct Hire · Troy, MI / REMOTE · Actively seeking a Data Engineer/Database Architect who possesses talent, passion and expertise to help design and implement highly scalable and available database solutions to support our growing business needs. Ins ...


  • NebulaTech Farmington, United States

    The planning office Baur & Oehm has been offering the specialist areas of architecture and engineering for 28 years with its interdisciplinary management in Farmington. · Our expertise in design and architecture covers measures in the state and federal construction sector for gov ...


  • Velocity Enterprises Farmington, United States

    Whether it's ministries or hospitals, barracks or military airports, research buildings for universities and colleges, special properties for police and justice, or the preservation of castles and palaces: we are the construction and real estate experts for the state of Rhineland ...


  • H2M architects + engineers Troy, United States

    H2M architects and engineers is seeking a Department Manager to join our well-established Troy, NY office. We seeks a dynamic professional engineer to direct projects, manage client relations, and develop and manage our Mechanical team (at various levels) on overall HVAC design/p ...

  • H2M architects + engineers

    Project Architect

    5 days ago


    H2M architects + engineers Troy, United States

    H2M architects + engineers, a multidiscipline architectural, engineering, environmental consulting firm seeks a Project Architect predominantly responsible for architectural CAD production and document coordination to join our team. · Come join our multi-disciplined team of archi ...


  • Detroit Engineered Products Sterling Heights, United States

    RESPONSIBILITIES · This role will with be responsible for what computing resources will be needed. · Will design the video architecture for the vehicle. · Designs the network architecture used for the vehicle. · Designs the time synchronization strategy to be used. · Will wo ...

  • WSP

    Managing Principal

    4 days ago


    WSP Troy, United States

    Great people. Great places. Great projects. kW Mission Critical Engineering, a WSP company, is a high-performance, fast-paced consulting engineering firm designing data centers and mission critical environments across the globe. We hire smart, responsive, team players to work in ...


  • Skyline Enterprises East Troy, United States

    "Our task has never been more important than it is today. As the largest state-owned IT company, we shape the path of public administration and society into the digital future. We protect the data of the state, companies, and citizens, building trust and guaranteeing the digital ...


  • General Dynamics Land Systems Sterling Heights, United States

    Job Description · A Systems Engineering Enterprise Architect will facilitate, strategize, and enhance our Integrated Digital Engineering Environment (IDEE). Focus will be on the digital engineering ecosystem and connecting engineering tools and data across engineering and other ...

  • Elit Builders

    Architect/Engineer

    6 days ago


    Elit Builders Oakland Park, United States Full time

    Architecture & Engineering · Location: 4520 NE 18th Ave, Oakland Park, FL 33334 · Qualifications: A self-starter with the ability to work collaboratively in a team setting with knowledge and interest in environmental and sustainable design · Strong technical and graphic ability ...


  • General Dynamics Sterling Heights, United States

    A Senior Systems Engineering Enterprise Architect will facilitate, strategize, and enhance our Integrated Digital Engineering Environment (IDEE). Focus will be on the digital engineering ecosystem and connecting engineering tools and data across engineering and other enterprise o ...


  • General Dynamics Sterling Heights, United States

    Responsibilities for this Position · Job description · Job Description · A Senior Systems Engineering Enterprise Architect will facilitate, strategize, and enhance our Integrated Digital Engineering Environment (IDEE). Focus will be on the digital engineering ecosystem and conn ...


  • tapwage Sterling Heights, United States Full time

    Job Description · A Senior Systems Engineering Enterprise Architect will facilitate, strategize, and enhance our Integrated Digital Engineering Environment (IDEE). Focus will be on the digital engineering ecosystem and connecting engineering tools and data across engineering and ...


  • Comerica Management Co Inc Auburn Hills, United States

    Data Engineering Domain Architect · The Data Engineering Domain Architect will participate in the creation and evolution of the technology road map that defines current technical architectures and future architectures for the Domain. The Domain Architect is the end-to-end subject ...


  • Velocity Solutions Clawson, United States

    .NET Software Engineer - Leading E-Book Company - Munich, Germany · (Technology stack: .NET Software Engineer, .NET 8, ASP.NET, C#, React, Angular 17, Microservices, TypeScript, Azure, Web API 2, Agile, SQL Server 2022, Programmer, Full Stack Developer, Architect, Software Develo ...

  • Raytheon

    Cloud Architect

    2 days ago


    Raytheon Sterling, United States

    **Date Posted**: · **Country**: · United States of America · **Location**: · VA543: 22270 Pacific Blvd, Dulles 22270 Pacific Boulevard Building CC5, Sterling, VA, USA · **Position Role Type**: · Onsite · **_ You have been redirected to RTX's career page as we have recently transi ...

  • Apex Ventures

    Landscape Architect

    1 week ago


    Apex Ventures Sterling, United States

    WipflerPLAN specializes in regional environmental design and infrastructure development. In our teams, we combine architectural and engineering services with creativity, knowledge, and foresight to create innovative holistic plans for the built environment. With over 220 employee ...


  • Harman International Industries Novi, United States

    HARMAN's engineers and designers are creative, purposeful and agile. As part of this team, you'll combine your technical expertise with innovative ideas to help drive cutting-edge solutions in the car, enterprise and connected ecosystem. Every day, you will push the boundaries of ...


  • American Battery Solutions Lake Orion, United States

    Job Description · Job DescriptionAmerican Battery Solutions has a full-time opening for an Engineering Tool Solution Architect in Lake Orion, Michigan. · Job Summary: · An Engineering Tool Solution Architect will be responsible for designing and implementing robust tool solutions ...