USM Business Systems Logo

USM Business Systems

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

Reposted 25 Days Ago
Be an Early Applicant
In-Office
Lexington, MA, USA
Senior level
In-Office
Lexington, MA, USA
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


Similar Jobs

29 Minutes Ago
Easy Apply
Hybrid
Boston, MA, USA
Easy Apply
155K-165K Annually
Senior level
155K-165K Annually
Senior level
Fintech • Software
Lead and grow an engineering team (up to 12), own kanban-based delivery, translate business priorities into measurable outcomes, recruit and develop engineers, model AI-native practices, partner with Principal Engineer on technical direction, and maintain clarity and accountability across stakeholders.
Top Skills: Agentic SystemsAi-Assisted Development ToolsKanban
35 Minutes Ago
In-Office or Remote
Boston, MA, USA
113K-148K Annually
Senior level
113K-148K Annually
Senior level
Blockchain • Fintech • Payments • Financial Services • Cryptocurrency • Web3
Design, implement, and scale finance systems (primarily Oracle Cloud Fusion) to automate and streamline core finance processes, enable international expansion, drive AI-enabled automation, manage solution design and testing, and support finance teams for internal and SOX audits.
Top Skills: Accounting HubAi ToolsApple MacosCash ManagementFdi ReportingGoogle Workspace (G Suite)KyribaNavan Travel And ExpenseOracle Cloud Fusion ErpPayablesReceivablesRevenue ManagementSlackSubledger AccountingSubscription ManagementWorkivaZip Procurement To Pay
36 Minutes Ago
In-Office or Remote
Boston, MA, USA
113K-148K Annually
Senior level
113K-148K Annually
Senior level
Blockchain • Fintech • Payments • Financial Services • Cryptocurrency • Web3
Lead and enhance Circle's IT SOX compliance program by evaluating ITGCs, automated and IT-dependent controls, documenting SOX-ready materials, coordinating testing and remediations, liaising with IT, Security, Finance and auditors, and driving control design for system implementations and new product launches.
Top Skills: Ai ToolsApple MacosAudit/Compliance Management ToolsCloud EnvironmentsCybersecurity ControlsErp SystemsFinancial ApplicationsGoogle WorkspaceGrc PlatformsIdentity And Access Management (Iam)SaaSSdlcSlack

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