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

Mnh5aUFnSlZZaDBNcXNWUXZZVy9VM3Q4QUE9PQ==
  • 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 18 week of 2026

Job Tags

Remote work

Similar Jobs

SGS Consulting

Software Engineer IV - Media streaming Job at SGS Consulting

 ...Job Responsibilities: Bachelors in computer science, engineering, etc. Related to role. Over 5 years of experience in one of the...  ...RTC protocols (WebRTC/RTP), Codecs(H.264, VP9, AV1), Network programming(TCP/UDP/Real time transmission), GPU programming (CUDA). Design... 

BJC Healthcare

Clinical Nurse Outpatient Infusion Job at BJC Healthcare

 ...Comprehensive Benefits ~ Prefer Infusion Experience ~ The BJC RN Career Ladder differentiates BJC as the place for nurses to work...  ...102-bed community hospital provides comprehensive inpatient and outpatient services including the Siteman Cancer Center at Barnes-Jewish St... 

Julia Day Nursery of Ansonia Inc.

Preschool Assistant Teacher Job at Julia Day Nursery of Ansonia Inc.

Summary Instruct preschool-aged children in activities designed to promote social, physical, and intellectual growth needed for primary school in preschool, day care center, or other child development facility. May be required to hold State certification. Duties...

Tutor Me Education

Online Instructor Job at Tutor Me Education

Tutor Me Education is reshaping how students learn. We are looking for teachers and tutors with virtual tutoring experience to provide 1:1 or group instruction to students all across the country! Apply Here: Here are the details: Virtual instruction from your...

Consilio LLC

Forensic Analyst Job at Consilio LLC

The Forensic Analyst leads, conducts, and assists in data preservation and digital investigations in complex litigation cases by leveraging knowledge of digital forensic tools, technology and protocols related to the collection and management of electronically stored information...