USM Business Systems Logo

USM Business Systems

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

Reposted 8 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


Top Skills

Oracle
Pl/Sql
SQL
T-Sql

Similar Jobs

An Hour Ago
Hybrid
Burlington, MA, USA
16-25 Hourly
Junior
16-25 Hourly
Junior
eCommerce • Fashion • Other • Retail • Sales • Wearables • Design
The Lead Supervisor II leads store operations, achieves sales targets, fosters a positive team environment, and enhances customer experiences while monitoring performance metrics.
7 Hours Ago
Hybrid
19-38 Hourly
Junior
19-38 Hourly
Junior
eCommerce • Fashion • Other • Retail • Sales • Wearables • Design
As an Assistant Store Manager, you will drive sales, ensure exceptional customer service, lead and develop talent, and maintain operational excellence while collaborating with leadership.
Top Skills: MS OfficeRetail Systems
7 Hours Ago
Easy Apply
Hybrid
Boston, MA, USA
Easy Apply
244K-366K Annually
Expert/Leader
244K-366K Annually
Expert/Leader
Consumer Web • eCommerce • Marketing Tech • Retail • Software • Analytics • Generative AI
In this role, you'll lead the team responsible for the AI engineering charter at Klaviyo, managing the development of AI-powered capabilities and ensuring high-quality, reliable AI experiences across the platform. You'll collaborate across departments and drive the delivery of AI solutions that enhance customer outcomes.
Top Skills: Agent FrameworksAIData ScienceLlmsMlRetrieval-Augmented GenerationSoftware Engineering

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