Reporting Automation Engineer - Phoenix Technology Partners, LLC

[ad_1] Reporting Automation EngineerDo you have a passion for processing raw data, developing and maintaining datasets, and improving data quality and efficiency? If the answer is yes, then we want you on your team! Responsibilities:With guidance from the director and in collaboration with the Analytics and Automation team, you will:Translate reporting requirements into modular, reusable Python classes and scriptsBuild automation workflows by using Python:Read JSON input filesDynamically construct and execute SQL queries against our databaseInvoke calculation modules to cleanse, transform, and compute derived metricsEmbed calculation outputs into specified PowerPoint slide shapes using python-pptxUpload completed presentations to Google Drive via the Google Drive APIImplement robust error handling, logging, and retry mechanisms to ensure production reliabilityParameterize and configure scripts to support different report types and inputs without code changesUse Git (or similar VCS) to manage deployment and scheduling of automated jobsMonitor script performance; optimize Python code for speed and scalabilityDocument solution architecture, data flows, module interfaces, and configuration optionsCollaborate with stakeholders to validate results and refine requirementsStay up-to-date with Python best practices, key libraries (pandas, SQLAlchemy, python-pptx, google-api-python-client), and automation trends Required QualificationsBachelors degree in Computer Science, Data Science, Engineering, or related field (or equivalent experience)Hands-on Python development, including object-oriented designProven experience building Python-driven reporting or data-processing automationsProficient in Python data and automation libraries (e.g., pandas, NumPy, SciPy, python-pptx, google-api-python-client, etc.)Hands-on experience integrating with Google APIs (Drive, Sheets, etc.)Solid data analysis foundation: cleansing, transformation, aggregation, and basic statisticsProficient with Git or similar version control systemsExcellent problem-solving skills and attention to detailStrong written and verbal communication; able to document and present technical solutions Preferred (Nice-to-Have)SQL skills; comfortable writing and optimizing complex queriesFamiliarity with scheduling or orchestration tools (cron, Airflow, etc.)Basic experience with Docker and CI/CD conceptsBackground in writing unit or integration tests for Python codeExposure to BI/reporting tools (Tableau, Power BI)Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity. [ad_2] Apply to this job