Director, Enterprise Data Integration & Analytics

Director, Enterprise Data Integration & Analytics (316)# Director, Enterprise Data Integration & Analytics (316)DHA Headquarters - Dallas , TX 75212## OverviewSalary Range$120,000.00 - $158,700.00 SalaryPosition TypeFull TimeEducation Level4 Year DegreeCategoryInformation Technology## DescriptionJoin the team dedicated to providing affordable housing solutions across North Texas.At DHA, Housing Solutions for North Texas, our mission is to provide quality, affordable housing and access to supportive resources across the region. As the Senior Network Administrator, you play an important role in helping us fulfill this mission by ensuring secure, reliable connectivity across the Agency's LAN, WAN, wireless, VPN, and voice systems.Enjoy these benefits when you join the DHA team!| | | || --- | --- | --- || Flex Work: 4.5 or 4-Day Work Week | Paid Time Off + 12 Paid Holidays | Retirement Plan with 5% Employer Contribution & 457(b) Deferred Compensation Plan || Tuition Reimbursement | Employee Assistance Program: Financial, Legal, Mental Health and Counseling | Medical, Dental and Vision Plans || Section 125 Pre-Tax Cafeteria Plan | Health Savings and Flexible Spending Accounts | Term Life Insurance: Short- and Long-term Disability Plans |Summary:The Director of Enterprise Data Integration & Analytics is a hands-on technical leader responsible for developing DHA's integrated data environment, connecting and streamlining data across multiple Agency systems. This role designs and implements enterprise frameworks for interoperability, integration, analytics, and information sharing across platforms, including Yardi ERP, RentCafe, Paycom, Salesforce, and related operational tools.The position leads personnel engaged in data planning, collection, processing, integration, analysis, visualization, and dissemination, ensuring data-driven execution aligns with DHA's mission. Reporting to the Vice President of Information Technology, the Director partners closely with IT teams, business units, operations, and vendors to deliver modern, high-quality data solutions and analytics that drive operational excellence, strategic planning, and decision-making.Essential FunctionsIntegrated Data Environment & Enterprise Architecture* Design and implement enterprise data integration frameworks that connect, manage, and streamline data across Yardi, RentCafe, Paycom, Salesforce, and BI platforms.* Develop patterns for API integration, ETL/ELT, data synchronization, operational data stores, and cross-system interoperability.* Ensure data flows, dependencies, lineage, and pipelines support efficient Agency operations across construction, housing, finance, HR, and customer service processes.* Lead intelligence data integration, interoperability, and information-sharing efforts within the agency.* Serve as the senior technical authority for enterprise data architecture, metadata management, semantic modeling, and system-of-record governance.Visualization, Analytics, and Business Intelligence* Design, build, and maintain Power BI dashboards, semantic models, composite models, dataflows, and KPI reporting environments.* Develop operational KPIs, performance scorecards, automated reporting pipelines, and real-time dashboards supporting Agency operations.* Build lightweight applications, tools, and Power Apps to streamline data capture, workflow automation, and reporting processes.* Partner with SMEs and operational teams to validate requirements, refine metrics, certify datasets, and deliver business-ready solutions.* Provide ongoing support, troubleshooting, documentation, and training for all BI and reporting solutions. Data Engineering, Pipelines & Automation* Develop and optimize SQL queries, stored procedures, schemas, and data pipelines for analytics and operational workloads.* Implement automation using Python, PowerShell, C#, or integration tools to support KPI extraction, data processing, validation, and monitoring.* Oversee data quality routines, exception reporting, reconciliation processes, and error-handling workflows.* Partner with IT teams to monitor system performance and ensure compatibility with hardware, network, and security standards.* Use feedback from users and system behavior to drive iterative improvements to data pipelines and reporting tools.Implementation, Change Management & Operations* Lead or support UAT, pilot programs, and go-live activities for data systems, integrations, and new analytic capabilities.* Support vendor evaluation and selection of integration platforms, BI tools, and data services.* Develop and deliver training (in-person and virtual) for business users, analysts, and operational teams.* Monitor adoption, gather feedback, and execute continuous improvement cycles.* Assist teams with configuration, testing, validation, and rollout of cross-system integrations or enhancements.Security, Governance & Compliance* Ensure data practices comply with DHA, HUD, federal, and privacy/security regulations.* Oversee governance guidelines for data access, entitlements, retention, and data sharing.* Work with Infrastructure & Security teams to secure data pipelines, Power BI assets, databases, and APIs.* Support audits, regulatory reviews, risk assessments, and incident response activities.Leadership & Collaboration* Lead, coach, and develop staff involved in data engineering, integration, analytics, visualization, and reporting.* Collaborate with application teams (Yardi, Paycom, Salesforce), operations, finance, HR, customer experience, and executive leadership.* Advocate for enterprise-wide data standards and promote a culture of data-driven decision-making.* Act as a hands-on subject matter expert for the most complex data modeling, integration, and visualization initiatives.## QualificationsKnowledge, Skills, and AbilitiesTechnical Knowledge* Deep expertise in Yardi Voyager, RentCafe, Paycom, Salesforce objects, reporting structures, and API frameworks.* Strong skills in Microsoft SQL Server, including T-SQL, data modeling, views, procedures, indexing, and optimization.* Advanced Power BI experience (Power Query, DAX, semantic modeling, DirectQuery, RLS/OLS, dataflows).* Proficiency with integration/ETL tools such as SSIS, Azure Data Factory, Boomi, or Snaplogic.* Advanced knowledge of Python, C#/.NET, and scripting for automation and data transformation.* Understanding of metadata management, master data, governance frameworks, and system-of-record definitions.* Familiarity with cloud platforms (Azure) and modern data pipeline architectures.* Experience with Git and documentation best practices.Skills & Abilities* Ability to architect and deliver scalable, secure, and maintainable data solutions across multiple systems.* Strong analytical, diagnostic, and problem-solving skills across databases, APIs, and BI tools.* Ability to translate business needs into data requirements and actionable insights.* Excellent communication skills for both technical and non-technical audiences.* Ability to manage complex projects, competing priorities, and cross-functional teams.* Strong instructional skills for training users and developing adoption strategies.* Ability to operate with discretion, confidentiality, and compliance discipline.Nice to Have* Experience with business process mapping and modeling data flows supporting operational processes.* Experience building custom visualization frameworks in Power BI.Position QualificationsEducation & Experience* Bachelor's degree in data science, Information Systems, Computer Science, or related field preferred; equivalent experience accepted.* 7–10 years of experience in data integration, analytics, data engineering, or application data ecosystems.* 3–5 years of experience leading data, BI, analytics, or integration teams.* Experience supporting Yardi, RentCafe, Salesforce, or Paycom integrations strongly preferred.Licenses, Certifications, and Other Requirements* Preferred certifications (one or more):* Microsoft Power BI (PL-300), Azure Data Engineer (DP-203), Azure Data Analyst (DP-500)* Yardi technical certifications* Salesforce certifications* Data engineering, analytics, or integration platform certificationsOccasional after-hours or weekend work may be required for data refreshes, cutovers, or system releases. J-18808-Ljbffr