Job Title: Senior BI Analyst
Location: Remote
FLSA Status: Exempt
Job Summary
We are seeking a highly skilled and experienced Senior BI Analyst to join our team. The ideal candidate will have a strong background in data warehouse strategies and extensive experience with Power BI. As a Senior BI Analyst, you will play a crucial role in transforming data into actionable insights, driving data-driven decision-making processes, and supporting business growth.
Essential Job Functions
- Develop and implement data warehouse strategies to optimize data storage, retrieval, and analysis.
- Design, develop, and maintain Power BI Reports and dashboards to provide clear and actionable insights.
- Design, develop, and maintain ETL processes using SQL Server Integration Services (SSIS) 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 SQL Server Reporting Services (SSRS) 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.
- Utilize DevOps tools such as Team Foundation Server (TFS) for version control, source control, and release procedures.
- Stay updated on emerging trends and technologies in the BI field to drive continuous improvement and innovation.
Minimum Qualifications
- Bachelor’s degree in Computer Science, Information Systems, or related field.
- Seven years of experience.
Additional Responsibilities
- Other duties as assigned or required.
Knowledge, Skills & Abilities
- Strong experience with SQL Server Integration Services (SSIS) and Intermediate Extract, Transform, Load (ETL) experience.
- Proficiency in T-SQL with a solid understanding of query mechanics, query optimization, and performance tuning.
- Proven experience as a BI Analyst or similar role, with a strong focus on data warehousing and Power BI.
- Strong analytical and problem-solving skills with the ability to interpret complex data sets.
- Experience with DevOps tools such as TFS (Team Foundation Server), source control, and release procedures.
- Strong analytical and problem-solving skills with the ability to interpret complex data sets.
- 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), and graphics.
Preferred Skills (Not Required)
- Familiarity with Agile methodologies and project management principles.
- Certification in relevant BI technologies (e.g., Microsoft Certified: Data Analyst Associate).
Physical Requirements/Working Conditions
- Sedentary work, requiring 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).
- Remote office.