Senior SQL Developer

At Van Metre, we believe that each employee contributes directly to our growth, success and culture. We seek out candidates who love to challenge themselves and work with others to fulfill this role. Van Metre Companies is seeking a Senior SQL Developer to work in our New Homes Division!

This is a fully remote opportunity

Position Summary: 

The Senior SQL Developer will design relational databases and data warehouses on Microsoft SQL server and Microsoft Azure SQL databases; develop ETLs to update the data warehouse; and write T-SQL queries and stored procedures to perform data analysis and to support reporting.

This role will involve collaborating with developers in the Business Intelligence team to provide the best practice suggestions for application development and the data system upgrade.  This role will also take DBA responsibilities to create user accounts, to grant permissions, and to implement database security policies.

Responsibilities:

• Leading the design, development, and optimization of complex SQL database designs, SQL queries, and SQL stored procedures  to meet business requirements.
• Proactively identifying and addressing database performance issues, and data quality concerns to ensure scalability and responsiveness.
• Designing and executing data migration projects by using SSIS and Azure Data Factory to ensure seamless transitions and minimal downtime.
• Implementing robust security protocols and compliance measures to protect sensitive data and ensure regulatory adherence
• Investigating and resolving data quality issues and query problems for the data warehouse and the internally developed applications.
• Providing technical leadership on database projects to guide the team in best practices and innovative solutions
• Collaborating with cross-functional teams to align database solutions with organizational goals and the latest new technologies.
• Maintaining comprehensive documentation of database architectures, processes, and best practices.
• Monitoring the logs and notification messages of the data warehouse ETL processes.  Resolving the ETL issues effectively and in a timely manner.

Required skills & experience:

• An advanced Microsoft T-SQL programming, including complex query optimization and database management skills.
• In-depth knowledge of the relational data modeling techniques, including normalization and denormalization, for efficient database designs.
• A proven track record of successful database project management from inception to completion.
• Skills to effectively communicate with technical and nontechnical stakeholders, translating technical concepts into actionable tasks.
• Problem-solving and decision-making abilities, especially in high-pressure situations.
• Ability to stay up-to-date with the latest trends and technologies in the database and data warehouse field and adapt to the evolving industry standards.
• Design and Program ETLs with SSIS, SQL stored procedures and Azure Data Factory.
• DBA skills to create user accounts, to grant permissions, and to implement database security policies.
• Have skills to create ODBC connections on users’ computer.
• Have knowledge and skills of using data comparison tools, such as Red-Gate SQL Data Compare, and Microsoft Visual Studio.

Compensation and Benefits information: Van Metre offers excellent benefits, and a work environment that fosters and rewards excellence. We also promote work/life balance, including a robust Employee Wellness Program.  We encourage employees to make full use of vacation and other company-paid leave to refresh their bodies and minds.

• Salary: $120,000 annually (Pay is commensurate with experience, education, training, and skills)
• Paid Time Off: 11 paid holidays; 10 vacation days, 10 sick days, Two Volunteer Days off, Two Personal Days, Winter Break, Day off for Annual Physical, Day off for your Birthday; comprehensive parental and bonding leave
• Retirement Planning: Company Matched 401(k) Retirement Savings Plan; access to retirement planning coaches
• Wellness: Annual Wellness Reimbursement of up to $900; Free and unlimited access to TaskHuman Wellness App for yourself and your family members.

Van Metre Core Values

Integrity; Ownership; Respect and Dignity; Diversity and Inclusion; Teamwork; Community; Work/Life Balance                                                          

Van Metre Mission Statement

The mission of Van Metre Companies is to build and continually improve upon the storied reputation, earned over the years since the Company’s founding in 1955, of providing top quality homes, investment properties and services to our customers and clients. The Company’s emphasis on integrity, professionalism and philanthropy ingrained by our founder Albert G. Van Metre, Sr. has garnered trust and respect in the Washington, D.C. area and beyond. It is critical to our future that we maintain that reputation and assure that Van Metre Companies continues to excel in real estate development and construction and in the management of apartment, retail and office investment properties, as well as in the provision of mortgage and related services. It is the task of our dedicated, energetic, and involved professionals to advance our ability to set the benchmark for luxury living and refined commercial development. The capstone of our mission is to make the “Van Metre” signature an icon for elegant residential communities, and industry leading condominium and apartment communities, as well as Class A neighborhood retail centers and office developments.