SQL Database Developer at John Burns Real Estate Consulting, LLC

We are looking for a bright, motivated, analytical SQL Database Developer to join our team in our Folsom/Sacramento office.

Required Skills/Abilities:

• 4+ years of recent experience in a database development role working with Microsoft SQL Server.
• Ability to understand and write complex T-SQL code.
• Knowledge of query optimization, indexes, and performance tuning techniques in MS SQL Server.
• Ability to create and manage all data aspects in end-to-end solutions.
• Experience with the Microsoft Azure platform.
• Knowledge of principles of database design, data acquisition and data access analysis and design.
• Self-motivated with ability to work with minimal supervision while supporting multiple projects and activities.
• Ability to translate technical specifications, and/or logical and physical design into code for new or enhancement projects.
• Focused on results.
• Experience working with Access and Excel.
• Experience in the following required: SSIS, SSAS, SSRS.
• Experience in the following recommended: Powershell, Source Control: TFS, Python.
• A cover letter and resume are required to apply for the position.

Description

We are looking for a bright, motivated, analytical SQL Database Developer to join our team in our Folsom/Sacramento office. Working with our research and information management groups the SQL Developer will service the critical information needs across our organization.

Our monthly reports cover housing markets on a national, regional, and metro-level basis. Our diverse group of clients includes home builders, developers, hedge funds, private equity groups and banks. We enjoy challenges, problem solving, economic analysis, market research and working on a team. We take great pride in all our work and have uncompromised ethics.

To succeed, you will need to be comfortable managing several projects at once and handle the occasional quick turnarounds.

Duties and Responsibilities:

• Support in the development, implementation, integration, and presentation of reports to support data analysts.
• Generate code to extract, transform and load data from production data sources to the data warehouse.
• Support database design, development, architecture, modernization, and implementation, including long- and short-term requirements.
• Participate in the database specification and review process to ensure system requirements can be translated into required report implementations.
• Participate and contribute to database/report development processes.
• Validate, analyze, and debug code to ensure accuracy and reliability of the data.
• Create stored procedures, triggers, functions, and complex queries.
• Maintain and enhance the existing data warehouse, exports, and reports.
• Create and maintain documentation for all projects.
• Perform quality checks on reports and exports.

About the Company

John Burns Real Estate Consulting, LLC provides independent subscription research and customized consulting services to executives at more than 600 companies related to the U.S. housing industry. John Burns founded the company in 2001 because he saw the opportunity to conduct better housing market analysis for executives. The company has grown to a highly passionate team of more than 100 research analysts and consultants in locations across the country, who work together to provide the most trusted source of U.S. housing analysis and consulting services.

Three principles guide us:

• Purpose: Solving today to help you navigate tomorrow.
• Vision: To be the most trusted and respected U.S. housing market analysts and consultants.
• Mission: To help executives make informed housing industry investment decisions.
• If you enjoy challenges, take great pride in 100% accuracy and professional appearance in all the work you complete, have a passion for excellence and enjoy working with a fantastic team that supports each other, this is the dynamic environment for you.

Employee Benefits

We offer everything we need to offer to attract and retain the best people:

Competitive Salary plus Profit Sharing

Retirement Benefits – 3% of your salary plus profit sharing added to our 401(k), even if you do not contribute, plus the opportunity for you to contribute the maximum benefit allowable by law.

Vacation and Leave – 4 weeks of personal, paid time off, plus 8 holidays and one paid day to volunteer as well as paid maternity and paternity leave.

$10,500 in customizable medical and other benefits – The company contributes $10,500 (in 2022) toward all other benefits, including high quality medical, dental, vision, and prescription drug coverage options, and offers flexible spending accounts. This amount fully covers all insurance for the dependents of more than half of our team members and allows those who spend less on insurance to spend the money on a plethora of other benefits, ranging from childcare to additional contributions to their 401(k).

Additional Customizable Benefits – We are a Continuous Learning organization that offers plenty of training courses, as well as selective tuition reimbursement, flex schedules and locations for many positions, with the ability to grow and expand your career.

Charitable Contributions – We match contributions to the charities of your choice up to $1,000.

A Great Work Environment for high achievers – We offer the opportunity to work with PALS (Passionate, Articulate, Likable and Smart) team members who have completed our proprietary training that includes Master Communicator (Compassionate, Candid, and Clear communication), Financial Literacy (we share detailed financials monthly and help everyone track a metric they personally impact) and Connected Worker (working successfully remote).