Data Warehousing Specialist

mks2technologies; Arlington (VA); On-site; USD 90,000 - 120,000; Full time

Job summary

MKS2 Technologies, LLC is seeking a Data Warehousing Specialist to join our Arlington, VA team on a completely on-site basis. You will conduct forensic data analysis, develop dashboards, and provide timely, accurate reporting to leadership.

The role requires strong data analysis, Excel/Power BI expertise, and experience with federal accounting concepts. Candidates will collaborate across departments, translate business needs into analytical solutions, and adapt to a dynamic government

Qualifications

• Bachelor's degree in a relevant discipline is required.
• Minimum of two years of experience performing similar tasks.
• Proficient in Excel or Power BI with data analysis and knowledge of federal accounting.

Responsibilities

• Conduct forensic data analysis to uncover trends and forecasts.
• Identify, analyze, query, and produce data metrics and reports.
• Coordinate and aggregate data calls for program managers and Financial Services Division executives.
• Understand and facilitate the integration of business processes, people, and relevant technology.
• Provide timely, relevant, and accurate reporting and analysis of performance against budgeted, forecasted, and strategic results to facilitate decision-making.
• Demonstrate understanding of accounting principles and internal controls.
• Create monthly and quarterly status dashboards providing a high-level financial overview.
• Automate processes where possible.

Skills

Data analysis

Financial analysis

Business process

Policy compliance

Management experience

Interpersonal communication

Problem solving

Detail-oriented

Team collaboration

Self-motivated

Education

Bachelor's degree in a relevant discipline

Master's degree in a related field

Bachelor's degree in accounting, finance, economics, or BIS

Tools

Power BI

Microsoft Excel

SQL

Tableau

Microsoft Access

Momentum or UFMS

Job description

MKS2 Technologies, LLC, an award-winning high growth small business, creates innovative and customer-centric technology solutions in the areas of Cyber Security, Instructional Design and Training, Software Engineering and IT Support Services to improve the security and well-being of our clients. Our commitment to excellence and our "Mission First" orientation has resulted in steady growth and an expanding client base across government agencies. We have employees nationwide and for the past three consecutive years were named one of the fastest growing Veteran-owned companies in the nation.

Data Warehousing Specialist

Work Location: Completely on-site in Arlington, VA.

Basic Required Qualifications and Skills

Note: These are mandatory items that all candidates must have when submitting an application to IMC for this position. Please ensure that your submission addresses each of these requirement items. Candidates without these required elements will not be considered.

• Bachelor's degree in a relevant discipline from an accredited institution of higher learning.
• Minimum of two (2) years of experience performing tasks similar to those stated below.
• Knowledge/experience in the following areas:
  • Financial Analysis
  • Business Process
  • Business Process Engineering
  • Policy compliance and reporting
  • Management experience
  • Data Analysis
• Proficient in Microsoft Excel or Power BI, and strong experience with data analysis, financial, and accounting (especially federal accounting) knowledge.
• Highly motivated individual who is willing to learn, work in a team environment, and is self-sufficient and willing to do independent research to solve problems.
• Self-sufficient worker and analytical thinker with the ability to normalize and manipulate data within large datasets to perform in-depth analysis and resolve complex problems.
• Detail-oriented with proven ability to adapt to a dynamic organization.
• Strong interpersonal and communications skills (both oral and written) with a customer service orientation and demonstrated ability to effectively interact at all levels across the organization to build successful relationships.
• Excellent consultative, conflict resolution, negotiation, and facilitation skills to gain consensus in a matrixed and complex organization.
• Proven problem-solving skills with demonstrated ability to think out of the box and generate creative solutions; ability to break a complex problem down into its component parts and arrive at the appropriate solution in a timely fashion.
• Must be flexible and able to thrive in a time-sensitive environment to meet strict deadlines.
• Positive attitude, averse to the status quo, always looking to improve current processes and procedures; ability to see opportunities for change, to capitalize on them, and implement them when appropriate for the benefit of the organization.
• A self-starter with a strong work ethic who sets high standards for self and others and demonstrates enthusiasm for the mission of the team.
• Please note that pursuant to a government contract, this specific position requires U.S. Citizenship
• Must be able to obtain a Moderate Risk Background Investigation (MBI) Public Trust T3 case type or higher.

Desired Qualifications and Skills

• Proficient in Microsoft Access.
• Federal government experience.
• Master's or higher degree in a relevant discipline from an accredited institution of higher learning.
• Bachelor's degree in accounting, finance, economics, or business information systems.
• Strong experience with SQL, Business Objects, Power BI, and Tableau.
• Experience with Momentum or UFMS.

Essential Duties and Responsibilities

• Conduct forensic data analysis to uncover and analyze data trends, patterns, and forecasts, explain processes and techniques, recommend actions, and provide accurate and reliable responses to program- and executive-level inquiries.
• Identify, analyze, query, and produce data metrics, as well as intra- and inter-agency benchmarks and reports.
• Coordinate, execute, and aggregate data calls for program managers and Financial Services Division (FSD) executives.
• Understand and facilitate the integration of business processes, people, and relevant technology to identify, configure, and communicate useful information.
• Provide timely, relevant, and accurate reporting and analysis of the results of the Division's performance against historical, budgeted, forecasted, and strategic planning results to facilitate decision-making.
• Demonstrate appropriate understanding and working knowledge of accounting principles and internal controls.
• Create monthly and quarterly status dashboards, providing a high-level financial overview of the organization to FSD leadership.
• Automate processes for