Data Analyst

Reposted 4 Days Ago
Washington, DC, USA
In-Office
Senior level
Artificial Intelligence • Information Technology • Internet of Things • Software • Automation
The Role
The Data Analyst will analyze data flows, create metrics for reconciliation, document requirements, and collaborate with technical teams to ensure data integrity and reporting.
Summary Generated by Built In
Company Description

USM Business Systems Inc. is a quickly developing worldwide System Integrator, Software and Product Development, IT Outsourcing and Technology assistance supplier headquartered in Chantilly, VA with off-shore delivery centers in India. We offer world-class ability in giving most astounding quality and administrations through industry best practices planned to convey remarkable worth to our customers.

Utilizing our industry knowledge, administration service offering expertise and innovation abilities, we distinguish new business and innovation slants and create answers for help customers around the globe, giving top of the line solid and practical IT benefits which are cost effective services.

Established in 1999, the organization has corner qualities in building and dealing with a Business Oriented IT environment with rich involvement in technology innovation, ERP and CRM counselling, Product Engineering, Business Intelligence, Data Management, SOA, BPM, Data Warehousing, SharePoint Consulting and IT Infrastructure. Our other offerings include modified solutions and administrations in ERP, CRM, Enterprise architecture, offshore advisory services ,e-commerce, Social , Mobile, Cloud, Analytics (SMAC) and DevOps.

USM, a US ensured Minority Business Enterprise (MBE) is perceived as one of the fastest developing IT Systems Integrator in the Washington, DC zone. Most as of late, USM was positioned #9 on the rundown of the Top administrations organizations in the DC Metro Area – Washington Business Journal (2011). We are a project-driven firm that reliably meets the IT needs of our State and Government customers through development and business keenness.

Job Description

LOCALS ONLY

Interview : Phone and In person required by the client

Identifies, analyzes, formulates, documents, and communicates business data requirements for the following:

• Deep dives into source to target mapping documentation and then confirmation of the data flows throughout the Enterprise Data Warehouse (EDW) 

• Business metrics to support post-process reconciliation routines to balance EDW source and target data

• Data analysis for Post-process queries to perform balancing and reconciliation between source data, control files for source data, and data loaded into the EDW

• Dash-boarding and Canned Reporting to support formal monitoring of reconciliation exceptions throughout the EDW load process

• Elaboration of standard operating procedures for formal monitoring of audit, balancing and reconciliation processes  

Verifies the delivered system(s)/audit routines against the functional and non-functional requirements and specifications. Authors a test plan and test cases, defines test data, executes tests, communicates test progress and results, and maintains a requirements traceability matrix (RTM).

Properly addresses and balances long-term needs with near-term project iteration requirements and timing. Effectively collaborates with subject matter experts, project lead, analysts, and developers to understand needs and to communicate detailed requirements and specifications and their benefits. 

Works closely with project lead to map out assigned activities to a well-thought out level of effort, plan, and schedule.

Works closely with project lead, data architect, and solution architect to understand data architecture, data models, and solution architecture and to align and trace to requirements, source data profiles, gaps in data and data integration processing rules.

Skills

1. Bachelor’s degree in computer science, decision support, information engineering, business administration, or other related discipline. Master’s degree in a related discipline is a plus.

2. 7+ years of experience using SQL and other techniques and tools to perform a combination of data profiling, data quality, and data affinity analysis.

3. 3+ years documenting source to target mapping of data entities and elements across an information supply chain (data lineage) in order to communicate dependencies, flows, derivation logic, and usage patterns.

4. Demonstrable understanding of the utilization of data for audit, balance and controls of data movement processes.

5. Strong ability to effectively communicate (oral presentation) concrete concepts to a variety of stakeholders across business and information technology organizations in a formal and informal manner.

6. Strong writing skills including attention to metadata and definitional detail as well as ability to visually depict concepts to technical and non-technical audiences.

7. Proven ability to work close with others, to work through design challenges, to solve problems, and to mentor and guide.

8. Proven ability to work both independently and in groups as a self-motivated and highly engaged contributor.

9. 3+ years hands-on design, development and support experience with Ab Initio using GDE, Co>Operating System and EME. Experience in any of the following is desired: Query>It, Conduct>It, Express>It, Continuous flows, Metadata Hub. (not required)

Additional Information

If you are interested in above position, please share your updated resume to  alih(at)usmsystems(dot)com or can directly call me on 703-955-3955.

Skills Required

  • Bachelor's degree in computer science or related discipline
  • 7+ years of experience using SQL
  • 3+ years documenting source to target mapping
  • Strong communication skills for stakeholder engagement
  • 3+ years hands-on design and support experience with Ab Initio

USM Business Systems Compensation & Benefits Highlights

The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about USM Business Systems and has not been reviewed or approved by USM Business Systems.

  • Fair & Transparent Compensation Pay is considered acceptable to good overall, with market-competitive figures evident in certain technical roles. Payroll is described as on time with straightforward arrangements, supporting baseline confidence in compensation.
  • Healthcare Strength Health coverage is characterized as solid in some contexts, including earlier mentions of free employer-paid insurance and a recent note of comprehensive benefits for certain employees. These experiences indicate pockets of strong medical coverage within the organization.
  • Wellbeing & Lifestyle Benefits Access to paid time off and some work-from-home flexibility is cited, contributing to a workable balance in select situations. These elements add practical lifestyle support even when other benefits are average.

USM Business Systems Insights

Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Chantilly, VA
580 Employees
Year Founded: 1999

What We Do

USM is helping companies change existing business paradigms by bringing tomorrow’s AI and Automation solutions to today’s businesses. Disruptive new technologies are helping corporations become more agile, competitive and profitable. Predictive algorithms are provisioning customer orders more accurately than ever before. Cognitive technologies are enhancing the customer experience at every touch point and open-ledger validation methods are improving the accuracy of complex, global financial transactions. Automation is no longer a choice, it is the engine that drives business growth. Established in 1999 as an IT Consulting services company in the Washington DC metro area, the USM group of companies today consists of 1000+ employees across North America, Europe, Asia and Australia, providing a range of services such as * Automation & Innovation * Architecture & Consulting * Maintenance & Support * Contingent Workforce. Our experts are SMEs in the following critical business areas – data sources (internet devices), mobile commerce strategies, customer acquisition & retention and ultimately, leveraging enterprise data management to drive competitiveness. We have the resources that can help you design your enterprise architecture, build & deploy your applications, as well as manage your IT operations 24x7. Our focus areas include AI, Data science, RPA, Connected cars & devices, Natural language processing, Computer vision, Virtual agents, Blockchain, IoT, Mobile commerce, Retention programs, AR, VR, Gaming, and Enterprise data management.

Similar Jobs

BAE Systems, Inc. Logo BAE Systems, Inc.

Data Analyst

Aerospace • Hardware • Information Technology • Security • Software • Cybersecurity • Defense
Hybrid
Washington, DC, USA
40000 Employees
64K-108K Annually

CrowdStrike Logo CrowdStrike

Data Analyst

Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
Remote or Hybrid
USA
11000 Employees
70K-95K Annually

Samsara Logo Samsara

Data Analyst

Artificial Intelligence • Cloud • Computer Vision • Hardware • Internet of Things • Software
Easy Apply
Remote or Hybrid
United States
4000 Employees
63K-95K Annually

Sporty Group Logo Sporty Group

Data Analyst

Digital Media • Fintech • Gaming • Sports
In-Office or Remote
7 Locations
1024 Employees

Similar Companies Hiring

Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
178 Employees
Kepler  Thumbnail
Fintech • Software
New York, New York
6 Employees
Onshore Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
60 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account