MAIN PURPOSE
We seek an experienced and creative programmer with unrelenting attention to detail, an ability to work well with a small team (including both programmers and non-programmers), and a strong interest in analytics. Fluency in Spark/ Databricks for SQL(spark SQL), Python and R is required. Also provide production support, manage issue resolution, manage BI / reporting requests, and support testing and documentation efforts. This position requires technical competencies in Python, Databricks, R and SQL.
MAJOR DUTIES / RESPONSIBILITIES
· Work collaboratively with our actuarial team to design and implement analytics solutions based on formal project proposals.
· Utilize expert-level knowledge of analytics associated programming languages to create scripts and pipelines capable of data access, manipulation, modelling, prediction, visualization, and reporting.
· Ensure successful and timely completion of project deliverables.
· Support deployment and test of solutions in the customer environment.
· Employ coding standards and advance guidelines for efficient and effective programming.
· Familiarity with package management and libraries for Python, R and SQL in the Spark ecosystem.
· Troubleshooting and maintenance.
· Maintaining data quality and overseeing database security.
· Partner with IT and other Department resources to identify root cause and propose solutions.
· Deliver verbal and written communications to business stakeholders on enhancements, issues, or general requests.
· Conduct thorough testing on new applications or enhancements.
· Support integration of BI tools into existing workflows (i.e., provide basic training, support change management activities) specifically Power BI.
· Develop and maintain clear and succinct documentation, including user training materials.
KNOWLEDGE & SKILLS
· Bachelor’s degree in mathematics, statistics, actuarial science, computer science, economics, or another quantitative field
· R, Python, MS Azure, SQL, Databricks and Github skills
· Knowledge of Power BI is a plus. (Power Query and DAX)
· Minimum 8 years in consulting or enterprise IT with system integration and application development experience under Windows and/or Linux.
· Programming skills including some experience with database interfaces.
· Additional experience with one or more of the following: web services, cloud computing, MS Azure.
· Solid understanding of software engineering best practices.
· Strong communication and interpersonal skills working with diverse teams.
· High attention to detail, strong analytical and problem-solving skills
· Able to establish positive relationships with IT staff, business partners and other key stakeholders.