Senior Business Intelligence Engineer

Company: OEConnection
Location: Richfield
Posted on: March 28, 2020

Job Description:

In just 18 years, OEC has grown globally to more than 1,000 employees with a double-digit revenue increase nearly every year. We provide a lively culture, employee rewards and recognition, and the opportunity to develop and implement innovative technology solutions.




Position Summary:



Develops effective business intelligence solutions for OEC by designing, developing, and deploying systems to support business intelligence, reporting, data warehousing, and integration with enterprise applications. Owns and architects business intelligence solutions. Designs, develops and maintains Enterprise Data Warehouse. Evaluates business needs in support of delivering effective business intelligence and reporting solutions. Maintains documentation of processes, reports, applications, and procedures.

Job Duties:

• 
  
  
• 
  Manages small projects as assigned by Associate Manager or Manager; provides training and leads others as a recognized business intelligence expert.
  
  
  
  
  • 
    
    
  • 
    Guides and coaches developers, shares best practices and performs code reviews.
    
    
    
    
    • 
      
      
    • 
      Designs Business Intelligence solutions in the areas of enterprise reporting, query and analysis, and analytical services.
      
      
      
      
      • 
        
        
      • 
        Facilitates KPI definition and implements strong BI processes throughout the organization; evaluates and makes recommendations on BI and analytics tools.
        
        
        
        
        • 
          
          
        • 
          Designs logical Data Warehouse architecture and data models. Implements physical data warehouse design and data cubes.
          
          
          
          
          • 
            
            
          • 
            Designs ETL (Extract, Transform, Load) architecture including mappings, data flows, procedures, schedules, etc.
            
            
            
            
            • 
              
              
            • 
              Implements user access controls and data security measures, as appropriate.
              
              
              
              
              • 
                
                
              • 
                Anticipates opportunities for improvement; outlines and identifies alternate solutions and presents to management for final approval and implementation.
                
                
                
                
                • 
                  
                  
                • 
                  Designs and develops interactive dashboards and reports. Creates and maintains documentation of processes, reports, applications, and procedures in accordance with department policy.
                  
                  
                  
                  
                  • 
                    
                    
                  • 
                    Develops and tests database scripts, stored procedures, triggers, functions, SSIS packages, and other back-end processes to support system integration and ETL to facilitate the creation and population of the Enterprise Data Warehouse.
                    
                    
                    
                    
                    • 
                      
                      
                    • 
                      Develops and performs system testing and fixes defects identified during testing and re-executes unit tests to validate results.
                      
                      
                      
                      Education:
                      
                      
                      
                      An undergraduate degree from an accredited college or university with a focus in Information Technology, Computer Science or related discipline; or in the absence of a degree, directly-related job experience in business Intelligence, data analytics and data warehouse reporting, where a number of years and proven knowledge may offset the degree requirement.
                      
                      
                      
                      
                      Experience & Skills:
                      
                      
                      
                      In addition to the education outlined above, a minimum of 5 years of experience in business intelligence, data analytics and data warehouse reporting required. Strong knowledge of data modeling, data quality, and ETL/SQL server needed along with Strong SQL skills and business intelligence tool expertise are required. This includes developing and testing database scripts, stored procedures, triggers, functions, SSIS packages, SQL agent jobs and other back-end processes to support system integration and ETL to facilitate the creation and population of the Enterprise Data Warehouse. Experience in formulating DAX calculations, data storytelling, and dashboard design. Understanding of Tabular models, Power BI and its components (Desktop, Service, Gateways, etc.). Writing relational and multi-dimensional database queries; configuring, deploying, and maintaining database servers. Strong written and oral communication skills with the ability to work in a cross functional team environment are a must. Refined analytical thinking and problem solving skills are needed. Strong desire to keep abreast of trends in the Business Intelligence technical landscape and shape the vision for future capabilities. General knowledge of Cloud Solutions such as Azure, AWS, and leveraging PaaS. Working knowledge of .Net along with general knowledge of NoSQL platforms such as MongoDB.
                      
                      Travel:
                      
                      
                      
                      
                      Travel for this position is rare.
                      
                      
                      
                      OEConnection is subject to certain governmental recordkeeping and reporting requirements for the administration of civil rights laws and regulations. In order to comply with these laws, we invite applicants and employees to voluntarily self-identify their gender, race and ethnicity. Submission of this information is strictly voluntary and refusal to provide it will not subject you to any adverse treatment. The information obtained will be kept confidential and may only be used in accordance with the provision of applicable laws, executive orders, and regulations, including those that require the information to be summarized and reported to the federal government for civil rights enforcement. When reported, data will not identify any specific individual. This information will be maintained separately from your application for employment. If you do not wish to self-identify at this time, you may do so in the future by submitting this form. Failure to provide the following information will not subject you to any adverse action or treatment. OEConnection is an Equal Opportunity/ Affirmative Action employer. We provide equal employment opportunities to all qualified employees and applicants for employment without regard to race, religion, sex, age, marital status, national origin, sexual orientation, citizenship status, veteran status, disability or any other legally protected status. We prohibit discrimination in decisions concerning recruitment, hiring, compensation, benefits, training, termination, promotions, or any other condition of employment or career development.
                      
                      

Keywords: OEConnection, Cleveland , Senior Business Intelligence Engineer, Engineering , Richfield, Ohio