Database Programmer / Analyst

Database Programmer, Database Analyst, data analysis, data modeling, Oracle, SQL Server, SSIS, Data Warehouse, Data Governance environments, Business operations, Business process, Computer science, Data validation, Data mapping, ETL, Microsoft SSIS, Decision-making, Information systems, Presentations, Scripting, SQL, Physical data model, Privacy, Quality improvement, IMPACT, Meta-data management, Conceptualization, Data extraction, RDBMS, QA, PL/SQL, Agile, Data governance, System implementation, Statistical models, Creativity, Transformation, Migration, SOW, System requirements, Taxonomy, Security, Modeling, Database, IT
Contract W2, Contract Independent, Contract Corp-To-Corp, 12 Months
$70 - $80
Work from home available

Job Description

Title : Database Programmer / Analyst

Location: Philadelphia 
 
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.
Skills/experience of the assigned staff: Required
  • 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.
About Us:
 
Tri-Force is one of the fastest growing companies in Philadelphia region by receiving the award 5 times and 3 times(Ranked #931 2021) on Inc. 5000 fastest growing companies in the USA. Tri-Force Consulting Services, Inc. is an established consulting services firm offering innovative solutions to Government and Commercial sectors. We specialize in building customized software applications solutions such as knowledge management systems, business intelligence, data analysis, database support and maintenance, data warehouse implementation and support, systems architecture and systems integration for our clients. Our technical competencies are in Java, .NET, SharePoint, PHP, Business Intelligence (Cognos, Data Warehouse), mobile applications platforms (iPhone, iPad, Android, Blackberry), and various other technologies. We also specialize in providing resources to manage infrastructure projects.  Tri-Force is one of the fastest growing companies in Philadelphia region by receiving the award 5 times and 2 times on Inc. 5000 fastest growing companies in the USA.
Dice Id : 10115907
Position Id : 7127541
Originally Posted : 1 month ago
Have a Job? Post it

Similar Positions

Database Programmer / Analyst
  • Powersolv
  • Philadelphia, PA, USA
Help Desk Analyst
  • Tri-Force Consulting Services Inc
  • Philadelphia, PA, USA
Full Stack Developer
  • Tri-Force Consulting Services Inc
  • Philadelphia, PA, USA
Data Support Analyst - Remote
  • Proactive Staffing
  • Philadelphia, PA, USA
Data Analyst
  • iTech Solutions
  • Conshohocken, PA, USA
Power BI Architect (NJ)
  • NSD International, Inc.
  • Jamesburg, NJ, USA
Data Modeler
  • IT Trailblazers, LLC
  • Trenton, NJ, USA
ETL Developer, Contract
  • The Denzel Group
  • , NJ, USA
Data Analyst
  • TeamSoft
  • New York, NY, USA
Sr. ETL Developer (SQL, SSIS)
  • TVS Next Inc.
  • Teaneck, NJ, USA