Intern Open Source Intelligence Analyst Jobs in Boston, MA

As a Senior Strategic Intelligence Analyst, you’ll play a pivotal role in shaping our organization’s technology-driven future. You will architect and advance cutting-edge analytical data models and intelligence solutions that power enterprise-wide reporting, dashboards, and impactful decision-making. Working closely with dynamic teams and stakeholders across all levels, you’ll transform complex business challenges into actionable insights, compelling visualizations, and performance metrics that drive growth and innovation. Your contributions will deliver trusted, accessible analytics, empowering leaders and colleagues to make confident operational and strategic decisions in a rapidly evolving environment. This is your opportunity to influence strategy, collaborate on visionary projects, and be a recognized contributor within a forward-thinking technology team.

• Design, develop, and maintain scalable analytical data models within Snowflake to support enterprise reporting, dashboards, and strategic analysis.
• Serve as a key contributor within the Strategic Intelligence team, owning the end-to-end analytics lifecycle from data modeling through insight delivery.
• Collaborate with departments and stakeholders at all levels of the organization to understand business questions, define metrics and KPIs, and translate needs into meaningful analytical solutions.
• Build, enhance, and maintain interactive dashboards, scorecards, and visualizations using Power BI or similar business intelligence and presentation tools.
• Develop, validate, and provide ongoing support for operational and project related reports, dashboards, and analytical outputs.
• Communicate analytical findings through clear data storytelling, visual narratives, and executive ready presentations that drive understanding and action.
• Define, document, and maintain business logic, metrics, data definitions, and assumptions to ensure consistent interpretation and trusted reporting.
• Identify, recommend, and implement improvements to analytics practices, reporting standards, and visualization approaches across Metro’s business units and departments.
• Perform additional duties assigned by management.

• Bachelor’s degree in Data Analytics, Information Systems, Statistics, Business, or a related field; or an equivalent combination of education and advanced analytical experience.
• Minimum 4 years of experience in data warehousing, ETL development, and business intelligence strongly preferred.
• Prior financial industry experience strongly preferred.

• Strong analytical and problem-solving skills.
• Demonstrated knowledge connecting to open database connectivity (ODBC) and object linking and embedded database (OLEDB) data sources and building complex SQL load scripts.
• Proficiency in SQL, data modeling, and database design.
• Technical skills including relational databases, SQL-based query development, report writing, data integration and transformation, building of semantic layers, and delivery framework monitoring and improvement including dashboard and report production/delivery.
• Knowledge of data visualization principles and best practices.
• Ability to manage multiple priorities and deliver projects on time.

• General office environment.
• Highly stationary.
• Frequent computer use.

• Minimum Days In Office per Week: 3 days per week; Tuesday and Wednesday in office required.
• Minimum Days In Office to Onboard: 5 days.
• 4x10 Eligible: Yes.

• Health, Dental, and Vision coverage for employees working a minimum of 20 hours per week; Metro provides assistance toward premiums and copays and offers 100% coverage on prescription copays.
• All staff eligible for an annual bonus and an annual (vesting) retention bonus.
• Three weeks of paid vacation per year and 11 paid holidays.
• 401(k) with matching plan and Safe Harbor Plan; Metro contributes 3% regardless of employee contribution.
• Wellness incentives, Employee Assistance Program, Flexible Spending Account, Prescription Drug Program, and a range of voluntary benefits (LTD, STD, AD&D).
• Access to no-interest loans and $150 per quarter reimbursement for wellness and lifestyle expenses.
• Discounts on pet insurance.
• Strong growth opportunities with individualized development plans.
• Position-related or job-related tuition assistance (one-year eligibility).
• Superb in-house training programs.
• A growing, dynamic environment with a strong culture and exceptional team members.

$84,000 – $113,000

The salary range listed provides a general expectation for the role. Final compensation is based on experience, unique strengths, and the impact you are expected to make. Metro also offers a competitive benefits package and additional perks that contribute to total compensation.