Data Warehouse Specialist # 17501/200660
- Location
- Albany, NY · On-site
- Job type
- Contract
- Level
- Mid-level
- Education
- Bachelor's degree
- Listed
- Today
Skills & highlights for this role
- dimensional data modeling
- star schema
- SQL
- OBIEE
Also useful
- ErWin
- Oracle
- healthcare BI reporting
How well does your resume fit this job?
Upload your resume to see your score for this Maganti IT Resources LLC role, what matches, what's missing, and your best other matches.
Scored on our server and not saved there. The file stays in this browser so you don't have to upload it again after you sign up.
About the role
- Title: Data Warehouse Specialist # 17501/200660
- Location: Albany, NY
- Duration: 24 Months
Day to Day Tasks
The Data Modeler will participate in a team approach to
- Work with SMEs, BI Business Analyst and BI Technology team to understand the data requirements and the full attribute set for entities and dimensions;
- Convert business processes, domain specific knowledge, and information needs into a conceptual model;
- Convert conceptual models into logical models with detailed descriptions of entities and dimensions;
- Develop and maintain fully defined conceptual, logical and physical dimensional data model to ensure the information models are capable of meeting end user and OBIEE developer needs;
- Develop data models and data migration strategies utilizing sound concepts of data modeling including star schema, snowflake schema, etc
- Model aggregation layers and specific star schemas as subject areas within a logical and physical model
- Understand and meet referential data integrity requirements
- Document decisions made in meetings and alternative solutions discussed
Requested Qualification
- 60 Months Demonstrated hands-on experience with developing and maintaining logical and physical dimensional data models, building data migration strategies utilizing sound concepts of data modeling including star schema, snowflake schema, etc
- 60 Months Demonstrated hands-on proficiency in a data modeling tool (e.g, ErWin)
- 60 Months Demonstrated hands-on experience in relational data management disciplines and strong design and development experience using Oracle technologies
- 60 Months Demonstrated hands-on experience with SQL programming
- 60 Months In-depth hands-on experience with business intelligence tools (e.g.OBIEE 11G) which demonstrates a strong data analytics background
- 60 Months Demonstrated hands-on, in-depth understanding of how to design and create BI applications and health care business intelligence reporting solutions
- 36 Months Demonstrated analytics and communications experience (e.g., math, statistics, quantitative methods, and writing proficiency)
- Bachelors degree in business intelligence, information science, computer science, or mathematics
- A copy of the degree must be submitted with the Candidate Response Form
Additional Information
- Please note that we allow Skype/remote interviews. However we reserve the right to require an in-person interview.
- Please respond with updated resume and covering letter with few sentences how you meet each Requested Qualification referring your earlier projects
- 3 references are must with the resume.
From Maganti IT Resources LLC's careers page, first listed on Rolev.ai on November 19, 2026. Rolev.ai is not the employer.
How Rolev.ai helps with this application
Rolev.ai is a job search and application tool for US job seekers. For this Data Warehouse Specialist # 17501/200660 role at Maganti IT Resources LLC, it shows how your resume fits, tailors your resume to the posting, and prepares the application for you to review.
See how you fit
Openings from employer career sites are ranked against your whole resume—and searchable inside Claude, ChatGPT, and Cursor via Rolev.ai MCP.
Tailor without inventing
Every change to your resume is checked against your original. New experience goes in only with your yes—zero fabricated claims.
Draft the full kit
Tailored and Full Match resumes, role-specific cover letters, and answers to employer screening questions are prepared in seconds.
1-Click Extension Autofill
The Chrome extension fills the employer's Greenhouse, Workday, Lever, or Ashby form in 1 click. You review it and press Submit.
Common questions
Where is the Data Warehouse Specialist # 17501/200660 job at Maganti IT Resources LLC located?
This Data Warehouse Specialist # 17501/200660 position at Maganti IT Resources LLC is located in Albany, NY (On-site). Always check Maganti IT Resources LLC's application page for specific state eligibility or relocation policies.
What qualifications are required for Data Warehouse Specialist # 17501/200660 at Maganti IT Resources LLC?
For the Data Warehouse Specialist # 17501/200660 role, Maganti IT Resources LLC highlights a bachelor's degree; experience with dimensional data modeling, star schema, SQL, OBIEE. Rolev.ai can score your existing resume against these requirements and show any skill gaps before you apply.
How do I apply for the Data Warehouse Specialist # 17501/200660 position at Maganti IT Resources LLC?
This listing links directly to Maganti IT Resources LLC's SmartRecruiters application page. You can apply directly on Maganti IT Resources LLC's site, or use Rolev.ai to check your resume fit, generate a zero-hallucination tailored resume and cover letter for this posting, and autofill the SmartRecruiters application form in 1 click with the Rolev.ai Chrome extension. You always review the form and press Submit yourself.