Data Engineer

Join to apply for the Data Engineer role at Jobright.ai 2 days ago Be among the first 25 applicants Join to apply for the Data Engineer role at Jobright.ai Get AI-powered advice on this job and more exclusive features. Jobright is an AI-powered career platform that helps job seekers discover the top opportunities in the US. We are NOT a staffing agency. Jobright does not hire directly for these positions. We connect you with verified openings from employers you can trust. Job Summary: Acra Lending is a company specializing in alternative income loan products, known for its responsible lending practices and product innovation. They are seeking a talented Data Engineer who will be responsible for developing and maintaining SQL Server and Snowflake Data Warehouses and Data Lakes, focusing on data governance, security, and performance optimization. Responsibilities: • 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. Qualifications: Required: • 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, PowerShell; or R. • 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). Preferred: • Experience with, and knowledge of, data integration and analytic tools such as Boomi, Redshift, or Databricks is desirable. Company: Acra Lending specializes in lending services and adjustable-rate mortgages as well as alternative income products. Founded in 2003, headquartered in Lake Forest, California, USA, team size 201-500 employees, currently Growth Stage. Seniority level Seniority level Mid-Senior level Employment type Employment type Full-time Job function Industries Software Development Referrals increase your chances of interviewing at Jobright.ai by 2x Inferred from the description for this job Medical insurance Vision insurance 401(k) Get notified about new Data Engineer jobs in Irvine, CA . Santa Ana, CA $100,000.00-$115,000.00 6 days ago San Juan Capistrano, CA $110,000.00-$130,000.00 2 months ago Irvine, CA $100,000.00-$150,000.00 1 week ago Irvine, CA $74,859.00-$100,227.00 1 week ago Irvine, CA $90,000.00-$120,000.00 2 weeks ago Irvine, CA $140,000.00-$180,000.00 2 months ago Irvine, CA $154,000.00-$192,500.00 1 hour ago Irvine, CA $125,000.00-$135,000.00 2 days ago Irvine, CA $125,000.00-$135,000.00 2 days ago Fountain Valley, CA $103,170.00-$158,873.00 1 week ago Irvine, CA $141,000.00-$202,000.00 3 days ago Irvine, CA $110,000.00-$130,000.00 1 month ago Newport Beach, CA $100,530.00-$122,870.00 3 days ago Newport Beach, CA $110,000.00-$120,000.00 5 days ago San Juan Capistrano, CA $110,000.00-$130,000.00 4 days ago Senior Data Engineer, Information Technology – Data & Development Cypress, CA $150,238.00-$160,000.00 2 days ago Irvine, CA $119,000.00-$180,000.00 1 week ago Irvine, CA $120,000.00-$140,000.00 2 weeks ago Data Engineer: MS SQL, AWS, ETL (Python w/ Airflow / SSIS) & basic Power BI req; Snowflake DW, MySQL, Boomi a + Irvine, CA $100,000.00-$150,000.00 2 weeks ago Aliso Viejo, CA $175,000.00-$230,000.00 2 weeks ago Irvine, CA $110,000.00-$150,000.00 1 week ago Newport Beach, CA $125,500.00-$150,000.00 2 weeks ago Irvine, CA $116,300.00-$145,400.00 2 weeks ago Irvine, CA $80,000.00-$105,000.00 2 weeks ago Irvine, CA $150,000.00-$180,000.00 6 days ago Newport Beach, CA $70.00-$80.00 2 weeks ago Irvine, CA $99,500.00-$200,000.00 2 weeks ago Newport Beach, CA $120,000.00-$162,000.00 1 day ago We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI. #J-18808-Ljbffr