Intermediate Data Analyst
|Company Name||Instaclick Inc.|
|Position||Intermediate Data Analyst|
This role is responsible for working within the Statistics group and will report to the Statistics Manager. Key duties include assisting with billing investigations for the business in order to save money, find inefficiencies, identify problems and verify business requirements are met. Typical work will involve database queries and existing data warehouses to fulfill business investigation needs.
o Reviewing payment and financial data to identify any errors, problems, or scenarios that are causing unneeded cost.
o Develop standard reports, and processes to keep critical metrics in line (revenue, cost, conversions broken down by key areas).
o Optimize data structures (databases) for statistical analysis.
o Integrate data feeds from external partners (such as transaction feeds from credit card processors).
o Gather and analyze web site and financial performance data to prepare regular reports for the statistics team.
o Audit financial data for the purposes of reconciliation and risk monitoring.
o Analyze user behaviour to make proposals for improvements to the prediction and risk models.
o Assist with the formalization and documentation of departmental procedures.
o Use available data to assist the development team in troubleshooting software bugs.
o Conduct routine maintenance of databases and analysis tools.
o Working on accounting reports, sales reports, member value reports, and email reports.
o Design report visualizations (including charts and graphs).
o Other duties as assigned.
o A minimum of 5+ years experience with relational database development, with a solid understanding of MySQL, database design, and optimization.
o Strong communication and teamwork abilities.
o Ability to manage timelines and prioritize effectively.
o Excellent math, logic, and problem-solving skills.
o Exception attention to detail.
o Strong understanding of financial risk models, actuary experience considered an asset.