IT Data Engineer - Westcor Land Title Insurance Company

https://www.ardaninc.com/california-employee-and-job-application-privacy-notice/

Position Summary: In this position, you will play a crucial role in managing and optimizing our data processes within our emerging Data Warehouse/Data Lake environments. This position requires a strong foundation in ETL systems, SQL development and a solid understanding of relational databases. You will work to ensure the efficiency and reliability of our data pipelines, contributing directly to the success of our projects. The ideal candidate will have a strong background in data analysis and data visualization with specific expertise in using SQL to transform and analyze data. You will work closely with stakeholders across the organization to deliver actionable insights and support data-driven decision-making.

Essential Functions:

• Collaborate with data engineers, analysts, and other stakeholders with data flows, scripts, and models using SQL, SnapLogic and other ETL systems, optimizing for performance and reliability throughout the organization.
• Assist in the development and testing of new features, models, or data processes within our data warehouses, leveraging feedback to drive continuous improvement.
• Document data processes, models, and workflows within our data warehouses for internal knowledge sharing and to support ongoing learning and development.
• Ensure integrity and quality of data throughout the entire data lifecycle, from ingestion to analysis, by implementing data validation and cleansing processes.

• Maintain security protocols and data governance practices to ensure compliance with organizational policies and industry regulations.
• Monitor performance and troubleshoot issues within ETL projects and related data environments.

• Create and maintain interactive dashboards and reports using SSRS, Power BI or similar visualization tools.
• Ensure data quality and integrity by implementing best practices in data governance and validation.

Education and Experience:  

• Bachelor’s degree in Computer Science, Information Systems, Data Science or a related field.
• 3 years of experience in a data engineering role, with a focus on SQL development (MS SQL Server experience preferred).
• Strong proficiency in relational databases and data querying techniques.
• Expertise in data modeling, ETL processes, and data integration techniques.
• Experience with using programmatic tools for data manipulation and analysis.
• Familiarity with cloud platforms such as Azure, AWS, or GCP.
• Knowledge of data visualization tools like Power BI, Tableau, or similar.
• Excellent problem-solving skills and attention to detail.
• Strong communication and collaboration skills, with the ability to work effectively with cross-functional teams
• Ability to learn quickly, be adaptable, flexible, and creative.
• Demonstrated capability to work well independently and as part of a team.

 Physical Demands

• Ability to safely and successfully perform the essential job functions consistent with the ADA, FMLA and other federal, state and local standards, including meeting qualitative and/or quantitative productivity standards.
• Ability to maintain reasonably regular, punctual attendance consistent with the ADA, FMLA and other federal, state and local standards.
• Must be able to sit, stand, stoop or bend for an extended period (8 hours).
• Must be able to listen and speak clearly over the phone.

Work Environment

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. The noise level in the work environment is usually moderate.

We offer some great perks:

• Health, dental, and vision benefits.
• Employer-paid disability and life insurance.
• Flexible spending accounts.
• 401K with company match.
• Paid time off and company-paid holidays.
• Wellness resources.

Note: This job description is not intended to be an exhaustive list of duties, responsibilities, or qualifications associated with the job.