Data Engineer Power Bi

Michael DeShay

Email: **************@*****.*** Phone: +1-404-***-**** Address: GA LinkedIn

Backend-driven Data Engineer and BI Engineer with a strong foundation in Python, SQL, dbt, and Airflow, delivering automated pipelines and cloud-native data solutions. Experienced in optimizing BigQuery, PostgreSQL, and Redshift for high-volume analytics and reporting. Adept at transforming raw data into BI-ready datasets and building reporting solutions with Power BI and SSRS. PROFESSIONAL SKILLS

Programming & Data Engineering: Python, SQL, dbt, Airflow, SSIS, PySpark Business Intelligence & Reporting: Power BI, Looker, SSRS (dashboards & paginated reports), KPI Frameworks Databases: BigQuery, PostgreSQL, CloudSQL, MySQL, MongoDB Cloud Platforms: Google Cloud Platform (BigQuery, Pub/Sub, Cloud Storage), AWS (Glue, Redshift, S3, Lambda) Data Modeling & ETL: Dimensional Modeling, Star/Snowflake Schemas, ETL/ELT Pipelines, Data Quality & Monitoring DevOps & Workflow: GitHub, Git CLI, GitHub Actions, Docker, CI/CD Pipelines Other Tools & Integrations: RESTful APIs, Data Governance, Anomaly Detection, Semantic Layer Design PROFESSIONAL EXPERIENCE

Mastercard, NY Apr 2024 – Current

Data Engineer / BI Engineer

• Designed and maintained scalable ETL/ELT pipelines using Python, SQL, dbt and SSIS supporting enterprise-scale fraud analytics, risk scoring, and BI reporting.

• Automated data ingestion, cleansing, and transformation workflows on Google Cloud Platform (BigQuery, Cloud Storage, Pub/Sub), enabling faster decision-making across risk and finance teams.

• Built and optimized dbt models with version control, automated testing, and CI/CD pipelines, ensuring reliability and consistency in production.

• Developed and supported Looker dashboards and semantic data models, empowering analysts and executives with self-service KPIs.

• Enhanced SQL performance (BigQuery, PostgreSQL, CloudSQL) through partitioning, clustering, and indexing strategies, reducing cost and runtime for high-volume queries.

• Implemented data quality checks, monitoring, and anomaly detection alerts to ensure trusted datasets for business-critical use cases.

• Collaborated with product, analytics, and compliance teams to design BI solutions and dimensional data models aligned with regulatory needs.

• Standardized builds by containerizing workflows with Docker, enabling reproducible deployments across environments. Recurve Analytics, CA Dec 2021 – Mar 2024

Software Engineer II

• Developed and deployed cloud-native ETL workflows using Python, SQL, dbt, Airflow, and SSIS, delivering analytics-ready datasets for customer and operational insights.

• Optimized BigQuery pipelines using schema redesign, partitioning, and clustering, improving both query speed and cost efficiency.

• Partnered with stakeholders to translate requirements into SQL transformations, SSIS workflows, and BI datasets, supporting client reporting and executive dashboards.

• Created reusable, version-controlled Python applications with GitHub, streamlining development workflows under Agile delivery.

• Implemented CI/CD pipelines (Git, GitHub Actions, Docker), reducing deployment times and ensuring consistent releases.

• Managed structured and unstructured data using MongoDB and MySQL, ensuring scalability and compliance.

• Partnered with analysts to design Power BI and Looker-ready datasets, supporting executive dashboards and client-facing reports. PROJECTS

Spacebook

• Developed Spacebook, a Facebook clone built with Ruby on Rails and React/Redux, featuring friend connections, post creation, AWS S3-based media storage, and user search functionality. HotSpot

• Led development of HotSpot, a location-based social media app built with React/Redux and MongoDB, enabling users to join groups, create events, and search users/groups via Google Maps API. Picross

• Created Picross, a logic-based puzzle game using JavaScript, Canvas, HTML5, and CSS3, featuring OOP-based tile logic, dynamic DOM manipulation, and an interactive 10x10 grid UI. EDUCATION

App Academy, CA Jun 2021

Curriculum of Study in Web/Software Development

Baylor University, TX Jun 2020

B.A In Philosophy & Computer Science

Contact this candidate