Data Engineer

Join to apply for the Data Engineer role at Acra Lending

Join to apply for the Data Engineer role at Acra Lending

Get AI-powered advice on this job and more exclusive features.

At Acra Lending our employees enjoy an opportunity to work with great people. We celebrate several events throughout the year accompanied by raffles and giveaways for employees nationwide. We are especially proud to give back to our community and truly enjoy one another's company. We provide a continental breakfast daily and cater lunch every Friday.

We are looking for candidates to join our team who are passionate about their vocation. Who are committed to making a contribution and are looking to gain experience in order to grow in their career. Our headquarters are located on a beautiful campus in Irvine, California and if you work out of our Irvine office we can also provide a free gym membership.

Summary

We are looking for a talented Data Engineer who loves to be hands-on and has experience with Microsoft SQL Server, Snowflake, AWS RDS, and MySQL to join a team of Business Intelligence Developers and Data Engineers. The ideal candidate will have a strong background and experience working with Snowflake Data Warehouses and Data Lakes, SQL Server, SSIS, and Power BI. This is a key position within the company and aligns with our data strategy, driving optimization, reliability, and robust business intelligence capabilities across the organization.

This position is ideal for data professionals seeking to have influence and who wish to apply their technical expertise in a collaborative, data-driven organization focused on innovation and growth.

This job is onsite, based in Irvine CA.

Essential Duties And 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.

• 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…