Associate Data Analyst

Seattle, WA 701 Pike St Seattle, WA 98101, USA Seattle, WA 701 Pike St Seattle, WA 98101, USA San Francisco, CA 77 Geary St 5th Floor Office 665 San Francisco, CA 94108, USA San Francisco, CA 77 Geary St 5th Floor Office 665 San Francisco, CA 94108, USA Atlanta, GA 990 Hammond Drive Suite 500 Atlanta, GA 30328, USA Atlanta, GA 990 Hammond Drive Suite 500 Atlanta, GA 30328, USA Chicago, IL 500 W Madison St Suite 3105 Chicago, IL 60661, USA Chicago, IL 500 W Madison St Suite 3105 Chicago, IL 60661, USA New York City, NY 1350 Broadway 2000 New York City, NY 10018, USA New York City, NY 1350 Broadway 2000 New York City, NY 10018, USA 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. Conductexploratorydata 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-functionalteams—including marketing, product, finance, andoperations—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. May provide mentorship, guidance, support, and knowledge-sharing to help less experienced team members develop their skills and grow within their roles. Skillsand Competencies 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 Experience Typically, a minimum of 2years'related work experience inDataAnalytics orarelated fieldis required. Education A bachelor's degree in a quantitative field (e.g., Mathematics, Statistics, Economics, Computer Science, or related discipline)is required. Salary Range Theanticipatedstarting payrange for this position is based on the employee's primary work location and maybemore or lessdependingupon skills, experience, and education. These ranges may be modified in the future. Location A: $71,000 - $96,000 Location B: $78,000 - $106,000 Location C: $85,000 - $115,000 Benefits and Other Compensation medical dental vision short and long-term disability life insurance an employee assistance program paid time off and parental leave paid holidays 401(k) retirement savings plan with employer match performance-based bonus eligibility employee referral bonuses tuition reimbursement pet insurance long-term care insurance 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 formunicipalities, 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, visitwww.brownandcaldwell.com This position is subject to a pre-employment background check and a pre-employment drug test. Notice to Third Party Agencies: Brown and Caldwell does not accept unsolicited resumes from recruiters or employment agencies. In the event a recruiter or agency submits a resume or candidate without a previously signed agreement and approved engagement request with Brown and Caldwell, Brown and Caldwell reserves the right to pursue and hire those candidate(s) without any financial obligation to the recruiter or agency. Qualifications Skills Behaviors : Motivations : Education Experience Licenses & Certifications Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities This employer is required to notify all applicants of their rights pursuant to federal employment laws.For further information, please review the Know Your Rights notice from the Department of Labor. J-18808-Ljbffr