Data Architect - Hybrid - No C2C

Troy, MI

Posted: 05/13/2024 Job Number: ATORCHINE32

Job Description

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 and available database solutions to support our growing business needs. Client’s 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.


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.

If you think this position is a good fit for you, please reach out to me - feel free e-mail me, or apply to this posting!
Andrew Torchine

Apply Online
Apply with LinkedIn Apply with Facebook Apply with Twitter

Send an email reminder to:

Share This Job:

Related Jobs:

Login to save this search and get notified of similar positions.

About Troy, MI

Ready to take your career to new heights? Discover exciting job opportunities in and around Troy, Michigan, and unlock your potential in this vibrant and dynamic region. Located in the heart of Metro Detroit, Troy offers a perfect blend of urban convenience and scenic beauty, with renowned art galleries like the Detroit Institute of Arts just a short drive away, top-tier theaters like the Fox Theatre, and thriving businesses providing ample room for professional growth. Indulge in the diverse culinary scene, including local favorites like Detroit-style pizza, and catch a game to cheer on the Detroit Lions at Ford Field or the Detroit Tigers at Comerica Park. With a plethora of parks, such as Boulan Park and Sylvan Glen Lake Park, and a strong sense of community, Troy is the ideal place to build your career and enjoy a fulfilling lifestyle.