Data Analyst, Associate

About The Company Brown and Caldwell is a renowned environmental engineering and construction services firm headquartered in Walnut Creek, California. With over 75 years of experience, the company has established itself as a leader in delivering innovative environmental solutions across North America. Operating through 50 offices and employing more than 2,100 professionals, Brown and Caldwell caters to municipalities, private industry, and government agencies. The organization is committed to excellence, collaboration, and sustainability, striving to be the preferred partner for clients seeking impactful environmental projects. The company's culture emphasizes continuous growth, technical expertise, and a dedication to making a positive environmental impact, providing employees with a dynamic and rewarding work environment. About The Role The Associate Data Analyst at Brown and Caldwell plays a vital role in supporting data-driven decision-making processes within the organization. This position involves performing comprehensive data analytics, creating dashboards, generating reports, and supporting various projects through high-quality data solutions. The role requires proactive data collection from diverse internal and external sources, meticulous data cleaning, validation, and analysis to uncover insights that inform strategic initiatives. Working under general supervision, the Associate Data Analyst collaborates with cross-functional teams such as marketing, product, finance, and operations to understand their data needs and translate these into actionable insights. The position offers an exciting opportunity for individuals passionate about data, analytics, and environmental solutions to contribute to impactful projects and organizational success. Qualifications Bachelor’s degree in Mathematics, Statistics, Economics, Computer Science, or a related quantitative disciplineMinimum of 2 years of relevant experience in Data Analytics or related fieldsProficiency in SQL for data extraction, transformation, and analysisAdvanced skills in Excel and Google Sheets, including pivot tables and complex formulasExperience with data visualization tools such as Tableau, Power BI, or Excel dashboardsStrong analytical skills with knowledge of statistical methods like regression, clustering, and hypothesis testingFamiliarity with programming languages such as Python or R for data manipulation and visualization (preferred)Excellent communication skills for presenting technical insights to non-technical stakeholdersDetail-oriented with a focus on data accuracy and integrityUnderstanding of data governance, privacy standards (GDPR, CCPA), and quality assurance practices Responsibilities Proactively gather data from internal systems such as CRM platforms, ERP systems, operational databases, and external sources including APIs, public datasets, and customer surveysApply robust data cleaning techniques, including handling missing data, correcting data types, removing duplicates, and standardizing formats to ensure high data qualityValidate data accuracy through cross-referencing with source systems, logic checks, and collaboration with domain expertsOrganize raw data into structured formats such as data tables, CSV files, or relational databases for analysis readinessConduct exploratory data analysis using statistical techniques to identify patterns, anomalies, and relationships within datasetsVisualize trends and key performance indicators over time using tools like matplotlib, seaborn, or Excel chartsTranslate analytical findings into actionable insights to support strategic initiatives including market expansion, product optimization, and customer retentionRespond to data inquiries from business units by investigating root causes, validating assumptions, and delivering data-backed solutionsDesign and build dynamic dashboards to track KPIs, operational metrics, and overall business performance using visualization platforms like Tableau or Power BIWrite efficient SQL queries to extract, join, filter, and aggregate data from relational databases such as MySQL, PostgreSQL, or SQL ServerLeverage Python or R to automate workflows, perform advanced analyses, and develop custom data pipelinesCollaborate with cross-functional teams to understand their data needs and translate them into technical requirementsMaintain comprehensive documentation of data sources, transformation logic, and business rules to ensure transparency and consistencyMonitor data integrity through validation checks, discrepancy reconciliation, and working with IT teams to resolve issuesHelp standardize data handling procedures by creating templates, SOPs, and training materials for team membersSupport mentorship of junior team members, sharing knowledge and best practices to foster team developmentAdapt to evolving organizational needs by executing additional data-related assignments as required Benefits Comprehensive health insurance including medical, dental, and vision coverageShort-term and long-term disability insurance and life insurance benefitsPaid time off, parental leave, and paid holidays to support work-life balance401(k) retirement savings plan with employer matching contributionsPerformance-based bonus eligibility and employee referral bonusesTuition reimbursement programs to support continuous learningAdditional perks such as pet insurance and long-term care insuranceEmployee assistance programs and wellness initiatives to promote overall well-being Equal Opportunity Brown and Caldwell is an equal opportunity employer committed to fostering a diverse and inclusive workplace. We do not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, veteran status, or any other protected class. We encourage applicants from all backgrounds to apply and welcome individuals with disabilities and protected veterans. Our commitment extends to providing a work environment where everyone can thrive and contribute to our mission of delivering sustainable environmental solutions.