Business Intelligence Analyst- Statistical knowledge, data warehouse ownership, lead, high volume data
The Consortium
- Baltimore, MD
- Permanent
- Full-time
- 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.
- 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
- Statistical background a plus