Business Intelligence Engineer

LHH Recruitment solutions is seeking a highly motivated Business Intelligence Engineer for a contract role with a manufacturing client of ours in Rancho Cucamonga. 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 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 Engineer combines business knowledge, technical expertise, and data analysis skills to help companies make informed decisions. The role involves collecting analyzing, and 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.

**This is an on-site position, working 5 days per week in their Rancho Cucamonga location.**

Key Responsibilities:

Data Collection, Design and Development:

• 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.

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.

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

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 regulate compliance when required.

Qualifications:

• A Bachelor’s Degree in Information Technology or similar field
• Three (3) plus years of experience in SQL development, Python, R, and other programming languages used for data analysis.
• Experience with data extraction, transformation, and loading (ETL) processes.
• Must be proficient in Cloud platform architecture, Cloud based storage solutions, Cloud data warehousing solutions, Cloud based data processing, Cloud Security and Cloud Analytics
• Develop business intelligence solutions using SSMS.
• Knowledge of statistical analysis techniques. Experience working with large datasets and data warehousing solutions.
• Experience in PL/SQL, T-SQL, and Advance Microsoft Excel/modeling skills is required.
• Results-driven with strong attention to the details; outstanding problem-solving skills.
• Excellent communication and interpersonal skills.
• Experience in driving customer discussions independently and acting as trusted advisor.

Pay: $50-65/hr

Benefit Offerings:

Benefit offerings include medical, dental, vision, life insurance, short-term disability, additional voluntary benefits, EAP program, commuter benefits and 401K plan. Our program provides employees the flexibility to choose the type of coverage that meets their individual needs. Available paid leave may include Paid Sick Leave, where required by law; any other paid leave required by Federal, State, or local law; and Holiday pay upon meeting eligibility criteria.

Applicants must be authorized to work for any employer in the U.S. and Visa sponsorship unavailable.

**Please no C2C applicants**