USM Business Systems Logo

USM Business Systems

BI/DW Modeler/ Architect – EAD or GC or USC ONLY

Reposted 14 Days Ago
Be an Early Applicant
In-Office
Lexington, MA
Senior level
In-Office
Lexington, MA
Senior level
The role focuses on BI data modeling and architecture, involving 80% hands-on SQL development and 20% design analysis, mainly using Oracle and SQL technologies.
The summary above was generated by AI
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. 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 and e-commerce. 

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

BI/DW Modeler/ Architect – EAD or GC or USC ONLY
Lexington, MA

Top Three Skills: 1. 8+ years of experience in data modeling/architecture for BI purposes. (Ideally Oracle)
2. Strong SQL/Oracle development (for BI purposes)
3. Must have extensive experience working in Business Intelligence/Analytical data warehousing environments.
Job Description: This position is a Sr. BI SQL Developer in the Business Intelligence team at Fresenius Medical Care. This person will specifically be focusing on data modelling.
This person will be primarily focused on the back-end development for reporting (PL/SQL or T-SQL depending on the project). They will be responsible for the design and extraction of data for the BI team. This person will be interacting with data modelers and architects, so much be able to read data models and influence whether it will work for the reporting environment. 80% of the work will be PL/SQL or T-SQL development, 20% analysis/design and influence of data modeling. It would be a plus if someone can write reports as well, but the focus is primarily in understanding structures, and extracting data for reports.
There is a separate Data Architecture team, but they do not have the bandwidth to support the BI team for their data modeling needs. Therefore, the BI team has taken on more responsibility for data modeling and architecture, building of ETL to move environments for reporting. They do not have a dedicated resource with a strong background in this. Therefore, they are looking to bring in someone with strong data modeling experience, dimensional models, understands what it means to pull large amounts of data for reporting purposes.
Project will be a mix of new development and enhancing current projects that are running.
** It is very important this person still does development. 1/2 time will be data modeling/architecture and 1/2 time will be hands on SQL or PL/SQL development**
Navya
703-953-1819

Additional Information

If my requirement matches your resume, then please do reply on my email id navyar(at)usmsystems(dot)com and contact no is 703-953-1819


Top Skills

Oracle
Pl/Sql
SQL
T-Sql

Similar Jobs

5 Minutes Ago
Easy Apply
Remote or Hybrid
United States
Easy Apply
116K-145K Annually
Senior level
116K-145K Annually
Senior level
Cloud • Healthtech • Professional Services • Software • Pharmaceutical
The Senior Technical Project Manager will oversee the delivery of eClinical Solutions' elluminate platform, ensuring quality, managing multiple projects, and maintaining client relationships.
Top Skills: Eclinical Solutions Elluminate PlatformExcelMicrosoft OutlookMicrosoft PowerpointMicrosoft ProjectMicrosoft TeamsMicrosoft VisioMicrosoft WordOnedriveSharepoint
An Hour Ago
Remote or Hybrid
USA
106K-132K Annually
Mid level
106K-132K Annually
Mid level
Edtech • Information Technology • Software
The Corporate Strategy Associate analyzes company strategy, evaluates opportunities, and collaborates with teams to optimize business growth and present findings.
Top Skills: ExcelPowerPoint
An Hour Ago
Remote or Hybrid
USA
129K-161K Annually
Senior level
129K-161K Annually
Senior level
Edtech • Information Technology • Software
The Senior Strategy Associate will lead strategic initiatives, manage projects, and collaborate with cross-functional teams to deliver business value and ensure effective execution.
Top Skills: Project Management Tools

What you need to know about the Boston Tech Scene

Boston is a powerhouse for technology innovation thanks to world-class research universities like MIT and Harvard and a robust pipeline of venture capital investment. Host to the first telephone call and one of the first general-purpose computers ever put into use, Boston is now a hub for biotechnology, robotics and artificial intelligence — though it’s also home to several B2B software giants. So it’s no surprise that the city consistently ranks among the greatest startup ecosystems in the world.

Key Facts About Boston Tech

  • Number of Tech Workers: 269,000; 9.4% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Thermo Fisher Scientific, Toast, Klaviyo, HubSpot, DraftKings
  • Key Industries: Artificial intelligence, biotechnology, robotics, software, aerospace
  • Funding Landscape: $15.7 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Summit Partners, Volition Capital, Bain Capital Ventures, MassVentures, Highland Capital Partners
  • Research Centers and Universities: MIT, Harvard University, Boston College, Tufts University, Boston University, Northeastern University, Smithsonian Astrophysical Observatory, National Bureau of Economic Research, Broad Institute, Lowell Center for Space Science & Technology, National Emerging Infectious Diseases Laboratories

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account