Data Analyst

3 weeks ago

Knoxville, United States Management Solutions LLC Full time
Job DescriptionJob DescriptionWho we are…

Management Solutions is a national award-winning management consulting firm that specializes in clean energy program management, organizational maturity assessment, environmental services, and project strategy and implementation. We deliver simple, innovative solutions to complex problems facing our customers. Founded in 2002, MSLLC has been named Small Business of the Year by the U.S. Small Business Administration, the Department of Energy, and the Oak Ridge National Laboratory. MSLLC has also been recognized as one of the Top Employers in the Greater Knoxville area.

Who we need…

Management Solutions is seeking a Data Analyst. You will work closely with the business to deliver data-driven analytical insights and business intelligence solutions that will help support and drive the decisions of the business. You will use your advanced data and SQL knowledge to become a subject matter expert (SME) of our internal data systems and our clients, understand what data is available to the business, and help design / structure systems that make use of this data.

Responsibilities
 
  • Acquire, prepare, and clean data to ensure usability for reporting and analytics.
  • Analyze data using statistical techniques to extract useful information and draw conclusions.
  • Develop statistical models to support analysis.
  • Understand and identify the appropriate technical requirements / specifications for designing a system to house and use data.
  • Partner with the business units, to gather technical requirements and implement BI solutions.
  • Develop reports, dashboards, scorecards, and other data visualizations in SSRS, Power BI, ZAP BI, Excel, and other BI platforms.
  • Unify business logic and KPI definitions across all BI solutions.
  • Maintain metadata and custom mappings used in reporting and analysis.
  • Coordinate with the Data Ops team to develop and document data warehouse collections and datasets needed for BI reporting and platforms.
  • Analyze and understand source system data for validity and completeness, troubleshooting basic data integrity issues, and document findings.
  • Maintain detailed data dictionaries, documentation, and source control for all BI processes and solutions.
  • Provide end user training and support for BI platforms.
  • Remain current in profession and industry trends, learning new platforms as needed.
Qualifications
 
  • Bachelor's degree required, preferably in Business Analytics, Mathematics, Statistics, Economics, Computer Science, Engineering, or another analytically challenging field.
  • Five (5) years of professional experience with data analytics, SQL Server, SSRS, Power BI, and/or Tabular data modeling required.
  • Adept at writing complex and optimized T-SQL queries (complex joins, CTEs, analytical functions, parameterization, etc.) against very large datasets, with the ability to combine data between multiple SQL sources via linked servers.
    ​​​​​​​Exceptional understanding of dimensional data modeling (star schema).
  • Extensive experience building dataflows, datasets, dashboards, and other visuals in Power BI, including extensive use of DAX to create complex KPIs. 
  • Ability to develop an understanding of table relationships in a RDBMS by reverse engineering views and stored procedures.
  • Familiarity with ETL/ELT processes, Kimball methodologies of data warehousing concepts and design, and DDL & DML operations.
  • Proficiency with Excel in a reporting and dashboarding capacity (Power Query, cube functions, array functions, etc.).
  • Working knowledge of Python.
  • Working knowledge of Power Automate and Power Apps.
  • Ability to work independently and as part of a team, manage time effectively, and meet project deadlines.
  • Desire to learn and support new technologies and systems.
  • Experience working in the energy industry is preferred.
  • Experience working with energy agencies (federal and/or state) is a plus.
  • Experience working with renewable energy certificates / credits is a plus.
  • Experience working with SCADA systems is a plus.
  • Location preference is Knoxville, TN; remote candidates will be considered.
  • Working hours - Eastern time zone.
  • Due to the nature of the government contract requirements and/or clearances requirements, US citizenship is required.

 

 

Management Solutions LLC is an Equal Employment Opportunity (EEO) employer. It is the policy of the Company to provide equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.

Powered by JazzHR

