Business Intelligence (BI) Analyst/Architect – Multiple Locations Direct Hire/ Full Time Employee

ALL DKKD JOBS: https://dkkdstaffing.com/job/dkkd-staffing-top-jobs-consolidated/

Please see the Application and Job-Related questions below.

Background/ Drug/ Vaccine Check Disclaimer: (each company is different)

• If selected, there might be a background check that includes a drug screen (usually 4-panel-excluding marijuana) and sometimes credit checks for financial clients.
• Most companies might also have a vaccine mandate, so once hired, we (or the client) will ask for proof of vaccination if required. If you are not vaccinated, we/they might ask you to work with them on a religious or medical exemption if necessary.

TITLE: Business Intelligence (BI) Analyst/Architect

LOCATION: El Segundo or Thousand Oaks, CA (ability to travel within US as needed)

DURATION: Direct Hire

SUPERVISORY RESPONSIBILITIES:

• This job has no supervisory responsibilities but provides technical leadership to lower-level employees. This includes, but is not limited to training employees, planning, assigning, directing work and resolving technically related work problems. It also includes interaction with other technical teams (e.g., server team, client team, applications team, support team, etc.). Additionally, the position will assist the manager in managing vendor relationships.

SALARY: To be discussed

• NOT open to Corp to Corp.
• Those authorized to work in the US are encouraged to apply.
• DKKD Staffing does not sponsor and cannot support H1, EAD, TN, etc. No outside agencies please.

JOB OVERVIEW

Position Summary and Responsibilities

The Business Intelligence Analyst is responsible for the design and support of business intelligence applications. Works with business and IT senior management to understand and prioritize data and information requirements. Solves complex technical problems.

Essential Duties and Responsibilities may include the following. Other duties may be assigned.

• Design/Architect data warehouse, BI, and analysis services using Microsoft technologies (SQL, SSAS, SSIS, SSRS, Power BI)
• Generates ad hoc reports and regular datasets or report information for end-users using system tools, stored procedures, and database or data warehouse queries and scripts
• Integrates data from multiple sources (ETL-Extract, Transform and Load) to produce requested or required data elements
• Monitors daily ETL routines and troubleshoots / resolves any issues on a timely manner
• Programs and maintains report forms and formats, information dashboards, data generators, canned reports and other end-user information portals or resources
• Optimizes the performance of enterprise business intelligence systems and tools by defining data to filter and index that add value to the user
• Creates testing methodology and criteria
• Creates specifications for reports based on business requests
• Creates process flows, detailed design documents and end user procedures
• Leads training sessions for users in-house and remotely on various tool sets
• Drives strategic business decision making through detailed analytics, insights and real-time reporting on Key Performance Indicators (KPIs) and financial results
• Conducts data audits to verify data accuracy and ensures data quality
• Uses reporting tools such as SQL Server, SSIS, SSAS, Crystal Reports, Excel, etc.
• Develops standards, policies and procedures for the form, structure and attributes of the business intelligence tools and systems
• Develops data/information quality metrics
• Responds to high-priority, critical reporting requests as needed
• Daily availability to include evenings and weekends when necessary to reach goals and deadlines

Qualifications

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Required Education and/or Experience: 

• Bachelor’s degree (B.S.) from four-year college or university in a related field and 10-15 years of information technology experience with a programming or development focus and/or training; or equivalent combination of education and experience
• Full knowledge of professional concepts and the ability to use this knowledge toward development of theories and methods

Other Knowledge, Skills, and Abilities

• Strong interpersonal skills
• Strong oral and written communication abilities with all levels of management, employees, and customers, ability to communicate and explain information efficiently
• Ability to create clear and detailed documentation
• Can organize and write about projects and prepare and present a coherent, confident, concise and articulate briefing, with minimal review needed
• Proactively communicates knowledge to others, enhancing their work
• Answers questions clearly and succinctly
• Develops solutions to complex problems which require the regular use of ingenuity and innovation. Ensures solutions are consistent with organization objectives.

Action: Please complete the Application & Job-related questions below. For fastest response, please answers to Di@DKKDstaffing.com

APPLICATION QUESTIONS (Please answer all questions)

• Name:
• Best Contact Info:
• Your Linked In:
• Where do you live and your desired geographical location:
• Why looking for a new job:
• Availability for interviews and a new job:
• Willing to work 100% on-site or hybrid:
• Are you open to relocation if required:
• Do you have an active passport if needed for the job:
• Are you open to travel if needed:
• Are you authorized to work in the US (Please indicate US, Green Card, or Other):
  • If not US Citizen or GC, do you require sponsorship at any time, or will you in the future?
• Salary Expectations: (We need a range) $
• Sizes of staff overseen and their titles: (include # of direct reports)
• Budgetary Responsibility: $
• Education/Certs/Degrees: (also indicate which certs are active )
• Who Referred You/ How Did You Hear About Job/ DKKD Staffing:

JOB-RELATED SCREENING QUESTIONS/ JOB REQUIREMENTS:

NOTE: Please provide your # of years of experience (per bullet/colon) and last year used. Elaborate if needed. If no experience, please indicate NA or none.

• Experience and/or the title of Business Intelligence (BI) Analyst/Architect:
• Advanced knowledge and thorough understanding of:
  • Information technology reporting tools (SSRS and Power BI):
  • Cube design and MDX (cube query language) and Tabular:
  • Programming languages, such as SQL, TSQL, or PLSQL:
  • Relational Database Design (3rd normal form):
  • Relational Database mechanics (Indexes/Primary Keys/View/Stored Procedures/Functions):
  • Relational vs multidimensional vs in-memory design concepts:
  • A Tier I or II ERP system (Oracle, SAP, IFS, Dynamics AX …):
• Advanced skills using ETL tools (SSIS, Dell Boomi, Informatica …):
• Microsoft Office Suite (i.e., Outlook, Word, Access, Excel, PowerPoint, Project, Visio, etc.):
• IT security concepts:

Connect with us on Linked In: www.LinkedIn.com/in/DianeKrehbiel

ALL DKKD JOBS: www.DKKDstaffing.com

We get 100’s of applicants applying to us. Please see the instructions above on how to apply to help us.

Diane “Di” Krehbiel-Delson

Executive and Technology Recruiting

Westlake Village, Ca 91362

JOBS & Application: www.DKKDstaffing.com

References: www.LinkedIn.com/in/DianeKrehbiel 

Leadership JOB LEADS on LINKED IN GROUP: Diane Krehbiel Executive & Technology Recruiting

IND123