Analytics / Business Intelligence Manager (dbt, Fivetran, Oracle Database, Snowflake)

2 weeks ago


Boston, United States Performance Architects Full time

OVERVIEW:


We are hiring a Senior Analytics Consulting Manager for our Business Intelligence (BI) consulting practice. As a member of our business intelligence practice, you will be exposed to all phases of the project lifecycle and will have the opportunity to help shape the future of Performance Architects. Excellent advancement opportunities are available for a candidate with the right attitude, talents and skills. This role requires hands-on expertise and participation in both business and technical analysis and solution development.


The ideal candidate MUST have strong expertise in utilizing the following technologies: Snowflake, Oracle databases, Fivetran, dbt, Windows scripting, and preferably Informatica Integration Cloud Services (IICS).


Experience in migrating Oracle data warehouses to Snowflake and establishing reporting capabilities during the transition phase are desired but not required. You will be instrumental in supporting our clients' needs, leading business requirements gathering and creating (and executing on) a technical design to support those requirements.


QUALIFICATIONS:

  • B.S. or B.A. degree in business, MIS, or equivalent required
  • Two to five years of previous work experience in the business or IT field required
  • Proper U.S. work authorization
  • Some flexibility to travel (Monday – Thursday) during the work week, if required
  • Experience in full consulting or IT project lifecycle (requirements, design, development, testing, deployment and training) preferred


SKILLS – BI FOCUS:

  • Minimum five years of working development experience with Business Intelligence (BI) solutions using Oracle Analytics Cloud (OAC), Oracle Business Intelligence Enterprise Edition (OBIEE), or Microsoft Power BI or Tableau
  • Experience leading and mentoring teams required
  • Intermediate to advanced SQL skills required. Experience with designing and developing relational data models to support Business Intelligence reporting a plus.
  • Working knowledge in MS Office required (MS Excel “power user” a plus)
  • Working knowledge in Windows operating system required (Unix experience, a plus)
  • Collaborate with project teams and clients to understand data requirements, architecture, and objectives
  • Design, develop, and maintain data pipelines and ETL processes using technologies like Snowflake, Oracle, Fivetran, dbt, and IICS
  • Develop and optimize SQL queries and scripts for data extraction, transformation, and loading
  • Troubleshoot and resolve data-related issues in a timely manner
  • Work closely with cross-functional teams, including data analysts, business users, and IT teams, to deliver high-quality solutions
  • Provide technical leadership and mentorship to junior team members
  • Stay updated on emerging technologies and industry trends related to data engineering and analytics


QUALITIES:

  • Integrity and honesty
  • Proactive self-starter with strong work ethic
  • Interest in entrepreneurship and innovation
  • Strong analytical skills
  • Comfortable in dynamic, constantly changing environments
  • Excellent time management skills with the ability to multi-task
  • Projects a composed professional image
  • Excellent written, oral and interpersonal communication / relationship-building skills
  • Effective working with diverse personalities
  • Team player


COMPENSATION AND BENEFITS:

  • Competitive base salary
  • Individual and company performance bonuses
  • Ongoing, formal technical and business skills training
  • Medical/dental insurance
  • LTD/STD insurance
  • Life insurance
  • 401K plan
  • Paid vacations and holidays
  • Job Type: Full-time


