Teams at Red Pico Consulting Services Inc.

Lead data and business intelligence initiatives by translating business needs into scalable data solutions, standardized KPIs, reporting logic, and analytical use cases. Partner with stakeholders, engineers, architects, and BI teams across data integration, transformation, modeling, governance, and reporting. Validate data, investigate discrepancies, improve data quality, and provide technical leadership for cross-functional data initiatives.

Develop and maintain SQL, SAS, and Python integrations for campaign data processes. Prepare mapping documentation and data lineage, convert legacy stored procedures to SQL, write SAS data step, macro, and PROC SQL code, and perform light business analysis independently.

Lead the migration of analytics workloads from SAS to Python while remaining hands-on with coding. Provide technical leadership, establish coding standards, conduct code reviews, migrate workloads, write and debug Python and SQL, create unit tests, and schedule jobs on Linux/Unix using CRON. Work with Git/GitHub, SAS Enterprise Guide, and JupyterHub, and own delivery from design through completion.