Senior Data Analytics Developer (Analyst Specialist Senior)
Current• Strengthen the planning, design, and implementation of strategic capital renewal strategies and satisfy business intelligence needs with robust ETL pipelines, test driven development, and actionable data analysis.• Automate geospatial business risk models using MSSQL, SQLAlchemy, Pandas, Polars, and Dask-GeoPandas.• Orchestrate multiple MSSQL/DuckDB/Python ETL pipelines with Windows Task Scheduler.• Manage multiple GitHub repositories with unit and integration tests (Pytest) and… Show more • Strengthen the planning, design, and implementation of strategic capital renewal strategies and satisfy business intelligence needs with robust ETL pipelines, test driven development, and actionable data analysis.• Automate geospatial business risk models using MSSQL, SQLAlchemy, Pandas, Polars, and Dask-GeoPandas.• Orchestrate multiple MSSQL/DuckDB/Python ETL pipelines with Windows Task Scheduler.• Manage multiple GitHub repositories with unit and integration tests (Pytest) and GitHub actions for CI/CD.• Generate automated code documentation with Sphinx, NBSphinx, and GitHub Pages.• Visualize data narratives for stakeholders with Tableau, Plotly, Seaborn, Altair, Folium, and Microsoft Excel.• Collaborate with multiple teams to meet data acquisition, dashboarding, reporting, or validation needs.• Oversaw a large data migration and communicated with consultants to resolve invalid data and edge cases.• Forecast business risk profiles with Monte Carlo Simulation for business strategy optimization.• Classify infrastructure defects with Computer Vision, OpenCV, Scikit-learn, and Supervised Learning.• Validate end-user inputs to dynamically improve source data via auto-generated Excel reports.• Distribute portable GUI apps to colleagues for repetitive task automation (Tkinter, PyInstaller, Slint, and Rust).• Model watershed flow accumulation with WhiteboxTools, Rasterio, XArray, NumPy, and PyVista.• Analyze transportation networks with OpenStreetMap API, NetworkX, OSMnx, Momepy, and GeoPandas. Show less