Database Administrator - Azure SQL & Microsoft Dataverse

Responsibilities

• Database Management & Administration
• Data Integration & Connectivity
• Analytics & Reporting Support
• Database Optimization & Performance Tuning
• Scripting & Automation
• Architecture & Design
• Documentation & Standards
• Collaboration & Communication

Requirements

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• Minimum of 5 years of experience as a Database Administrator.
• Extensive experience managing and administering Azure SQL Databases, including performance tuning, security, and high availability configurations.
• Strong experience with Microsoft Dataverse, including entity modeling, security roles, business rules, and solution management.
• Proven experience in utilizing APIs (REST, SOAP) and other modern data integration technologies (e.g., Azure Data Factory, Logic Apps) to connect and integrate data from various sources.
• Solid understanding and practical experience with Power BI or other data visualization and analytical tools.
• Proficiency in database optimization techniques, including indexing, query tuning, and performance monitoring.
• Strong scripting skills in T-SQL, PowerShell, and/or Python for automation and database management tasks.
• Experience with database design principles and data modeling.
• Excellent problem-solving, analytical, and troubleshooting skills.
• 4+ years of experience as a Technical Business Analyst, Data Analyst, or similar analytics-focused role.
• Advanced experience with Power BI, including data modeling, DAX, and performance optimization.
• Strong experience working with SQL, Dataverse, and Azure-based data platforms.
• Proven experience integrating and analyzing data from multiple SaaS platforms and APIs.
• Strong analytical and problem-solving skills with the ability to interpret complex, multi-source datasets.
• Ability to translate AEC business needs into technical solutions and actionable insights.
• Excellent communication skills and the ability to work effectively with both technical and non-technical stakeholders.

Qualifications

• Prior experience working in an architecture, engineering, or construction (AEC) firm.
• Knowledge of Deltek Vision and/or Deltek Vantagepoint, including project, financial, and labor data.
• Experience integrating or working with Autodesk Platform Services (APS / Forge) or Autodesk-related datasets.
• Familiarity with architectural, engineering, or project delivery data, such as fees, budgets, schedules, utilization, and project performance.
• Experience with building, space, or facilities data analysis.

Skills

• Power BI
• SQL
• Microsoft Dataverse
• Azure SQL Database
• Azure Data Factory
• Logic Apps
• T-SQL
• PowerShell
• Python