Senior Business Intelligence Developer at MartinMariettaMaterials in Raleigh, North Carolina

Posted in Other 24 days ago.

Job Description:


The Senior Business Intelligence (BI) Developer will work under the direction of the Business Intelligence Architect Team Lead and be part of the Analytics and Business Intelligence (BI) team. This individual will function as the resident BI technical and functional development expert. The primary focus of this role will be to work with the business users and end-users, to help conceive the BI solution, do the detailed technical and functional design, develop a robust solution and deliver business solutions through understanding the current and future needs of the business partners. Work with other team members and Analysts in other areas within IS applications, such as infrastructure, DBAs, CNC, PMs to support the successful deployment of the solution.

The Senior BI Developer will be required to assist and provide quality and solid system designs and solutions to solve various business requirements. To be successful, you must have proven experience managing technical solution within the projects through the entire project lifecycle. The role requires an individual who is resourceful, confident under pressure and has demonstrated skill in both crisis management and expectation management. You should be able to deliver effective presentations, solution walk-through to audiences of all sizes, and possess excellent communication skills.

The role requires both broad and deep technical knowledge of the Business Intelligence Application and the ability to architect solutions by mapping the functional design and the business problems to reusable, configurable and upgradable end-to-end business application solutions. You should have a passion for business and technology, which is demonstrated through professionalism and striving for excellence in all aspects of the business experience.

The successful candidate must have a Bachelor's Degree in Computer Science or Engineering (foreign equivalent acceptable) with a deep understanding of Data Warehousing techniques,

Data Modeling using tools such as
  • IBM Cognos Framework Manager
  • IBM Cognos Powerplay Transformer
  • IBM Cognos Dynamic Cube Designer
  • IBM Cognos Analytics Data module
  • Tableau Desktop
  • Planning Analytics' TM1 Architect
Reporting using tools such as
  • IBM Cognos 10x Report Studio
  • IBM Cognos 10x Analysis Studio
  • IBM Cognos 10x Powerplay Studio
  • IBM Cognos 10x Metric Studio
  • IBM Cognos 10x Workspace
  • IBM Cognos 10x Workspace Advanced
  • IBM Cognos 10x Event Studio
  • IBM Cognos Analytics Authoring
  • IBM Cognos Analytics Story
  • IBM Cognos Insight
  • Tableau Online
  • TM1 Perspectives
  • IBM Cognos CAFÉ'
  • Planning Analytics Workspace
  • Planning Analytics for Excel
Visualization and Dashboarding using tools such as
  • IBM Cognos Analytics Dashboard
  • IBM Cognos Analytics Story
  • Tableau Desktop and Web Authoring
Administer BI environments using tools such as
  • IBM Cognos Administration
  • Tableau Server
Proven ability in scripting via HTML, JavaScript, and/or Jquery to Cognos capabilities.
Proven ability in Cognos MDX for working with Multidimensional Concepts.
Proven ability in Structured Query Language (SQL).

Position requires extensive relevant working experience.

  • Collaborate with cross-functional teams to gather and document BI requirements.
  • Analyze BI requirements and design/develop Reporting solutions using IBM Cognos, IBM Planning Analytics, and Tableau product suite to support standard reporting, Dashboards, Storyboards, and self-service environment.
  • Experience in upgrading content between recent Cognos versions.
  • Analyze end-user requirements and develop Tableau visualizations.
  • Support and maintain existing reports and visualizations.
  • Performance tuning to ensure reports function within acceptable service levels.
  • Collaborate with stakeholders to define the business layer and presentation layer of the BI model that is business-friendly and supports a self-service environment.
  • Analyze requirements and architect appropriate solutions providing and maintaining detailed design documentation.
  • Review the current architecture and recommend changes as appropriate.
  • Performs all activities per the Company's Mission, Vision, and Values, and in compliance with the Company's policies, procedures, and Code of Ethical Business Conduct.
  • Enable/train users on using Cognos, Planning Analytics, and Tableau portals.
  • Installation, configuration, and maintenance of IBM Cognos suite of products.
  • Installation, configuration, and maintenance of IBM Planning Analytics suite of products
  • Report and dashboard development using advanced features for interactivity and data analysis
  • Integration Planning Analytics with Cognos Analytics.
  • Enable/train users on using Cognos, Tableau, and Planning Analytics portals.
  • Expertise with relational and dimensional modeling, expertise in creating reports using a dimensional model using Cognos MDX.
  • Report and Dashboard development using advanced features for interactivity and data analysis
  • Bachelor's degree in CS or Engineering (foreign equivalent acceptable).
  • At least 8 years of Information Technology experience required.
  • Most recent experience must be Business Intelligence focused with at least 5 years of hands-on experience in dashboard and report development.
  • At least 8 years of hands-on experience with IBM Cognos BI (10.2.2) Product Suite (Report Studio, Analytics Studio, Metric Studio, Event Studio, Powerplay Studio, Workspace Advanced, Framework Manager, Powerplay Transformer, Administration) and IBM Cognos Analytics 11.X Product Suite (Authoring, Dashboarding, Story, Data Module)
  • At least 8 years of hands-on experience with SQL to query Oracle and SQLserver Databases.
  • At least 6 years of hands-on experience in creating reports out of Dimensionally modeled datasources( Cognos DMR, Cognos Powerplay cubes, TM1 cubes) using Cognos MDX.
  • At least 1 years of hands-on experience with with Tableau Desktop, Web authoring, and Tableau Server and Online.
  • At least 1 year of hands-on experience IBM TM1 Perspectives, IBM Cognos CAFÉ', IBM TM1 Architect, IBM Planning Analytics Workspace, and IBM Planning Analytics for Excel.
  • At least 5 years of hands-on experience in Framework Manager Dimensional Modeling, Transformer cube design, and development
  • At least 4 years of hands-on experience in scripting (HTML, Java Scripting and/or jQuery) to extend Cognos capabilities
  • At least 4 years of hands-on experience performing Adminstration activities such as content migration between environmnents, performance tuning and troubleshooting skills
  • At least 4 years of hands-on experience working with Key Performance Indicators, Office of Finance, Sales, Inventory, and other subject areas.
  • At least 5 years of exposure to end-to-end business processes.
  • Advanced query writing skills using SQL code
    • Prior experience in designing and developing dashboards and storyboards using Cognos Analytics and Tableau
    • Prior experience in upgrading content to Cognos Analytics
    • Prior experience working with data sourced from JD Edwards
    • Understanding of SOX and project management principles and concepts
    • Rapid prototyping and agile methodology - experience in DevOps environment
    • Cognos Administration experience

Raleigh, NC with occasional travel on an as-needed basis to locations TBD