Skip to Main Content

SQL Database Developer

John Burns Real Estate Consulting, LLC
Folsom, CA
  • Posted: 2 days ago
  • Full-Time
Job 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.

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

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 the 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.

Desired Skills and Experience:
  • 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 the 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.

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 US 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 US 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 US housing market analysts and consultants.
  • Mission: To help executives make informed housing industry investment decisions.
If you enjoy want to help a well-established, dynamic team take it to the next level, this is the 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 also 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 the 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).


About John Burns Real Estate Consulting, LLC:

John Burns Real Estate Consulting, LLC provides independent research and consulting services related to the US housing industry.John Burns founded the company in 2001 because he saw a need for better analysis on the housing market. The company has grown to a highly passionate team of research analysts and consultants in offices across the country, who work together to provide the most trusted source of US housing analysis.PurposeSolving today to help you navigate tomorrow.VisionTo be the most trusted and respected US housing market analysts and consultants.MissionTo help executives make informed housing industry investment decisions.

John Burns Real Estate Consulting, LLC

Address

Folsom, CA
USA

Industry

Technology

What email should the hiring manager reach you at?

By clicking the button above, I agree to the ZipRecruiter Terms of Use and acknowledge I have read the Privacy Policy, and agree to receive email job alerts.