Business Intelligence Analyst

2 weeks ago

West Jordan, United States Smith Johnson Tech Full time

**This role is not open to C2C candidates or sub vendor candidates.**

**This role is not open to candidates not currently living in Utah.**

**DO NOT apply if you are looking for C2C work or living outside of Utah; I do not have other roles for you.**


This is a contract with a great organization. As a contractor for Smith Johnson, you are eligible for medical, dental, life, disability. Smith Johnson pays for 70% of your medical and dental and 100% of life and disability. The contract is also eligible for PTO/holiday accrued monthly. You are also eligible for a 3% retirement matching plan. Smith Johnson believes in taking care of our contractors.


Job Summary


Our client is looking for an experienced Business Intelligence Analyst/Consultant to support them in collecting, integrating, coding, querying, and reporting data. The selected Contractor will:


  • Develop and maintain systems for collecting, storing, and analyzing data from various sources within the corrections system
  • Create dashboards and reports that provide insights into Key Performance Indicators (KPIs) such as recidivism rates, program participation and effectiveness, staff turnover, and operational costs
  • Use predictive analytics to identify trends and forecast future challenges within the correctional system
  • Analyze data to recommend optimal resource allocation
  • Collaborate with client staff to implement and design the O-Track system, ensuring smooth integration of complex datasets
  • Provide regular oral and written reports and project updates to client


Primary Duties & Responsibilities


The BI Consultant will perform the following tasks:


  • Learn and research current client systems and the O-Track program
  • Create data models in BI dashboards, focusing on Releases and Length of Stay (LOS) Admissions
  • Develop and maintain a standard Date table with release and LOS data from the client system
  • Provide updates to the Executive Team on Power BI work and progress
  • Conduct KPI research, data gathering, and review scripts
  • Refine the data gathering process for KPIs
  • Update grievance metrics with information provided by Subject Matter Experts
  • Create popups for KPI cards
  • Work on data and Power BI development, planning detailed reports
  • Test the security of Power BI
  • Work with client staff and continue coordination on Cognos
  • Collaborate with client on server permissions, BI appearances and features, and implementing suggestions
  • Conduct KPI-HR research, troubleshooting, and implement solutions
  • Create a data dictionary, scripting and import scripts
  • Create table scripts and stored procedures
  • Gather data for Human Resources and Board of Pardons and Parole changes
  • Learn procedures in Informix
  • Code logic into tables
  • Develop reports on inmate populations, grievances, available beds, etc.
  • Discuss project requirements with key stakeholders to determine objectives, timeframe, and deliverables
  • Collaborate with the data warehouse administration on design and performance needs
  • Collaborate with the data warehouse administration on data pipelines to ingest, transform, and load data from various sources such as on-premise Informix databases and eventually PostgreSQL from AWS into BigQuery in GCP
  • Implement data security best practices, manage access controls, and ensure compliance with relevant regulations and standards
  • Develop and enforce data governance policies, data quality standards, and best practices
  • Work closely with data analysts, engineers, and business stakeholders to understand data requirements and deliver solutions that meet their needs
  • Document business intelligence architecture, processes, and best practices.
  • Provide training and support to team members and end-users
  • Accommodate work that needs to be performed both during and after business hours
  • Other tasks as assigned


