Management Solutions · 1 week ago

Data Analyst

Knoxville, TN

Full-time

Onsite

Mid, Senior Level

5+ years exp

Wonder how qualified you are to the job?

ConsultingProject Management

Growth Opportunities

Insider Connection @Management Solutions

Discover valuable connections within the company who might provide insights and potential referrals, giving your job application an inside edge.

Responsibilities

Acquire, prepare, and clean data for reporting and analytics

Analyze data using statistical techniques and develop models

Identify technical requirements for data systems design

Develop and implement BI solutions, reports, and visualizations

Maintain metadata, data dictionaries, and source control

Provide end user training and support for BI platforms

Stay updated on industry trends and learn new platforms

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

Data analyticsSql serverSsrsPower biTabular data modelingT-sqlCtesAnalytical functionsDimensional data modelingDataflowsDatasetsDashboardsDaxRdbmsEtl/elt processesKimball methodologiesDdl & dml operationsExcelPythonPower automatePower appsProblem-solvingTime managementTeamworkCommunicationAdaptabilityEnergy IndustryEnergy AgenciesRenewable Energy CertificatesSCADA Systems

Required

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

Due to the nature of the government contract requirements and/or clearances requirements, US citizenship is required