Portico has an amazing opportunity to join our team as an Analytics Engineer, Automation amp; AI!
Job Summary
The Analytics Engineer, Automation amp; AI partners closely with the VP of Analytics to build scalable data solutions, automate operational workflows, and develop AI-enabled tools that improve business performance and decision-making. This role combines analytics engineering, automation, and problem-solving to transform operational data into actionable insights and repeatable systems.
Key Responsibilities
Automation amp; AI
- Design and build internal tools and automated workflows that improve operational efficiency and decision-making.
- Identify opportunities to streamline manual processes using Python, APIs, scripting, and AI-enabled solutions.
- Translate business processes and institutional knowledge into scalable, repeatable systems.
- Prototype and test practical AI and automation solutions that drive measurable business impact.
Data Engineering amp; Analytics
- Develop and optimize SQL queries to organize, transform, and analyze operational data.
- Build and maintain reusable datasets and reporting infrastructure for business intelligence and analytics.
- Support and enhance Python-based data ingestion and automation pipelines.
- Integrate and manage data from APIs, SFTP processes, and third-party platforms.
- Improve the reliability, scalability, and performance of existing data models and workflows.
Business Partnership amp; Insights
- Translate business needs into practical analytical and technical solutions.
- Collaborate cross-functionally with operations, marketing, HR, and leadership teams.
- Support strategic initiatives with trusted reporting, dashboards, and data-driven insights.
- Help standardize KPIs and improve organizational confidence in reporting and analytics.
Continuous Improvement
- Contribute to the ongoing development of Portico’s analytics and automation ecosystem.
- Identify process inefficiencies and recommend scalable solutions.
- Participate in rapid prototyping, experimentation, and implementation of new ideas and technologies.
Qualifications
Required Qualifications
- 1–3 years of experience in analytics, data engineering, automation, technical problem-solving, or related project work.
- Strong SQL skills and experience working with relational databases.
- Foundational Python experience for automation, APIs, or data workflows.
- Strong analytical thinking and problem-solving abilities.
- Ability to translate business challenges into technical solutions.
- Strong communication skills and willingness to learn in a fast-paced environment.
Preferred Qualifications
- Experience with cloud platforms, preferably Microsoft Azure.
- Familiarity with BI and visualization tools such as Metabase, Tableau, or Power BI.
- Exposure to data modeling and data architecture concepts.
- Experience working with APIs and workflow automation tools.
- Interest in AI applications and business process automation.
- Familiarity with CRM systems and attribution workflows.
Physical Requirements
- Reasonable accommodations may be made to enable individuals with disabilities to perform essential job functions.
- Ability to communicate clearly and effectively in English.
- Ability to sit and work at a computer for extended periods.
- Ability to perform repetitive hand and wrist movements, including typing.
- Ability to occasionally lift and transport materials up to 30 pounds.
- Ability to read and analyze printed and digital information.
Work Environment
- Primarily office and computer-based work environment.
- Occasional extended work hours may be required based on business needs.
- Limited travel may be required for meetings, training, or company events.
- Moderate noise level typical of an office environment.
Our Company is an equal Opportunity Employer. As a condition of employment, a satisfactory drug test and background check are required.