Senior Business Intelligence Analyst / Report Builder - MICROSTRATEGY
Company: Affinity Executive Search
Posted on: May 12, 2022
Senior Business Intelligence Analyst / Report Builder --
MICROSTRATEGY Not right for you? We've got others Salary:
Confidential Location: Modesto, CA Posted: October 6th 2021 Minimum
Degree: Bachelor of Science Apply for this position Full Name Email
Address Resume Select a File Upload or Paste , Dropbox , Google
Drive Cover Letter (optional) Select a File Upload or Paste ,
Dropbox , Google Drive Exciting opportunity to work with a
continuously growing company that is well-respected in their
industry! This stable organization in the Logistics / Manufacturing
industry has been on a steady upward trajectory for many years and
they offer a healthy, friendly, professional work environment where
you can enjoy good career growth opportunities while making a
positive impact and participating in the success story.This role
can be a critical step in your career path as you will be working
with an innovative leader in the industry while enjoying a team
environment and company culture that is supportive, and encourages
and rewards your valuable contributions. While making a positive
impact in an environment where your career will thrive and grow,
you will enjoy competitive compensation, generous benefits,
matching 401(k) plan, and a lot of other perks! Come join a great
team and be treated like an important member of the family!Value
Proposition / Outstanding Career Move
- Opportunity for Growth... -While based in the Central Valley of
California, this company works with clients within the United
States and internationally, and has been growing continually
through the years. Through expansion within the industry and
several key acquisitions, the company's growth is quite impressive.
Additionally, this company is closely associated with global
business partners and you have excellent opportunities to grow
professionally and join new teams. This company also likes to
promote from within and your career growth is encouraged.
- Ability to Make an Impact... You will work as part of a small
team where your voice can be heard and you will collaborate
cross-functionally and be a key part of the success story. -
- Outstanding Team Members... -This is a highly collaborative
environment. The company is selective and hires the best talent...
the culture is smart, respectful and inclusive.
- Open Door - Approachable Environment... -The hiring manager is
great to work with and you will have access to being mentored by an
incredible professional who is approachable and eager to help you
- Outstanding Benefits... -This includes world-class health
plans, matching 401(k) plan, Summer hours so you can enjoy more
time with family and friends, vision plan, perks and discounts on
products, life insurance, long term care insurance, service awards,
family benefits such as adoption and autism therapy support,
vitality wellness program, profit sharing plan, dental plan,
flexible spending account, retirement programs, and so much
- Innovative Industry Leader... -You will have the opportunity to
work within an innovative company that is committed to providing
excellence for their clients. Their focus on excellence and
innovation has earned impressive respect within the industry, as
they have leveraged the most cutting-edge technologies to impact
advances and improvements.
- Challenge... -As a member of the team, you will be continually
encouraged to learn, and be challenged so you can thrive
professionally and personally. The company provides a fun and
healthy working environment and there are always opportunities to
be your best self. In this role, as the team's Senior Business
Intelligence Analyst / Report Builder will be the MAIN
MicroStrategy resource in the company, and you must be comfortable
with that.Excellent benefits + eligibility for overtime pay +
strong path for career growth!Great opportunity for an IT
professional with good MicroStrategy experience (cloud version
preferred but not required) + solid ability to read and write SQL
queries! The employer is looking for someone that can help build /
establish a foundation, and make some infrastructure changes, so
good technical back-end skills are critical. The person hired for
this role will be the MAIN MicroStrategy resource within the
organization and must feel comfortable working in this
If you are excited about digging into data and building reports, as
well as having the freedom to learn new ways to get data, this
position is an ideal role for you.
LOCAL candidates preferred (Sacramento region, Central Valley area,
or Bay Area of Northern California) with ability to work remotely
at the onset, and later on to move to a hybrid role (partially
onsite and partially remote) and potentially working onsite
full-time in the near future. Employer is also willing to consider
out-of-area candidates that have strong ties to the area with a
willingness to relocate to the Central Valley of California in the
future.MUST be a US citizen or Green Card holder, or be legally
authorized to work in the United States without sponsorship or visa
transfer. Employer is not able to transfer or sponsor work
visas.SummaryCreates reporting and analytical solutions that enable
translating data into knowledge and maintains MicroStrategy
infrastructure across the organization. Analyzes business
intelligence data to inform business decisions. Partners with other
areas of the business to model the outcome of implementing
potential business strategies.What You Will Be Doing
--- Design and develop data architecture to enable business
decisions and recommend technical solutions to management and
internal customers based on scalability and complexity.
--- Administration duties to include maintaining and auditing user
access, and cloud instance infrastructure.
--- Responsible for setting up new data connections within
MicroStrategy Intelligence Server.
--- Provide guidance and analytical support to include analysis and
research in areas across the corporation.
--- Satisfy ad-hoc requests for information from company teams that
aid in uncovering new understandings that drive decisions which
move the organization forward.
--- Act as technical expert, addressing infrastructure needs,
systems/applications integration, compatibility, and multiple
--- Analyze data to create and maintain reports, dashboards,
visualizations, and other tools (such as cubes and views) in
multiple development and production environments.
--- Responsible for executing the implementation of the BI strategy
related to the company's SAP ERP and OTM systems.
--- Source data from various systems via Enterprise Data Warehouse
(EDW) and external data sources.
--- Design user driven analytics structure using existing data
--- Influence data warehousing teams to recommend data layer
structures and integrate systems.
--- Performance tuning of business intelligence applications.
--- Gather, document, and translate business requirements to
functional and technical design solutions, specifications, and
--- Collaborate with development teams to design business
intelligence solutions to facilitate data gathering, storage, and
--- Consult with users or decision makers to identify data sources,
required data elements, or data validation standards.
--- Develop test plans and facilitate testing prior to
--- Lead promotion processes, to include source and environment
controls, as well as promotion governance.
--- Create and maintain technical documentation.
--- Perform cross-functional analysis and collaborate with
stakeholders across departments. Partner and present findings to
senior leadership.Minimum Qualifications
--- Bachelor's degree in Computer Science, Business Administration,
MIS, Mathematics, Data Analytics, Data Science, or Engineering plus
5 years of experience in business intelligence, technical
architecture, application development, middleware, or database
management; OR High School diploma or State-issued equivalency
certificate plus 9 years of experience in business intelligence,
technical architecture, application development, middleware, or
database management.--- 3 to 5 years of experience with
MicroStrategy is a MUST.--- Ability to build, understand, and
de-bug SQL queries.
--- MicroStrategy Intelligence Server Development experience is a
--- Experience designing and executing Application objects and
Schema objects using MicroStrategy Desktop.
--- Experience analysis, design, development, testing, and
debugging of complex reports, dossiers, and dashboards.
--- Master's degree in Computer Science, Operations Research,
Business Administration, MIS, Mathematics, or Engineering.
--- Experience troubleshooting high level issues to identify and
resolve problems caused by the database, source data, ETL scripts,
or the Business Intelligence software (common examples: nulls in
data causing joins to function incorrectly; ETLs running out of
sequence; MicroStrategy Objects not set up properly).
--- Experience with cloud computing and "big data" processing and
--- Understanding of web servers and applications.
--- Knowledge of components of an enterprise systems
--- Knowledge of business process re-engineering processes
including Lean Six Sigma principles.
--- Lean Six Sigma Green or Black Belt Certified.
--- Working knowledge of Agile software development concepts and
--- Strong understanding of network architecture and application
--- Knowledge of emerging technologies and development
--- Experience applying machine learning or artificial intelligence
to BI applications.
--- Possesses a passion for technology and its impact on the
enterprise, customers and consumers along with a breadth of
experience that can balance business, application and operational
--- Strong understanding of systems and "systems thinking" with the
ability to make trade-off decisions to accomplish system-wide
--- Excellent written and verbal communication skills.
--- Excellent planning and organizational skills.
--- Skilled in balancing long-term and short-term goals and
perspectives of challenging situations.
--- Skilled in applying multiple technical solutions to business
--- Remains unbiased toward any specific technology or vendor
--- Excellent analytical and technical skills.
--- Exceptional interpersonal skills, including teamwork,
facilitation and negotiation.
--- Experience with performance tuning of business intelligence
--- Strong knowledge of SQL queries including writing, reading, and
--- Experience working with Enterprise Data Warehousing,
specifically SAP Data Warehousing (HANA).
Keywords: Affinity Executive Search, Modesto , Senior Business Intelligence Analyst / Report Builder - MICROSTRATEGY, Professions , Modesto, California
Didn't find what you're looking for? Search again!