Database Programmer / Analyst

Database Programmer / Analyst

07 Nov 2024
Pennsylvania, Philadelphia, 19136 Philadelphia USA

Database Programmer / Analyst

Vacancy expired!

Position overview / Statement of Work

  • The Database Programmer / Analyst is responsible for identifying, capturing, and analyzing the agency's data, contributing to better data decision-making.
  • He/she performs data analysis, including conceptualization, modeling, and presentation of data.
  • The Database Programmer /Analyst participates as a project member of system implementation initiatives, advising the team on aspects of data usage, taxonomy, migration, profiling, quality improvement, transformation, and dependencies of data-related tasks to the broader program.
Work activities
  • Analyze, design, and create SQL code scripts to extract, transform, load data into Oracle or SQL Data database.
  • Document metadata definitions and data base entity definitions.
  • Perform data mapping analysis between data sources and targets, construct, and test SSIS ETL packages.
  • Understands and applies information and data analysis requirements
  • Works with open datasets, including populating and extracting data from internal and public open datasets.
  • Cleans and prunes data to discard irrelevant information.
  • Develops procedures for data validation, analysis, and presentation.
  • Implements statistical models to identify and reveal trends, patterns, and relationships in data to provide guidance to others for decision making processes.
  • Supports innovative efforts by driving creativity, acting with agility, and thinking outside current boundaries.
Required Skills/experience of the assigned staff:
  • Bachelor's degree or in Computer Science, Information Systems, Business, or other related field. Or equivalent work experience.
  • Typically requires 5-10 years of relevant technical and business work experience.
  • Experience in an agile environment.
  • Experience in using Oracle, SQL Server and SSIS.
Preferred Knowledge & Skills
  • Requires in-depth knowledge of business operations, systems requirements and IT processes and technologies.
  • Demonstrated ability to perform data analysis identifying, analyzing and interpreting trends or patterns in structured and unstructured complex data sets.
  • Strong understanding of how data is used within business processes and its impact on desired business process outcomes.
  • Awareness of the security, privacy, and quality requirements for critical data entities.
  • Ability to assist in resolving the different points of view and requirements that invariably collide during cross-team and cross-organization efforts.
  • Demonstrated ability to use/leverage spreadsheets and databases.
  • Strong knowledge of relational databases, data extraction, querying, and scripting.
  • Demonstrated ability to interpret trends or patterns in structured and unstructured complex data sets.
  • Demonstrated ability to summarize findings, draw conclusions and put together presentations for a wide variety of audiences.
  • Applies original thinking to produce new ideas and innovate.
  • Experience in Data Warehouse and Data Governance environments
  • Demonstrated knowledge in logical and physical data modeling

Related jobs

  • Effectv helps businesses reach the right audience with the right message at the right time. We harness the scale and quality of Comcast data to target advertisers’ audiences across linear TV, streaming, and video on demand and enabling clients to evaluate performance. A division of Comcast, we have a presence in 60+ markets and an estimated reach of 96 million U.S. adults that include both Comcast and non-Comcast households.

  • Reference #: 126425-1 We are excited to bring on a new Technical Support Analyst to join our growing team at Clarivate! As first point of contact for North America, you will be responsible for all inbound customer inquiries and providing expertise to customers, distributors, and internal stakeholders. As a key member of the team, your main purpose is to diagnose and resolve both technical and product functional inquiries or to handle implementation requirements for new customers, including customer training. You will be responsible for proactive, seamless customer service in response to client service requests received via multiple channels (telephone, e-mail, chat) for Primo. By collaborating internally with regional departments, you will deliver exceptional service by investigating, reporting, and documenting customer issues and/or enhancement requests while ensuring that both internal and external stakeholders are updated as appropriate. You will be working closely with senior team members, and actively participate in discussions to optimize the customer experience. If this sounds like an opportunity you are interested in, then we would love to talk to you!

  • Reference #: 21982423 Client Summary: Our Client has been the birthplace for countless breakthroughs and dramatic firsts in pediatric medicine. Built on a foundation of delivering safe, high-quality, family-centered care, the Hospital has fostered medical discoveries and innovations that have improved pediatric healthcare and saved countless children\'s lives.

  • What We\'re Looking For

  • Description

  • Description

  • Reference #: R2949 Morgan, Lewis & Bockius LLP, one of the world\'s leading global law firms with offices in strategic hubs of commerce, law, and government across North America, Asia, Europe, and the Middle East, is seeking to hire a Business Operations Analyst to support the daily business operations, financial management and strategic vision of our Practice leadership team.

Job Details

Jocancy Online Job Portal by jobSearchi.