Business Data Analyst

Petabyte Technologies - Framingham, MA

Full-time - Mid Level

Framingham, MA

Professional, Scientific, and Technical Services

About the position

The Business Data Analyst role focuses on analyzing complex data sets and developing interactive dashboards to provide insights into key business metrics. The position involves transitioning database solutions to enhance data integrity and performance, as well as managing reporting and documentation processes to ensure timely and accurate information distribution to stakeholders.

Responsibilities

• Develop and maintain interactive dashboards and reports using Microsoft Power BI to provide insights into key business metrics.
• Analyze complex data sets using SQL to identify trends, patterns, and opportunities for improvement.
• Transition database solution from an Access-based environment to a SQL-based data mart, ensuring data integrity and optimal performance.
• Design, develop and maintain databases to support various reporting and analytical needs.
• Continuously improve existing databases to adapt to evolving business needs.
• Manage ad-hoc inquiries related to reporting, ensuring timely and accurate responses.
• Create comprehensive documentation of data processes, methodologies, and reports.
• Ensure the timely and accurate distribution of canned and ad-hoc reports to stakeholders.

Requirements

• Proficiency in Microsoft Power BI for dashboard development and reporting.
• Strong SQL skills for data analysis and manipulation.
• Experience in transitioning database solutions from Access to SQL-based environments.
• Ability to design and maintain databases for reporting and analytical purposes.
• Strong analytical skills to identify trends and opportunities for improvement.

Nice-to-haves

• Experience with data visualization best practices.
• Familiarity with data governance and data quality principles.
• Knowledge of additional programming languages such as Python or R for data analysis.

Benefits

• Health insurance coverage
• 401k retirement savings plan
• Paid time off and holidays
• Professional development opportunities