- 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.
- 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.
-
Data Analyst
1 week ago
American Bureau of Shipping Knoxville, United StatesJob Description · ABS Group is a global company that provides data-driven risk and reliability solutions and technical services that help our clients enhance the safety, integrity, quality, and environmental efficiency of their critical assets and operations. · In January 2020, ...
-
Data Analyst
5 days ago
Management Solutions Knoxville, United StatesWho 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 sol ...
-
Telematics Data Analyst
1 week ago
Phillips & Jordan Knoxville, United StatesPhillips 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 operation ...
-
Client Comp Data Analyst
5 days ago
LPL Financial Fort Mill, United States Full timeAre you a team player? Are you curious to learn? Are you interested in supporting others as they grow their business? Are you interested in being part of a team that is working to transform and do things differently? If so, LPL Financial is the place for you · LPL Financial (Nasd ...
-
quality data analyst
1 week ago
Blount Memorial Hospital Maryville, United StatesJOB SUMMARY The Data Quality Analyst for Blount Memorial Hospital assists in quality program initiatives set forth by the Director of Quality Services which include, but are not limited to, the components and reportable metrics of CMS Quality programs such as Inpatient Quality Re ...
-
Data Analyst I
1 week ago
Clayton Homes Maryville, United StatesPosition Summary · We are seeking a skilled Data Analyst to help Clayton answer tough questions with data. The mission for the Data Analytics team is to partner with the business units to provide tools for data-driven decisions through data visualization, ad-hoc analyses, and st ...
-
Senior Data and Systems Analyst
1 day ago
Direct Federal Credit Union Oak Ridge, United StatesThe deadline to apply for this opportunity is June 24, 2024. · Job Description: The Senior Data and Systems Analyst - Lending analyzes complex data related to lending and collections, incorporating company and industry knowledge, mathematical and technological expertise and sound ...
-
Fraud Analyst
4 days ago
eTeam Knoxville, United StatesJob 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 int ...
-
Telematics Business Analyst
20 hours ago
Phillips Infrastructure Holdings, Inc. Knoxville, United StatesPhillips 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 opera ...
-
Box Office Insights Specialist
4 days ago
Regal Knoxville, United States Full timeEssential Duties and Responsibilities include the following. Other duties may be assigned. · Experience of SQL and Tableau is needed, but eagerness to undertake training on or one or both to a workable level is important. · Monitor Regal theatre pricing by individual theatre, reg ...
-
Software Analyst
2 weeks ago
InsideHigherEd Knoxville, United States Administrative Jobs ,Software Analyst - Office of Innovative Technologies · (Hiring Multiple Positions) · IT Analyst II, III or IV · MR 11 – IT Software Developer II · MR 13 – IT Software Developer III · MR 14 – IT Software Developer IV · Positions located in Knoxville, TN · Hybrid Schedule · The Off ...
-
OSINT Intelligence Analyst
5 days ago
SAIC Fort Knox, United StatesDescription · SAIC is currently seeking an OSINT Intelligence Analyst at Fort Knox, KY. · Duties/Responsibilities: · Serves as an integrated member of a Multi-Functional Intelligence analysis team, and serves as an Open Source (OSINT) Analyst and SME for FORSCOM. · Assist in sup ...
-
Senior Financial Analyst- Budget
1 week ago
InsideHigherEd Knoxville, United States Administrative Jobs ,Senior Financial Analyst, Office of Budget, and Finance · Regular, Full-time, Market Range MR13 · The University of Tennessee, Knoxville (UTK) invites applications and nominations for the position of Senior Financial Analyst in the Office of Budget and Finance. UTK is seeking can ...
-
Financial Analyst
2 weeks ago
University of Tennessee Knoxville, United States Full timeFinancial Analyst Description Financial Analyst, Office of Budget, and Finance · Regular, Full-time, Market Range MR12 · The University of Tennessee, Knoxville (UTK) invites applications and nominations for the position of Senior Financial Analyst in the Office of Budget and ...
-
Senior Application Analyst
1 week ago
Covenant Health Knoxville, United States Full timePosition Summary: · Under general direction, responsible for defining, implementing, and supporting software applications, and interfacing with end-users and other IT groups to identify and resolve application issues. Passionate about technology in healthcare? We are excited to ...
-
Financial Analyst
1 week ago
InsideHigherEd Knoxville, United StatesFinancial Analyst, Office of Budget, and Finance · Regular, Full-time, Market Range MR12 · The University of Tennessee, Knoxville (UTK) invites applications and nominations for the position of Senior Financial Analyst in the Office of Budget and Finance. UTK is seeking candidates ...
-
Laboratory Analyst
3 days ago
Eurofins Knoxville, United States Full timeJob Description · The Analyst I prepares and analyzes environmental samples using standard analytical techniques according to scientific and EPA methodology in compliance with Eurofins Quality Assurance programs and SOP's. · VOA Analyst I responsibilities include, but are not li ...
-
Senior Financial Analyst
1 week ago
Keurig Dr Pepper Knoxville, United States Full timeKeurig Dr. Pepper is looking for a Senior Financial Analyst to support the Coffee Manufacturing operation. If you are looking for a dynamic and challenging work environment, with opportunity to expand your influence across the organization, grow personally and professionally wit ...
-
Associate Analyst, Operations
1 week ago
LPL Financial Fort Mill, United States Full timeJob Overview: · The ideal candidate will understand the financial services industry and have a willingness to operate in a dynamic, fast-paced, customer-driven environment. The Associate Analyst will support project & task assignments related to the facilitation of client mailing ...
-
Director of Loan Servicing Technology
20 hours ago
Clayton Knoxville, United StatesClayton Technology is undertaking a major, multi-year initiative to modernize, simplify and strengthen our core infrastructure, ultimately impacting or replacing most of our systems. As a Director of VMF Technology, you will be accountable for the technology strategy, vendor eval ...
Data Analyst - Knoxville, United States - Management Solutions LLC
Description
Job Description
Job 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
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
