Associate Data Analyst

Brown and Caldwell
Denver, CO, United States
11 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Starter
Experience required
2 years minimum
Compensation
$33,280.0
Working hours
Regular working hours

Tech stack

Microsoft Excel Application Programming Interfaces (APIs) Artificial Intelligence Data Analysis Big Data Cluster Analysis Data Cleansing Data Governance Data Integrity Data Mining Data Presentation Data Visualization
+21 more
Relational Databases Excel Formulas Statistical Hypothesis Testing Python (Programming Language) PostgreSQL Meta-Data Management Microsoft SQL Server MySQL Operational Databases Pivot Tables Raw Data Power BI SQL Databases Tableau (Software) Data Processing Matplotlib Build Management Information Technology Data Analytics Data Pipelines Programming Languages

Job description

Perform data collection, cleaning, validation, exploratory analysis, and visualization to produce dashboards and reports. Write SQL and use Python/R and visualization tools to generate insights, support cross-functional teams, maintain documentation and data quality, and assist senior analysts on modeling and forecasting. The summary above was generated by AI

The Associate Data Analyst position performs data analytics for informed decision making, dashboards, report generation and overall project support. This role supports and contributes to organizational success by supporting the delivery of high-quality data solutions. Work is performed under general supervision with guidance provided for complex issues.

Responsibilities

  • Proactively gather data from diverse internal systems (e.g., CRM platforms, ERP systems, operational databases) and external sources (e.g., public datasets, APIs, third-party vendors, customer surveys).

  • Apply robust data cleaning techniques such as handling missing values, correcting data types, removing duplicates, and standardizing formats to ensure high data quality.

  • Validate data accuracy by cross-referencing with source systems, applying logic checks, and collaborating with domain experts to confirm assumptions.

  • Organize raw data into structured formats-such as data tables, CSV files, or relational databases-making it accessible and ready for analysis by analysts, data scientists, and business stakeholders.

  • Conduct exploratory data analysis using statistical techniques (e.g., regression, clustering, hypothesis testing) to uncover hidden patterns, anomalies, and relationships within datasets.

  • Visualize trends over time, segment customer behavior, and identify key performance drivers using tools like matplotlib, seaborn, or built-in Excel charts.

  • Translate analytical findings into actionable insights that support strategic initiatives such as market expansion, product optimization, or customer retention.

  • Respond to data-related inquiries from business units by investigating root causes, validating assumptions, and delivering clear, data-backed answers.

  • Design and build dynamic dashboards that track KPIs, operational metrics, and business performance using visualization tools like Tableau, Power BI, or Excel.

  • Write efficient SQL queries to extract, join, filter, and aggregate data from relational databases such as MySQL, PostgreSQL, or Microsoft SQL Server.

  • Leverage programming languages like Python or R to automate data workflows, perform advanced statistical analysis, and build custom data pipelines.

  • Collaborate with cross-functional teams-including marketing, product, finance, and operations-to understand their goals and translate them into data requirements.

  • Maintain detailed documentation of data sources, definitions, transformation logic, and business rules to ensure transparency and consistency across reports.

  • Monitor data integrity by setting up validation checks, reconciling discrepancies, and working with IT or engineering teams to resolve issues.

  • Help standardize procedures for data handling, reporting, and analysis by creating templates, SOPs, and training materials for team members.

  • Flexibility to adapt and execute various additional assignments based on evolving needs.

Mentorship

  • May provide mentorship, guidance, support, and knowledge-sharing to help less experienced team members develop their skills and grow within their roles., 42 Minutes Ago Remote or Hybrid Texas, USA 16-16 Hourly Junior 16-16 Hourly Junior Fintech * Professional Services * Sales * Financial Services Provide empathetic phone and email support to members, assist with onboarding and account setup, handle high-volume inbound calls, document interactions, and collaborate with team members to share best practices. Achieve

Customer Service

