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

V3RSblhybi9TM2hqSVRLazhTTnAxOU92Nnc9PQ==
  • 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

Civica UK Ltd

Product Consultant - Local Government (P653) Job at Civica UK Ltd

 ...Were Civica and we make software that helps deliver critical services for citizens all around the world. From local to state government, to education, to health and care, over 5,000 public bodies across the globe use our software to help provide critical services to over... 

Confidential

Oracle Database Administrator Job at Confidential

 ...thrive, make a difference and be part of a culture where individuality is noticed and valued every day. Conduent is seeking an Oracle Database Administrator (DBA) wholl participate with the day-to-day operational aspects of application and infrastructure delivery.... 

BJC Healthcare

ICU Registered Nurse-PT Job at BJC Healthcare

 ...The BJC RN Career Ladder differentiates BJC as the place for nurses to work in the greater St. Louis area. This is a tool to empower...  ...Education ~ Nursing Diploma/Associate's - Nursing Experience ~ No Experience Supervisor Experience ~ No Experience... 

Dermafix Spa

Spa Manager Job at Dermafix Spa

 ...Sales Manager URGENT!! Ourspa is on the lookout for a dedicated and passionate sales expert to join our team as a Sales Manager; you'll play a vital role in promoting and selling our range of treatments, packages, and skincare regimens while providing expert advice... 

Belay Technologies

Full Stack Software Engineer Job at Belay Technologies

 ...and a finalist in 2021! Belay Technologies is seeking a Software Engineer to join our Intel team.This high-priority position offers...  ...but not limited to, geographic location, Federal Government contract labor categories and contract wage rates, relevant prior work...