Data Engineer Analyst

Ian A Menendez

***.**.****@*****.*** 773-***-**** Chicago, IL 60610

SUMMARY

Experienced and results-driven Senior Data Engineer and Analytics Leader with a strong track record of designing and optimizing data warehouses, building scalable ETL pipelines, and delivering end-to-end analytics solutions across enterprise environments. Skilled in architecting modern data platforms using Microsoft Fabric, Azure Data Factory, Synapse Analytics, Power BI, and SQL to support cross-functional reporting, automation, and decision-making. Proven ability to lead technical teams, unify data across complex business domains, and translate business needs into actionable, data-driven strategies. Adept at improving data infrastructure performance, enhancing self-service analytics, and presenting clear insights to executives and stakeholders. Recent experience includes leveraging AI tools and prompt engineering techniques to prototype intelligent workflows, enhance automation, and support innovative analytical use cases.

EXPERIENCE

Senior Data Engineer / Data Analyst Manager City Mattress Delray, FL

12/2023 – Current

Led the design, implementation, and support of a modern analytics architecture using Microsoft Fabric, including Fabric Lakehouse, Mirrored Database, Data Factory Pipelines, Synapse Analytics, and Power BI Semantic Models.

Engineered scalable ETL pipelines and warehouse solutions across Azure Synapse and ADF, enabling reliable ingestion of high-volume transactional and operational data with improved performance and resiliency.

Directed the successful delivery of a company-wide Common Data Model, aligning data structures and business definitions across Finance, Marketing, Sales, and Operations.

Implemented automated alerting, self-healing logic, and monitoring frameworks to proactively detect and resolve data pipeline issues, minimizing downtime and manual intervention.

Optimized cross-functional Power BI reports and Semantic Models using DAX and tabular modeling best practices, significantly improving refresh performance and user experience.

Created centralized SQL views and stored procedures to serve as the foundation for critical dashboards, ensuring data consistency and streamlined access for analysts and business users.

Standardized documentation processes, metadata tracking, and data dictionary efforts across systems, increasing transparency and long-term maintainability of the data ecosystem.

Diagnosed and corrected data quality issues across business-critical reports, improving trust and adoption of analytics solutions at all organizational levels.

Regularly partnered with C-level executives and departmental leaders to translate business challenges into scalable, data-driven solutions that influenced strategic direction.

Mentored analysts and business users on Power BI report building, DAX fundamentals, and best practices in semantic modeling, supporting a self-service analytics culture.

Played a key leadership role in transitioning legacy reporting infrastructure into Fabric-based modern data architecture, positioning the company for future growth and innovation.

Prototyped AI-powered solutions using prompt engineering with LLMs to streamline reporting workflows and automate insight generation for business stakeholders.

Lead Data Analyst / Data Engineer Cellcore Biosciences West Palm Beach, FL

07/2023 – 12/2023

Sole Data Analyst and Engineer responsible for end-to-end data architecture, ETL development, analysis, and dashboard delivery across Sales, Operations, and Finance departments.

Built and maintained automated ETL pipelines using SQL and Python to integrate data from MySQL in Azure, Salesforce, Shopify, and SAP HANA, improving data freshness and reliability for reporting.

Established and implemented a comprehensive Data Governance policy and company-wide Data Dictionary, laying the foundation for scalable, compliant data management.

Led Tableau and Power BI administration, including license management, permission structures, workspace configuration, and user onboarding.

Optimized data warehouse structures and SQL logic to improve report performance by 30% and reduce load times for large datasets.

Delivered executive-ready dashboards and KPI visualizations, including event ROI analysis, customer lifetime value models, and revenue trend projections.

Collaborated cross-functionally with developers and IT stakeholders to ensure accurate data capture and clean integration with operational systems.

Regularly presented to C-Suite and Board of Directors, translating complex datasets into strategic business recommendations.

Conducted company-wide training sessions to increase data literacy and empower teams to explore insights independently.

