Senior Business Analyst (Data Warehouse)

SolutionIT - Boston, MA

Full-time - Mid Level

Boston, MA

Professional, Scientific, and Technical Services

About the position

The Senior Business Analyst (Data Warehouse) will play a crucial role in analyzing and optimizing data flows, ETL processes, and data models for a client in Boston, MA. This position requires a strong focus on data warehousing and reporting solutions, utilizing various data visualization tools and platforms. The analyst will work closely with both technical and non-technical stakeholders to ensure effective communication and project management in a dynamic environment.

Responsibilities

• Manage and optimize data flows and ETL processes.
• Develop and maintain data models for reporting solutions.
• Utilize data visualization tools such as Tableau, Cognos, and Jasper Reports.
• Collaborate with stakeholders to gather requirements and provide insights.
• Conduct data analysis and reporting using SQL.
• Ensure data quality and integrity throughout the data lifecycle.

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.