Database Developer

Insight Global

Seattle, WA

Apply

JOB DETAILS

SKILLS

Access Control, Analysis Skills, Artificial Intelligence (AI), Best Practices, Business Operations, Business Support, Communication Skills, Data Management, Data Modeling, Data Quality, Data Recovery, Database Administration, Database Architecture, Database Programming, Database Technology, Deltek Accounting Software, Deltek Vision, Documentation, ERP (Enterprise Resource Planning), Enterprise Data Integration, Failover, File Management, File Systems, Finance, Financial Analysis, Financial Operations, Financial Reporting, Financial Systems, High Availability, High Reliability, Identify Issues, Incident Response, Infrastructure as a Service (IaaS), Internet Security, Leadership, Machine Learning, Machine Tool, Maintain Compliance, Mentoring, Microsoft SQL Server, Microsoft SQL Server DBA (Database Administration), Microsoft Windows Azure, MongoDB, MySQL, Operational Support, People Management, Performance Tuning/Optimization, Platform as a Service (PaaS), Power BI, Production Support, Production Systems, Redis, Risk Management, SQL (Structured Query Language), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Secure/SSH File Transfer Protocol (SFTP), Security Auditing, Server Programming/Applications, Software Development, Software Patches, Stored Procedures, Support Documentation, System Integration (SI), System Validation, Systems Administration/Management

LOCATION

Seattle, WA

POSTED

1 day ago

Job Description In practice, the role functions as the firm's technical authority for SQL-based data platforms, ensuring reliability, integrity, compliance, and continuity of NBBJ's core data assets. The approximate distribution of responsibilities is as follows: - 55-65% Digital / firmwide responsibilities o Enterprise database development and architecture o Data infrastructure and system integration o Broader database administration supporting firm systems - 35-45% Finance-focused responsibilities o Deltek Vantagepoint development, maintenance, and administration o Finance-related analytics, 3rd party systems integrations, and reporting support o AI and Database enhancements supporting Finance workflows and process evolution Technical Responsibilities - SQL Platform Ownership and Administration - Own and operate NBBJ's SQL Server environments, including standalone and clustered deployments, including both on-premises and Azure PaaS and IaaS instances. - Own and operate non-SQL environments such as Redis, MongoDB, MySQL. - Install, configure, patch, and upgrade SQL Server instances and related components such as SQL Server Integration Services and Reporting Services, during nights or weekends as needed. - Serve as the primary escalation point for SQL platform issues, performance tuning, and stability concerns. - Design and maintain high availability and failover configurations, including backup and recovery processes, to ensure business continuity. Database Development and Data Engineering - Design, build, and maintain operational and reporting databases that support finance, operations, BIM, and studio leadership. - Develop and maintain SQL objects including schemas, tables, views, stored procedures, and functions. - Implement data transformations and pipelines using SQL Server Integration Services and related tooling. - Modify data models to support evolving business requirements while maintaining data integrity and performance. - Collaborate with stakeholders to implement repeatable, maintainable database changes and data engineering practices that support reliable reporting. Enterprise Data Integration - Own and maintain data integrations between core enterprise systems, including Deltek Vantagepoint, HR and talent systems, finance and payroll platforms, and third-party vendors. - Manage secure file transfers and system to system feeds, including SFTP based integrations. - Troubleshoot and resolve data feed, synchronization, and downstream system issues in coordination with stakeholders. - Ensure integrations are reliable, monitored, and documented to support operational continuity and reporting accuracy. - Security, Access, and Compliance Support - Design and maintain role-based access controls for SQL environments, including separation of finance and nonfinance access. - Collaborate with Cybersecurity and Infrastructure teams on security controls, service accounts, and incident response activities related to database systems. - Support audit, compliance, and risk management activities by providing data, documentation, and secure handling of sensitive information. - Ensure databases and integrations align with internal security standards and client confidentiality requirements. Finance and Operational Partnership - Serve as a trusted technical partner to Finance, Operations, and other leadership teams. - Support financial reporting and analysis lead process evolution, and drive system innovation. - Translate strategic business questions into analytical approaches, including determining when traditional statistical methods, machine learning, or generative AI tools are the most appropriate path to insight - Assist with audits and reviews by retrieving and validating system documentation and data outputs. - Provide guidance on data usage, limitations, and interpretation for decision-making. Collaboration and Knowledge Sharing - Work closely with application developers, analysts, infrastructure engineers, cybersecurity, and business stakeholders. - Document systems, processes, and dependencies to reduce institutional risk. - Mentor and cross-train designated backups to ensure continuity of critical database functions. We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com.To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/. Skills and Requirements - 4-6+ years of experience in database administration and development - Advanced experience administering and developing on Microsoft SQL Server platforms. - Strong expertise in SQL development, performance tuning, and troubleshooting. - Hands-on experience with SQL Server Integration Services and Reporting Services. - Experience supporting Finance teams, HR, or ERP systems such as Deltek Vision or Vantagepoint. - Understands, has experience with, and can articulate mid-level to complex financial concepts - Familiarity with Power BI and enterprise reporting platforms. - Working knowledge of data governance, audit support, and security best practices related to enterprise data platforms. - Experience designing and supporting business-critical operational and financial data systems. - Ability to work independently, manage competing priorities, and support production systems with high reliability expectations. - Strong communication skills and the ability to work effectively with both technical and non-technical stakeholders

About the Company

Insight Global

INDUSTRY

Other/Not Classified

Resume Resources

Free Resume Templates Free Resume Builder