Logo
i-staff

Lead Data Architect

i-staff, Dallas, Texas, United States, 75215

Save Job

Position Summary We are seeking a highly skilled and versatile

Lead Data Architect / Developer

to support and enhance our existing data infrastructure while leading the design and implementation of a modern, cloud-based data platform. This role is perfect for a technically strong professional who enjoys both maintaining mission-critical systems and building innovative solutions from the ground up. In the immediate term, you will play a key role in supporting and optimizing our

SQL Server 2017

environment to ensure stability and performance for business operations. At the same time, you will help shape our next-generation platform in

Microsoft Azure and Microsoft Fabric , driving data architecture, integration, and reporting initiatives. This is a unique opportunity to work across a wide range of technologies, collaborate with cross-functional teams, and make a lasting impact on the future of our data ecosystemall while ensuring continuity and reliability of todays systems. Strong communication skills are essential, as you will regularly partner with other departments and present technical concepts to both technical and non-technical audiences. Key Responsibilities Support and maintain the current

SQL Server 2017

environment, ensuring performance, availability, and reliability. Design and implement scalable, secure, and efficient data solutions in

Microsoft Azure and Microsoft Fabric , including Azure SQL, Data Factory, and Synapse. Develop and optimize

data pipelines, ETL/ELT processes, and integrations

between systems using modern tools and best practices. Build and maintain

Power BI dashboards and data models

to support analytics and reporting. Collaborate with cross-functional teams to gather requirements and deliver effective solutions aligned to business needs. Ensure

data quality, governance, and security

across both legacy and modern platforms. Document architecture, workflows, and processes to support knowledge sharing. Proactively monitor and troubleshoot systems and integrations. Lead and contribute to the planning and execution of the

data platform migration strategy . Stay current with emerging Azure and Fabric capabilities, recommending innovations where appropriate. Debug and troubleshoot

SQL, SQL Server databases, Python code, and APIs . Qualifications Bachelors degree in Computer Science, Information Systems, Data Engineering, or related field (Masters preferred). 7+ years of experience in data engineering, data development, or database administration. 3+ years of experience with

Microsoft Azure data services

(Azure SQL, Data Factory, Synapse, etc.). Strong experience with

Microsoft Fabric

for modern analytics, data modeling, and integration. Deep expertise in

SQL Server , including performance tuning, stored procedures, and database design. Proven experience with

Power BI

dashboards and data models. Development experience with

T-SQL, SSRS, SSIS, Python, and APIs . Hands-on experience building and supporting ETL/ELT pipelines and integrations. Exposure to multiple database technologies (e.g., PostgreSQL, NoSQL, columnar databases). Familiarity with

CI/CD practices

(Azure DevOps preferred). Strong communication, organizational, and problem-solving skills. Preferred Experience Background in

Construction, Single Family, Multi-Family, Commercial Property Management, or Accounting . Experience supporting and modernizing legacy systems while migrating to cloud-based platforms. Familiarity with

data governance, compliance, and security best practices . Why Join Us? This is a rare opportunity to lead both the

support of critical legacy systems

and the

design of a next-generation Azure/Fabric data ecosystem . Youll collaborate with stakeholders across the organization, drive innovation, and make a direct impact on the way we manage and leverage data.