The Consortium, Inc.

Business Intelligence Analyst- Statistical knowledge, data warehouse ownership, lead, high volume data

The Consortium, Inc. - Baltimore, MD

***MUST BE WITHIN 30 MILES OF BALTIMORE, FULL TIME PERMANENT POSITION***

As the Business Intelligence Analyst, you will maintain the Business Intelligence (BI) initiatives and support data warehousing initiatives in collaboration with the Data Operations Engineer and Director of Analytics.

Client amasses a high volume of structured and unstructured data in multiple production systems. We strive to have one source of truth for our data, analytics and insights.

As the Business Intelligence Analyst you will be the function lead and primary point of contact for the BI function - will take ownership of stakeholder management, strategy, and the data that is available in our data warehouse to the entire organization. You must be comfortable working with a wide range of stakeholders and functional teams.

The Business Intelligence Analyst is also a member of an innovative, proprietary framework for developing new statistical and machine learning models and advanced products for partners and consumers. It unifies various organizations and business practices, including Business Intelligence, Data Engineering, and Advanced Analytics.

In addition, you'll assist in training and evangelizing democratization of data and data governance standards throughout the organization. You must be comfortable working with a wide range of stakeholders and functional teams.

Responsibilities

  • As the Business Intelligence Lead, you will:
  • Implement the short and long-term roadmap for the BI function with support from leadership
  • Support the Data Operations Engineer and Director of Analytics in deploying and documenting clean, curated, organized data sets used by BI and DAP teams. The role is hands-on and collaborative building data sets that enable analysis and drives tactical and strategic decisions.
  • Apply best practices with regards to analytics reporting, data storytelling, data warehousing, ETL/ELT frameworks and data governance standards.
  • Work directly with stakeholders to understand data analytics requirements; propose and develop analytic solutions that provide market insights and enable effective decision-making to drive business objectives.
  • Provide business application and platform support, troubleshoot technical issues, enable data connections, and assist end-users with their analytics and reporting needs.
  • Actively promote user enablement of self-service tools.
  • Work closely with the Product Development team to understand upstream systems and data gaps as well as maintain information security standards and protocols according to ISO 27001 and SOC2 policies.
  • Other duties and responsibilities as assigned.

Competencies and Criteria for Success

 

    Respected: Do you value integrity and display leadership qualities? Are you trusted to represent the brand well?

    Judiciously Courageous: Are you courageous enough to judiciously speak up?

    Composed: Are you composed, respectful, and calm? Do you value outcomes over output?

    Accountable: Do you own your work, your decisions, and the outcomes – good or bad?

    No Ego: Are you confident without having an ego? Would people say you are an active listener? Do you delegate where necessary, knowing that you can’t possibly know it all?

    Builder Mindset: Do you have an open mindset? Would you consider yourself a strategic doer?

    Focused: Do you easily differentiate between real problems and background noise?

    Requirements:

    • 3+ years of experience in tools-based data warehousing development
    • 5 years of experience in data warehousing development with emphasis on software development, credit reporting, mortgage or related industries.
    • Bachelor’s degree in such fields as information systems, computer science, mathematics, or statistics.
    • Applied data warehousing techniques and architecture approach
    • Strong data modeling skills
    • Experienced in creating single sources of truth from disparate data sources
    • Strong SQL skills with structured and unstructured data
    • Advanced in SQL, Fivetran, Sigma and other data/visualizing systems
    • Experience with Snowflake and dbt
    • Experience w/ one or more of the following relational databases: MySQL, Postgres, Oracle, Sybase, SQL Server
    • Experience with Atlassian, Git, CI/CD tools, and agile methodology
    • Experience with Hubspot, Linkedin, Facebook campaign data, Google Analytics
    • Experience with reporting and dashboarding tools, preferably Sigma
    • Ability to document process and procedures related to data structure and compliance

    Nice to haves…

    • Statistical background a plus

    They offer a flex schedule with 2-3 days in the office, mandatory day on Wednesdays.

     

     



    Posted On: Wednesday, February 28, 2024
    Compensation: 110,000



    Apply to this job

    or