Murphy Huang
AUBREY
Summary
Results-driven Analytics Engineer with extensive experience at First Command Financial Services, specializing in advanced data analytics and cross-functional collaboration. Proven track record in optimizing data pipelines and implementing AI-driven forecasting models, enhancing decision-making accuracy and operational efficiency. Skilled in SQL and adept at fostering teamwork within data-driven environments.
Overview
4
4
years of professional experience
1
1
Certification
Work History
Analytics Engineer III
First Command Financial Services
Fort Worth
07.2025 - Current
- Continue driving innovation and operational efficiency through advanced analytics solutions. Lead cross-functional teams to deliver impactful data-driven strategies.
- Spearheaded migration to scalable, cloud-native data architectures using Fabric, improving data processing efficiency.
- Developed data models to enhance reporting capabilities for financial analysis.
- Collaborated with cross-functional teams to gather requirements and define analytics solutions.
- Conducted data validation to ensure accuracy and reliability of financial information.
- Assisted in troubleshooting technical issues related to analytics software and systems.
- Championed the development of organization-wide KPI frameworks, standardizing business metrics and analytics.
- Mentored junior data professionals, fostering a culture of collaboration and continuous learning within the data team.
- Partnered with leadership to implement AI-driven forecasting models, increasing planning accuracy for company-wide initiatives.
Analytic Engineer II
First Command Financial Services
Fort Worth
01.2022 - 07.2025
- Design and maintain robust data pipelines, ensuring seamless data flow from multiple sources into data warehouses and analytical platforms. Develop dynamic dashboards and visualizations, delivering clear data insights that empower stakeholders to make informed, data-driven decisions. Produce detailed documentation for all data processes and products, ensuring transparency and consistency across teams.
- Automated repetitive tasks through custom tools and scripts, improving workflow efficiency and making data more accessible to non-technical users.
- Led DevOps initiatives focused on enhancing system reliability, optimizing performance, and driving cost-effective solutions.
- Extracted actionable insights from complex data sets by creating and deploying advanced statistical models and algorithms.
- Designed and visualized semantic models to enhance data products, ensuring clarity and usability across analytics teams.
Compensation & Recognition Report Analyst
First Command Financial Services
Fort Worth
06.2023 - 09.2024
- Developed and implemented reporting and visualization solutions to facilitate monthly sales volume analysis, enhancing decision-making accuracy. Partnered with external contractors to design and deploy advanced compensation data models, ensuring alignment with organizational goals.
- Optimized and visualized key performance metrics, including New Money Revenue Credit, New Client Creation, and Military Planning Incentives, supporting Compensation, Finance, and Advisor Operations teams.
- Leveraged tools such as Alteryx, AS 400, SQL Server, and MS Azure to streamline workflows, reducing data processing workload by 40%.
- Spearheaded the transition of the compensation and recognition system from SAP to CIQ, impacting over 1,500 employees.
Business Intelligence Engineer Intern
First Command Financial Services
Fort Worth
06.2022 - 06.2023
- Designed and implemented a solution to track asset flow within the Asset Management System (AMS), enabling the finance department to predict client and advisor lifetime value, effectively reducing attrition risk. Created a client experience score and asset flow monitoring dashboard to provide real-time insights into advisor performance and asset management.
- Developed and executed a Customer Experience (CX) score to evaluate advisor service performance, strengthening client relationships, and aiding the marketing team in improving advisor effectiveness.
- Established role-based and column-level security protocols across platforms such as Power BI and Fabric, significantly enhancing data privacy and security.
- Streamlined compliance reporting processes using SQL, enhancing the accuracy and timeliness of audit requests.
Education
Master of Science - Business Analytics
Texas A&M University-Commerce
Commerce, Texas08.2022
Bachelor of Arts - Chemistry
Southern Methodist University
Dallas, Texas05.2021
Skills
- SQL, R, Python, Tableau, Power BI, IBM Cognos Analytics, ThoughtSpot, MS Azure, MS Access, MS Office Suite, Alteryx, Captivate IQ, Compensation & Recognition
- Data Analysis & Reporting
- Advanced Data Analytics & Insights
- Data Governance & Compliance
- Data Pipeline Management
- Business Intelligence Solutions
- Cross-Functional Collaboration
- Dashboard & Data Visualization
- Data Warehousing & Integration
- Reporting System Optimization
- Process Optimization & Automation
- Performance Metric Development
- Data Privacy & Security Protocols
- Project Management & Coordination
- Data-driven Decision Making
- Forecasting & Predictive Analytics
- Data modeling
- SQL development
- Advanced analytics
- Business intelligence
- Cross-functional collaboration
- Problem solving
- Power BI tools
- SQL database management
- Data warehousing
Certification
- Tableau Desktop Specialist
- Google Data Analytics Certification
- IBM Data Science Professional Certificate
- Microsoft Certified: Power BI Data Analyst Associate
- Alteryx Foundation Certified
- Alteryx Designer Core Certified
Timeline
Analytics Engineer III
First Command Financial Services
07.2025 - Current
Compensation & Recognition Report Analyst
First Command Financial Services
06.2023 - 09.2024
Business Intelligence Engineer Intern
First Command Financial Services
06.2022 - 06.2023
Analytic Engineer II
First Command Financial Services
01.2022 - 07.2025
Master of Science - Business Analytics
Texas A&M University-Commerce
Bachelor of Arts - Chemistry
Southern Methodist University
Similar Profiles
Kimberly SparksKimberly Sparks
Supervision Principal – Contract Role at First Command Financial ServicesSupervision Principal – Contract Role at First Command Financial Services
Natalie PalaNatalie Pala
Insurance Operations Specialist /Insurance Operations Associate at First Command Financial ServicesInsurance Operations Specialist /Insurance Operations Associate at First Command Financial Services
Mohammed AbukhiranMohammed Abukhiran
Principal Architect at First Command Financial ServicesPrincipal Architect at First Command Financial Services
Katheryn HernonKatheryn Hernon
Licensed Practical Nurse at ClinovatorsLicensed Practical Nurse at Clinovators
Grace StewartGrace Stewart
PM Floor Manager at The Kid's CorralPM Floor Manager at The Kid's Corral