BI Analyst II

Location: Charlotte, North Carolina

Type: Direct Hire

Optomi, in partnership with an industry-leading technology company, is seeking a BI Analyst II for their Charlotte, NC location.

Apply today if your background includes:

  • 5-7 years of development experience with Oracle ERP BI tools or closely related financial reporting packages
  • Some background education in computer science or engineering
  • Experience in SQL Server performance tuning and query monitoring
  • Understanding of relational data modeling
  • Experience in T-SQL
  • Experience with SSIS
  • Ability to perform well under pressure in a fast paced environment with a high sense of urgency
  • Highly motivated self-starter with the ability to prioritize
  • Mentor team members

What the right professional will enjoy!!!!

  • Fun and collaborative environment
  • Opportunity for remote work
  • Full benefits
  • Opportunity for advancement


Key Responsibilities:

  • Recommends business intelligence solutions and reporting tools, by studying information needs, conferring with users, studying system flows, data usage, work processes, investigating problem areas, and following the development lifecycle
  • Reviews operational feasibility of BI and reporting tools by evaluating analysis, requirements, system constraints, solution development, and proposed solutions.
  • Provides insight to architects and developers to ensure user requirements are captured, sustained and scalable
  • Contributor to user interface and system communication, design and implementation
  • Utilizes scalable approaches such as unit testing, integration testing, and system level testing in support of QA team
  • Responsible to comply with design and development SOP’s in compliance with relevant standards and validation
  • Participates in development optimization for reporting tools thru modeling, simulation and analysis
  • Implement ETL processes
  • Monitor ETL processes to ensure Production processes are always up and running
  • Build reporting and BI tools for financial data
  • Design and implement data models
  • Be passionate about new technologies and products with the willingness to keep on learning

Bonus Points:

Reporting Package experience;  OBIEE experience; Hyperion Consolidation experience; SQL Server administration experience in a clustered environment; BE or MS in computer science or electrical engineering; SQL administration experience including clustering and replication