Data Engineer/Database Architect
Troy, MI, United States
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’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. Hearst and MOTOR Information Systems 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.
Being MOTOR Driven is Being Diversity Driven
We are MOTOR driven. At MOTOR, we are driven by diversity and creating an inclusive and welcoming workplace that celebrates our differences. Being MOTOR driven is celebrating your uniqueness. #MOTORDriven
EEO Employer
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Architecture AWS Azure Big Data CI/CD Computer Science DevOps DynamoDB EC2 ETL Jira Lambda MS SQL Neo4j Python Redshift Research SQL Testing
Perks/benefits: Career development Startup environment Team events
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Data Science Manager jobs
- Open Lead Data Analyst jobs
- Open Marketing Data Analyst jobs
- Open Data Engineer II jobs
- Open Senior Business Intelligence Analyst jobs
- Open MLOps Engineer jobs
- Open Principal Data Engineer jobs
- Open Data Scientist II jobs
- Open Power BI Developer jobs
- Open Data Analytics Engineer jobs
- Open Business Intelligence Developer jobs
- Open Junior Data Scientist jobs
- Open Business Data Analyst jobs
- Open Sr Data Engineer jobs
- Open Data Analyst Intern jobs
- Open Product Data Analyst jobs
- Open Sr. Data Scientist jobs
- Open Senior Data Architect jobs
- Open Research Scientist jobs
- Open Big Data Engineer jobs
- Open Data Quality Analyst jobs
- Open Azure Data Engineer jobs
- Open Principal Data Scientist jobs
- Open Manager, Data Engineering jobs
- Open Junior Data Engineer jobs
- Open Data quality-related jobs
- Open GCP-related jobs
- Open Java-related jobs
- Open ML models-related jobs
- Open Business Intelligence-related jobs
- Open Data management-related jobs
- Open Privacy-related jobs
- Open Deep Learning-related jobs
- Open PhD-related jobs
- Open Data visualization-related jobs
- Open Finance-related jobs
- Open PyTorch-related jobs
- Open NLP-related jobs
- Open TensorFlow-related jobs
- Open APIs-related jobs
- Open Consulting-related jobs
- Open LLMs-related jobs
- Open CI/CD-related jobs
- Open Generative AI-related jobs
- Open Snowflake-related jobs
- Open Kubernetes-related jobs
- Open Hadoop-related jobs
- Open Data governance-related jobs
- Open Databricks-related jobs
- Open Airflow-related jobs