L2 Data Engineer

Job Title: L2 Data Engineer

Job Location: Westerville, OH | Onsite 5 days a week

Description:

AgreeYa is a global Systems Integrator and is seeking an L2 Data Engineer to join our growing team. We are seeking an L2 Data Engineer to join our National Business Lines technology team. This role is responsible for designing, developing, and maintaining scalable data solutions that power our Business Escrow Services. The successful candidate will leverage SQL to build robust data pipelines and analytics dashboards, ensuring the integrity and accessibility of financial data for specialized commercial banking distributions.

Job Responsibilities

Data Engineering & Pipeline Development

• SQL Solution Design: Design, develop, and maintain SQL-based data solutions to support complex escrow banking and operational systems.
• Pipeline Orchestration: Build and support scalable data pipelines and datasets using Databricks for efficient, high-volume data workflows.
• Query Optimization: Write, optimize, and manage complex SQL queries, stored procedures, and views to ensure high-performance data processing.
• Data Transformation: Implement sophisticated transformation logic to convert raw escrow transaction data into actionable business intelligence
• Design, develop, and maintain SQL-based data solutions to support banking and operational systems.
• Write, optimize, and manage SQL queries, stored procedures, and views for efficient data processing.

Technical Support & Troubleshooting

• Provide Level 2/3 support for data-related issues
• Investigate and resolve data quality issues, pipeline failures, and performance bottlenecks
• Collaborate with business users to understand and resolve data discrepancies
• Create and maintain comprehensive documentation for troubleshooting procedures
• Establish monitoring and alerting systems for proactive issue identification

Collaboration & Communication

• Work closely with data analysts, business intelligence developers, and business stakeholders
• Participate in agile development processes and sprint planning

DevOps & CI/CD Implementation (Nice to have)

• Design and implement CI/CD pipelines using Azure DevOps for data engineering projects
• Automate deployment processes for packages, Python scripts, and database objects
• Implement infrastructure as code practices for data platform components

Professional Requirements

• Soft Skills: Strong analytical, problem-solving, and communication skills with the ability to work independently in a fast-paced environment
• 3 5 years of experience in data engineering with strong SQL expertise.

Education:

• Bachelor s degree in Computer Science, Information Technology, or a related field.

AgreeYa is a global systems integrator delivering competitive advantage for its customers through software, solutions, and services. Established in 1999, AgreeYa is headquartered in Folsom, California, with a global footprint and a team of more than 2,200 staff across offices. AgreeYa works with 500+ organizations ranging from Fortune 100 firms to small and large businesses across industries such as Telecom, Banking, Financial Services & Insurance, Healthcare, Utility & Energy, Technology, Public sector, Pharma & Biotech, and others. Please visit us at for more information.

AgreeYa is an equal opportunity employer. We evaluate qualified applicants without regard to race, color, religion, gender identity, sexual orientation, national origin, disability, veteran status or other protected characteristics. Visit our website to learn about our Career & Culture.