Job Details
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
...@alinestaffing.com