Elliott Pawlak
Rockland,MA
Summary
Strategic Analytics Engineer and Business Intelligence Professional with military leadership experience and expertise in scalable data architecture. Centralized fragmented data infrastructures using Snowflake, SQL, and Python. Translated executive requirements into automated data models and KPI dashboards to enhance operational efficiency while managing cross-functional teams.
Overview
6
6
years of professional experience
1
1
Certification
Work History
Business Intelligence Officer
Office of the Veteran Advocate
Braintree, MA
09.2024 - Current
- Implemented technology solutions using Snowflake, Salesforce, and Microsoft Power BI to meet operational requirements.
- Engineered three analytical dashboards uniting over 20 data sources for deeper insights.
- Engaged 8 executive agencies to identify technological opportunities and develop innovative solutions.
- Co-authored research paper analyzing Massachusetts laws on veteran benefits to inform policy recommendations.
Community Outreach Specialist
City of Boston
Boston, MA
06.2023 - 08.2024
- Developed $2,000,000 grant to enhance resources for local veteran organizations.
- Analyzed de-identified datasets encompassing 16,000+ individual records to isolate regional programmatic trends, directly uncovering insights that optimized local resource deployment.
- Authored project plans for over 50 city events, outlining tasks and deadlines to ensure successful implementation.
Army Officer
US Army
Fort Sill, OK
05.2020 - 06.2023
- Managed resources exceeding $2,000,000 to optimize mission support and operational capabilities.
- Guided 20 subordinates to achieve clear task objectives and enhance overall mission effectiveness.
- Synthesized complex intelligence briefings and predictive tracking data to present actionable operational recommendations directly to executive commanders.
Education
Master of Science - Information Technology
University of Massachusetts, Boston
Boston, MA05-2027
MBA - Business Administration
University of Massachusetts, Boston
Boston, MA05-2025
Bachelor of Arts - Criminal Justice
University of Massachusetts, Dartmouth
North Dartmouth, MA05-2020
Skills
- Data Architecture & Warehousing: Snowflake, ETL/ELT Pipeline Development, Relational Modeling, Data Cleansing
- Languages & Querying: Advanced SQL (Complex Joins, Window Functions), Python (Pandas, NumPy, Automation scripts)
- Business Intelligence: Microsoft Power BI (Advanced DAX, Modeling), Salesforce System Administration, Dashboards
- Methodologies & Management: Technical Project Management, Agile Frameworks, Cross-Functional Stakeholder Alignment
Certification
- MIT Certificate in Applied Agentic AI for Organization Transformation
- Data Analyst Associate
- Data Engineer Associate
- UMass Amherst Post Graduate Program in Project Management
Timeline
Business Intelligence Officer
Office of the Veteran Advocate
09.2024 - Current
Community Outreach Specialist
City of Boston
06.2023 - 08.2024
Army Officer
US Army
05.2020 - 06.2023
Master of Science - Information Technology
University of Massachusetts, Boston
MBA - Business Administration
University of Massachusetts, Boston
Bachelor of Arts - Criminal Justice
University of Massachusetts, Dartmouth