The UAM Data Operations Team at Davey Resource Group, Inc. requires a skilled Data Analyst / SQL Developer to assist with managing, analyzing, and transforming data into meaningful insights.
Requirements
- Strong proficiency in SQL (e.g., complex JOINs, window functions, CTEs, indexing).
- Experience with relational databases such as SQL Server, PostgreSQL, or MySQL.
- Hands-on experience with ETL tools or processes (SSIS, Azure Data Factory, etc.).
- Proficiency with data visualization tools (Looker, Power BI, or Tableau).
- Strong Excel or Google Sheets skills (pivot tables, advanced formulas).
- Understanding of data modeling concepts (star schema, normalization, fact/dimension tables).
- Familiarity with at least one programming language used in data analysis (Python or R preferred).
Responsibilities
- Design, write, and optimize SQL queries, stored procedures, functions, and scripts for use in both data lake (BigQuery) and relational database platforms (SQL Server).
- Develop and maintain ETL processes to integrate and transform data from multiple sources.
- Ensure data integrity, accuracy, and performance across databases and other data environments.
- Assist with database maintenance, schema design, indexing strategies, and performance tuning.
- Develop dashboards, reports, and visualizations using BI tools (Looker, Power BI).
- Translate business requirements into analytical solutions, datasets, and data models.
- Analyze large datasets to identify trends, patterns, and actionable insights.
Other
- Bachelor’s degree in Data Analytics, Computer Science, Information Systems, Statistics, Mathematics, or a related field.
- 2+ years of experience as a Data Analyst, SQL Developer, or in a similar data-focused role.
- Ability to communicate technical concepts to non-technical stakeholders.
- Ability to manage multiple projects and deadlines in a dynamic environment.
- Strong documentation and organizational skills.