huIi0NDJxf

  • Telematics Data Analyst

    2 weeks ago

    Knoxville, Tennessee, United States Phillips & Jordan Full time

    Phillips Infrastructure Holdings Inc is currently seeking a highly motivated and detail oriented Telematics Data Analyst to join our team. As a Telematics Analyst specializing in Commercial Motor Vehicles, you will be at the forefront of leveraging data to optimize the operations and performance of fleets. Your role will involve monitoring driving...

  • Telematics Data Analyst

    4 weeks ago

    Knoxville, United States Phillips & Jordan Full time

    Phillips Infrastructure Holdings Inc is currently seeking a highly motivated and detail oriented Telematics Data Analyst to join our team. As a Telematics Analyst specializing in Commercial Motor Vehicles, you will be at the forefront of leveraging data to optimize the operations and performance of fleets. Your role will involve monitoring driving...

  • Telematics Data Analyst

    2 weeks ago

    Knoxville, United States Phillips & Jordan Full time

    Phillips Infrastructure Holdings Inc is currently seeking a highly motivated and detail oriented Telematics Data Analyst to join our team. As a Telematics Analyst specializing in Commercial Motor Vehicles, you will be at the forefront of leveraging data to optimize the operations and performance of fleets. Your role will involve monitoring driving...

  • Data Analyst

    3 weeks ago

    Knoxville, United States Management Solutions Full time

    Who we are… Management Solutions is a national award-winning management consulting firm that specializes in clean energy program management, organizational maturity assessment, environmental services, and project strategy and implementation. We deliver simple, innovative solutions to complex problems facing our customers. Founded in 2002, MSLLC has been...

  • Fraud Analyst

    2 weeks ago

    Knoxville, United States eTeam Full time

    Job Title: Fraud Analyst Location: Knoxville, TN 37920(Onsite) Duration: 6 Months(Contract), possible extension Pay: $25/hr Job Description: The Triage team with Fraud Investigations conducts the review of all Investigative Referral Forms and referrals created from internal sources. The analyst is responsible for reviewing each referral including the...

  • Fraud Analyst

    3 weeks ago

    Knoxville, United States eTeam Full time

    Job Title: Fraud AnalystLocation: Knoxville, TN 37920(Onsite)Duration: 6 Months(Contract), possible extension Pay: $25/hr Job Description: The Triage team with Fraud Investigations conducts the review of all Investigative Referral Forms and referrals created from internal sources. The analyst is responsible for reviewing each referral including the...

  • Fraud Analyst

    3 weeks ago

    Knoxville, United States eTeam Full time

    Job Title: Fraud AnalystLocation: Knoxville, TN 37920(Onsite)Duration: 6 Months(Contract), possible extension Pay: $25/hr Job Description: The Triage team with Fraud Investigations conducts the review of all Investigative Referral Forms and referrals created from internal sources. The analyst is responsible for reviewing each referral including the...

  • Fraud Analyst

    13 hours ago

    Knoxville, United States eTeam Full time

    Job Title: Fraud AnalystLocation: Knoxville, TN 37920(Onsite)Duration: 6 Months(Contract), possible extensionPay: $27/hr Job Description: • What are your top 3 MUST HAVE skills or experience required? Attention to detail, self-motivated, proficient in Microsoft Office.• What are 3 NICE TO HAVE skills (or experience) that are preferred, but not required?...

  • Grid Modernization Consultant

    2 months ago

    Knoxville, United States EnerNex Full time

    Grid Modernization Consultant Analyst (intern) Job Description: Under general direction with EnerNex consultants, perform work on a broad range of general management consulting and energy engineering consulting engagements. Primarily responsible for information management, data analysis, research, and deliverable preparation. Analysts serve in supporting...

  • Systems Analyst Staff

    2 weeks ago

    Knoxville, Tennessee, United States Covenant Health (Tennessee) Full time

    Overview Systems Analyst Staff Full Time, 80 hours per pay period, Day Shift Covenant Health Overview: Covenant Health is the regions top-performing healthcare network with 10 hospitals ) , outpatient and specialty services ) , and Covenant Medical Group ) , our areas fastest-growing physician practice division. Headquartered in Knoxville, Covenant...

  • Systems Analyst Assoc

    2 weeks ago

    Knoxville, Tennessee, United States Covenant Health (Tennessee) Full time

    Overview Systems Analyst Associate Full time, 80 hours per pay period, Day Shift Covenant Health Overview: Covenant Health is the regions top-performing healthcare network with 10 hospitals ) , outpatient and specialty services ) , and Covenant Medical Group ) , our areas fastest-growing physician practice division. Headquartered in Knoxville, Covenant...

  • Software Analyst

    2 weeks ago

    Knoxville, Tennessee, United States InsideHigherEd Full time

    Software Analyst - Office of Innovative Technologies(Multiple Positions Available)Various IT Analyst Positions Available:IT Analyst II - IT Software Developer IIIT Analyst III - IT Software Developer IIIIT Analyst IV - IT Software Developer IVLocation: Knoxville, TNWork Schedule: HybridThe Office of Innovative Technology is looking for IT Analysts at...

  • Telematics Business Analyst

    2 weeks ago

    Knoxville, United States Phillips Infrastructure Holdings, Inc. Full time

    Phillips Infrastructure Holdings Inc is currently seeking a highly motivated and detail oriented Telematics Business Analyst to join our team. As a Telematics Analyst specializing in Commercial Motor Vehicles, you will be at the forefront of leveraging data to optimize the operations and performance of fleets. Your role will involve monitoring driving...

  • Telematics Business Analyst

    2 weeks ago

    Knoxville, United States Phillips Infrastructure Holdings, Inc. Full time

    Phillips Infrastructure Holdings Inc is currently seeking a highly motivated and detail oriented Telematics Business Analyst to join our team. As a Telematics Analyst specializing in Commercial Motor Vehicles, you will be at the forefront of leveraging data to optimize the operations and performance of fleets. Your role will involve monitoring driving...

  • Telematics Business Analyst

    2 weeks ago

    Knoxville, United States Phillips & Jordan Full time

    Phillips Infrastructure Holdings Inc is currently seeking a highly motivated and detail oriented Telematics Business Analyst to join our team. As a Telematics Analyst specializing in Commercial Motor Vehicles, you will be at the forefront of leveraging data to optimize the operations and performance of fleets. Your role will involve monitoring driving...

  • Telematics Business Analyst

    2 weeks ago

    Knoxville, United States Phillips Infrastructure Holdings, Inc. Full time

    Phillips Infrastructure Holdings Inc is currently seeking a highly motivated and detail oriented Telematics Business Analyst to join our team. As a Telematics Analyst specializing in Commercial Motor Vehicles, you will be at the forefront of leveraging data to optimize the operations and performance of fleets. Your role will involve monitoring driving...

  • ERP Analyst

    3 weeks ago

    Knoxville, United States SDS Imports Full time

    Job DescriptionJob DescriptionJob Summary:The ERP Analyst will play a critical role in optimizing and maintaining our ERP system to enhance business operations. This role requires a deep understanding of ERP systems, business processes, and the ability to collaborate effectively with cross-functional teams. The successful candidate will be responsible for...

  • VMI Analyst

    3 days ago

    Knoxville, United States StaffSource, LLC Full time

    Job DescriptionJob DescriptionVMI (Vendor Managed Inventory) AnalystResponsibilitiesPerform all logistics functions relating to assigned customers; track all purchase orders from the time the order was created or received by the analyst through customer receipt of product. Securing delivery appointments; tendering of loads to carriers or other 3rd party...

  • ERP Analyst

    4 days ago

    Knoxville, United States Green Meadows Partners Full time

    Job DescriptionJob DescriptionThe ERP Analyst will play a critical role in optimizing and maintaining our ERP system to enhance business operations. This role requires a deep understanding of ERP systems, business processes, and the ability to collaborate effectively with cross-functional teams. The successful candidate will be responsible for configuring,...

  • Qlikview Analyst

    1 month ago

    Knoxville, Tennessee, United States Saxon AI Full time

    Company DescriptionSaxon Global is one of the fastest growing Inc 500 Companies in the US, providing enhanced IT consulting, and engineering solution services from past 16 years. Saxon global specializes in Business Intelligence, Mobility, Big Data & Cloud and provides IT tools and services to help organizations across industry verticals such as Financial...