Returning Candidate?

Business Intelligence Developer

Business Intelligence Developer

Position Type 
Full Time
Requisition ID 
# of Openings 
Job Locations 
US-TX-Fort Worth
Posted Date 

More information about this job


Pier 1 imports is now looking for a Business Intelligence Developer to join our team!  The ideal candidate will be a collaborative team player and work in a quick paced agile environment responsible for architecting, analyzing, designing and developing custom tools, dashboards, reports, and processes by engineering technical packages to offer solutions and implement systems that drive business objectives.  The position will design and develop enterprise and departmental business intelligence and reporting solutions while collaborating with end users.  The role will seek out new tools and techniques as well as provide input into new technology offerings that will support the challenges and changing needs of the business.  The position will be instrumental in all phases of the SDLC including facilitating business discussions, planning, design, data modeling, development, testing, and implementation.

Duties & Responsibilities

  • Take an innovative approach to architecting, designing, developing, and managing Business Intelligence (BI) Solutions while driving new data metrics where unavailable.
  • Responsible for discovering, mapping, and synthesizing data from multiple sources through crafting relational and multidimensional models and database queries to design enterprise reporting, tools, systems, and solutions.
  • Will design and develop effective products for the end user through a rapidly changing agile development process that are efficient and provide high business value.
  • Contribute to data warehouse strategy and initiatives by creating new metrics, measures, and standards and ensuring adoption.
  • Partner with customers to plan and analyze system and reporting needs by gathering with application users to create an effective solution.
  • Interface with the customer to discuss business goals and trends requiring modifications to existing developed processes, tools, and reports.
  • Engage in gap analysis and collaborate with customers on relevant reporting and system solutions while providing ad hoc tools to address immediate business needs.
  • Critically evaluate information gathered from multiple sources, reconcile conflicts, decompose high-level information into details, provide root-cause analysis, and distinguish user requests from the underlying true needs.
  • Responsible for the evaluation and fit of new technology while proposing changes to existing to maintain the most efficient tools possible and provide seamless support to the business.
  • Participate in Analytic Center of Excellence with key business partners and define best practices, business definitions, measures, and standards.
  • Develop routines and protocols for end-users to facilitate best in class practices of reporting tools and applications.
  • Monitor, review, and analyze the effectiveness and efficiency of existing reporting and system procedures and develop strategy for enhancing or further leveraging the findings.
  • Generate documentation artifacts pertaining to development (Technical Design Documents, ER diagrams, Data Definition Documents, Data Dictionary/Glossary, process flow, etc.)
  • Provide front-line support to the business and troubleshoot issues across all systems, processes, and reports.
  • Perform unit and integration testing as necessary when involved in larger projects in lower environments and validate once in production.

Education & Experience

  • 4 – year college degree required
  • 3 – 5 years experience
  • Proficient in SQL Server, SSRS, SSIS, SSAS, VBA, Advanced Microsoft Excel, Oracle SQL, Visual Studio, Microsoft Query, and DAX
  • Must demonstrate mastery of cubes, principles of organizational data warehouse structures and marts, MS data models, data design, modeling, and mining techniques
  • Will have significant experience with concepts and tools in a BI stack such as MicroStrategy, Tableau, QlikView, SAS or other BI front end tool while working with large data sets ("big data") and be proficient in developing and implementing interactive analytic reports and dashboards
  • Experience with R, Python, and Alteryx is preferred.
  • 24 hour availability for on-call production support, phone or pager capable of accepting text message pages, internet access from personal residence required.