Business Intelligence Analyst

Job Summary

We are seeking a dynamic and detail-oriented Business Intelligence (BI) Analyst to join our innovative team. In this role, you will harness the power of data to drive strategic decision-making, develop insightful dashboards, and deliver actionable business insights.

Your expertise in data analytics tools, data visualization, and database management will enable you to transform complex data sets into clear, compelling stories that support organizational growth. This position offers an exciting opportunity to work across multiple departments, influence business strategies, and contribute to a data-driven culture.

Responsibilities

• Design, develop, and maintain interactive dashboards and reports using tools such as Tableau, Power BI, and Looker to visualize key performance indicators and business metrics.
• Collaborate with stakeholders to gather requirements, analyze business needs, and translate them into technical specifications for data models and reports.
• Perform data analysis using SQL, R, Python, and other analytics tools to identify trends, patterns, and insights that inform strategic decisions.
• Manage ETL (Extract, Transform, Load) processes to ensure accurate data integration from various sources including SQL databases, Oracle, Talend, and Linked Data platforms.
• Conduct database design and query management within Microsoft SQL Server and SQL databases to optimize performance and support reporting needs.
• Support the entire Software Development Lifecycle (SDLC) by analyzing requirements, developing solutions, testing functionalities, and deploying updates in an Agile environment.
• Develop comprehensive documentation using Visio or similar tools for data models, workflows, and technical specifications to facilitate ongoing maintenance and enhancements.

Skills

• Proficiency with business intelligence and reporting tools such as Tableau, Power BI, Looker, and dashboard development techniques.
• Strong knowledge of SQL databases including query management and database design principles.
• Experience with ETL tools like Talend or Bash (Unix shell scripting) for data integration tasks.
• Programming skills in R and Python for advanced data analysis and analytics automation.
• Familiarity with data visualization best practices for creating engaging dashboards that communicate insights effectively.
• Understanding of the Software Development Lifecycle (SDLC), Agile methodologies, and project management principles.
• Ability to analyze complex datasets using Excel data analysis techniques alongside comprehensive analysis skills.
• Knowledge of linked data concepts for integrating disparate sources into unified views.
• Experience with VBA scripting for automating Excel workflows and enhancing reporting capabilities.
• Technical proficiency in Oracle databases and Microsoft SQL Server environments.
• Skills in database design, data model design, query optimization, and report development aligned with business analysis needs.

Join us as a Business Intelligence Analyst to leverage your technical expertise in analytics tools combined with your passion for transforming raw data into strategic assets!

Pay: $66,051. 01 - $79,545. 30 per year

Benefits:

• 401(k)
• 401(k) 2% match
• 401(k) 3% Match
• 401(k) 4% Match
• Green card sponsorship

Work Location: In person