The Sr. Business Intelligence Analyst position requires a senior level individual with proven capacity to lead the design and development of enterprise data warehouse business intelligence applications. Individual will mentor and provide direction to other development team members where appropriate.
The candidate must be a detail-oriented individual, with strong organizational skills, who has the flexibility to succeed in a fast-paced, remote, and dynamic atmosphere. Candidate must possess extensive experience with design and development in the areas of Business and have a proven track record with Enterprise Data Warehousing concepts, including schema designs and self-service analytics & reporting.
This is a hands-on role, responsible for the development to deployment of solutions using our enterprise analytic tool(s). The candidate should have a strong customer focus and be able to communicate and navigate many different personalities and opinions. Basic domain knowledge of the retail industry is a must for this role. We are open to remote candidates based in the continental United States for this opportunity.
Reports To: Sr. Manager, Business Intelligence (Solutions Delivery & Design)
Essential Duties and Responsibilities:
- Creates a robust, sustainable business intelligence solutions that supports requirements and provides expansion capabilities
- Work with the business on requirements investigation and development of functional and technical reporting requirements documentation
- Must be able to build schema, cubes, metrics, prompts, filters, subscriptions, custom groupings, consolidations, advanced reporting, and documents, including visualizations with dashboards and dossiers in MicroStrategy, or has other BI tool experience
- Participate in the on-call support rotation
- Estimate phases of the Software Development Lifecycle as they relate to reporting and analytics
- Ensures that all reports are developed and delivered timely and accurately with focus on Quality.
- Support of existing and prior developed reports across the various business units
- Maintain or create schema designs and knowledge documentation
- Provide training to other DSW associates to foster stronger cross-departmental relations
- Create Platform Analytics reporting to show opportunities for environment enhancements
- Mentor or support team members with technical expertise and knowledge
Required Skills:
- Proven extensive hands-on experience with at least one of major BI platforms (MicroStrategy)
- Excellent written and verbal communication skills
- Extensive SQL knowledge and ability to perform SQL tuning a must
- Prior experience or working knowledge of an RDBMS
- Knowledge of all phases of project life cycle from inception to production deployment.
- High level knowledge in relational and dimensional modeling (conceptual, logical, and physical data models)
- Multi-task, manage time and priorities and be self-directed while maintaining high degree of organization
Competencies:
SETTING GOALS – Creates and follows effective plans. Anticipates risks, creates contingency plans. Aligns plans with goals. Allocates adequate resources. Accepts and supports change. Willing to take risks and suggest new ideas, approaches. Takes initiative. Seeks out learning activities.
WORKING WITH OTHERS – Clearly articulates own, other’s goals. Promotes a team atmosphere by demonstrating humility and respect. Builds effective relationships, relates well to others. Delivers and responds to feedback in a constructive manner. Considers multiple perspectives. Handles conflict, pressure, uncertainty and adapts independently. Meets commitments. Dedicated to working with business partners on their expectations.
GETTING RESULTS – Personally accountable for work performance targets and achieving results. Prioritizes well. Anticipates and handles obstacles effectively. Makes good, timely decisions. Can simplify and process complex problems. Understands underlying issues and addresses root causes. Meets deadlines, works until finished.
Qualifications:
Experience:
- 5+ years of BI tool (MicroStrategy) experience
- 5+ years of report requirements development & estimation
Preferred Qualifications:
- Experience in Looker, Power BI, or Tableau a plus
- Data governance, quality, mapping, profiling, cleansing and/or standardization
- Experience with a batch monitor scheduling tool such as CA Workload Automation dSeries or Control M a plus
- High level knowledge of retail with financial acumen a plus
Education:
- Bachelor’s degree in Computer Science, MIS, or Business Administration
#LI-Remote
