USM Business Systems Logo

USM Business Systems

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

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

28 Minutes Ago
Remote or Hybrid
United States
42K-57K Annually
Junior
42K-57K Annually
Junior
Fintech • Information Technology • Insurance • Financial Services • Big Data Analytics
Administers group insurance transactions for participants, plan sponsors, customers, and internal partners. Reviews and enters enrollment data, manages eligibility and beneficiary records, handles plan referrals, maintains automated systems, troubleshoots data issues, develops customer relationships, and researches escalated cases. The role also supports process improvements, explains procedures during customer interactions, and ensures accurate, timely service delivery.
Top Skills: Microsoft Office Suite
An Hour Ago
Remote or Hybrid
United States
181K-273K Annually
Expert/Leader
181K-273K Annually
Expert/Leader
Artificial Intelligence • Consumer Web • Edtech • Enterprise Web • HR Tech • Social Impact • Generative AI
Serve as strategic partner to the Enterprise GM to design and execute multi-year strategies and operating models. Lead cross-functional initiatives, align executive priorities and resource allocation, drive organizational change and operational excellence, synthesize insights for senior decision-making, and build relationships across VP+ leaders to mobilize company-level transformation.
An Hour Ago
Remote or Hybrid
United States
66K-89K Annually
Junior
66K-89K Annually
Junior
Cloud • Fintech • Software • Business Intelligence • Consulting • Financial Services
Perform financial due diligence and Quality of Earnings analyses for buy- and sell-side M&A transactions. Analyze historical and projected financials, assess working capital and net debt, prepare diligence reports and data books, support valuation and transaction structuring, present findings to clients, and assist in business development.
Top Skills: Data Room PlatformsExcelPowerPoint

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