Database Analyst

People Results; Troy (MI); Remote; USD 72,000 - 82,000; Full time

Job summary

A leading consultancy seeks a Database Analyst to enhance their data management and support analytics efforts. In this virtual role, you will design and maintain efficient databases, ensuring security and performance while collaborating with various teams. Ideal candidates will possess a degree in Computer Science or related fields, and demonstrated expertise in SQL and database optimization.

Qualifications

• Proven experience as a Database Analyst or similar role.
• Experience with large datasets and optimization.
• Knowledge of scripting languages like Python or R is a plus.

Responsibilities

• Design, build, and maintain databases and data systems.
• Develop and optimize SQL queries and reports.
• Ensure data accuracy, consistency, and security.

Skills

SQL/T-SQL

Problem-solving

Analytical skills

Data governance

Cloud-based databases

Education

Bachelor's degree in Computer Science

Bachelor's degree in Information Systems

Tools

SSIS

SSRS

MySQL

PostgreSQL

SQL Server

Job description

Description

About People Results

People Results is the leading consultancy for partnering with organizations to manage labor relations, enhance communication, and bolster employee engagement. We believe the greatest strength of any organization is its people.

About The Position

The Database Analyst will be responsible for designing, maintaining, and optimizing our databases and data stores to ensure the integrity, accessibility, security, and performance of our data systems. This role involves working closely with various practice areas to provide actionable insights, improve data processes, and support business decision-making.

The Database Analyst reports to the Lead Research Consultant of the Research and People Analytics Practice.

Essential Duties And Responsibilities

The database analyst will deliver a broad range of services to People Results clients. The following descriptions of services are examples of the work the database analyst may be asked to perform, but additional types of services may also be required.

• Design, build, and maintain databases and data systems (e.g., MySQL, PostgreSQL, SQL Server).
• Develop and optimize SQL queries, stored procedures, and reports.
• Ensure data accuracy, consistency, and security.
• Collaborate with team members to identify data needs and support reporting and analytics efforts.
• Monitor database performance and implement improvements where needed.
• Develop documentation for database systems, procedures, and best practices.
• Assist in data migration, integration, and backup processes.
• Support the company’s business intelligence and reporting needs.
  
  

Requirements

• Proven experience as a Database Analyst or similar role.
• Bachelor's degree in Computer Science, Information Systems, or a related field (or equivalent experience).
• Proficient in SQL/T-SQL and relational database management systems.
• Competent in working with very large datasets, with an emphasis on optimizing performance, particularly with tree-shaped/hierarchical data and completely unstructured data.
• Familiarity with data governance, security practices, and compliance requirements.
• Strong problem-solving and analytical skills.
• Comfortable working in a small, dynamic team environment.
• Knowledge of cloud-based databases (e.g., AWS RDS, Google Cloud SQL).
• Experience with scripting languages (e.g., Python, R) for data processing.
• Understanding of basic front-end or back-end development is a plus.
• Ability to translate business needs into technical solutions.
• Experience with SSIS / SSRS.
  
  

Additional Requirements

• Must maintain complete confidentiality on all client matters at all times.
• Must be able to use independent judgment and be able to work cooperatively in a team environment, often in a virtual/remote format.
• Must possess strong critical thinking and problem-solving skills.
• Must demonstrate a high degree of agility and adaptability to changing conditions and demands.
• Must be organizationally savvy to maneuver successfully through complex dynamics across diverse channels of business.
• Ability to relate effectively to people at all levels within an organization.
• Ability to successfully manage multiple projects, including several client projects simultaneously.
• Experience and comfort working in a virtual or remote environment, including limited interaction with co-workers beyond technological connection.
  
  

WORK ENVIRONMENT AND PHYSICAL DEMANDS

The work environment characteristics and physical demands described represent those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions.

The position primarily works virtually from home, and during those times, the person must maintain a work environment that is free from any distractions, such as childcare responsibilities or other personal responsibilities, which could inhibit the person's ability to be entirely focused, and work performed at home.

Pay: The pay range for this position is $72,000-$82,000. People Results takes into consideration a wide range of factors in making compensation decisions including, but not limited to skill sets, experience, training, qualifications, education and other business and organizational needs.