Data analyst intern - Excel, SQL Job at Deemsys, Inc, Denver, CO

ME1KMnJBSWRLSlBQOExFMm9iQmY1RHhaZ1E9PQ==
  • Deemsys, Inc
  • Denver, CO

Job Description

Salary: $50,257 - 60,524 per year Requirements:

  • Proficient in SQL for querying databases such as Microsoft SQL Server and Oracle.
  • Familiar with data visualization tools including Tableau, Power BI, or Looker.
  • Knowledge of ETL processes and tools like Talend or scripting languages such as Python or R.
  • Understanding of database design principles and best practices.
  • Awareness of SDLC methodologies and Agile project management frameworks.
  • Strong analytical abilities to accurately interpret complex datasets.
  • Capable of conducting business analysis to translate data insights into actionable recommendations.
  • Experience with linked data concepts and handling large datasets from multiple sources is desirable.
  • Familiar with VBA macros, Bash scripting, or other automation techniques is beneficial.
Responsibilities:
  • Collaborate with teammates to gather and clarify business requirements for data analysis initiatives.
  • Assist in the design and maintenance of databases, including management tasks using Microsoft SQL Server and Oracle.
  • Develop and implement ETL (Extract, Transform, Load) processes utilizing tools like Talend or Python for data preparation.
  • Create interactive dashboards and reports with Tableau, Power BI, Looker, or similar visualization tools to effectively communicate findings.
  • Support the development of data models and visualizations that aid in business analysis and decision-making processes.
  • Engage in Agile project management practices, which include sprint planning and stand-up meetings to ensure timely task completion.
  • Contribute to the documentation of SDLC (Software Development Life Cycle) processes and project workflows using tools such as Visio.
  • Assist in analyzing linked data sources and performing business analysis to uncover trends, patterns, and opportunities for improvement.
  • Support the team in database design tasks and optimize SQL queries to enhance performance.
  • Gain exposure to scripting languages such as R, VBA, Bash (Unix shell), and Python for automating data workflows.
Technologies:
  • Bash
  • ETL
  • Support
  • Looker
  • Oracle
  • Power BI
  • Python
  • SQL
  • Tableau
  • Talend
  • Unix
  • VBA

More:

We are excited to welcome a motivated and detail-oriented Data Analyst Intern to our dynamic analytics team. This paid internship offers a remarkable opportunity to cultivate your data analysis abilities while driving significant business insights. You will directly influence our processes, enhance reporting capabilities, and promote data-driven growth. This role is tailored for aspiring data professionals looking for hands-on experience with industry-leading tools and methodologies. We provide an innovative and collaborative environment dedicated to your professional growth. Join us and embark on your journey with a competitive compensation package and an array of benefits, including a 401(k) with a 7% match, green card sponsorship, health savings account, paid time off, and prescription drug insurance, all while enjoying the flexibility of a remote work location.

last updated 16 week of 2026

Job Tags

Remote work

Similar Jobs

Apollo Executives

Customer Acquisition Associate Job at Apollo Executives

Apollo Executives is seeking motivated individuals to join our growing team as Customer Acquisition Specialists. In this role, you will support marketing initiatives designed to help nationally recognized telecommunications brands expand their customer base and strengthen...

Pellissippi State Community College

Adjunct Instructor - Anthropology Job at Pellissippi State Community College

 ...Title: Adjunct Instructor Anthropology Required Documents Needed to Upload at Time of Application: Resume Unofficial Transcripts Position Summary: To provide quality instruction for student learning and to maintain a positive learning environment... 

Bank of America Corporation

Federal Government Relations Executive Job at Bank of America Corporation

 ...social responsibility issues and advocating those positions to government officials. Job expectations include maintaining strong...  ...stakeholders on important policy issues. The Federal Government Relations Executive will serve as a key advocate for the banks interests... 

Carowinds

Workforce Scheduler Job at Carowinds

Overview: $16 per hour This position reports to the Workforce Supervisor. They will assist associates with FUNtime, UKG/Kronos, and App questions. This position will also be trained to back up the Full-Time park schedulers ensuring all departments and associates... 

Visiting Nurse Association of Texas

LMSW Social Worker Job at Visiting Nurse Association of Texas

 ...We are seeking a compassionate and dedicated Medical Social Worker (LMSW) to join our clinical team. In this role, you will provide essential coordinated care and psychosocial support to patients of all ages within their home environments. If you are a resourceful...