One of our premier clients is looking for a Senior Data Modeler in Trenton, NJ for a Contract position. If interested, please submit your resume ASAP indicating (1) current location (2) desired hourly rate (3) Your email address.
JOB DESCRIPTION: Senior Data Modeler (SDM) Specialist will be responsible for the design, develop & implementation of Data Warehouse database structures and Analytical Database structures. SDM will work with Business groups and Application Teams during pre & post assessment periods. The SDM reports to Supervisor/Team Lead. DSM should be able to write complex SQL’s ,write and execute Stored Procedures for analysis for data . SDM should understand the needs of the Business team and BI team for building proper Data Warehouse and DataMart. Should be capable of developing structured and unstructured data model for BI and Analytics.
RESPONSIBILITIES:
Understand and translate business needs into data models supporting long-term solutions for different Judiciary systems.
Work with the Application Development teams (ex: Pega Applications) to implement data strategies, build data flows and develop conceptual data models.
Create logical and physical data models using best practices to ensure high data quality and reduced redundancy.
Optimize and update logical and physical data models to support Data Initiative project for different phases of implementation.
Develop best practices for standard naming conventions and coding practices to ensure consistency of data models.
Recommend opportunities for reuse of data models in new environments.
Perform reverse engineering of physical data models from databases like DB2 and SQL scripts.
Evaluate data models and physical databases for variances and discrepancies across the different source systems in Judiciary.
Analyze data-related system integration challenges and propose appropriate solutions and develop the model according to Judiciary Standards.
Work with all IT teams like System Analysts, Engineers, Programmers, BI and others on project limitations and capabilities, performance requirements and interfaces.
Review modifications to existing software to improve efficiency and performance.
Build logical data model and translate logical model into physical database.
Compare actual project procedures to the specified standards and procedures.
Demonstrate expertise with the most recent and relevant technologies in the data modelling implementation.
They must have excellent communication skills and possess the ability to collaborate with internal and external groups including vendors.
They must have the ability of working independently and with minimal supervision
REQUIRED SKILLS:
8+ years of experience in Data Modeling for Databases like DB2, AWS’ Redshift, Dynamo DB, Postgres, SQL Server, Pega Application.
Data modeling software (6 years)
AWS and Other Cloud systems experience is must.
Strong SQL and data profiling skills in various relational databases.
Analyzing source databases, source data, source database referential integrity and profiling source data (8 years)
Database tuning techniques (minimum 4 years)
Experience in building Data Lakes for both structured and unstructured data (2 years)
PagerDuty is looking for a strategic driven analyst to correlate goals to key performance indicators (KPIs), ensure tracking is set up to report and analyze, set up automated Tableau dashboards, run experimentation and a/b tests, and provide collaborative insights to internal stakeholders for performance reporting and optimization.
EY focuses on high-ethical standards and integrity among its employees and expects all candidates to demonstrate these qualities. At EY, you’ll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture and technology to become the best version of you. And we’re counting on your unique voice and perspective to help EY become even better, too. Join us and build an exceptional experience for yourself, and a better working world for all.