iLocatum

Pittsburgh, PA

Senior Business Intelligence Analyst

Senior Business Intelligence Analyst

Salary: $90,000.00 - $120,000.00 + Quarterly Bonus + 12% 401K

POSITION DESCRIPTION:

In this role, you will utilize tools such as IBM Cognos and Power BI Reports to deliver and administer data. You will also have expertise in data warehousing using relational databases such as Oracle and MS SQL Server BI Studio, as well as ETL Technologies like WhereScape and TimeXtender. You will stay informed about the latest market capabilities and continuously find ways to apply technology to improve processes, communications, and information.

EDUCATION/EXPERIENCE:

  • BS in Business Information Systems, Information Technology, Computer Science, or related field OR a combination of 5-7 years of experience in data warehouse/business intelligence
  • Experience with WhereScape RED and/or TimeXtender Data warehousing tools is a major plus
  • Experience with Cognos and Power BI is positive, but not required
  • Experience with Azure SQL, Synapse Serverless, D365 Dynamics F&O is a plus

QUALIFICATIONS:

  • Understanding of data modeling concepts, OLAP Cubes, Star Schemas, Relational DBs, etc.
  • High proficiency in SQL and SQL Server Databases
  • Proficiency in Oracle DBs is a plus
  • Experience with Financial Reporting packages
  • Experience in the manufacturing industry
  • High personal and professional integrity
  • Ability to collaborate with a small team
  • Able to perform job functions with minimal oversight
  • Ability to identify and understand the existing organizational culture
  • Ability to articulate a vision of transformation efforts
  • Highly developed skills in priority setting and aligning to a Departmental strategy
  • Ability to break down complex problems into manageable goals
  • Ability to use critical thinking to solve complex problems related to entity linking
  • Capability to analyze and troubleshoot complicated data sets
  • Possess demonstrated experience in systems project management and implementation in a manufacturing environment
  • Excellent English for in-office working environment

RESPONSIBILITIES:

  • Lead and assist in the development, implementation, and support of business applications and business intelligence solutions throughout all life-cycle phases
  • Develop a thorough knowledge of manufacturing systems, business processes, data structures, and information delivery/analysis tools and techniques
  • Develop knowledge of application solutions and business processes
  • Participate in the design and implementation of business process changes
  • Develop and manage projects, ensuring resources are allocated appropriately and deliverables are completed on time
  • Develop and document procedural and system documentation, and provide training to key users
  • Participate in the evaluation and selection of alternatives, solutions, and partners
  • Communicate plans, activities, progress, issues, and status to management and key stakeholders

*Excellent benefits include medical with a standard PPO plan with deductibles as low as $1,500 and wellness credit up to $750; free concierge primary care; voluntary 401k plan currently matching up to 12%; voluntary dental and vision plans; free telemedicine services; basic life, long and short-term disability coverage.

Back to Jobs

  • Max. file size: 300 MB.

Ready to take
the next step?

Submit your resume and join a realm of unparalleled opportunities at iLocatum. We’re dedicated to connecting exceptional talent with impactful roles. Start your journey towards success by sharing your expertise with us.