Available to hire
Hi, I’m Jordan Patrick Smith—an experienced Data Engineer and Machine Learning Engineer with 8+ years designing, building, and optimizing ETL pipelines, data warehouses, and analytics platforms. I’m proficient in Python (Pandas, PySpark, Scikit-learn, TensorFlow, PyTorch), SQL (T-SQL, PostgreSQL, Snowflake), and BI tools (Power BI, Tableau, Looker Studio) for data integration, visualization, and modeling.
I have hands-on cloud experience with AWS, Azure, Spark, Kafka, and Terraform, and I enjoy building ML pipelines, forecasting models, and automated reporting that drive actionable business outcomes. I bring a business-savvy analytics mindset that bridges data science with enterprise architecture to deliver scalable, production-ready solutions.
Skills
Experience Level
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Intermediate
Intermediate
Language
English
Fluent
Work Experience
Marketing Analytics Consultant at Data In Motion
October 1, 2025 - October 1, 2025Enhanced campaign analysis accuracy by 30% by leveraging SQL Server and PostgreSQL for advanced querying, data cleansing, and clustering techniques to identify audience segments and engagement trends. Improved dashboard data freshness by automating updates through ETL pipelines built with Python and Airflow, integrating test automation and integration testing for reliable Power BI and Tableau dashboard refreshes. Increased campaign ROI measurement precision by 25% by engineering feature sets and applying regression analysis with SQL and Python, supporting data-driven database design and capacity planning for analytics workflows. Accelerated project delivery timelines by 20% by collaborating with marketing and data teams in Agile sprints, conducting integration testing, and delivering recommendations that improved campaign reach and engagement.
Data Engineer at DATA IN MOTION
May 1, 2025 - October 1, 2025Data Engineer / Marketing Analytics Consultant (Contract): Designed and orchestrated automated ETL pipelines using Python and Airflow to ingest and process 365 days of LinkedIn analytics data. Built modular Python scripts to clean, normalize, and join multi-source campaign data using Pandas and SQL. Developed a metrics layer containing over 25 standardized KPIs to enable consistent reporting across marketing teams. Created predictive models using Scikit-learn to forecast engagement, impressions, and optimal posting windows. Automated Power BI/Tableau dataset refreshes, reducing manual reporting effort by 90%. Built a data validation framework to monitor schema changes, missing fields, and data drift. Implemented API ingestion workflows pulling LinkedIn, Facebook, and internal data into a unified analytics store. Conducted A/B testing and uplift analysis to compare messaging styles and campaign performance. Collaborated with content teams to deploy AI-driven content scoring models, impr
Business Analyst at Hughes Enterprise Methodologies & Solutions
January 1, 2025 - January 1, 2025Improved reporting efficiency by 40% by automating SQL Server and PostgreSQL data pipelines and integrating SQL-based ETL workflows, enhancing data quality and reliability for analytics dashboards. Increased proposal win rate through data-driven decision-making by designing and implementing database models and test automation using SQL and Python, supporting machine learning scripts that predicted proposal success likelihood and informed bid strategies. Enabled scalable analytics and predictive insights by leading integration testing and capacity planning for data models and clustering solutions on SQL Server and PostgreSQL, collaborating with analysts and developers in an Agile environment to design robust, scalable data pipelines. Reduced manual intervention in reporting workflows by developing and maintaining Python-based ETL processes with SQL for database design and ongoing test automation, supporting seamless data migration and integrity across platforms.
Data Analyst | Junior Data Engineer at HUGHES ENTERPRISE METHODOLOGIES & SOLUTIONS
March 1, 2024 - January 31, 2025Built analytics pipelines using Azure Data Factory, Synapse SQL, and Python for CRM, financial, and operations datasets. Designed star-schema and snowflake data models to support dashboards and self-service analytics. Automated Power BI reporting workflows, eliminating recurring manual tasks. Created ML-based scoring models to predict proposal win probability, using feature engineering from CRM history. Designed DAX measures and semantic models for executive dashboards. Improved data quality by implementing rule-based validation scripts and exception reporting. Migrated legacy Excel reports into scalable, governed BI dashboards. Developed SQL stored procedures for data transformation and incremental loads. Collaborated with leadership to define KPIs and standardize analytics processes. Provided pipeline monitoring, debugging, and performance optimization to ensure high data refresh stability.
Inside Sales Executive at GANNETT | USA TODAY NETWORK
February 1, 2024 - February 1, 2024Improved customer retention by 50% by leveraging SQL Server and PostgreSQL for segmentation models and churn prediction algorithms, enhancing database design and supporting data-driven strategies. Enhanced campaign ROI and outreach efficiency by conducting integration testing and test automation for A/B testing workflows with SQL and Python, increasing the reliability of campaign performance analysis. Enabled data-driven capacity planning and sales forecasting by developing interactive Tableau dashboards using backend SQL queries, supporting Agile teams with real-time insights. Supported regional performance analysis and operational scalability by leveraging SQL Server clustering to manage and analyze high-volume sales data, contributing to a stable and scalable data environment.
Data Analyst (Sales Analytics) at GANNETT | USA TODAY NETWORK
February 1, 2021 - February 29, 2024Built customer segmentation logic using SQL and engineered features related to churn, retention, and user behavior. Developed Python-based churn prediction models, improving renewal outcomes and driving a 50% increase in retention. Created dynamic Tableau dashboards to track churn patterns, sales performance, outreach quality, and campaign efficiency. Performed A/B testing on outreach strategies to optimize email cadence, discounting, and follow-ups. Automated lead-scoring workflows using SQL + Python to prioritize high-value prospects. Integrated Salesforce data into analytical pipelines, cleaning and transforming large datasets for reporting. Prepared weekly and monthly insights for regional managers to improve forecasting and quota planning. Conducted root-cause analysis on customer drop-offs using statistical modeling and behavioral data. Reduced manual data preparation by 70% through reusable scripts and scheduled jobs. Partnered with product and marketing teams to define KPIs and
Vice President, Strome Sales Club at Strome College of Business
May 1, 2018 - May 1, 2018Increased student recruitment efficiency by 30% through designing and maintaining engagement tracking databases using SQL Server and PostgreSQL, applying database design best practices and supporting Agile project delivery. Improved data reliability and campaign targeting by developing SQL queries for data extraction and analysis, conducting integration testing to validate data pipelines, and implementing test automation to ensure data accuracy. Supported scalable membership growth of 25% year-over-year by performing capacity planning and clustering of engagement databases to ensure high availability and performance during peak recruitment periods.
Data Analyst | VP, Strome Sales Club at Strome College of Business
August 1, 2017 - May 31, 2018Analyzed recruitment and engagement data to identify patterns affecting club growth and student participation. Designed small dashboards and automated summaries to improve event planning decisions. Built surveys, collected response data, and generated insights to increase membership activity. Collaborated with faculty and student officers to implement data-backed recruitment strategies.
Marketing Intern at CampusWise LLC
August 1, 2017 - August 1, 2017Increased campaign engagement by 25% by designing and analyzing social media campaigns using SQL to evaluate engagement metrics, leveraging Agile methodologies to iterate content strategies. Identified top-performing content types by utilizing test automation and integration testing principles to streamline A/B testing of social media posts, improving marketing efficiency. Enhanced reporting accuracy and capacity planning by applying database design concepts and PostgreSQL queries to create structured data reports from social media performance data. Improved campaign data reliability by supporting data clustering and SQL Server reporting to group audience segments and analyze trends, aligning with Agile project cycles.
Marketing Analytics Intern at CampusWise LLC
May 1, 2017 - August 31, 2017Analyzed social media performance using Excel, basic Python scripts, and engagement metrics. Tested multiple versions of ads and posts using A/B testing methods. Produced weekly reports summarizing campaign performance, conversion trends, and user growth. Recommended content and timing strategies based on data trends and audience behavior.
Education
Master's, Computer Science at Regent University
January 1, 2020 - December 1, 2023Bachelor's, Business at Old Dominion University
January 1, 2014 - December 1, 2018Master's, Business at Randolph-Macon College
January 1, 2013 - December 1, 2014Master of Business Administration (MBA) at Regent University
January 1, 2020 - December 31, 2023Bachelor’s Degree — Business, Management, Marketing at Old Dominion University
January 1, 2014 - December 31, 2018Business Studies at Randolph-Macon College
January 1, 2013 - December 31, 2014Qualifications
Advanced Data Visualization with Tableau
January 1, 2025 - January 1, 2025IBM Business Intelligence (BI) Analyst Specialization
January 1, 2025 - January 1, 2025SQL: A Practical Introduction for Querying Databases
December 1, 2024 - December 1, 2024Statistical Analysis Fundamentals using Excel
December 1, 2024 - December 1, 2024Business Intelligence (BI) Essentials
November 1, 2024 - November 1, 2024Data Visualization and Dashboards with Excel and Cognos
November 1, 2024 - November 1, 2024Excel Essentials for Data Analytics
November 1, 2024 - November 1, 2024Advanced Data Visualization with Tableau
January 1, 2025 - December 16, 2025IBM Business Intelligence (BI) Analyst Specialization
January 1, 2025 - December 16, 2025SQL: A Practical Introduction for Querying Databases
December 1, 2024 - December 16, 2025Statistical Analysis Fundamentals using Excel
December 1, 2024 - December 16, 2025Business Intelligence (BI) Essentials
November 1, 2024 - December 16, 2025Data Visualization and Dashboards with Excel and Cognos
November 1, 2024 - December 16, 2025Excel Essentials for Data Analytics
November 1, 2024 - December 16, 2025Industry Experience
Software & Internet, Professional Services, Education, Media & Entertainment, Other
Skills
Experience Level
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Intermediate
Intermediate
Hire a Web Designer
We have the best web designer experts on Twine. Hire a web designer today.