Typical Qualifications


  1. 5+ years of experience in business intelligence, data analytics, or a similar role
  2. Proven experience developing BI solutions using Power BI
  3. Strong expertise in data integration, data transformation and loading (ETL) processes, and data warehousing concepts, including the ability to transform and model data from various sources working with large-scale datasets in cloud environments
  4. Hands-on experience with predictive analytics, data modeling, and developing dashboards for executive use
  5. Proficiency in documenting processes, creating data dictionaries, and maintaining BI architecture documentation
  6. Knowledge of data modeling, data warehousing concepts, and best practices
  7. Strong analytical, research, and organizational skills, with impeccable attention to detail
  8. Knowledge of SQL and scripting languages (Python, R) for data analysis and automation
  9. Experience with relational databases such as Informix, PostgreSQL, and understanding data warehouse technologies (BigQuery, GCP)
  10. Experience with data warehouse technologies (e.g., Redshift, Snowflake) and cloud platforms (e.g., AWS, GCP)
  11. Understanding of regulatory requirements related to data privacy and security, particularly in a government or public service context
  12. Good understanding of GitHub database version control
  13. Ability to test and troubleshoot using appropriate methodologies and techniques
  14. Excellent written/verbal communication, interpersonal, and organizational skills required
  15. Interact with people in a manner that shows sensitivity, tact, and professionalism
  16. Familiarity with correctional or public safety systems and understanding of operational metrics specific to the corrections environment

  • Business Intelligence Analyst

    7 days ago

    West Lebanon, United States Robert Half Full time

    Job DescriptionJob DescriptionWe are in search of a Data Analyst to be a part of our team. The key role of the Data Analyst will be to design, compile, and interpret management reports for various business lines while ensuring alignment with business strategies. Responsibilities:Analyze and interpret financial data. Responsible for designing and generating...

  • Senior Business Intelligence Analyst

    4 weeks ago

    West Chester, Pennsylvania, United States Doyle Group, Inc Defunct Full time

    Business Intelligence AnalystWe are seeking a skilled Business Intelligence Analyst to join our team at Doyle Group, Inc. Defunct. As a Business Intelligence Analyst, you will work closely with cross-functional teams to gather, analyze, and optimize data to drive business decisions. The ideal candidate will have hands-on experience writing and pulling SQL...

  • Business Intelligence Analyst

    2 weeks ago

    west jordan, United States Smith Johnson Tech Full time

    **This role is not open to C2C candidates or sub vendor candidates.****This role is not open to candidates not currently living in Utah.****DO NOT apply if you are looking for C2C work or living outside of Utah; I do not have other roles for you.**This is a contract with a great organization. As a contractor for Smith Johnson, you are eligible for medical,...

  • Business Intelligence Analyst

    2 weeks ago

    west jordan, United States Smith Johnson Tech Full time

    **This role is not open to C2C candidates or sub vendor candidates.****This role is not open to candidates not currently living in Utah.****DO NOT apply if you are looking for C2C work or living outside of Utah; I do not have other roles for you.**This is a contract with a great organization. As a contractor for Smith Johnson, you are eligible for medical,...

  • Business Intelligence Specialist

    4 weeks ago

    South Jordan, Utah, United States Innova Solutions Full time

    Job Title: AnalystAt Innova Solutions, we are seeking a highly skilled Analyst to join our team. As an Analyst, you will be responsible for analyzing data to identify trends and insights that will inform business decisions.Key Responsibilities:* Analyze data to identify trends and insights* Develop and maintain reports and dashboards to present findings*...

  • Business Intelligence Specialist

    4 weeks ago

    South Jordan, Utah, United States Innova Solutions Full time

    Job Summary: We are seeking a highly skilled Analyst II to join our team at Innova Solutions. As an Analyst II, you will be responsible for providing analytical support to our clients and contributing to the development of business solutions.Key Responsibilities:Provide analytical support to clients, including data analysis, reporting, and...

  • Business Intelligence Developer

    3 weeks ago

    West Sacramento, California, United States State Teachers' Retirement System Full time

    Job SummaryWe are seeking a skilled Data Analyst to join our team. As a Data Analyst, you will be responsible for analyzing and interpreting complex data to inform business decisions.Key Responsibilities:Develop and maintain data visualizations and reports to communicate insights to stakeholdersAnalyze large datasets to identify trends and...

  • Senior Business Analyst

    3 weeks ago

    West Jordan, Utah, United States State of Utah Full time

    The State of Utah is seeking a highly skilled Senior Business Analyst to join its Technology and Innovation Division.This role involves utilizing computer software programs to store, retrieve, analyze, and present data in a format that supports the organization's production activities.The ideal candidate will have strong analytical skills, the ability to...

  • Business Analyst

    1 month ago

    South Jordan, Utah, United States Innova Solutions Full time

    Job Title: Business AnalystWe are seeking a highly skilled Business Analyst to join our team at Innova Solutions. As a Business Analyst, you will play a critical role in analyzing business needs and developing solutions to drive growth and improvement.Key Responsibilities:Respond to and coordinate with clients/business areas regarding returned mail...

  • Public Safety Intelligence Analyst

    4 months ago

    West Chester, United States Ohio Department of Developmental Disabilities Full time

    Public Safety Intelligence Analyst(24000728) Organization :Public Safety Unposting Date :Ongoing Work Location :ONIC Cincinnati2950 East Crescentville RoadWest Chester45069 Primary Location :United States of America-OHIO-Butler County-West ChesterCompensation:$30.96 per hour Schedule :Full-timeWork Hours:8:00AM to 5:00PMClassified...

  • Intelligence Analyst for Public Safety

    4 weeks ago

    West Chester, Pennsylvania, United States Ohio Department of Developmental Disabilities Full time

    Job SummaryAs a Public Safety Intelligence Analyst, you will play a crucial role in supporting the Ohio Department of Developmental Disabilities by analyzing and interpreting data to inform public safety strategies. This position requires a strong analytical mindset and the ability to work with complex data sets.Key ResponsibilitiesAnalyze and interpret data...

  • Intelligence Analyst for Public Safety

    4 weeks ago

    West Chester, Pennsylvania, United States Ohio Department of Developmental Disabilities Full time

    Job SummaryAs a Public Safety Intelligence Analyst, you will play a critical role in supporting the Ohio Department of Developmental Disabilities by analyzing and interpreting data to inform public safety strategies. This is a full-time position with a competitive hourly rate of $30.96.Key ResponsibilitiesAnalyze and interpret data to identify trends and...

  • **Business Analyst**

    2 weeks ago

    West Burlington, Iowa, United States Great River Health Full time

    We are seeking a Business Analyst to join our team at {company}. As a Business Analyst, you will be responsible for analyzing business needs and developing solutions to meet those needs. You will work closely with our cross-functional teams to understand business requirements and identify opportunities for improvement.Key Responsibilities:Conduct market and...

  • Power BI Business Intelligence Specialist

    3 weeks ago

    West Palm Beach, Florida, United States Georgia IT Inc Full time

    Job Title: Power BI Business Intelligence SpecialistAbout the Role:At Georgia IT Inc, we are seeking a highly skilled Power BI Business Intelligence Specialist to join our team. As a key member of our data analytics team, you will be responsible for designing, developing, and maintaining business intelligence solutions using Power BI.Key Responsibilities:...

  • Business Analyst

    1 month ago

    West Des Moines, United States Robert Half Full time

    Job DescriptionJob DescriptionWe are offering a hybrid/onsite contract employment opportunity for a Business Analyst in our team based in Urbandale, Iowa. The chosen candidate will be crucial in the decision-making process, testing business solutions, and maintaining critical documentation. This role requires a robust understanding of systems and products,...

  • IT Technical Project Manager/Business Analyst

    3 weeks ago

    South Jordan, Utah, United States Altius Technologies Inc Full time

    Job Title: IT Technical Project Manager/Business AnalystJob Summary:We are seeking a highly skilled IT Technical Project Manager/Business Analyst to join our team at Altius Technologies Inc. The ideal candidate will have a strong background in both project management and business analysis, capable of driving projects to successful completion and optimizing...

  • Senior Business Leader

    3 weeks ago

    West Jordan, Utah, United States IDEX Full time

    Job DescriptionAbout the Role:IDEX is seeking a highly skilled and experienced General Manager to lead our Trebor business. As a key member of our leadership team, you will be responsible for driving strategic growth, commercial excellence, and operational efficiency across our global operations.Key Responsibilities:Develop and execute a comprehensive...

  • IT Business Systems Analyst

    3 weeks ago

    West Middlesex, Pennsylvania, United States WernerCo Full time

    Job Title: IT Business Systems AnalystWernerCo is seeking an IT Business Systems Analyst to support the day-to-day financial operations of a global manufacturing company.Key Responsibilities:Analyze and evaluate existing or proposed systems to determine feasibility, costs, and compatibility with current systems.Develop Subject Matter Experts in supported...

  • Business Analyst

    1 month ago

    West Des Moines, United States Robert Half Full time

    Job DescriptionJob DescriptionWe are in search of a meticulous Derivatives Business Analyst to join our team in WEST DES MOINES, Iowa. As a Derivatives Business Analyst, your primary role will be to conduct comprehensive business analysis, design and document business process workflows, and provide detailed requirements for our technology team. This role...

  • Intelligence Systems Engineer/Analyst

    2 weeks ago

    West Mclean, United States The MITRE Corporation Full time

    Why choose between doing meaningful work and having a fulfilling life? At MITRE, you can have both. That's because MITRE people are committed to tackling our nation's toughest challenges—and we're committed to the long-term well-being of our employees. MITRE is different from most technology companies. We are a not-for-profit corporation chartered to work...