Data Engineer Information Technology

Overview

This job is onsite, based in Irvine CA.

• Develop and maintain SQL Server and Snowflake Data Warehouses and Data Lakes with a focus on data governance, security, and performance optimization.
• Manage and optimize database solutions within Snowflake, SQL Server, MySQL, and AWS RDS environments.
• Build and optimize ETL pipeline processes using Snowpipe, DBT, Boomi, SSIS and/or Azure Data Factory.
• Proficiency in Data Tools such as SSMS, Profiler, Query Store, Redgate, etc.
• Perform light operational tasks, including database backup & restore.
• Collaborate and support organizational data development projects, working closely with the Business Intelligence and Business Analysts Teams.
• Help ensure and maintain database security, integrity, and compliance following the industry’s best practices.
• Configure and manage data integration platforms and business intelligence tools, ideally including Power BI, Tableau, Power Automate, and scripting languages like Python or R.

• 7+ years of hands-on experience working as Microsoft SQL Server Developer or Administrator, with hands-on experience developing relational and object-oriented databases.
• 2+ years of hands-on experience working with Snowflake data warehouses and data lake environments.
• Proven mastery of Microsoft SQL Server, including t-SQL.
• Hands-on experience developing databases, pipelines, and reporting solutions using BI Reporting & ETL tools such as Power BI, SSRS, SSIS, Azure Data Factory, DBT and other similar industry tool sets.
• Proficiency with scripting and automation, including Python, Power Shell; or R.
• Experience with, and knowledge of, data integration and analytic tools such as Boomi, Redshift, or Databricks is desirable.
• Excellent communication and organizational skills.

• Bachelor or Master’s Degree in Computer Science, Information Systems, Data Sciences, or equivalent experience.

• Ability to read and comprehend simple instructions, short correspondence, and memos. Ability to write simple correspondence. Ability to effectively present information in one-on-one and small group situations to customers, clients, and other employees of the organization.

• Ability to add, subtract, multiply, and divide in all units of measure, using whole numbers, common fractions, and decimals. Ability to compute rate, ratio, and percentage and to draw and interpret bar graphs.

• Ability to apply common sense understanding to carry out detailed instructions. Ability to deal with problems involving a few concrete variables in standardized situations.

• Advanced knowledge of Microsoft Office applications (Word, Excel, Outlook, etc).

• 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. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions.

• While performing the duties of this Job, the employee is regularly required to use hands to finger, handle, or feel; reach with hands and arms and talk or hear. Employees are frequently required to walk and sit. The employee is occasionally required to stand. The employee must occasionally lift and/or move up to 25 pounds. Specific vision abilities required by this job include close vision, distance vision, color vision, peripheral vision, depth perception and ability to adjust focus.
  
  Always practice good judgment and refer to the safety guidelines.

• 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. Always practice good judgment and refer to the safety guidelines.
• The noise level in the work environment is usually moderate

• $125K-$135k

Our benefit offerings include:
Medical, dental, vision, wellness programs, EAP counseling services, FSA & HSA, company sponsored life insurance for employee, voluntary life…