Data Analyst SQL Developer
Share
Job Location:
Richfield, MN - USA
Monthly Salary:
$ 65000 - 72000
Posted on:
7 hours ago
Vacancies:
1 Vacancy
Job Summary
Company:Davey Resource Group Inc.
Locations:Richfield OH
Additional Locations:Remote with EST Availability
Work Site:Remote
Req ID:219150
Position Overview
The UAM Data Operations Team requires a skilled Data Analyst / SQL Developer to assist with managing analyzing and transforming data into meaningful insights. The ideal candidate will be responsible for developing efficient SQL queries maintaining datasets and databases creating analytical reports and supporting data-driven decision-making across the organization. This role requires a blend of technical development skills and analytical thinking. The position reports to the Senior Data Scientist under the direction of the Data Operations team leader.
Job Duties
What Youll Do:
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.
Prepare and present findings to technical and non-technical stakeholders.
Conduct ad-hoc analysis to support ongoing business needs.
Analyze large datasets to identify trends patterns and actionable insights.
Work closely with application development operations finance and business teams to understand data needs.
Provide analytical support for strategic initiatives and performance tracking.
Document data flows business rules queries and reporting logic for internal knowledge sharing.
Qualifications
Skills Were Seeking:
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).
Excellent analytical thinking and problem-solving abilities.
Strong attention to detail and commitment to data accuracy.
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.
Compensation Data
This is a non-exempt full-time position with a base range of $65000 - $72000 in addition to an annual performance bonus up to 10-15%.
Education & Experience
Bachelors 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.
Experience with BI dashboards data modeling and SQL development is required.
Certifications in data analytics SQL cloud technologies or BI tools are a plus.
Additional Information
What We Offer: *
- Paid time off and paid holidays
- Opportunities for advancement
- 401(k) retirement savings plan with a company match
- Employee-owned company and discounted stock purchase options
- Group health plan
- Employee referral bonus program
- Locations throughout US in major cities and desirable areas
- Scholarship program for children of employees
- Charitable matching gift program
*all listed benefits available to eligible employees
The Davey Tree Expert Company is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to protected class including race color religion sex pregnancy sexual orientation gender identity or expression national or ethnic origin marital or familial status disability status as a protected veteran status as an Aboriginal or Indigenous person or other classification protected by law.
Utility Asset Management is a division of Davey Resource Group Inc.(DRG) a Davey company. Davey has been employee-owned since 1979. Our engineering field services inspection and construction teams help keep the world connected supporting the infrastructure of our electric utility and communications Davey Tree Expert Company provides research-driven tree services grounds maintenance and environmental and utility infrastructure consulting for residential utility commercial and environmental partners in the U.S. and Canada. We care about our clients each other and the world around us. We offer the resources size and stability of a big company while maintaining the culture entrepreneurial spirit and feel of a small one. We invest in our people offering industry-leading training technology and benefits that lead to a rewarding and safe work experience at all levels. Wherever you want to grow your career theres a place for you at Davey. To learn more visit .
Accommodations:If requested by employee or otherwise as required by law reasonable accommodations will be made to enable employees with disabilities to perform essential job functions.
If you need assistance at any time please contact us at 1- or at.
Employment Type:Permanent
Job Type:Full Time
Travel Expectations: None
Required Experience:
IC
Key Skills
- Databases
- SQL Server Management Studio
- SQL
- .NET
- Microsoft SQL Server
- ssrs
- TFS
- Database Design
- Performance Tuning
- SSIS
- T Sql
- Data Warehouse
About Company
With over 130 years of experience, you can rely on Davey’s safe, professional tree services for your home, like tree trimming, tree health inspections, tree removal, tree fertilization, and cabling and bracing. Find a local office near you to schedule a free tree consultation today.
