Overview
Skills
Job Details
MBA Consulting Services, Inc. is seeking an experienced Data Analyst that is responsible for the transactional data in a traditional database, telemetry data from services that you use, to signals that you get from different areas like social media. With data and information as the most strategic asset of a business, the underlying challenge that organizations have today is understanding and using their data to positively effect change within the business.
Businesses continue to struggle to use their data in a meaningful and productive way, which impacts their ability to act.
The key to unlocking this data is being able to tell a story with it. In today's highly competitive and fast-paced business world, crafting reports that tell that story is what helps business leaders take action on the data. Business decision makers depend on an accurate story to drive better business decisions. The faster a business can make precise decisions, the more competitive they will be and the better advantage they will have. Without the story, it is difficult to understand what the data is trying to tell you.
Data analysis exists to help overcome these challenges and pain points, ultimately assisting businesses in finding insights and uncovering hidden value in troves of data through storytelling. We are looking for a data analyst with Power BI skills that lets you visualize data and share insights across an organization or embed them in an application or website. We require a data analyst to connect large volumes of data sources and bring that data to life with live dashboards and reports. We require someone with Power Query and Power Pivot experience in MS Excel to enable the discovery of data trends and share impactful visualizations with our customers.
Responsibilities include:
- Preparing queries
- Cleansing data with Power Query
- Enhancing queries
- Creating a data model in Power Pivot
- Building relationships
- Creating Pivot Tables and Pivot Charts
- Creating Lookups
- Using DAX to link data
- Creating data model
- Creating relationship between data sources
- Analyzing data with PivotTables and PivotCharts
- Using Power Query with PowerPivot
- Connecting to a variety of data sources with Power BI
- Create and publish reports to Power BI Service
- Refreshing Data Source
- Updating Queries
- Using Conditional statements
- Using quick and dynamic measures
- Transforming data on connected datasets
Minimum Education Required:
Bachelor's Degree in relevant field. Strong data analytics coursework preferred.
Minimum Experience Required:
At least 5 years of experience in:
- Advanced Excel to include creating and using pivot tables and macros.
- Power Query and the ability to package results into visualization or professional presentations.
- Strategic thinking to analyze data and highlight trends or new ideas.
Additional Requirements:
- Must be able to pass a pre-employment background check & drug test.
- Candidates must meet eligibility requirements to obtain a Public Trust clearance.
MBA Consulting Services, Inc. (MBA) is a federal government IT systems integrator committed to delivering solutions that solve mission challenges with agility, experience, and innovation. As a mission-focused integrator, we provide a comprehensive range of information technology, engineering, professional services, and facilities management solutions. We have proven expertise in delivering custom data analytics, digital services, systems engineering, human factor engineering, and infrastructure solutions.
MBA is headquartered in Chantilly, Virginia, has more than 350 employees, and is in 46 locations worldwide. With proven leadership and a 20-year heritage, our reputation has been forged by acquiring and developing the best talent in a values-driven culture of integrity, respect, and quality solutions.
"MBA CSi is an Equal Opportunity, Affirmative Action Employer. Women, Minorities, Veterans, and individuals with disabilities are encouraged to apply. EOE Minority/ Female/ Veteran/ Disabled