Senior Business Analyst (Reporting and Data Warehouse)

Info Way Solutions - Boston, MA

Full-time - Mid Level

Boston, MA

Sporting Goods, Hobby, Musical Instrument, Book, and Miscellaneous Retailers

About the position

The Senior Business Analyst (Reporting and Data Warehouse) is responsible for enhancing data warehouse solutions and reporting structures to support the organization's data strategy. This role involves collaborating with stakeholders to understand reporting needs, optimizing data flows, and developing dashboards and reports using various reporting tools. The position requires strong analytical skills and the ability to bridge technical and business requirements effectively.

Responsibilities

• Collaborate with business teams to gather and document requirements for reporting and data warehouse improvements.
• Analyze data needs and reporting requirements to develop solutions that support the organization’s data strategy.
• Prioritize and translate business requirements into technical specifications, focusing on ETL processes and reporting solutions.
• Work closely with data engineering teams to define and enhance data models and ETL workflows in the data warehouse.
• Support the integration of data from application databases and various state/federal entities.
• Optimize data pipelines and processing workflows for efficient data delivery for reporting purposes.
• Oversee the design and development of reports and dashboards using tools like Tableau, Cognos, and Jasper Reports.
• Provide guidance on best practices for report development and dashboard design to ensure data accuracy and usability.
• Conduct testing and validation of reports and dashboards, resolving issues with QA and development teams.
• Ensure compliance with data quality standards, data protection regulations, and governance policies throughout reporting processes.
• Regularly audit data flows and reports to maintain accuracy and consistency.
• Document data lineage, data dictionaries, and other artifacts essential for maintaining a reliable data environment.
• Develop comprehensive documentation, including report specifications and process workflows.
• Create training materials and conduct training sessions for end-users, providing ongoing support.
• Gather feedback from users to continuously improve reporting functionalities and optimize the data warehouse structure.
• Stay informed about new technologies in data warehousing, ETL, and reporting to recommend improvements in data infrastructure.

Requirements

• Bachelor’s degree in Data Science, Information Systems, Computer Science, or a related field.
• 5+ years of experience in business analysis with a focus on data warehousing and reporting solutions.
• Demonstrated experience in managing and optimizing data flows, ETL processes, and data models.
• Strong familiarity with data visualization tools, specifically Tableau, Cognos, and Jasper Reports.
• Proficiency with data warehouse platforms (e.g., Oracle, Snowflake) and ETL tools such as Informatica.
• Hands-on experience with SQL for data analysis, transformation, and reporting.
• Familiarity with cloud data technologies, especially Snowflake, and experience working on Unix, Linux, and Windows OS.
• Strong analytical and problem-solving skills with meticulous attention to detail.
• Excellent communication and interpersonal skills.

Nice-to-haves

• Advanced degree in Data Science, Information Systems, or a related field.
• Certification in data warehousing or business intelligence tools.
• Experience in cloud-based data platforms and familiarity with data governance and data protection regulations.