Business Intelligence Data Analyst II
Advarra · United States
- Hybrid
- Full-time
- $100,000 / year
- United States
Tailored resume — keyword-matched to this role.
Hiring manager — we find who's hiring.
Intro email — drafted to reach them directly.
Job highlights
- Deliver reporting, dashboards, and data insights.
- Create and maintain deliverables and conduct analysis.
- Resolve business and technical issues.
- Optimize data structure and lead data modeling.
- Collaborate with cross-functional teams.
About the role
Job Overview Summary
This position supports Advarra’s Analytics and Reporting team, working closely with both Business Intelligence and Data Engineering to deliver reporting, dashboards, and data-driven insights. The role involves creating and maintaining deliverables, conducting ad hoc analysis, and resolving business and technical issues. Success requires strong analytical skills, attention to detail, effective documentation, and the ability to manage multiple priorities while aligning with broader business objectives.Job Duties & Responsibilities
- Understand and optimize data structure to drive consistent data capture and reporting.
- Lead situations where new data modeling is required to support the business.
- Follow best practices as defined by Data Engineering to support Business Intelligence needs.
- Drive collaboration with identification of required individuals necessary for identified resolutions.
- Work with Business and Product Management teams to ensure appropriate requirements are captured and documented.
- Support the architect of solutions to support analytics needs.
- Understand all development in process, regardless of team ownership, for appropriate tracking and project updates.
- Participate in release management and deployment, where necessary.
- Monitor data feeds and engage with Data Engineering to resolve issues.
Location
This role is open to candidates working remotely in the United States.Basic Qualifications
- Bachelor’s Degree in Data Science, Information Science or related area of experience.
- 2-4 years of experience with a focus on SQL coding, system and data feed monitoring, and data validation.
- Excel – advanced.
- Snowflake – advanced.
- Databricks – advanced.
- SQL – advanced.
- DBTG Hub – advanced.
- Presentation skills – advanced.
- Business analysis skills – advanced.
- Demonstrated proficiency in making effective, well-reasoned decisions.
- Demonstrated proficiency in end-user requirements gathering.
- Ability to work on cross-functional teams.
- Excellent attention to detail and time management skills, proven ability to adapt and navigate change.
- Ability to quickly learn new technologies and systems.
Preferred Qualifications
- Python, JSON, HTML, and other coding experience.
Physical And Mental Requirements
- Sit or stand for extended periods of time at a stationary workstation.
- Regularly carry, raise, and lower objects of up to 10 Lbs.
- Learn and comprehend basic instructions.
- Focus and attention to tasks and responsibilities.
- Verbal communication; listening and understanding, responding, and speaking.
Key skills/competency
- Business Intelligence
- Data Analysis
- SQL
- Snowflake
- Databricks
- Excel
- Data Modeling
- Reporting
- Dashboards
- Business Analysis
Skills & topics
- Business Intelligence
- Data Analyst
- SQL
- Snowflake
- Databricks
- Excel
- Data Modeling
- Reporting
- Data Visualization
- Business Analysis
How to get hired
- Tailor your resume: Highlight SQL, Snowflake, Databricks, and Excel skills.
- Showcase analytics experience: Detail your involvement in data modeling and reporting.
- Emphasize collaboration: Mention experience working in cross-functional teams.
- Prepare for technical questions: Be ready to discuss data validation and system monitoring.
- Demonstrate problem-solving: Provide examples of resolving business and technical issues.
Technical preparation
Master SQL for complex queries and data manipulation.,Practice advanced Excel functions and data analysis.,Familiarize with Snowflake and Databricks environments.,Understand data validation and feed monitoring techniques.
Behavioral questions
Describe a time you improved data capture.,How do you ensure accurate data reporting?,Share an experience resolving technical issues.,How do you manage multiple priorities effectively?
Frequently asked questions
- What are the key technical skills required for the Business Intelligence Data Analyst II role at Advarra?
- The Business Intelligence Data Analyst II role at Advarra requires advanced proficiency in SQL, Excel, Snowflake, and Databricks. Experience with system and data feed monitoring, and data validation are also crucial. A Bachelor's degree in Data Science, Information Science, or a related field is necessary, along with 2-4 years of relevant experience.
- Is this Business Intelligence Data Analyst II position remote?
- Yes, this Business Intelligence Data Analyst II position is open to candidates working remotely within the United States. Advarra offers flexibility for this role, allowing you to contribute from your home location.
- What is the typical career progression for a Business Intelligence Data Analyst at Advarra?
- While specific paths vary, Advarra values employee growth. Successful Business Intelligence Data Analysts may advance to senior analyst roles, specialize in data engineering, or move into leadership positions within the analytics department, contributing to more complex projects and strategic decision-making.
- How does Advarra foster a collaborative environment for its Business Intelligence Data Analysts?
- Advarra emphasizes a collaborative company culture. For the Business Intelligence Data Analyst II role, this means actively working with Business Intelligence, Data Engineering, and Product Management teams to ensure requirements are captured and solutions are effectively architected and implemented.
- What kind of projects will a Business Intelligence Data Analyst II work on at Advarra?
- As a Business Intelligence Data Analyst II, you will focus on delivering reporting, dashboards, and data-driven insights. This includes creating and maintaining deliverables, conducting ad hoc analysis, optimizing data structures, and potentially leading new data modeling efforts to support business needs.