Columbus, OH, US
Text size
aA+ aA-
Click here to print

sr. Business Intelligence Analyst

Country : USA USA

State : Ohio

County : Franklin County

Town : Columbus

Category : Sales

Contract type : Permanent

Availability : Full time

Job description

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.

Reports To: Manager, 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

  • 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

  • Maintains existing and new users' permissions for all reports

  • Work both internally and with the business to ensure quality is met on delivery of reporting.

  • Support of existing and prior developed reports across the various business units

  • Maintain reporting architecture 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 follow effective plans. Anticipates risks, creates contingency plans. Aligns plans with goals. Allocates adequate resources. Accepts and supports change. Willing to take risks and suggests 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 simply and process complex problems. Understands underlying issues and addresses root causes. Meets deadlines, works until finished.



      • 5+ years of BI tool (MicroStrategy) experience

      • 5+ years of report requirements development & estimation

      • 5+ years of Teradata experience

      • Preferred:

        • Experience in 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 supply chain, order management, transactional sources, financial acumen, inventory and merchandising, and ERP a plus

        • Experience in MicroStrategy Workstation a plus

        • Education:

          • Bachelor's degree in Computer Science, MIS, or Business Administration
Click here to print

Similar Offers

Principal Business Intelligence Analyst

| Columbus

Analyst, Business System

| Columbus

Fashion Jobs

oc Support Business Analyst ii

| Permanent | Deerfield township

Chanel Business Manager

| Permanent | New york