Charlotte Metro
Senior Data Analytics Engineer with 8 years of experience delivering high impact data and AI solutions within modern ecosystems. - Ecosystems: Azure, Snowflake, SAP. - Tools: dbt, jinja, Python, SQL, Streamlit, Tableau, Power BI. Email: [email protected] My cover photo was generated by Mid-Journey using keywords from my LinkedIn profile.
Responsible for leading cloud data warehouse migration strategy and analytics solutions for all functional business areas supporting the largest commercial truck dealer and servicing network in the world. Senior Data Analytics Engineer supporting all facets of the analytics team including: - Engineering and leading analytics solutions using Power BI, Tableau, and Streamlit, including an enterprise-level Streamlit application to display real-time freshness data across Snowflake. - Designing, engineering, and deploying data pipelines using ADF, Aecorsoft, Python, dbt, and Snowflake, while successfully implementing and leading multiple migrations from SAP to Snowflake with teams of full-time employees and offshore contractors. - Documenting cloud data warehouse migration procedures and maintaining comprehensive technical documentation for analytics processes. - Training engineers in dbt, SQL, and Jinja best practices, fostering a culture of technical excellence and knowledge sharing. - Strategizing long-term cloud data warehouse design and architecture, aligning with organizational goals and scalability requirements. - Conducting code reviews and quality assurance to ensure robustness, efficiency, and adherence to best practices. - Mentoring junior engineers and providing technical guidance to enhance team capabilities and project outcomes. - Applying domain knowledge to optimize data models and pipelines for downstream machine learning model performance. - Developing an advanced search functionality for our e-commerce website by integrating Snowflake Cortex with Retrieval-Augmented Generation (RAG) techniques and Large Language Models (LLMs), enabling contextually relevant, historically accurate, and LLM-enhanced search results for users.
Responsible for leading cloud data warehouse migration strategy and analytics solutions for all functional business areas supporting the largest commercial truck dealer and servicing network in the world. Data Analytics Engineer supporting all facets of the analytics team including: -Engineering and leading business intelligence and analytics solutions using PowerBi, Tableau, and Streamlit. -Designing, Engineering, and Deploying data pipelines using ADF, Aecorsoft, Python, dbt, and Snowflake. -Documenting cloud data warehouse migration procedures. -Training engineers in dbt, SQL, and jinja best practices. -Strategizing long term cloud data warehouse design and architecture. -Applying domain knowledge to enhance features for downstream machine learning models.
Data Analyst under the BI Finance Department. Responsibilities include: - Translating business requirements - Engineering BI process automation. - Development, deployment, and maintenance of BI reporting tools. - Report curation, data modeling, and participating in data warehouse design. Technologies/languages: -Python -Azure Dev Ops -Alteryx -Alteryx Server -Snowflake -SAP HANA -SQL -Tableau -Tableau Server -VBA
Business Analyst Consultant within the Customer Connect project of Duke Energy. Responsibilities: - Translating stockholder requirements into reporting and analytic deliverables. - Writing SQL queries, data mining, designing reports and dashboards. - Designing calculated views within SAP HANA to feed the reporting needs of billing, credit, collections, and accounting departments. - Writing and executing test cases for business leaders while conforming to different limitations of implemented software. - Participating in evaluating new technologies to ensure the advancement of technology architecture and data within Duke’s Business Intelligence needs. - Supporting ad-hoc query requests from business and power users against SAP web IDE. - Building functional designs for developers and testing using MSRS and Power BI.
Data Analyst with the financial shared services department of Coca-Cola Bottling Consolidated. Responsible for implementing automated processes that involve cleaning data for warehousing, writing SQL queries visualized through Tableau dashboards, and ultimately deploying visualizations and summations to Tableau server. •Worked with a team of analysts to design a semi automated Python/SQL/Tableau application with the goal of identifying and flagging capital lost through stages of production. •Tasked with building/deploying weekly scorecards that outlined and forecasted financial growth, trends, pricing analysis, and departmental productivity. • Skills: SAP HANA, SQL, Tableau, Python and Microsoft Office
Worked with a team of representatives to build a new agency’s book of business. Accomplished through selling and managing various lines of insurance and financial products. Entrusted with managing agency sales data, building monthly dashboards, and presenting findings to representatives to inform future business decisions resulting in new sales strategies and substantial revenue growth in 2018. - Approx. $80,000 insurance premium written. - Approx. $50,000 in financial services. - Agency grew to over $500,000 in premium attained. - Within three months I was entrusted to manage agency sales data and tasked with creating real-time shared sales dashboards that enabled representatives to track growth, plan for the future, and improved the process of documenting sales. - Appointed to manage accounts after 6 months which involved managing premium payments and communicating findings to clients and upper management to ensure premium retention.