Business Analyst - Power BI, Advanced Excel, SQL Queries, Data Model/Analysis

Business Analyst - Power BI, Advanced Excel, SQL Queries, Data Model/Analysis

13 Jan 2024
California, Camarillo, 93010 Camarillo USA

Business Analyst - Power BI, Advanced Excel, SQL Queries, Data Model/Analysis

Vacancy expired!


Job Description:

SMCI is seeking a IT Business Intelligence Analyst to be a key member of the BI and Data Analytics Team, will collaborate with all other GSMS departments (Commercial / Sales, Business Development, Marketing, Operations, Supply Chain, Quality Assurance and IT). This position is responsible for the successful execution and delivery of assigned programs and projects. Additionally, this role will be responsible for ensuring the timeliness of scheduled data loads for the data warehouse, development of new reporting capabilities and quality control of data warehouse curated data sets.

Responsibilities:

  • Develop and manage BI solutions
  • Develop and maintain PowerBI reports and processes through the application life cycle
  • Write SQL queries to analyze and validate data warehouse data
  • Utilize company resources to curate data
  • Analyze data for market trends and patterns
  • Design new data collection models to better collect information
  • Coordinate with IT department to implement new models
  • Perform data profiling to identify anomalies
  • Develop protocol on how to best filter and report variances
  • Collaborate with business users
  • Analyze business processes, requirements and data
  • Create and maintain documentation including requirements, technical design and user manuals
  • Identify opportunities to improve processes and strategies with technology solutions
  • Identify application development needs in order to improve and streamline operations

    Required qualifications:
  • Demonstrates initiative. Is conscientious and provides complete follow-through on areas of responsibility to ensures successful project execution and delivery.
  • Regulatory compliance knowledge of company and IT department policies and procedures including the documentation of audit evidence as part of the System Development Life Cycle (SDLC) procedures, Sarbanes-Oxley (SOX) and other government regulations.
  • Able to work well under pressure with multiple project deadlines.
  • Ability to work effectively on long term, complex projects while juggling detailed day-to-day business demand responsibilities.
  • Comfortable with team-based work structure.
  • Proven customer service skills in supporting the business owners.
  • Familiarity with SDLC methodologies and best practices. Familiarity with MSFT Azure Devops Agile tools a plus.
  • Strong written and verbal communication skills.
  • Excellent organizational skills.

    Preferred qualifications:
  • Microsoft Azure environments
  • Advanced SQL queries, SSRS, SSAS, Data Modeling, Scripting languages (PowerShell and Python), Power BI and Microsoft Dynamics
  • Familiarity with Azure Analysis Services a plus
  • Advanced Excel skills
  • Syspro ERP / VAR environment experience
  • Ability to de-code and migrate legacy reporting applications (i.e. SSRS, SSAS, Crystal reports).
  • Proficient with Microsoft Office applications, Teams and Office 365
  • Operating in a private equity ownership model / experience with supporting IT investments with business cases and results tracking
  • Preference for working in a dynamic and fast-paced environment, flexibility to provide off-hours availability during critical project delivery windows
  • Experience and ability to work with offshore development teams in different time zones.

    Education:
  • Bachelor's degree required, preferably in Computer Science, Management Information Systems, or Information Technology.
  • 4+ years related experience delivering and managing data, developing data warehouse processes and strategies and reporting with Microsoft Power BI
  • Medical Manufacturing and Pharmaceuticals Distribution services industry experience is desired.
    Required Skills: DATA MODEL; DATA ANALYSIS; BUSINESS REQUIREMENTS; SDLC; MS-OFFICE; ADVANCD EXCEL; TEAMS; SQL; POWER BI.

    Don't hesitate! Submit your resume today.

    SMCI is an EEO employer. All qualified applicants will receive consideration without regard to race, color, religion, sex, sexual orientation, national origin, disability, age, genetic information, marital status, military, and veteran status. Members of minority groups, Vietnam Era Veterans and individuals with mental or physical disabilities are encouraged to contact us regarding employment opportunities. In addition, in order to support the provision of business to minority-owned and Women-owned businesses (MWBE), such MWBE are encouraged to contact us regarding subcontracting business opportunities with our firm.

    (No third parties, please)
    (H1 sponsorship currently unavailable)
    (Local candidates only, please)

  • Related jobs

    Job Details

    • ID
      JC8146155
    • State
    • City
    • Job type
      Contract
    • Salary
      Market
    • Hiring Company
      Software Management Consultants, Inc.
    • Date
      2021-01-12
    • Deadline
      2021-03-13
    • Category

    Jocancy Online Job Portal by jobSearchi.