Business Intelligence Architect (Dallas) at Robert Half

We are seeking a highly skilled and Business Intelligence Architect to lead the development and implementation of an in-house business intelligence (BI) reporting platform. The successful candidate will be the sole developer responsible for designing, building, and deploying the new platform, working closely with the C-suite to deliver actionable insights.Responsibilities:BI Platform Development: Design, develop, and implement a comprehensive BI reporting platform using Power BI.Data Integration & ETL: Extract, transform, and load (ETL) data from various sources, including Planet DDS, Denticon, Eaglesoft (including historical data), Great Plains (Financial Modules), ADP (HR Modules), Denticon (RCM), and MS Dynamics (CRM).Data Modeling & Visualization: Create robust data models and develop interactive dashboards and reports using Power BI for effective data visualization.KPI Development & Tracking: Define, calculate, and track critical practice management KPIs, including doctor performance, client retention, and other dental-specific metrics.SQL Querying & Manipulation: Write complex SQL queries to extract and manipulate data from diverse databases.Azure Data Lake Management: Utilize and manage Azure Data Lake for data storage and processing (data updated every 24 hours).C-Suite Reporting & Presentations: Develop and present ad-hoc and regular reports to the CEO, CFO, and CIO, providing actionable insights.Cross-Functional Collaboration: Work closely with various departments, including HR, Finance, and Operations, to understand their reporting needs and deliver tailored solutions.Data Consistency and Accuracy: Ensure data integrity and consistency across all reporting platforms.Migration Support: Support the ongoing migration from Eaglesoft to Denticon, ensuring data from historical Eaglesoft servers is accurately sourced and integrated.Required Skills & Experience:Power BI Expertise: Advanced proficiency in Power BI for report and dashboard creation, data visualization, and data modeling.SQL Proficiency: Strong SQL skills for querying and manipulating data from various relational databases.ETL Development: Proven experience in designing and implementing ETL processes.Microsoft Environment: Extensive experience with the Microsoft technology stack, including Azure, SQL Server, and Excel.KPI Development & Tracking: Demonstrated ability to define, calculate, and report on key performance indicators.Data Warehousing & Data Lake Experience: Experience working with data warehousing concepts and Azure Data Lake.Dental Industry Knowledge (Preferred): Familiarity with dental practice management systems and KPIs is a plus.Excellent Communication & Presentation Skills: Ability to effectively communicate complex data insights to non-technical stakeholders, including C-suite executives.Independent & Proactive: Ability to work independently and take initiative in a fast-paced environment.Technology Stack:Microsoft Azure Data LakePower BISQL ServerGreat PlainsADPMS Dynamics CRMPlanet DDSDenticonEaglesoft.