Troy, MI Production Jobs

TITLE: Senior Database Architect

DUTIES: *** Business Publishing, Inc. seeks Senior Database Architect in Troy, MI to research, architect, and develop innovative multi-tiered solutions using modern tools and methodologies. Work closely with developers, architects, and stakeholders to provide project estimates based on customer experience, features, and envisioned solutions. 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 platforms. Modernize the existing database infrastructure. Perform data migration, data warehousing and create reports. Automate and optimize current solutions. Perform production support and do critical bug and issue fixes. Communicate effectively and fluently while working in close coordination with the team. Train, guide, and mentor others by reviewing team code and offering suggestions and improvements for others to follow, while maintaining and elevating organizational standards and best practices. Determine best paths and strategies for migrating to and adapting new technologies while minimizing the costs and risks to the organization. Architect efficient new database structures, optimize and maintain existing structures, and automate jobs and processes that do not require human interaction. Serve as cloud architect and migrate servers and data across platforms - both on-premises and in the cloud, designing and architecting solutions that would resolve current and future data-related issues, and envisioning data solutions that would help the organization perform its business at optimum levels while being duly prepared for future challenges.

REQUIREMENTS : Master's degree or foreign equivalent in Applied Computer Science, Information Technology, or a related field and nine (9) years of experience in the job offered or related occupation: designing and developing SQL database; planning, designing, executing legacy SQL server upgrades; creating SSIS packages and SQL solution for data migration; designing and developing data warehouse solution using SSAS; creating SSRS reports of the data available in warehouse and SQL databases; designing and creating SQL based test solutions for data reconciliation and compatibility; performing database related bug fixing and debugging; performing SQL based feature enhancement and performance optimization; implementing SQL best practices; managing and implementing SQL server security and data audits; and automating of SQL database deliveries and recurring processes. Telecommuting and/or working from home may be permissible pursuant to company policies.

QUALIFIED APPLICANTS: Please apply directly through our websitewww. *** .com/careers & indicate job code SD112823WEB.

#LI-DNI

The Content Analyst is Responsible for working in department activities related to the automated capture of data, the research of applicable data, and the identification of vehicle applications to the researched data.

Daily and Monthly Responsibilities

• Analyze and interpret vehicle information as it relates to data researched from multiple formats including:
  • Part descriptions and other attributes
  • Print formats (paper catalogs, microfiche, DVD)
  • Internet research
  • Dealer visits, brochures
• Website content may be acquired in both text and image formats and may require various levels of editing. Acquired content will be mapped to specific vehicle applications (i.e., year, make, model, etc.) as well as systems, locations, components, etc., using proprietary tools. Load data to database repository using proprietary tool and troubleshoot any issues resulting from the load.
• Execution of quality assurance processes to ensure published content meets product and end-user expectations
• Assist in resolving customer concerns

Skills and Qualifications Required

• Demonstrated knowledge of vehicle parts, systems, ser *** and repair operations, relationships, and nomenclature for light duty as well as medium-heavy duty vehicles
• Ability to work with a stringent deadline while maintaining the quality of work
• Self-motivated, results-oriented team player, with an ability to work effectively in a remote/offsite capacity
• Basic skill level with Microsoft Office applications
• Data entry and cleanup of existing database as defined for team products
• Possess strong analytical thinking, with an attention to detail
• Proven ability to produce high-quality, accurate content
• A passion for the automotive world
• Strong written and verbal communication skills
• Associate degree from accredited college or university or equivalent industry experience

Preferred Qualifications

• Industry certifications
• Extensive knowledge of vehicle parts/systems and basic operations of an Electronic Parts Catalogs
• Familiarity with database concepts
• Knowledge of industry related applications
• Technical degree, certificate in Automotive/Truck repair or three+ years' experience working with an OEM or aftermarket company on parts catalogs for passenger cars, light-duty trucks, or medium/heavy duty
• Understanding of automotive or industry taxonomies

MOTOR data is involved in billions of transactions annually across multiple segments of the industry. If you have ever taken a vehicle in for an oil change, received an estimate for mechanical or collision repair, or purchased a part online or in a store, you've benefited from MOTOR data. In addition, the fleets of cars and trucks that deliver your goods and services are maintained using MOTOR data.

Headquartered in Troy, Michigan, MOTOR is a *** company. *** is one of the nation's largest diversified *** , information and services companies with more than 360 businesses. Its major interests include ownership in cable television networks such as *** , HISTORY, Lifetime and *** ; majority ownership of global ratings agency Fitch Group; *** Health, a group of medical information and services businesses; 30 television stations such as ****-TV in Boston and ****-TV in Sacramento, Calif., which reach a combined 19 percent of U.S. viewers; newspapers such as the Houston Chronicle, San Francisco Chronicle and Albany Times Union, nearly 300 magazines around the world including Cosmopolitan, ELLE, Harper's BAZAAR and Car and Driver; digital services businesses such as iCrossing and ****A; and investments in emerging digital and video companies such as BuzzFeed, *** , Complex Networks and *** TV.

As a member of the *** team we offer our employees superior benefits, compensation and career development opportunities created to attract and retain the top candidates.