Database Warehouse Analyst designs and supports data warehouse systems, maintenance processes, and projects. Designs and writes code for ETL data solutions. Being a Database Warehouse Analyst plans and executes data warehouse implementations following system requirements and anticipated usage. Performs data extraction, ensures data accuracy, troubleshoots, and resolves bugs during data warehouse operations. Additionally, Database Warehouse Analyst analyzes business intelligence data and designs and generates reports. Understands and utilizes ETL tools like Informatica and programming languages like Python. Acts as liaison between information technology and business units. Requires a bachelor's degree. Typically reports to a manager. The Database Warehouse Analyst work is closely managed. Works on projects/matters of limited complexity in a support role. To be a Database Warehouse Analyst typically requires 0-2 years of related experience. (Copyright 2024 Salary.com)
Location: PA-Philadelphia, Hybrid 3-4 days on site
Overview: Every Turnberry consultant belongs to a practice, an internal group of consultants and leaders with shared experience and expertise. Each of these practices aligns to one of the eight core services Turnberry offers to clients. As a Database Analyst, you will join Turnberry's Data & Insights practice and service. Turnberry's Data & Insights service helps clients who seek visibility into company data, lack a single source of truth for accurate data, desire advanced analytics solutions, have data governance needs to ensure data quality, or have specific data challenges that may require an assessment, proof of concept, or custom solution not available in a typical out-of-the-box analytics methodology.
Responsibilities:
Design, model, develop, and support Database Management Systems DBMS
Analyze data requirements application and process architectures data dictionaries and database schemas
Design, develop, amend, optimize, and certify database schema design to meet systems requirements
Gather, analyze, and normalize relevant information related to and from business processes functions and operations to evaluate data credibility and determine relevance and meaning
Develop database and warehousing designs across multiple platforms and computing environments
Develop an overall data architecture that supports the information needs of the business in a flexible but secure environment
Qualifications:
Bachelor's Degree in Computer Science Information Systems or other related field orr equivalent work experience
8 years of IT work experience in DBA DBMS design and support and relevant computing environments
MS Powerpoint Intermediate, Oracle Financials, Project Planning
The salary range for this role is $80,000 to $160,000 or the hourly equivalent. Pay is based on several factors including but not limited to education, work experience, certifications, etc. In addition to your salary, Turnberry Solutions offers benefits such as a comprehensive healthcare package (medical, dental, vision), disability and group term life insurance, health and flexible spending accounts, a utilization bonus, 401(k) with match, flexible time off for salaried employees, parental leave for salaried employees, and flexible work arrangements (all benefits are subject to eligibility requirements). No matter where or when you begin a career with Turnberry, you'll find a far-reaching choice of benefits and incentives.
At Turnberry, inclusion is one of our core values. We are fully invested in and focused on hiring and growing a diverse team of high performers. We're committed to creating a positive and connected work environment for all. We believe that uniqueness in ideas, experiences, and backgrounds make us a better Turnberry: Turnberry is an Equal Employment Opportunity/Affirmative Action employer, and recruits, employs, trains, compensates, and promotes regardless of age, ancestry, family medical or genetic information, gender identity and expression, marital, military, or veteran status; national and ethnic origin; physical or mental disability; political affiliation; pregnancy; race; religion; sex; sexual orientation; and any other protected characteristics.
Summary: The Database Analyst will be responsible for developing financial reporting dashboards and creating and maintaining integrated database systems. The ideal candidate will have a strong backgro...
Job Title: PLC Programmer Location: Pittsburgh, PA Job Description: Minimum of 5 years of experience in PLC programming, preferably in an industrial automation environment. Proficiency in programming ...
Job Title: Maintenance Technician Location: Phoenixville, PA Type: Full-Time Direct Hire Industry: Healthcare / Health Services Job Category: Medical / Health – Maintenance Day shift hours 7:00 AM to ...
Job Description:The primary function of this position is to support and perform complex database services related to DEXIS products, by answering customer questions or resolving issues in a support ce...
Pennsylvania (/ˌpɛnsɪlˈveɪniə/ (listen) PEN-sil-VAY-nee-ə), officially the Commonwealth of Pennsylvania, is a state located in the northeastern and Mid-Atlantic regions of the United States. The Appalachian Mountains run through its middle. The Commonwealth is bordered by Delaware to the southeast, Maryland to the south, West Virginia to the southwest, Ohio to the west, Lake Erie and the Canadian province of Ontario to the northwest, New York to the north, and New Jersey to the east.
Pennsylvania is the 33rd-largest state by area, and the 6th-most populous state according to the most recent of...
Source: Wikipedia (as of 04/11/2019). Read more from Wikipedia
Income Estimation for Database Warehouse Analyst jobs
$67,045 to $85,976
Most Popular Cities in Pennsylvania for Database Warehouse Analyst Jobs