Benefits:

  • 401(k)
  • Dental insurance
  • Flexible schedule
  • Flexible spending account
  • Health insurance
  • Life insurance
  • Paid time off
  • Professional development assistance
  • Referral program

  • Analytics Engineer

    2 weeks ago


    Boston, Massachusetts, United States Pure Lithium Full time

    Job Description:Working with a small team of Software and Data Engineers, you will play a critical role in transforming raw data into well-formed models to accelerate research for Pure Lithium's battery technology. You will interact directly with scientists in the laboratory, translating their requirements into code. As you architect data models primed for...

  • Sr DBA

    5 days ago


    Boston, United States BMR Infotek Full time

    Role Sr DBA Location Boston, MA (Onsite) Only Local Candidates Visa GC or USC In-Person Interview Senior DBA This is a Senior DBA position to work as a part of skilled DBA team in order to assist with migration, maintenance, update, and support of various database platforms including Snowflake, Fivetran, DBT, DB2, Oracle, SQL Server, AWS RDS, Redis,...


  • Boston, United States Metaplane, Inc Full time

    We're a Boston-based, remote-friendly company founded by MIT and HubSpot alums.We're backed by leading investors such as Y Combinator, Flybridge, and notable angel investors, including the founders of HubSpot, Okta, and Lookout.The role will be responsible for all aspects of our backend, including our suite of integrations, machine learning...


  • Boston, Massachusetts, United States Metaplane, Inc Full time

    We're a Boston-based, remote-friendly company founded by MIT and HubSpot alums.We're backed by leading investors such as Y Combinator, Flybridge, and notable angel investors, including the founders of HubSpot, Okta, and Lookout.The role will be responsible for all aspects of our backend, including our suite of integrations, machine learning pipeline, and...


  • Boston, United States firstPRO, Inc Full time

    Long term contractOnsite in Boston 4 days per weekActivities will include working with other teams including development, security, and data warehouse teams. Production on-call support, maintenance, and off-hour deployments is required.Knowledge, Skills and Education RequiredHands on experience with designing, implementing, and maintaining Snowflake, and...


  • Boston, United States firstPRO, Inc Full time

    Long term contractOnsite in Boston 4 days per weekActivities will include working with other teams including development, security, and data warehouse teams. Production on-call support, maintenance, and off-hour deployments is required.Knowledge, Skills and Education RequiredHands on experience with designing, implementing, and maintaining Snowflake, and...


  • Boston, United States FirstPRO Full time

    Long term contract Onsite in Boston 4 days per week Activities will include working with other teams including development, security, and data warehouse teams. Production on-call support, maintenance, and off-hour deployments is required. Knowledge, Skills and Education Required Hands on experience with designing, implementing, and maintaining Snowflake,...

  • Sr DBA

    5 days ago


    Boston, MA, United States BMR Infotek Full time

    Role Sr DBA Location Boston, MA (Onsite) Only Local Candidates Visa GC or USC In-Person Interview Senior DBA This is a Senior DBA position to work as a part of skilled DBA team in order to assist with migration, maintenance, update, and support of various database platforms including Snowflake, Fivetran, DBT, DB2, Oracle, SQL Server, AWS RDS, Redis,...

  • Analytics Engineer

    4 weeks ago


    Boston, United States Pure Lithium Corporation Full time

    Job Description:Working with a small team of Software and Data Engineers, you will play a critical role in transforming raw data into well-formed models to accelerate research for Pure Lithium’s battery technology.You will interact directly with scientists in the laboratory, translating their requirements into code. As you architect data models primed for...


  • Boston, United States Rapid7 Full time

    Overview Rapid7 is looking for a highly motivated Business Intelligence Analyst to drive insights and recommendations for key business stakeholders across our functional areas. This role will be accountable for providing accurate, timely and high-impact data solutions and BI products to executive leadership, operating groups and management teams to...


  • Boston, United States Mindlance Full time

    Seeking a contract Senior BI Architect to design, develop, and implement our organizations BI strategy for a health data warehouse project for approximately fifteen (15) months. The project team, consisting of temporary and permanent staff, will rebuild an existing data warehouse using new ETL, Business Intelligence, and database platforms with an eye...


  • Boston, United States Mindlance Full time

    Seeking a contract Senior BI Architect to design, develop, and implement our organization’s BI strategy for a health data warehouse project for approximately fifteen (15) months. The project team, consisting of temporary and permanent staff, will rebuild an existing data warehouse using new ETL, Business Intelligence, and database platforms with an eye...


  • Boston, United States Mindlance Full time

    Seeking a contract Senior BI Architect to design, develop, and implement our organization’s BI strategy for a health data warehouse project for approximately fifteen (15) months. The project team, consisting of temporary and permanent staff, will rebuild an existing data warehouse using new ETL, Business Intelligence, and database platforms with an eye...


  • Boston, United States Mindlance Full time

    Seeking a contract Senior BI Architect to design, develop, and implement our organization’s BI strategy for a health data warehouse project for approximately fifteen (15) months. The project team, consisting of temporary and permanent staff, will rebuild an existing data warehouse using new ETL, Business Intelligence, and database platforms with an eye...


  • Boston, United States Acro Service Corp Full time

    Job Title: Senior BI ArchitectProject Duration: 13 Months (With Possible Renewal)Hours per Week: 40Worksite Address: Boston, MA 02116- HYBRIDJob Description : seeking a contract Senior BI Architect to design, develop, and implement our organization’s BI strategy for a health data warehouse project for approximately fifteen (15) months. The project team,...


  • Boston, United States Acro Service Corp Full time

    Job Title: Senior BI ArchitectProject Duration: 13 Months (With Possible Renewal)Hours per Week: 40Worksite Address: Boston, MA 02116- HYBRIDJob Description : seeking a contract Senior BI Architect to design, develop, and implement our organization’s BI strategy for a health data warehouse project for approximately fifteen (15) months. The project team,...


  • Boston, United States Mindlance Full time

    Duration: Possibility for full time employment Location: US Either Remote or Hybrid in Boston, MA Looking for an experienced database developer to support Oracle cloud application including Oracle Analytical Cloud and Oracle Integration Cloud. Advanced SQL writing / development skills required as well. Knowledge of Python and Workday is a plus. Description:...


  • Boston, MA, United States Boston Consulting Group Full time

    WHAT YOU'LL DO Design, document & implement the data pipelines to feed data models for subsequent consumption in Snowflake using dbt, airflow . Ensure correctness and completeness of the data being transformed via engineering pipelines for end consumption in Analytical Dashboards. Actively monitor and triage technical challenges in critical...


  • Boston, Massachusetts, United States findojobs Full time

    At WHOOP, we're on a mission to unlock human performance. WHOOP empowers users to perform at a higher level through a deeper understanding of their bodies and daily lives.We are seeking a Business Analytics Manager (Marketing) who is adept at leveraging data to forge impactful marketing strategies. In this role, you will take the lead in analyzing and...


  • Boston, United States Boston Consulting Group Full time

    WHAT YOU'LL DO Design, document & implement the data pipelines to feed data models for subsequent consumption in Snowflake using dbt, airflow. Ensure correctness and completeness of the data being transformed via engineering pipelines for end consumption in Analytical Dashboards. Actively monitor and triage technical challenges in critical situations that...