Nick Mackowski

I have 6+ years delivering data analysis, ETL, and data visualization across federal programs. SQL, Python, R, Tableau, Power BI, Databricks, database administration. Additionally, I am self-driven with personal projects utilizing Google Cloud Platform (GCP), Azure, various Python frameworks, JavaScript and associated frameworks, and am part of a local coding meetup.

Skills

SQLPythonRTableauPower BIPower QueryDatabricksExcel

Certifications

CompTIA Security+ (Lapsed)
ScrumAlliance Certified Scrum Master (Lapsed)
Microsoft Certified: Azure Administrator Associate
Certified Strength and Conditioning Specialist (CSCS) – National Strength & Conditioning Association (NSCA)

Experience

LMI Consulting

Remote

Sr. Analyst, Human Capital Data Analyst / People Data Analyst for NASA

02/2024 – Current

Work with Executive Services, HR groups to gather project requirements and then assist with data visualization, dashboarding, reporting, and automation
Build and maintain data pipelines across SQL, R, Python, Tableau, and Power BI (DAX / Power Query) for extraction, transformation, and visualization of multi-source datasets
Develop and maintain data dictionaries and process documentation
Perform attrition analysis for Executive Services
Assist in the development of Quarto and R Shiny internal products including a knowledge base and project management system

Sr. Analyst, Data Engineering for DoD

08/2022 – 02/2024

Administered enterprise ETL and data-integration feeds (Informatica PowerCenter) across Teradata and Oracle databases, authoring complex SQL to extract, reconcile, and maintain integrity across multiple data sources
Diagnosed and resolved ETL failures through log analysis, improving pipeline reliability and reporting accuracy

InfoSciTex, Inc. (DoD Contractor), for Air Force Research Labs

Wright-Patterson AFB, OH

Data Analyst and Associate Researcher for STRONG Lab

Scientist II 6/2021 – 8/2022; Scientist I 6/2019 – 6/2021

Served as data analyst for human performance staff embedded in Special Forces units, supporting Smartabase, a data management system
Provided onboarding for new hires (Athletic Trainers, Physical Therapists, Dietitians, Psychologists)
Developed new data visualizations and forms for existing staff
Provided analytical support
Collaborated with human performance staff in research design, logistical plans for performance enhancement, facility use, experimental data collection, and manpower utilization
Gathered and interpreted data in analytics reports
Served as liaison between research staff and data scientists

ORISE (DoD Fellow), for Air Force Research Labs

Wright-Patterson AFB, OH

Associate Researcher and Sport Scientist for STRONG Lab

2/2018 – 6/2019

Administered tests to identify physical performance status and deficits in Airmen
Assisted researchers in study design and data collection
Managed Smartabase, an athlete management system, for research purposes

Publications

Merrigan, J., Strang, A., Eckerle, J., Mackowski, N., Hierholzer, K., Ray, N., Smith, R., Hagen, J. and Briggs, R., 2024. Countermovement jump force-time curve analyses: reliability and comparability across force plate systems. The Journal of Strength & Conditioning Research, 38(1), pp.30-37.

Merrigan, J., Stute, N., Eckerle, J., Mackowski, N., Walters, J., O’Connor, M., Barrett, K., Robert, R., Strang, A. and Hagen, J., 2022. Reliability and Validity of Contemporary Bioelectrical Impedance Analysis Devices for Body Composition Assessment. Journal of Exercise and Nutrition, 5(4).

Hierholzer K., Briggs R., Tolston M., Mackowski N., Eckerle J., O’Connor M., Barrett K., Smith R., Strang A., Heart Rate Variability: A Longitudinal Comparison of Commercial Devices for Individual and Group Stress-Response, Advances in Applied Physiology. Volume 7, Issue 2, December 2022, pp. 26-33. doi: 10.11648/j.aap.20220702.12

Stute NL, Szeghy RE, Mackowski NS. All is fair in menstruation, POTS and… war? J Physiol. 2022 Aug 1. doi: 10.1113/JP283297. Epub ahead of print. PMID: 35913261.

