Sr. Business Intelligence Developer

AssistRx; Town of Florida (NY); On-site; USD 80,000 - 100,000; Full time

Job summary

AssistRx in Town of Florida, NY is seeking a skilled Business Intelligence Analyst. This role involves developing and maintaining data models and visualizations using tools like dbt and Tableau. Candidates should have a Bachelor's degree in a relevant field and at least five years of experience with BI tools and technologies. The position requires strong analytical skills and the ability to collaborate effectively across teams, providing valuable insights to enhance decision-making processes.

Qualifications

• 5 years’ experience working with business intelligence tools.
• Experience in using tools to create data views, models, and tables.
• Able to translate business needs to technical specifications.

Responsibilities

• Develop and maintain data view, models, and tables using dbt.
• Develop and maintain data visualizations and reports using Tableau or SSRS.
• Collaborate with data architects to define and maintain the overall data architecture.

Skills

Business intelligence tools

SQL

Tableau

Data modeling

Data visualization

Education

Bachelor’s degree in computer science, information systems, or math

Tools

dbt

SQL Server Reporting Services (SSRS)

Job description

RESPONSIBILITIES

• Develop and maintain data view, models, and tables using dbt
• Develop and maintain data visualizations and reports using Tableau or SSRS
• Collaborate with data architects to define and maintain the overall data architecture for the BI environment
• Optimize dashboard performance by reducing load times and improving responsiveness through efficient data source connections and visual design
• Follow the SDLC process in development and utilize proper naming standards
• Works cross-functionally to assist in creating data feeds according to defined specifications
• Peer review reports and logic for validity
• Work with subject matter experts to understand the needs of both internal and external customers
• Fields ongoing, incoming requests, and questions regarding data specifications
• Performs other related duties as assigned by management.

SUPERVISORY RESPONSIBILITIES

• This job has no supervisory responsibilities.

QUALIFICATIONS

• Bachelor’s degree in computer science, information systems, or math or equivalent experience or combination of education and experience.
• 5 years’ experience working with business intelligence tools that included systems analysis and/or information technology activities.
• Experience in using tools to create data views, models, and tables (e.g. dbt)
• Experience with BI technologies (e.g. Tableau)
• Experience with SQL and knowledge of SQL queries, and SQL Server Reporting Services (SSRS)
• Able to translate business needs to technical specifications
• Develop and update technical documentation

COMPETENCIES

• Diversity - Demonstrates knowledge of EEO policy; Shows respect and sensitivity for cultural differences; Educates others on the value of diversity; Promotes a harassment-free environment; Builds a diverse workforce.
• Ethics - Treats people with respect; Keeps commitments; Inspires the trust of others; Works with integrity and ethically; Upholds organizational values.
• Adaptability - Adapts to changes in the work environment; Manages competing demands; Changes approach or method to best fit the situation; Able to deal with frequent change, delays, or unexpected events.
• Analytical - Synthesizes complex or diverse information; Collects and researches data; Uses intuition and experience to complement data; Designs workflows and procedures.
• Initiative - Volunteers readily; Undertakes self-development activities; Seeks increased responsibilities; Takes independent actions and calculated risks; Looks for and takes advantage of opportunities; Asks for and offers help when needed.
• Oral Communication - Speaks clearly and persuasively in positive or negative situations; Listens and gets clarification; Responds well to questions; Demonstrates group presentation skills; Participates in meetings.
• Organizational Support - Follows policies and procedures; Completes administrative tasks correctly and on time; Supports organization's goals and values; Benefits organization through outside activities; Supports affirmative action and respects diversity.
• Problem Solving - Identifies and resolves problems in a timely manner; Gathers and analyzes information skillfully; Develops alternative solutions; Works well in group problem solving situations; Uses reason even when dealing with emotional topics.
• Quality - Demonstrates accuracy and thoroughness; Looks for ways to improve and promote quality; Applies feedback to improve performance; Monitors own work to ensure quality.
• Teamwork - Balances team and individual responsibilities; Exhibits objectivity and openness to others' views; Gives and welcomes feedback; Contributes to building a positive team spirit; Puts success of team above own interests; Able to build morale and group commitments to goals and objectives; Supports everyone's efforts to succeed.
• Technical Skills - Assesses own strengths and weaknesses; Pursues training and development opportunities; Strives to continuously build knowledge and skills; Shares expertise with others.
• Written Communication - Writes clearly and informatively; Edits work for spelling and grammar; Varies writing style to meet needs; Presents numerical data effectively; Able to read and interpret written information.

PHYSICAL DEMANDS AND WORK ENVIRONMENT

• Occasionally required to stand.
• Occasionally required to walk.
• Frequently required to sit.
• Continually required to utilize hand and finger dexterity.
• Continually required to talk or hear.
• Tight deadlines must be met with limited staff to support projects.
• Occasional evening and weekend work may be required.

The above is intended to describe the general content of and requirements for the performance of this job. It is not to be construed as an exhaustive statement of duties, responsibilities, or physical requirements. Nothing in this job description restricts management’s right to assign or reassign duties and responsibilities to this job at any time. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.