Back to jobsCollaborate with SIA management and business users to define data analysis requirements and specifications
Work with transactional system developers to locate and understand source data
Use ETL and data modeling tools to translate requirements into functioning, accurate data analysis solutions, including writing custom code in SQL, Python, MDX and other languages as needed
Develop efficient, robust ETL processes to extract data from transactional systems and other sources; follow organizational change management procedures
Design, create, and maintain data warehouses, data lakes, data marts, etc. to support analysis and reporting, following best practices and considering data retention policies
Create and model ontology objects; design and build reports and data visualizations, including dashboards
Modify solutions to fix errors, adapt to new hardware or runtimes, improve performance, or upgrade interfaces or software versions
Lead and/or support continuous improvement activities to improve analysis capability and performance; advise the business on possible and recommended metrics based on experience and industry best practice
Deliver ad hoc reports and data extracts as needed
All other duties as assigned (ex. perform or coordinate web development)
