Business Intelligence Engineer
POSITION SUMMARY
The Business Intelligence Engineer will be responsible for implementing database driven solutions using SQL, create complex queries, and develop business solutions.
The successful candidate will ensure the performance, security, and availability of databases, create program views, functions, and stored procedures as well as develop SQL queries, custom reports, and modify existing objects.
The Business Intelligence Data Analyst Engineer combines business knowledge, technical expertise, and data analysis skills to help companies make informed decisions. The role involves collecting analyzing, and interpreting structuring large amounts of data from various sources to identify trends, patterns, and insights that can conform business strategies.
This role is a key player in helping businesses make data-driven decisions.
The role requires a strong combination of technical, analytical, and business skills, along with excellent communication and problem-solving skills.
ESSENTIAL JOB FUNCTIONS
* SQL Development
* Reporting & Analytics
* Project Management
* Data Governance
* Documentation
* Business Intelligence
* Design
* Process Development
* Production Support
PRINCIPAL TASKS
1.
Data Collection: Actively participate in the Data Warehouse development lifecycle; including but not limited to gathering and understanding of requirements, data and ETL design/mapping from various sources using ETL tools like Informatica/Azure Data Factory pipeline, and SQL Server database development.
Responsible for debugging, monitoring, and troubleshooting BI solutions during work hours and production failures at night.
Document designs, specifications, and flow diagrams to assist in development, support, and problem analysis.
Drive data model design, and ETL processes for the enterprise Data Warehouse. Build semantic layer using MicroStrategy/Power BI developer/architect tool and define entity relationship model for data modeling.
2.
Reporting: Creates reports and visualizations that communicate data insights in a clear and actionable way.
Develops and documents processes, methodologies, and best practices for data analysis and reporting
3.
Business Analysis: Collaborates with business stakeholders to identify business needs and requirements.
Ability to translate business needs into data analysis projects.
Designs, develops dashboards, scorecards, and reports to support business decision-making.
Responsible for BI tools and user set up for BI tools such as MicroStrategy, Power BI, Tableau
4.
Data Modeling: Designs and implements data models that organize and structure data for efficient analysis.
Understand the existing datasets, collect and connect the data while maintaining data accuracy and consistency.
Support data security, govern and regul...
- Rate: 109500
- Location: Rancho Cucamonga, US-CA
- Type: Permanent
- Industry: IT
- Recruiter: SUMITOMO RUBBER NORTH AMERICA INC
- Contact: Not Specified
- Email: to view click here
- Reference: 0C03342515
- Posted: 2024-04-27 08:54:10 -
- View all Jobs from SUMITOMO RUBBER NORTH AMERICA INC
More Jobs from SUMITOMO RUBBER NORTH AMERICA INC
- Field Tech I
- Pharma Rebate Analytics Lead Analyst- Express Scripts (Hybrid)
- Medical Director - Clinical Biochemical Genetics or Clinical Molecular Genetics and Genomics - EviCo
- Consult Staff Pharmacist - Accredo - Remote (AZ, FL, OH, TN)
- Medical Director Anatomic Pathology/Clinical Pathology (AP/CP) - eviCore
- Sales Operations Associate Analyst (Retention)-Work from Home-3
- Medical Director - Pediatric Urology - eviCore
- Sales Operations Associate Analyst (Retention)-Work from Home-1
- Business Analytics Senior Advisor (Value Based Care) - Hybrid
- Financial Operations Analyst - HYBRID
- Medicare Affordability Value Program Management Advisor - Cigna Healthcare - Hybrid
- Bilingual Health Educator- Evernorth- El Paso, TX
- Home Infusion Nurse, 32 hours - Fort Wayne, IN - Accredo
- Coding Education Specialist -Careallies - Nashville, TN - Hybrid
- Medical Director - Plastic Surgery - EviCore
- Medical Director - Pediatric Infectious Disease - EviCore
- Financial Analysis Senior Advisor, Network Underwriting & Analysis - Express Scripts (Hybrid)
- Pick Packer- Curascript
- Care Coordinator - EviCore - Full Time Remote
- Enrollment & Billing Representative - HYBRID