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 industrys 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
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.
Experience with and knowledge of data integration and analytic tools such as Boomi Redshift or Databricks is desirable.
Excellent communication and organizational skills.
Education and/or Experience
Bachelor or Masters Degree in Computer Science Information Systems Data Sciences or equivalent experience.
Language Skills
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.
Mathematical Skills
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.
Reasoning Ability
Ability to apply common sense understanding to carry out detailed instructions. Ability to deal with problems involving a few concrete variables in standardized situations.
Computer Skills
Advanced knowledge of Microsoft Office applications (Word Excel Outlook etc).
Physical Demands
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.
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. Always practice good judgment and refer to the safety guidelines.
The noise level in the work environment is usually moderate
Salary:
$125K-$135k
Benefits Our benefit offerings include: Medical dental vision wellness programs EAP counseling services FSA & HSA company sponsored life insurance for employee voluntary life insurance for employee spouse and child AD&D Insurance voluntary short-term and long-term disability critical illness insurance accident insurance legal assistance pet insurance living will and trust preparation discounts commuter program annual walking challenge employee appreciation events and monthly sales awards. At Acra Lending we were founded with a clear purpose: to specialize in alternative income loan products that help borrowers qualify for our flexible loan programs. We operate in 39 States out of nine offices in Arizona California Florida Georgia Hawaii Missouri Nevada Texas and Utah along with a growing team of remote professionals across the country. Throughout the mortgage industry Acra Lending is widely known for responsible lending practices product innovation and operational efficiency. The foundation of our Company is built on helping our customers by providing Non-QM mortgage solutions for todays borrower in residential and commercial properties across America. Our Leadership team will encourage you to grow make time to have fun and work together to make great things happen. We embrace the strengths and values of each team member. We believe in having diverse perspectives where everyone is included to serve customers from all walks of life. We reward our employees with a competitive salary and a variety of benefits to help our team members reach their health retirement and professional goals along with an exceptional 401k match program. We look forward to meeting you!
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.