42 Minutes Ago Remote or Hybrid 18-18 Hourly Junior 18-18 Hourly Junior Fintech * Professional Services * Sales * Financial Services Provide empathetic phone and email support to members for onboarding, account setup, and ongoing inquiries. Listen, troubleshoot, document interactions, collaborate with team, and maintain high call volumes while coaching members toward financial solutions. Navan

Event Travel Manager

49 Minutes Ago Easy Apply Remote or Hybrid USA Easy Apply 68K-70K Annually Junior 68K-70K Annually Junior Fintech * Information Technology * Payments * Productivity * Software * Travel * Automation Serve as primary client liaison for Event Travel, providing end-to-end travel support, fare and booking management, program coordination from post-sale to billing, troubleshooting using agent tools, maintaining documentation and SLAs, training on travel platforms, and supporting team leads to maximize revenue and client ROI. Top Skills: AmadeusGoogle WorkspaceExcelMicrosoft PowerpointMicrosoft WordNavan TravelxenNavan/R&M SystemsNdcSabreSlack

What you need to know about the Colorado Tech Scene

With a business-friendly climate and research universities like CU Boulder and Colorado State, Colorado has made a name for itself as a startup ecosystem. The state boasts a skilled workforce and high quality of life thanks to its affordable housing, vibrant cultural scene and unparalleled opportunities for outdoor recreation. Colorado is also home to the National Renewable Energy Laboratory, helping cement its status as a hub for renewable energy innovation.

Key Facts About Colorado Tech

  • Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3
  • Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech
  • Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook)
  • Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures
  • Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute

Requirements

  • Proficiency in SQL for data extraction, transformation, and analysis

  • Advanced Excel and Google Sheets skills, including pivot tables and complex formulas

  • Experience with data visualization tools such as Tableau, Power BI, or Excel dashboards

  • Strong analytical skills with knowledge of statistical methods (e.g., regression, clustering)

  • Ability to perform exploratory data analysis and identify actionable insights

  • Familiarity with Python or R for data manipulation and visualization (preferred)

  • Skilled in cleaning, validating, and transforming large datasets

  • Excellent communication skills for presenting data to non-technical stakeholders

  • Collaborative mindset with experience working across departments

  • Detail-oriented with a focus on data accuracy and consistency

  • Knowledge of data governance, metadata management, and quality assurance practices

  • Understanding of data privacy and compliance standards (e.g., GDPR, CCPA)

  • Ability to identify process inefficiencies and recommend improvements

  • Experience supporting senior analysts with modeling, forecasting, and reporting, * Typically, a minimum of 2 years’ related work experience in Data Analytics or a related field is required., * A bachelor’s degree in a quantitative field (e.g., Mathematics, Statistics, Economics, Computer Science, or related discipline) is required.

About the company

Headquartered in Walnut Creek, California, Brown and Caldwell is a full-service environmental engineering and construction services firm with 50 offices and over 2,100 professionals across North America and the Pacific. For more than 75 years, we have created leading-edge environmental solutions for municipalities, private industry, and government agencies. We strive to be the company of choice-to our clients, who benefit from our passion for delivering exceptional quality, and to our employees, present and future, who share our commitment to client service, collaboration, and innovation. Join us, and you will find a home where you can do your best work, reach new levels of expertise, and enjoy exceptional development opportunities. For more information, visit www.brownandcaldwell.com

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on recruiting2.ultipro.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

3:03 min

Career evolution in data engineering and AI platforms

Maria Apazoglou · Coffee With Developers

1:46 min

Traditional data architecture before Microsoft Fabric

Dr. Alexander Wachtel Dr. Alexander Wachtel +1 · WWC 2025

3:28 min

Defining big data and machine learning fundamentals

Ayon Roy · LIVE

2:18 min

Scaling MySQL databases for massive user growth

Johannes Nicolai Johannes Nicolai +1 · LIVE

2:44 min

Integrating data analytics into the talent acquisition function

Kobi Kobi +1 · WWC 2025

3:48 min

Standardizing data access schemas with OData

Florian Bader Florian Bader · WWC Europe 2026

Videos

See all

Related articles

See all