Facebook LinkedIn Twitter Email
Back to Jobs

Data/BI Analyst

Advantage Tech is searching for a solid Data/BI Analyst, to join their client’s team in De Soto, KS.
 

Job Summary: 

As a Technical Data Analyst, this position is responsible for expanding the use of data as a strategic enabler of corporate goals and objectives in Business Intelligence. The analyst acts as the primary advocate of data governance and data management best practices to ensure all data is defined and used consistently across all systems. This individual also acts as the primary advocate of data modeling methodologies best practices, by strategically reviewing and creating data models for enterprise-level applications and systems. This position implements methods to improve data reliability and quality, combines raw information from different sources to create consistent and machine-readable formats and develops and tests architectures that enable data extraction and transformation.? 

 

Essential Functions? 

  • Provides technical and data leadership to the data and business intelligence teams

  • Participates in the development of data centric strategies, solutions, and systems design

  • Identifies, researches, and resolves complex technical problems to enable business capabilities in the areas of development of a data warehouse, creating of data marts, implementation of BI tools and propagation of a data culture

  • Expertise in relational and multidimensional database schemas is a must. 

  • Defines standards for naming, describing, governing, managing, modeling, cleansing, enriching, transforming, moving, storing, searching, and delivering all data within the enterprise

  • Facilitate and maintain any data warehouse / data mart platforms that expose disparate data repositories to the BI platform 

  • Serves as a liaison between data consumer representatives and data solution development, integration and governance teams

  • Determine the feasibility of data-related solutions, make recommendations, perform analysis, program and test activities as required

  • Provide advanced technical support to the research, experimentation, business analysis and use of systems technology including architecture, integration capabilities, data visualization and database management.

  • Ensure development team is conforming to data access/manipulation/propagation documented standards and add to these standards as the need arises

  • Authors technical and functional specifications associated with data architecture and associated data platform solutions

  • Works with the Database Administration team to design tables, queries, and packages to obtain information from and send information to remote databases 

  • Ensures timely creation and generation of managerial reports/data extracts, in collaboration with IT and business departments

  • Responsible for leading the strategic design and tactical maintenance of business intelligence applications.

  • Participate in the development and support of BI reporting objects (via high quality dashboards and data visualizations) utilizing various tools. 

  • Works closely with other IT groups to coordinate current and future plans, including coordination and technical assistance to facilitate specific data platform projects that involve the computing environment, the coordination of software upgrades and the installation of new products

  • Recognizes and identifies potential areas where existing policies and procedures require change, or where new ones need to be developed, especially regarding future business expansion

 

Job Qualifications

Required

  • Bachelor’s degree in information technology, data analytics, business, or a related field required

  • Minimum 7 years IT experience required 

Preferred

• Seven years experience as a data/BI architect and engineer including BI/DW technologies

  • Experience with Oracle Fusion Cloud BI tools including OTBI, FRS, BI Publisher, SmartView

• One or more of the following certifications or similar:

  • Certified Business Intelligence Professional

  • Microsoft Certified Solutions Associate in BI Development 

  • Microsoft Certified Solutions Associate Bi Reporting

  • Microsoft Certified Solutions Expert in Data Management and Analytics

  • Experience in complete life cycle of design, development, and implementation of data warehousing?projects including specifically designing an enterprise data model; developing extract, transform & load

(ETL) solutions; creating data marts (cubes), star schemas and data architectures; designing logical and?physical databases; and business intelligence reporting

  • Hands-on knowledge of enterprise repository tools, data modeling tools, data mapping tools, and data profiling tools

  • Strong familiarity with metadata management and associated processes

  • Strong understanding of relational database concepts including SQL

  • Strong troubleshooting and problem-solving skills

  • Experience delivering formal designs to teams of developers 

  • Experience reviewing requirements with the business users and business analysts

  • Experience in presenting and demonstrating solutions to clients 

  • Ability to communicate ideas in both technical and user-friendly language

  • Ability to work in a fast-paced, dynamic, team–oriented environment

  • Highly self-motivated and directed, with strong attention to detail

  • Proven track record of successful BI solution design and implementation.

  • Proven track record of successful data architecture solution delivery and involvement

Submit Resume