Data Engineer Systems Analyst

Steven Bernal

Bensenville, IL ********@*****.*** 630-***-**** https://www.linkedin.com/in/stevenbernal67/

Professional Summary

Results-driven Data Engineer and Business Systems Analyst with over five years of experience in designing, building, and optimizing data pipelines and scalable architectures across insurance and financial domains. Skilled in SQL, AWS, and Unix-based scripting, with hands-on exposure to big data tools (Hadoop, Spark, Hive) and NoSQL databases (MongoDB, Redis). Proven ability to collaborate with cross-functional stakeholders, manage offshore development teams, and support compliance (HIPAA, SOC 2) across cloud infrastructure. Adept in metadata management, process automation, and building client-facing analytics dashboards that drive business insights.

Skills

Data Pipeline Design & Optimization

SQL, T-SQL, MySQL, SQL Server

Big Data Tools: Hadoop, Hive, Spark (Academic)

ETL Development: Pentaho, PowerShell

Cloud Platforms: AWS (RDS, S3, EC2), Azure (Exposure)

NoSQL: MongoDB, Redis (Academic/Project-based)

Metadata Management & Data Lineage

Data Visualization: Power BI, Tableau

CI/CD: GitHub Actions, Jenkins

Unix/Linux Scripting

Compliance: HIPAA, SOC 2

Agile, Jira, Confluence

Fluent in Spanish

Work Experience

Data Engineer Magnifact 02/2020 – 05/2025

Designed and maintained MySQL and AWS RDS databases to support ACA life insurance policy processing.

Built scalable ETL pipelines and automation scripts using Pentaho and PowerShell.

Created client-facing dashboards and analytics tools to track data currency and policy metrics.

Collaborated cross-functionally with business analysts, clients, and offshore developers to deliver technical solutions aligned with stakeholder requirements.

Managed CI/CD pipelines via GitHub Actions, streamlining deployments across dev and prod.

Authored documentation for metadata, data lineage, and system architecture.

Data Specialist II SQL Server Developer Medical Marketing Services 02/2019 – 02/2020

Developed T-SQL queries and optimized stored procedures for complex insurance reporting solutions.

Participated in disaster recovery planning and implemented log shipping strategies for SQL Server.

Created custom reporting for insurance client needs, including trend analysis and policy loss tracking.

Programmer II Microsoft SQL Server Paylocity 07/2016 – 01/2019

Analyzed business requirements and developed ER diagrams to enhance system architecture.

Created and maintained Tableau dashboards, delivering actionable business insights.

Optimized SQL Server procedures to reduce query execution times and improve system efficiency.

Database Programmer (Business Intelligence) Tranzact Technologies 11/2014 – 07/2016

Developed scalable ETL pipelines using Pentaho to support data integration projects.

Visualized operational data metrics through Tableau dashboards for executive reporting.

Led process improvement initiatives that increased reporting accuracy

Education

Bachelor of Science: Computer Engineering Technology DeVry University 10/2013

Data Engineering Certificate Massachusetts Institute of Technology 09/2023

Achievements

Developed and deployed a custom business dashboard, eliminating manual reporting and increasing data transparency.

Improved ETL pipeline reliability

Successfully completed SOC 2 and HIPAA-compliant data handling implementations across multiple projects.

Delivered critical reporting solutions under aggressive open enrollment deadlines, supporting executive decision-making.

Contact this candidate