What are the responsibilities and job description for the Business Intelligence Analyst - OR position at Ideas Collide?
A Business Intelligence Analyst at Ideas Collide collects, analyses, and builds sustainable data solutions to identify trends that support business-making decisions and drive our client’s significant analytic initiatives. They provide clients or internal teams with valuable information that they can use to improve marketing, operational and businesses practices through easy-to-understand graphs, charts, tables, and reports.
About Ideas Collide
Ideas Collide is an exciting, forward-thinking firm that builds custom-marketing solutions for clients internationally, across the US with headquarters in Phoenix, Arizona, and operations in Portland, Oregon. We deliver award-winning, results-driven marketing campaigns by empowering passionate and collaborative team members, and we’re looking to add more talent to our A-team.
The team and business are driven by our core agency values.
We Are…
Diverse Inclusive Collaborators
Owners
Curious
Relentless
We…
Work Smart
Love the Team
Show Customer Love
Give Back
Make an Impact
Ideas Collide is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all team members.
Core Responsibilities:
- Partner with client/internal business owners to gather, document, analyze and prioritize business reporting requirements.
- Map business requirements to source data structures and develop data models from data located within multiple data stores.
- Standardize data collection by developing methods for database design and validation reports.
- Provide application analysis and data modeling design to collect data for centralized data warehouse.
- Partner with IT teams to identify and centralize data for all reporting and analysis needs.
- Design, build and maintain dashboard visualizations using BI applications such as Domo to enable marketing decision-making and optimizations.
- Analyze report data for accuracy and report on potential quality errors.
- Provide regular communications on the status of assigned items, both currently being worked and those in the backlog.
- Identify growth opportunities for client/internal teams to advance the agency analytics team and competencies
Knowledge, Skills & Abilities:
- Bachelor’s Degree
- 2 years of experience with a business intelligence and/or data integration platform such as Domo or Tableau a must
- Solid understanding of database architecture
- Ability to use SQL for data extraction as well as data preparation and normalization
- Excellent analytical skills, data-driven thinking, and ability to work in a fast-paced and dynamic environment with competing deadlines and multiple priorities
- Proficient with cross-departmental collaboration and demonstrates excellent leadership capabilities
- Strong presentation skills for leading client/internal meetings discussing organizational data, optimization recommendations and advising on future directions
- Capable of working within a diverse, global workforce while maintaining a consumer-oriented approach
- Excellent written and verbal communication skills
Compensation Package
Your compensation will be a combination of salary and company benefits, including health insurance, 401(K) company match, weekly paid discovery, and volunteer time options, hybrid-of remote and in-office either based in Phoenix, Arizona or Portland, Oregon.
#ZR
Business Analytics/ Business Intelligence Specialist
Family Insurance Solutions -
Vancouver, WA
35N Signals Intelligence Analyst
DC Army National Guard -
Portland, OR
35N Signals Intelligence Analyst
Oregon - Army National Guard -
Portland, OR