Shift: Full-time

*This is not a remote position and will be fully in office*

Job Description

The Programmer Analyst is responsible for developing and maintaining software, analyzing data, and creating insightful reports to support business decision-making. This role acts as a bridge between business needs and technical solutions, translating business requirements into code and actionable data visualizations for stakeholders. The ideal candidate is a proactive problem-solver with strong programming and analytical abilities, as well as exceptional communication skills.

Essential Duties

Individuals must be able to perform each essential duty satisfactorily.  Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Data analysis and reporting

• Work with stakeholders and business leaders to define reporting requirements and deliver tailored solutions.
• Collect, clean, and process large datasets from various sources to ensure accuracy and relevance.
• Perform in-depth analysis to identify trends, patterns, and insights that inform strategic decisions.
• Create, deploy, and maintain reports, dashboards, and other data visualizations using tools like Power BI, SSRS and Crystal Reports.
• Respond to ad-hoc data requests and provide timely analysis to support departmental needs.

Programming and development

• Design, develop, and maintain applications, software, and databases to meet business requirements.
• Write and optimize complex SQL queries, stored procedures, and scripts for efficient data extraction and manipulation.
• Develop and implement automated processes for data handling, reporting, and other operational tasks.
• Test and debug software and reporting solutions to ensure they function correctly and produce accurate results.

Database management and data governance

• Maintain databases, monitor performance, and troubleshoot issues to ensure system integrity and security.
• Document reporting processes, data sources, and system logic to ensure clarity and accessibility for future reference.
• Ensure compliance with data governance policies and best practices

Requirements

Education and experience

• Bachelor’s degree in Computer Science, Information Systems, or a related field.
• Proven experience in a role involving programming, data analysis, and report writing.

Technical skills

• SQL proficiency: Advanced skills in writing complex queries, stored procedures, and views.
• Programming languages: Experience with one or more languages such as C#, Java or VBA.
• Reporting and visualization tools: Expertise in platforms like Power BI, SSRS and Crystal Reports.
• Database knowledge: Solid understanding of database management systems and ETL (Extract, Transform, Load) processes.
• Spreadsheet software: Advanced knowledge of Microsoft Excel.

At John Roberts, all employees are offered a comprehensive benefits package, including Health Insurance, Dental & Vision Coverage, Paid Time Off, FSA, 401K, Life Insurance, Short- and Long-Term Disability, and Tuition Assistance. Plus, our 24/7 on-site gym is available for your fitness needs! For more details, head to our "Careers" page and scroll down.

-

John Roberts is proud to be an equal opportunity employer that values diversity. We are committed to creating a space where all employees feel included and understood. We do not discriminate on any unlawful basis including race, religion, color, national origin, disability, gender, gender identity, sexual orientation, age, marital status, veteran status, genetic information, or any other basis prohibited by applicable federal, state, or local laws. John Roberts also prohibits harassment of applicants and employees based on any protected categories.

As an Equal Opportunity Employer, we encourage all individuals to apply.