Database Administrator - Azure SQL & Microsoft Dataverse

About the role

The ideal candidate will possess deep expertise in leveraging APIs and modern integration technologies to connect disparate data sources, coupled with a proven ability to utilize Power BI and other analytical tools for data-driven insights. This role requires a proactive individual with a strong understanding of database optimization, scripting, and automation techniques to ensure the performance, security, and reliability of our data assets. Experience working in the Architecture, Engineering, or Construction industry is a significant plus.

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.
• Able 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

• SQL Server Database Administrator
• Microsoft Dataverse
• Power BI
• APIs (REST, SOAP)
• Azure Data Factory
• Logic Apps
• T-SQL, PowerShell, Python
• Power BI
• Deltek Vision
• Deltek Vantagepoint
• Autodesk Platform Services (APS / Forge)

Benefits

Not specified

Pay

• $94,027 per year
• $100,000.00 - $120,000.00 per year
• $54,589 per year

Schedule

Not specified