Job Description

Job Description

Looking for an exceptional opportunity for personal and professional growth in a fast-paced, team-oriented environment? AIM HIGHER and join the Lipsey’s team! Lipsey’s is looking for a hard-working, self-motivated Programmer Analyst to support our growing business and take it to the next level. Candidates are expected to have enough experience to develop, implement, maintain and oversee projects. You’ll be provided with the tools, responsibilities and work environment necessary to create and build upon innovative internal and customer facing applications.

Primary Duties and Responsibilities:

• Maintenance and improvement of Lipsey’s data warehouse and integrated reporting functionality
• Support and development of internal applications and workflows
• Create and distribute data reports, analytics, and datasets to both internal and external stakeholders
• Work independently on moderate to highly complex programming tasks
• Manage application releases within the production environment
• Support and/or refactor existing code base as technology and business needs evolve.
• Manage end-to-end software development lifecycle for assigned projects; from gathering requirements to production rollout and support, ensuring deliverables and quality goals are met
• Follow good programming practices and incorporate feedback in code reviews to deliver code that is easy to manage.
• Incorporate security directly into development/design activities
• Research and recommend technologies relevant to our environment and business goals.
• Write quality documentation at both the code and business level

Required Skills & Competencies:

• Bachelor’s or Master’s degree in Computer Science or equivalent
• Comfortable working independently and in a team environment
• Great initiative and time management skills
• High level debugging and problem-solving skills
• Excellent understanding of Object-Oriented software design
• Experience writing complex SQL Queries
• Experience in the design & deployment of relational databases
• Aptitude and desire to learn new technologies
• Exceptional written and verbal communication skills

Expertise and/or relevant experience in the following:

• Python
• pandas
• Advanced SQL
• GitHub / Version Control
• Amazon AWS – S3, RDS, Redshift, LightSail
• PostgreSQL
• MySQL
• API’s & Web Services

Additional Skills & Competencies Sought:

• Data Visualization Tools (Tableau, Quicksight, etc…)
• Plotly Dash experience
• Docker / Container Experience
• Prefect Workflow Orchestration
• General Windows & Networking experience
• Microsoft Office Suite Experience