Job description

Job Description

This role will play a pivotal role in assisting the IT team with the evolution of the company data architecture. In addition to supporting extensions to the data warehouse design, this role will design and develop ETL required to onboard new types of business data. Finally, this role will also provide support for Analytics assignments as needed.

Responsibilities

• Display sense of ownership over assigned work, requiring minimal direction and driving to completion in a sometimes fuzzy and uncharted environment.
• Designing and building new data pipelines that support business requirements.
• Work with IT and other business partners to support the evolution of the enterprise data architecture.
• Work with IT to build new ETLs to take data from various operational systems and extend existing data warehouse data model for analytics and reporting.
• Continually improve ongoing reporting and analysis processes, automating or simplifying self-service support for business constituents.
• Support the development of the company BI infrastructure, including the construction of scalable analytic solutions, and on-premises reporting tools.
• Utilize Power BI development to build scalable reporting models to serve BI reporting needs.
• Demonstrate the ability to gather requirements, extract and manipulate data residing in multiple disparate databases, and articulate solutions to support the business.
• Design, develop, and maintain performant data models in Power BI utilizing best practices.
• Serve as a subject matter expert for all data warehouse and enterprise systems
• Use new or existing technologies to produce analytics solutions (in the form of excel spreadsheets, dashboards, etc.).
• Work with IT and Analytics team to architect and build data pipelines to optimize for performance, data quality, scalability, ease of future development, and cost.
• Gather requirements, assess gaps and build roadmaps to help the analytics driven organization achieve its goals.
• Develop data-related Proof of Concepts in order to demonstrate feasibility and value to Symmetry business constituents.

Qualifications / Requirements

• Bachelor’s degree in Information Systems, Computer Science, Finance, or similar education from an accredited college
• 2-3 years Accounting and Finance background preferred
• Strong skillset in Microsoft Excel (2-3 years, financial formulas & VBA is a plus) and familiarity with Microsoft Office Productivity Suite (Excel, Word, etc.)
• 5+years’ experience with advanced SQL concepts and writing SQL statements (SQL Server or similar).
• Prefer 2 years’ experience with Microsoft BI Suite, PowerBI, Power Query, PowerPivot, Reporting Service (SSRS), SharePoint
• Experience in mentoring other team members in development best practice, and methodologies.
• You are passionate about data quality control and know how and where to anticipate potential errors.
• Knowledge of the software development lifecycle, agile methodologies, and structured software development methodologies.
• Experience performing analysis with large datasets in a cloud-based environment.
• Ability to work effectively with stakeholders at all levels within the organization
• Strong communication and time management skills and a self-motivated approach
• Ability to work independently, detail-oriented, and execution focused
• Highly collaborative and team oriented
• Tenacious (doesn’t give up easily)
• Genuine passion for clean and reliable data
• At least 5 years of work experience

About Symmetry

Symmetry Lending, specializes in providing mortgage fulfillment services to include origination, servicing, and capital markets needs to various Lenders across the country with whom we partner. We have offices in Atlanta, GA, Eden Prairie, MN, Denver, CO, Orlando, FL, and Anaheim, CA, and we do business from coast to coast. We take great pride in building a diverse team of motivated professionals that contribute to an exciting work atmosphere. We provide a competitive benefits package including medical, dental, and vision plan options, paid time off, and more.

California Disclosure - Employee Notice at Collection

This disclosure is intended to comply with the California Consumer Privacy Act (CCPA), which gives California residents who are applicants, employees, or contractors of Symmetry Lending (“Symmetry”) the right to know what categories of personal information Symmetry collects about them and the purposes for which Symmetry uses that information. As used in this Privacy Notice, “Personal Information” means information that identifies, relates to, describes, is reasonably capable of being associated with, or could reasonably be linked, directly or indirectly, with a particular individual or household. Personal Information includes, but is not limited to, the categories of personal information identified below if such information identifies, relates to, describes, is reasonably capable of being associated with, or could be reasonably linked, directly or indirectly, with a particular individual or household.

The following is a list of the categories of Personal Information that we may collect about consumers:

• Identifiers. This may include a real name, alias, postal address, unique personal identifier, online identifier, Internet Protocol address, email address, account name, Social Security number, driver's license number, passport number, or other similar identifiers.

• Personal information described in the California Customer Records Statute (Cal. Civ. Code § 1798.80(e)). This may include a name, signature, Social Security number, physical characteristics or description, address, telephone number, passport number, driver's license or state identification card number, insurance policy number, education, employment, employment history, bank account number, or any other financial information, medical information, or health insurance information.

• Characteristics of Protected Classification under California or Federal Law. This may include age, race, color, ancestry, national or ethnic origin, citizenship status, religion or belief, marital status, a childbirth or related medical condition, physical or mental disability, sex (including gender, gender identity, gender expression, pregnancy or childbirth, and related medical conditions), sexual orientation, veteran or military status.

• Biometric information. This may include voice and video recordings.

• Sensory data. This may include audio, electronic, visual, or similar information, including photos.
• Professional or employment-related information. This may include current or past job history, compensation data, performance evaluations, or employee benefits.
• Beneficiaries, dependents, and emergency contact information. This may include the name, gender, phone number, and relationship of beneficiaries, dependents, and emergency contacts.

We may use the categories of Personal Information for the following business or commercial purposes:

• To perform background checks necessary to comply with licensing requirements, to perform reference checks, to verify eligibility to work in the United States, for contact purposes, to assess your qualification for employment, to conduct performance evaluations, for payrolls and budgeting purposes, for implementation of employee benefits, for internal organizational purposes to establish proper accommodations for sick time, PTO, leaves of absences, or emergency situations, and to conduct health screenings as allowed by OSHA and the CDC to protect the safety of our employee during pandemic situations.

• For internal use, such as tracking access into buildings, timekeeping, activity logs, etc.
• To comply with laws and regulations, including but not limited to applicable tax, health and safety, anti-discrimination, immigration, labor and employment, and social welfare laws.
• For security or the prevention, detection, or investigation of fraud, suspected or actual illegal activity, violations of company policy or rules, or other misconduct.
• To comply with civil, criminal, judicial, or regulatory inquiries, investigations, subpoenas, or summons.
• To comply with all licensing requirements necessary for our business operations, including state exam audits.
• To exercise or defend the legal rights of Symmetry and its employees, affiliates, customers, contractors, and agents.
• To seek advice from lawyers, auditors, or other professional advisors.

If Symmetry uses Personal Information of an applicant, employee, or contractor for a purpose materially different than those disclosed in this notice, Symmetry will notify the employee and obtain explicit consent from the employee to use the Personal Information for this new purpose.

Job Type: Full-time

Benefits:

• 401(k)
• 401(k) matching
• Dental insurance
• Flexible spending account
• Health insurance
• Health savings account
• Paid time off
• Vision insurance

Schedule:

• Monday to Friday

Ability to commute/relocate:

• Anaheim, CA 92807: Reliably commute or planning to relocate before starting work (Required)

Education:

• Bachelor's (Preferred)

Experience:

• Accounting and Finance: 2 years (Preferred)
• advanced SQL concepts and writing SQL statements: 5 years (Preferred)

Work Location: Hybrid remote in Anaheim, CA 92807

colinoncars.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, colinoncars.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, colinoncars.com is the ideal place to find your next job.