Candace Cox Email and Phone Number

Technology and Languages Proficiency:Airflow, AWS(Redshift, s3, Secrets Manager, Lambda), AWS Management Console, Batch, Bash, Databricks, Databricks Lakehouse, DBeaver, DBT (Data Build Tool), Jenkins, Jira (agile), Microsoft Azure, Microsoft Teams, Python (core, Pandas, Spark), Pycharm IDE, SQL (T-SQL and PostgreSQL)Accomplishments:Worked closely with internal clients to design, develop and manage analytics solutions using various tools and technologies. Architected and created data views from big data store to feed into analytics solutions and visualization layers. Support planning and executive decision making by developing data-driven solutions.• Orchestrated migration of multiple jobs from Jenkins to Airflow, enhancing workflow efficiency.• Collaborated with DevOps team to establish streamlined CI/CD pipelines on Azure utilizing Airflow.• Implemented Terraform scripts to seamlessly generate Databricks Unity catalogs, tailoring schemas to project requirements.• Translated over 10,000 lines of SQL from Transact SQL to PostgreSQL, resulting in an 80% reduction in processing time, within a cloud environment over SQL Server.• Spearheaded the creation and maintenance of data models and operations for a forecasting engine, pivotal in forecasting a $5-7 billion revenue stream.• Expanded and maintained hundreds of DBT models, implementing source table references, parameterized variables, and macros for enhanced efficiency.• Developed Airflow jobs and ensured pipeline optimization to populate reporting models used in updating of 50+ Tableau and Qlik dashboards.• Conducted root cause analysis on data models and tables, driving improvements and efficiency gains.• Executed database table operations including creation, deletion, and alteration of tables, ensuring seamless data management.• Orchestrated ETL processes between Redshift and Databricks Lakehouse platform, facilitating streamlined data integration and analysis.

Technologies Proficiency:PostgreSQL, Django, NVd3, JavaScript, jQuery, HTML5, and CSS3Accomplishments:Interned with HP, actively involved in building and maintaining data visualization websites and PostgreSQL databases.• Demonstrated expertise in creating dynamic graphs utilizing d3.js, enhancing the visualization capabilities of projects.• Developed reusable code modules in Python and JavaScript, optimizing efficiency and facilitating easier maintenance across projects.• Contributed to backend engineering tasks using Django, ensuring robustness and scalability of web applications.

At Nevada Legal Guides, I worked as a Media Specialist during which time I built and maintained the company website, designed and created 200 stock media products, branded attorneypoint.com, did video production for a series of law commercials, designed the layout for three legal guides as well as work on a new version of an existing guide.• Communication• Web Design• Graphic Design• Video Production• Marketing• Advertising• File Organization