Avenu Insights & Analytics

Data Engineer

• Support Justice software implementation and data support projects
• Ensure data hygiene and prepare data for migration
• Oversee full data conversion lifecycle
• Develop and maintain Python and SQL scripts
• Design, build, and optimize ETL pipelines and workflows
• Execute data conversion activities and implement data hygiene standards
• Analyze and tune SQL performance
• Leverage AI and automation tools to streamline data processes

Data Analyst

• Gather, clean, and validate data from multiple sources.
• Perform detailed analysis using statistical methods to uncover trends, patterns, and root causes.
• Modify, convert, and load data using SQL, Excel, and internal tooling.
• Create clear dashboards and reports to communicate insights.
• Troubleshoot data issues and assess downstream impacts to product workflows.
• Write Jira tickets documenting defects or required development work to permanently resolve data problems.
• Collaborate with implementation, support, and account management teams to resolve customer data issues.
• Contribute to continuous improvement of data processes and data integrity.
• Communicate with customers clearly and be customer facing as needed.
• Perform other duties as assigned.