151 Data Analyst Jobs in Washington, DC
Sorry! This job is no longer available. Please explore similar jobs listed on the left.
Management Solutions Inc. is Hiring a Data Analyst Near Washington, DC
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.
This position is remote, with the expectation that candidates can work during United States Eastern Time Zone office hours. Both United States citizenship and residency are mandatory requirements.This opportunity is posted as a consulting / 1099 position with MSLLC and our clients.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
- This position is remote, with the expectation that candidates can work during Eastern Time Zone office hours. Residency in the United States is a mandatory requirement
- Due to the nature of the government contract requirements and/or clearances requirements, US citizenship is 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
- 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
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
Job Summary
Contractor
Business Services
$93k-122k (estimate)
07/26/2024
08/17/2024
msgweb.com
GRAND RAPIDS, MI
50 - 100
1999
Private
BRANDON KERKSTRA
$10M - $50M
Business Services
Related Companies
About Management Solutions Inc.
MSG is a management consulting firm designed to support and improve business management practices.
The following is the career advancement route for Data Analyst positions, which can be used as a reference in future career path planning. As a Data Analyst, it can be promoted into senior positions as a Data Analyst III that are expected to handle more key tasks, people in this role will get a higher salary paid than an ordinary Data Analyst. You can explore the career advancement for a Data Analyst below and select your interested title to get hiring information.
If you are interested in becoming a Data Analyst, you need to understand the job requirements and the detailed related responsibilities. Of course, a good educational background and an applicable major will also help in job hunting. Below are some tips on how to become a Data Analyst for your reference.
Step 1: Understand the job description and responsibilities of an Accountant.
Quotes from people on Data Analyst job description and responsibilities
A data analyst also helps the business use the present data to make better business decisions and deliver better services to consumers.
12/10/2021: Lynchburg, VA
Their role will be like to work on collaborative, multidisciplinary teams with leaders where they can review and analyze data and to develop the presentation for the data consumption across the organization.
02/10/2022: Temple, TX
Data analysts work constantly with stakeholders, fellow colleagues and data suppliers, so good communication skills are essential.
12/21/2021: New London, CT
Many data analysts are required to create presentations of their findings to share with stakeholders and other key members of an organization.
12/24/2021: Alamogordo, NM
Gathered requirements, analyze data and create functional/technical specifications to functionality required by new business rules, regulations or standards change.
03/03/2022: Santa Maria, CA
Step 2: Knowing the best tips for becoming an Accountant can help you explore the needs of the position and prepare for the job-related knowledge well ahead of time.
Career tips from people on Data Analyst jobs
Data analysts typically work with existing data to solve defined business problems.
02/20/2022: Laramie, WY
Data analysts rely on various tools to collect and make sense of their data.
01/17/2022: Melbourne, FL
Banks and financial firms need data analysts for financial reporting and forecasting.
03/04/2022: Akron, OH
Data analysts often work directly with more senior data team members like data scientists or data engineers.
03/02/2022: Grand Forks, ND
Predictive analysis refers to a data analyst's ability to use data, machine learning and statistical algorithms to predict the likelihood of future outcomes based on previous historical data.
02/26/2022: Las Vegas, NV
Step 3: View the best colleges and universities for Data Analyst.
Similar Jobs
Popular Articles
