Jobs
>
Troy

    Data Engineer/ Architect - Troy, United States - Softtek

    Softtek
    Default job background
    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 companys 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.



  • Hearst Troy, United States Full time

    MOTOR Information Systems, an owned subsidiary of Hearst, is 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. MOTOR' ...


  • 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. Insigh ...


  • 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 ...


  • General Dynamics Sterling Heights, United States

    Responsibilities for this Position · Job description · 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 ...


  • 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 ...


  • 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 ...

  • Elit Builders

    Architect/Engineer

    3 weeks 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 ...


  • BAE Systems Sterling, United States Full time

    Job Description We are looking for experienced Cloud Professional Engineers to join our technology-based program supporting a key government customer. This program will deliver engineering services for network infrastructure as well as sophisticated enterprise computing infrastru ...


  • 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 ...


  • FLEX Inc Farmington, United States

    The Sr. Mechanical Architect and Technology Engineer will be based in Farmington Hills, MI. You will be a member of a team of high-performance computing specialists developing advanced Autonomous Vehicle and Computing systems. You are a hands-on, mot Mechanical, Technology, Engin ...


  • Scout Motors Novi, United States

    Scout Motors · Here at Scout Motors, we're carrying forward the heritage of one of the most iconic American vehicles in history. A vehicle dating back to 1960. One that forged the path for future generations of rugged SUVs and will do so once again. · But Scout is more than just ...


  • 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 ...

  • A-Line Staffing Solutions

    Data Architect

    3 days ago


    A-Line Staffing Solutions Troy, MI, United States

    Title: Data Architect · Location: Troy, MI - Hybrid · Note: This position is a direct hire on W2, and is NOT open to C2C · Our client is actively seeking a Data Engineer/Database Architect who possesses talent, passion and expertise to help design and implement highly scalable an ...


  • Smart Synergies Sterling, United States

    Seeking a System Engineer/Solutions Architect with enterprise-wide experience to support the Navy with all aspects of designing and implementing the Integrated Navy Operations Command and Control System (INOCCS), to include an out-of-band management network, operating models, and ...


  • Hearst Troy, United States Full time

    MOTOR Information Systems, an operating group of Hearst, is actively seeking a team of enthusiastic, creative, and driven technologists. People with a proven track record, who are willing to experiment with new ideas, invest time in them, fail-fast, and move on if they don't work ...


  • WSP Troy, United States Regular, Full

    This Opportunity · kW Mission Critical Engineering is currently initiating a search for a Fire & Life Safety Engineer that can be located out of any of our kW offices which include the following locations: New York, New York - Troy, NY - Milwaukee, WI - Atlanta, GA - Tempe, AZ. A ...

  • Gpac

    Truss Designer

    1 week ago


    Gpac Troy, United States Full time

    Our client is a leading provider of innovative construction solutions with a strong commitment to quality and customer satisfaction. We are seeking a highly skilled Truss Designer to join our client's dynamic team. If you are passionate about construction, possess a strong attent ...