Business Intelligence Analyst

Job Summary

We are seeking a talented BI Analyst to join our dynamic team. The ideal candidate will have a strong background in Business Intelligence (BI) tools and technologies, with a focus on data integration, analysis, and reporting. As a BI Analyst, you will play a crucial role in creating and maintaining processes for business-critical data, as well as analyzing this data to provide valuable insights to stakeholders.

Essential Job Functions

• Design, develop, and maintain ETL processes using SSIS (SQL Server Integration Services) to ensure accurate and timely data extraction, transformation, and loading.
• Utilize strong T-SQL skills to create and optimize queries for data analysis and reporting purposes.
• Develop and maintain reports using SSRS (SQL Server Reporting Services) to meet business requirements and provide actionable insights.
• Perform query optimization and performance tuning to enhance database performance and improve overall efficiency.
• Collaborate with cross-functional teams to understand business needs and translate them into technical requirements.
• Maintain a basic understanding of data warehouse strategies and best practices to support data modeling and architecture initiatives.
• Utilize DevOps tools such as TFS (Team Foundation Server) for version control, source control, and release procedures.
• Assist in the development and maintenance of Power BI dashboards and reports (experience preferred but not required).
• Stay updated on emerging trends and technologies in the BI field to drive continuous improvement and innovation.

Additional Responsibilities

Other job tasks that may be utilized but are not essential to performing the job.

Minimum Qualifications for Consideration

Qualifications include:

• Bachelor’s degree in Computer Science, Information Systems, Mathematics, Statistics, or related field
• 3+ years experience

Knowledge, Skills, and Abilities:

• Strong experience with SSIS (SQL Server Integration Services) and Intermediate ETL (Extract, Transform, Load) experience.
• Proficiency in T-SQL with a solid understanding of query mechanics, query optimization, and performance tuning.
• Knowledgeable in data warehouse strategies and best practices.
• Experience with DevOps tools such as TFS (Team Foundation Server), source control, and release procedures.
• Excellent analytical and problem-solving skills with a keen attention to detail.
• Strong communication and collaboration skills to work effectively with cross-functional teams.
• Ability to prioritize tasks and manage multiple projects simultaneously.
• Demonstrate resourcefulness and ability to take initiative in development and completion of projects.
• Strong sense of customer service.
• Demonstrate basic computer knowledge through effective use of a personal computer including Microsoft Office applications. Computer skills to include file management skills, Internet, Microsoft Windows, database, word processing (WORD), spreadsheets (Excel), presentation software (PowerPoint), graphics.

Preferred Skills

• Experience with Power BI for dashboard development and data visualization.
• Familiarity with Agile methodologies and project management principles.
• Certification in relevant BI technologies (e.g., Microsoft Certified: Data Analyst Associate).

Physical requirements/Working Conditions

This work is sedentary and requires the following physical activities:

• Sitting for long periods of time; occasional bending, squatting, kneeling, stooping; good finger dexterity and feeling; frequent repetitive motions; talking, hearing, and visual acuity.
• Frequent lifting (up to 20 pounds of paper supplies or minor office equipment).
• Driving to client locations and other sites as needed.

NOTE: The above statements are intended to describe the general nature and level of work performed by an employee in this position. These statements are not to be construed as an exhaustive list of all responsibilities, duties, and skills required of employees in this position.

AlignRx is an equal opportunity employer and is committed to providing a workplace free from harassment and discrimination. We celebrate unique differences of our employees, knowing diversity drives innovation, and the success of our business. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, gender identity or expression, age, marital status, veteran status, disability status, pregnancy, parental status, genetic information, political affiliation, or any other status protected by applicable laws or regulations.

Benefits:

• 401(k)
• 401(k) matching
• Dental insurance
• Employee assistance program
• Flexible spending account
• Health insurance
• Health savings account
• Life insurance
• Paid time off
• Tuition reimbursement
• Vision insurance

Job Type: Full-time

Pay: $92,400.00 - $118,000.00 per year

Experience level:

• 3 years

Education:

• Bachelor's (Required)

Experience:

• Business Intelligence Analyst: 3 years (Required)

Work Location: Remote