Created robust, parameterized SQL queries and stored procedures to support dynamic, ad-hoc reporting needs.

Actively led requirement gathering and solution design with senior leadership to ensure alignment between data systems and business strategy.

Explored generative AI use cases and built early prompt engineering frameworks to test how LLMs could accelerate report generation and automate data summaries.

Lead Data Analyst / Jr Data Engineer Now Optics Delray Beach, FL

06/2020 – 07/2023

Served as Lead Data Analyst, Junior Data Engineer, and Tableau Administrator within a multidisciplinary team, supporting data visualization and reporting across Finance, Operations, and Marketing primarily.

Led a team of 5 data engineers and 3 Tableau developers, acting as the primary liaison between business stakeholders and the data team for requirement gathering and solution design.

Built and maintained ETL pipelines using SQL and SSIS to consolidate data from multiple sources (POS, CRM, and HER systems), significantly improving data accessibility and reducing latency in reporting.

Implemented rigorous data quality measures, including removal, and merging of duplicate patient accounts while remaining HIPPA compliant, resulting in more accurate and reliable reporting metrics.

Migrated legacy Excel-based and Tableau reporting into centralized, scalable Tableau and Power BI dashboards, reducing manual processes and increasing data reliability

Engineered automated workflows to detect and correct data discrepancies across systems, increasing data accuracy for key KPIs and executive reports.

Collaborated with backend developers to optimize table structures and indexing strategies, resulting in a 40% improvement in query performance.

Conducted post-migration audits of Tableau dashboards and SQL queries to ensure consistency with historical data and reporting logic.

Designed robust SQL views and complex subqueries to enable deeper insights into customer behavior, store performance, and sales trends.

Delivered high-impact visualizations, including a Shipping Analysis Dashboard ($500K projected savings), Promotion ROI Dashboard, and Executive P&L Summary.

Performed requirement gathering directly with business executive leadership to shape strategic reporting tools and drive data-driven business decisions.

Service and Engagement Manager Target West Palm Beach, FL

01/2019 – 06/2020

Analyzed KPI and labor data to optimize staffing strategies, improving sales performance and customer satisfaction across departments.

Built and presented Excel-based visualizations and pivot tables to guide operational decisions and communicate results to leadership.

Managed training, scheduling, and performance expectations across multiple teams to consistently exceed district benchmarks.

Account Manager CDW Chicago, IL

03/2017 – 10/2018

Identified client needs and delivered tailored IT and data solutions by analyzing customer data and internal metrics.

Coordinated cross-functional teams to ensure timely and successful project execution.

Created and presented client-facing reports and solution proposals, translating technical offerings into business value.

Managed project timelines, tracked outcomes, and captured lessons learned to improve future delivery.

EDUCATION

Master of Science in Data Engineering

Western Governors University Salt Lake City, UT Graduation: 05/2026

Bachelor of Science in Business Administration, Information Technology (IT) Management

Western Governors University Salt Lake City, UT Graduation: 05/2023

CERTIFICATION & TRAINING

Power BI Certified, Coderhouse

Python Code for Data Analysis Certified, freecodecamp

Data Engineering, Coderhouse (Enrolled, Complete By: 05/2023)

Tableau Creator, Tableau

SQL: Querying and Managing Data, Khan Academy

Data Analytics and Data Management Course, Western Governors University

Advanced Excel Functions and Pivot Tables for Data Visualization, Western Governors University

SKILLS

Power BI

Tableau

Python

SQL

ETL

Executive Comms

Data Analytics

Azure

Synapse

Azure Data Factory (ADF)

Synapse

Business Requirements

APIs

PostgreSQL

GraphQL

Microsoft Fabric

Requirement Gathering

Customer Presentation

Client Management

SSIS

Documentation

Team Management

Project Management

Systems Documentation

Report Building

AI Prompt Engineering

Problem-Solving

Interpersonal Skills

Client Presentation

Training

On-Boarding

Hiring

Mentoring

Contact this candidate