Data Scientist

Tech Consulting; United States; On-site; MXN 946,000 - 1,461,000; Full time

Job summary

Tech Consulting in the USA is seeking an entry-level Data Scientist (Machine Learning-Data) to assist in designing, developing, testing, and maintaining database solutions while working with large datasets. This role emphasizes database and data management skills and offers a path into data-driven decision making.

Ideal candidates are recent graduates or interns eager to build careers in ETL/SQL/data development, data quality, and reporting, collaborating with engineers and analysts to deliver

Qualifications

• Proficiency in SQL and data manipulation.
• Experience with relational databases (SQL Server, Oracle, MySQL, PostgreSQL).
• Familiarity with ETL concepts and data warehousing basics.
• Strong analytical and problem-solving abilities.

Responsibilities

• Develop, test, and maintain SQL queries, stored procedures, and views.
• Write optimized SQL to retrieve and analyze data.
• Assist in designing relational database structures.
• Perform ETL/ELT data loading and validation tasks.
• Analyze data and generate business reports.
• Troubleshoot and resolve database issues.
• Monitor query performance and optimize databases.
• Collaborate with developers, analysts, and DBAs.
• Ensure data accuracy, integrity, and security.
• Assist with data warehouse projects and migrations.
• Document designs, scripts, and processes.
• Stay updated with database technologies.

Skills

SQL Programming

Relational Databases

ETL Basics

Data Analysis

Git Version Control

Analytical Skills

Teamwork

Problem Solving

Education

Bachelor's degree in CS/Math/Stats or related field

Tools

SSIS

Informatica

Talend

Power BI

Job description

Job Title: Data Scientist

Job Type: Full-Time

Location: Candidate must be open to relocation within the USA

We are seeking a motivated Entry-Level Software Engineer (Machine Learning-Data) with a strong interest in database development, data analysis, and data management. The ideal candidate will assist in designing, developing, testing, and maintaining database solutions while working with large datasets and supporting data-driven business decisions. This role is ideal for recent graduates or candidates with internship or project experience who are eager to build their careers in ETL/SQL/Data development and database technologies.

Key Responsibilities

• Develop, test, and maintain SQL queries, stored procedures, functions, views, and database objects.
• Write efficient and optimized SQL queries to retrieve, analyze, and manage data.
• Assist in designing and maintaining relational database structures.
• Perform data extraction, transformation, validation, and loading activities.
• Analyze data and generate reports to support business and operational requirements.
• Troubleshoot and resolve database-related issues.
• Monitor query performance and assist with database optimization.
• Collaborate with developers, data engineers, business analysts, and database administrators.
• Ensure data accuracy, consistency, integrity, and security.
• Assist with database migration, integration, and data warehouse projects.
• Document database designs, SQL scripts, technical processes, and solutions.
• Stay updated with emerging database technologies and industry best practices.

Required Skills

• knowledge of SQL programming.
• Familiarity with relational databases such as SQL Server, Oracle, MySQL, or PostgreSQL .
• Understanding of database concepts, including tables, relationships, keys, indexes, views, and constraints.
• Knowledge of joins, subqueries, Common Table Expressions (CTEs), and window functions.
• Basic understanding of stored procedures, functions, triggers, and database transactions.
• Familiarity with database design and normalization concepts.
• Basic knowledge of data analysis and reporting.
• Understanding of data quality, validation, and integrity principles.
• Familiarity with Git or other version control systems.
• Strong analytical, troubleshooting, and problem-solving skills.
• Good communication and teamwork abilities.

Preferred Skills

• Experience with Microsoft SQL Server, Oracle Database, MySQL, or PostgreSQL.
• Familiarity with ETL tools such as SSIS, Informatica, Talend, or AWS Glue.
• Knowledge of data warehousing concepts, including star and snowflake schemas.
• Exposure to reporting and visualization tools such as Power BI, Tableau, or SSRS.
• Basic knowledge of Python or another programming language.
• Familiarity with cloud database services on AWS, Azure, or Google Cloud Platform (GCP).
• Understanding of database performance tuning and query optimization.
• Exposure to Agile or Scrum development methodologies.

Thanks,