Senior Data Engineer - ETL/BI Pipelines
Resume:
Julia Rivera
DATA ENGINEER
San Diego, USA
*****.**********@*****.***
Skills
Synapse Analytics
Power BI
AWS - S3
Glue
Athena
Informatica PowerCenter
SSMS
SSIS
Docker
Visual Studio
Azure - DevOps (ADO)
HTML
CSS
C#
SQL
JavaScript
Python
Oracle
MS SQL Server
MySQL
AWS Athena
PostgreSQL
Summary
Results-oriented Senior Data Engineer with over 15 years of experience orchestrating data integration, ETL/ELT design, and data modeling. Proven ability to develop robust data pipelines, engineer scalable solutions, and implement data quality standards. Adept at working with Python, SQL, Synapse Analytics, and AWS, with a strong understanding of dimensional modeling principles. Eager to leverage expertise in building and maintaining critical data flows to contribute to PadSplit's analytics platform as a Data Engineer.
Work Experience
SENIOR DATA ENGINEER, Unified Business Technologies, San Diego, USA
09/2024 – PRESENT
Orchestrated the delivery of business intelligence (BI) information across the entire organization, encompassing assessment of business requirements, collection and identification of technical specifications, and development of technology solutions.
Engineered and maintained robust data integration solutions, including ETL/ELT design and architecture, semantic layer objects, presentation layer objects, reports, and dashboards for analytical solution delivery. Applied architectural and engineering concepts to analyze requirements and develop solutions that meet business needs while upholding sustainability objectives, such as scalability, maintainability, security, reliability, extensibility, flexibility, availability, and manageability. Facilitated training and provided consulting services to various technical and non-technical internal teams.
Produced detailed work breakdowns and task estimates for scoping and tracking project activities.
Provided Level 3 support for production systems, resolving complex issues.
Demonstrated a proven track record of successfully delivering data- centric projects.
Possess excellent data skills, including complex query development, performance tuning, and expertise in various data approaches (e.g., relational, dimensional, unstructured).
Data Scientist, Solvere Technical Group - NIWC Pacific, San Diego, USA
03/2024 – 09/2024
Developed data pipelines to extract, transform, and load data into the IL5 Data Warehouse utilizing Synapse Analytics, implementing techniques to enhance performance and data processing times. Constructed data pipelines for extracting, transforming, and loading data from diverse sources into a central Data Warehouse. Implemented rigorous data quality checks to ensure data accuracy and integrity throughout the data lifecycle.
Designed and deployed an automated monitoring and alerting system to proactively detect and resolve data processing errors. Collaborated effectively with cross-functional teams to ensure alignment with and fulfillment of business requirements.
Provided technical guidance to team members, leading to the establishment of new development standards.
Created Power BI Dashboards, leveraging programming in M, R, and KQL to develop custom columns and measures. Holds current IL5 and IL6 Azure Administrator accounts, along with GitHub, NIPR, and SIPR accounts.
SENIOR DATA MODELER,
Fleet Readiness Center Southwest FRCSW, San Diego, USA 08/2019 – 09/2024
Spearheaded the development and innovation of data strategy and architectural frameworks.
Served as the primary liaison between business data consumers and the data warehouse/BI teams, ensuring clear communication and understanding.
Established and enforced enterprise-wide standards for data management, modeling, and delivery.
Partnered with and engaged divisional business leadership, Enterprise Risk Management, Data Warehouse, and business process teams to comprehend business requirements and influence optimal solution architecture designs.
Directed other data modelers in the design of relational and dimensional models adhering to Kimball Methodology.
Developed and validated robust modeling solutions to meet complex analytical needs.
Integrated and drove the adoption of modeling solutions into existing business processes to enhance data utilization.
Maintained up-to-date data models and standards documentation for master data.
Assisted customers in understanding and effectively leveraging existing data sets.
Championed and supported the fundamental principles of sound data architecture and governance practices.
Executed necessary activities to drive standardized definitions of facts and dimensions.
Created data models and schemas at conceptual, logical, and physical levels for both relational and dimensional solutions. Consolidated disparate data models into coherent enterprise-wide data models.
Captured critical business rules governing data transformation, integration, and usage.
Integrated several core NDMS applications (e.g., NERP, MAXIMO, MRO, TAP, IPA) into the enterprise data warehouse for enhanced consumption. LEAD ETL DEVELOPER,
Fleet Readiness Center Southwest FRCSW, San Diego, USA 03/2009 – 08/2019
Managed all Solaris and RHEL Informatica Server installations, migrations, SSL certificate implementations, STIG compliance, and daily operations of ETL nightly processing as project manager. Pioneered the development and implementation of numerous ETL standards that continue to be utilized by the CRS ETL Team. Facilitated collaboration between data modelers and the data warehouse/BI teams to ensure seamless data flow and integration. Provided 24/7 support to maintain optimal data conditions within the production environment.
Analyzed business requirements and architected ETL solutions, subsequently developing the code using Informatica Power Center. Interpreted requirement specifications and prepared comprehensive functional and technical design documents.
Collaborated with data modelers to rectify production issues promptly. Delivered solutions within short timeframes while maintaining high quality.
Incorporated robust error and exception handling by logging issues into error tables and dispatching email alerts to concerned distribution lists. Oversaw batch monitoring and resolved troubleshooting issues across all environments.
Developed source and target definitions to facilitate data extraction from flat files and relational sources.
Implemented various transformations to apply key business rules and functionalities to source data.
Engineered ETL solutions for reporting designed to sustainably support business outcome requirements.
Engaged with department and business unit resources to ensure a thorough understanding of requirements and the data environment. Delivered timely, validated, and well-tested work products. Participated in the continuous improvement of quality standards and protocols for ETL processes.
Certificates
Informatica Developer, Informatica
Security X, CompTIA
04/2021
Security +, CompTIA
04/2021
References
Richard Heinrich, Supervisor and Technical Lead, FRCSW 619-***-****
Ernesto Arce Jr, Data Architect/Coworker, FRCSW
Contact this candidate