Hierholzer, K., Briggs, R., Tolston, M., Mackowski, N., O’Connor, M., Barrett, K., Smith, R., Eckerle, J. and Strang, A., 2022. Heart Rate Variability Metrics from Commercial Devices Predicts Strength and Cardiovascular Performance in a Military Cohort. American Journal of Sports Science, 10(1), pp.14-23.

Strang, A.J., Smith, R., Hierholzer, K., Moore, B., Crews, R. and Mackowski, N., 2021. Effects of an AMINO-ACID Gel (AQUAGARD (registered trademark)) on Hydration and Performance Parameters During Prolonged Aerobic Exercise. Oak Ridge Institute for Science and Education.

Devine, K.A., Viola, A., Levonyan‐Radloff, K., Mackowski, N., Bozzini, B., Chandler, A., Xu, B., Ohman‐Strickland, P., Mayans, S., Farrar‐Anton, A. and Sahler, O.J.Z., 2020. Feasibility of FitSurvivor: A technology‐enhanced group‐based fitness intervention for adolescent and young adult survivors of childhood cancer. Pediatric Blood & Cancer, 67(9), p.e28530.

Harshman, S.W., Strayer, K.E., Davidson, C.N., Pitsch, R.L., Narayanan, L., Scott, A.M., Schaeublin, N.M., Wiens, T.L., Phelps, M.S., O’Connor, M.L. and Mackowski, N.S., 2021. Rate normalization for sweat metabolomics biomarker discovery. Talanta, 223, p.121797.

Harshman, S.W., Browder, A.B., Davidson, C.N., Pitsch, R.L., Strayer, K.E., Schaeublin, N.M., Phelps, M.S., O’Connor, M.L., Mackowski, N.S., Barrett, K.N. and Eckerle, J.J., 2021. The impact of nutritional supplementation on sweat metabolomic content: a proof-of-concept study. Frontiers in Chemistry, 9, p.255.

Abstracts

Tok, O., Pellegrino, J., Walker, A., Sanders, D., McFadden, B., Rabideau, M., Conway, S., Ordway, C., Bello, M., Hofacker, M., Mackowski, N., Poyssick, A., Capone, E., Monaco, R., Fragala, M., & Arent, S. (2016). In-season changes in plasma amino acid levels in division I NCAA female athletes. Journal of the International Society of Sports Nutrition, 13, P25.

Walker, A., Conway, S., Hofacker, M., Rabideau, M., McFadden, B., Mackowski, N., Pellegrino, J., Ordway, C., Bello, M., Tok, O., Sanders, D., & Arent, S. (2016). Changes in markers of recovery, readiness, and nutritional status in DI female soccer placers over the first half of the competitive season. Medicine & Science in Sport Exercise, 48, P.S265.

Hofacker, M., Walker, A., McFadden, B., Rabideau, M., Conway, S., Sanders, D., Mackowski, N., & Arent, S. (2016) Practice vs. competition work rates in collegiate soccer players: do they practice like they play?. Medicine & Science in Sport Exercise, 48, P.S793.

McFadden, B., Walker, A., Hofacker, M., Rabideau, M., Poyssick, A., Conway, S., Pellegrino, J., Mackowski, N., Ordway, C., & Arent, S. (2016). Monitoring the effect of a yearlong training program on power, ventilatory threshold, body composition, and aerobic capacity of division I male college soccer players. Medicine & Science in Sport Exercise, 48, P.S792

Pellegrino, J., Walker, A., Conway, S., Hofacker, M., Rabideau, M., McFadden, B., Mackowski, N., Ordway, C., Bello, M., Tok, O., Sanders, D., & Arent, S. (2016). Biomarker changes in collegiate female power-endurance athletes: the role of fitness as a predictor. Medicine & Science in Sport Exercise, Vol. 48 No. 5, 2016. P.S265

Awards

top_100_badge

Top 100 Analytics Professional 2024

top_100_badge

Dayton Startup Weekend 2025 - 1st Place: Dry Guy - The plant health monitor that also was the Crowd Favorite.

Education

M.S. in Kinesiology and Applied Physiology — Rutgers University

B.S. in Exercise Science, Applied Kinesiology — Rutgers University