Data Engineer

Job Summary

Data Engineers at ARS design build and maintain the data assets and pipelines that enable high-quality actionable intelligence across business operations and client engagements. They ensure that information delivery is timely reliable and aligned with the needs of end users adhering to internal quality standards and supporting business-critical reporting and visualization.

Data Engineers are responsible for managing and prioritizing their workload across weekly deliverables and longer-term strategic objectives. They are expected to apply sound judgment and technical discretion in developing solutions resolving data issues and making trade-offs in a resource-constrained environment.

In addition to engineering robust data solutions the role requires active collaboration with partner teams to improve processes enhance automation and influence technology investments that strengthen ARSs data ecosystem. Data Engineers also provide analytical and data-mining expertise to support strategic initiatives and guide the organization in leveraging data as an enterprise asset.

Essential Duties

1.Develop New Data and Reporting Solutions

• Translate business and client requirements into effective data models pipelines and reporting solutions.
• Collaborate with end users business stakeholders and management to validate requirements and ensure solutions meet functional and strategic needs.
• Apply established solution design principles to ensure scalability sustainability and adherence to architectural standards.

2. Maintain and Enhance Existing Reporting Assets

• Update and optimize existing solutions to reflect evolving client requirements business processes and performance needs.
• Evaluate existing reports and pipelines to determine ongoing viability and lead their decommissioning when they no longer provide business value.
• Troubleshoot and resolve data or performance issues as they arise.

3. Drive Automation and Improve the Sustainability of the Reporting Suite

• Lead or support initiatives to migrate legacy solutions to automated maintainable and modernized architectures.
• Redesign and rebuild legacy assets to align with current engineering principles tooling and best practices.
• Identify opportunities for process automation that streamline delivery and reduce manual intervention.

4. Support Data Gathering Mining and Analytical Efforts

• Serve as a subject matter expert on the data warehouse including data structures lineage availability and appropriate usage.
• Develop queries extracts and aggregated datasets to support business analysts operational reporting and strategic initiatives.
• Advise stakeholders on data interpretation constraints and best practices for analytical use.

5. Uphold Data Stewardship and Quality Standards

• Ensure all solutions meet ARSs standards for data accuracy completeness and consistency.
• Validate and monitor data pipelines and reports to ensure correct data population and correct application of business rules.
• Contribute to the documentation governance and continuous improvement of data quality processes.

Competencies

Organization

• Decision Quality Making good and timely decisions that keep the organization moving forward.
• Drives Results Consistently achieving results even under tough circumstances.
• Communicates Effectively Clearly communicates messages through appropriate channels and listens to understand and respond.
• Being Resilient Rebounding from setbacks and adversity when facing difficult situations.
• Self-Development Actively seeking new ways to grow and be challenged using both formal and informal development channels.

Position Specific

• Snowflake knowledge desired

Technical and/or Functional Skills & Knowledge

• Proficiency in T-SQL
• Proficiency in Report Builder / Visual Studio
• Proficiency in Microsoft Office

Qualifications:

• Requires at least an associates degree preferably in STEM
• Experience in reporting and data analysis preferred

Work Environment

While performing the duties of this job the employee regularly works in a climate-controlled setting seated continuously and is sedentary the majority of the workday. This position is in a call center with moderate to high noise levels & frequent foot traffic. This position routinely uses standard office equipment such as computer phones and photocopiers. Work area stations and cubicles are close in proximity to others.

Physical Demands

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. While performing the duties of this job the employee is continuously required to use hands and fingers to handle feel or operate office equipment such as computers phones and photocopiers; and have moderate reach with hands and arms. The employee is regularly required to talk and hear sit and see in order to perform close-up computer work and phone equipment and requires close-up vision and color recognition.

Specific requirements for Remote Work

• This position is estimated to be 80% in office Escondido CA and 20% remote.
• Must adopt and embrace a flexible schedule mindset.
• Must be available to meet and work during regular business hours of the clients and the company (across all time zones) which may be outside of standard business hours or work schedule in any given location.
• Must possess self-motivation and be self-disciplined to complete necessary job duties and pro-actively seek all necessary information.
• Must be able to effectively and efficiently use all forms of communication as appropriate (video calls telephone e-mail instant-messaging).
• Strong written and verbal communication skills must be utilized to resolve issues timely as well as an ability to implement recommended adjustments.
• Must be a team player and have cross-cultural literacy ability to communicate and collaborate be accountable to other team members departments and clients with little to no prompting.
• Must have reliable and secure equipment and services (-speed internet).
• Must be able to set and meet established deadlines and commitments on a regular basis.
• Must discern company goals and be motivated to create personal/department short term and long term goals in support.
• Utilize critical thinking skills to overcome challenges and seek support from supervisor or the Human Resources Department for assistance.
• Must be able to travel to/from ARS business units based on business needs.

Reasonable Accommodations

Reasonable accommodations may be provided by ARS National Services Inc. to enable individuals with disabilities to perform essential functions as defined per Company policy.

NOTE: This job description is not intended to be all-inclusive. Employee may perform other related duties to meet the ongoing needs of the organization.

Required Experience:

IC