Brian Megilligan

WORK HISTORY

EDUCATION

SKILLS

ABOUT BRIAN MEGILLIGAN

I’m a Senior Data Engineer and Analytics Lead with a foundation in business analysis and a passion for building data solutions that people actually trust and use.After seven years as a Business Analyst (culminating in earning my CBAP), I transitioned into data engineering, where I combined technical execution with strong stakeholder alignment. That background continues to shape how I work: translating business needs into scalable data models, analytics platforms, and reporting solutions.I specialize in enterprise BI and analytics engineering, with deep hands-on experience across Power BI, Microsoft Fabric, Snowflake, Azure Synapse, dbt, and SQL Server. My work spans the full analytics lifecycle, including:* Data modeling and semantic model design* ETL / ELT pipelines (Fabric, Synapse, dbt, SSIS)* Power BI development (DAX, Power Query, CI/CD, deployment pipelines)* SAP data integration and enterprise reporting modernizationAs a consultant and team lead, I regularly guide junior engineers, help teams break down complex initiatives into executable work, and serve as a bridge between technical teams and business stakeholders. I’m especially effective in environments where data quality, governance, and clarity matter as much as speed.I enjoy roles that sit at the intersection of data engineering, analytics, and strategy, and I’m motivated by enabling organizations to make confident, data-driven decisions at scale.