Civic Financial Services is a private money lender, specializing in the financing of non-owner-occupied residential investment properties. CIVIC provides Mortgage Brokers and Real Estate Investors with a fast, cost effective funding source for their real estate investment needs.
CIVIC is committed to creating a workplace where our people thrive, which translates into a culture of inclusion, recognition, and success for our teammates and clients alike. Since 2016, CIVIC has been recognized by Best Workplaces and Fortune as a Great Place to Work, and CIVIC’s employee engagement ranks among the top 5% of companies nationally.
Whether you are an entrepreneur, an innovator, a game changer, a creative, a problem-solver, a thinker, or an operator we have all kinds. CIVIC is the place for smart, ambitious, dedicated people who work hard and play nice.
Yes, our business is in real estate investing... but our greatest investment is in you!
The Database Developer is responsible for supporting the needs of multiple business teams within Civic, with a focus on the SQL Data Warehouse and SQL Reporting Server; Application database design, development, code reviews, and testing; and the movement of data from application systems and external sources into the SQL Servers.

What you’ll do:

• Develop high quality database solutions providing data for reporting and application development.
• Design, develop and maintain database code (schemas, stored procedures, views, triggers, indexes (familiarity with Microsoft databases including Azure).
• Develop and maintain SQL jobs and ETL/ELT.
• Develop and maintain reporting solutions
• Develop ad-hoc queries for troubleshooting.
• Develop and maintain requirements, specifications and documentation.
• Maintain SOX compliance in SDLC, Change Management, data access/movement, etc.
• Analyze database performance and make improvements.
• Monitor SQL Server environments (Azure and On-Prem) and daily operations.
• Work closely with business analysts, IT professionals and project managers to understand their data requirements for existing and future projects involving data – big and small.
• Work with IT and data owners to understand the types of data collected in various databases and data warehouses helping maintain their integrity and security.
• Conduct testing and perform troubleshooting on databases to ensure accuracy, security, and efficiency.
• Develop procedures and scripts for data migration across databases and ensure migrated data is accurate and intact.
• Create and optimize SQL queries to sort, retrieve or store data.
• Create program views, functions, and stored procedures.
• Develop, implement, and optimize stored procedures and functions using T-SQL.
• Review and interpret ongoing business report requirements; research required data.
• Build appropriate and useful reporting deliverables. Provide timely scheduled deliverables.
• Analyze existing SQL queries for performance improvements; suggest new queries.

What you’ll need:

• Bachelor’s degree in Computer Science, Engineering, or equivalent experience preferred; or a combination of education and experience.
• 3-5 years of experience as a SQL Developer or similar role.
• 3 years of hands-on experience with SQL Server Reporting Services and SQL Server Analysis Services.
• Excellent understanding of Microsoft SQL Server.
• Familiarity with the practical application of unstructured data (Azure Cosmos DB).
• Sense of ownership and pride in performance and impact to company’s success
• Demonstrated ability to project manage
• Ability to work in a fast-paced environment
• Strong verbal, written and presentation skills
• Critical thinker and problem-solver
• Exceptional time management skills
• Able to distill complex data into smaller, comprehensible solutions

What’s in it for you?

We have a strong focus on going above and beyond when it comes to caring for our team members and our communities. In addition to traditional benefits like health insurance, casual Fridays, paid vacation, holidays and sick leave, we are proud to offer these unique and enriching work perks:

• Celebrations: When we say we “work hard and play hard,” we mean it! We like to celebrate often via onsite, offsite, and virtual happy hours, themed parties, parking lot BBQ's, milestone ceremonies, birthday gift cards, and Workout Tuesdays (to name a few).
• Investments: As we are in the lending space, we believe we should consistently and frequently invest in our CIVIC team. We support our teammates in paying off student debts and invest in your education with a tuition reimbursement program.
• Flexible Work Environment: Work-life balance is important. We work with you to determine the best work style for you and CIVIC.
• Office Life: We like to make sure that when you are in the office, you are well fed and can access the resources you need. Our kitchens are stocked with snacks and beverages, and we have created an office spaces dedicated to collaboration, focus time, creativity while ensuring team members safety.
• Education: We offer an online curriculum of courses through our own CIVIC University. We also created programs to support you and your manager in career development discussions.
• #CIVICCares Initiative: From beach cleanups, food and clothing drives, building homes for Habitat for Humanity, to volunteer hours, CIVIC provides several opportunities throughout the year for our team to step outside the office, bond, and come together to give back to our local communities.

Civic Financial Services is an EEO/AA/Disability/Vets Employer.