Solutions Architect

SummaryBalfour Beatty is seeking a Solutions Architect to work in Dallas TX. This is a hybrid position (three days in the office two from home).The Solutions Architect will own the vision architecture and delivery of our BI platforms across AWS SQL Server Azure and Microsoft Fabric. Youll collaborate closely with business stakeholders guide a small team of BI developers and drive our migration from SQL Server to the Azure/Fabric data ResponsibilitiesPlatform OwnershipManage and enhance two BI environments:AWS (S3 Redshift Lambda ETL Power BI)SQL Server stack on EC2 (SSAS SSIS BIML Power BI)Cloud MigrationLead the end-to-end migration of our SQL Server BI solution to Azure Data Factory Synapse Analytics OneLake and other Microsoft Fabric servicesDevelopment & ArchitectureDesign build and optimize data pipelines semantic models and reportsImplement best practices for data modeling (Star/Snowflake schemas) performance tuning and securityDelivery ManagementDefine project scopes schedules and priorities for multiple concurrent BI initiativesTrack milestones manage risks and report status to stakeholdersStakeholder EngagementPartner with business customers to gather requirements scope new initiatives and translate needs into technical designsFacilitate design reviews demo sessions and end-user trainingTeam LeadershipMentor and coach BI developers/analysts; conduct code reviews and knowledge-sharing sessionsEstablish and evangelize standards for data governance testing and documentationRequirementsBachelors degree in Computer Science Information Systems or related field5 years of hands-on BI development and architecture across both AWS and SQL Server stacksDeep hands-on experience with Power BI and DAX for advanced calculations custom visuals and performance tuningStrong expertise in:AWS BI: S3 Redshift LambdaSQL Server BI: SSAS SSIS (on EC2)Azure & Microsoft Fabric: Data Factory on Fabric Synapse Analytics OneLake Data Activator Azure Analysis ServicesExposure to BIML a plusProven track record migrating SQL Server BI solutions to Azure/FabricExperience with data modeling ETL design patterns and semantic layer developmentMicrosoft Certified: Azure Data Engineer Associate and/or Microsoft Fabric Data Engineer (preferred)Job SkillsTechnical Leadership: Ability to set architecture direction enforce standards and drive continuous improvementAnalytical Thinking: Strong problem-solving skills attention to detail and data-driven mindsetCommunication: Excellent verbal and written skills for working with both technical teams and non-technical stakeholdersDelivery Management: Skilled at scheduling prioritizing tasks and managing stakeholder expectationsCollaboration: Comfortable facilitating workshops requirement sessions and cross-functional teamingAdaptability: Eager to learn new technologies and adjust to evolving business needs