Data & BI Analyst jobs

208642 / Sr. Data Analyst

Procom ServicesNew York, NY

Pay not listed

Key facts

Experience
6+ years
US visa
No US visa sponsorship

2 things to check before you apply.

On Procom Services’ own careers site (SmartRecruiters), checked open today.

  • To check: Posted by the employer 11 years agoLong-open jobs are sometimes already filled. Ask when they plan to hire.
  • To check: No pay range listed, though one is likely required in NYAsk for the pay range before you interview. The law here likely requires one.
  • Checked: On the company's own careers siteSmartRecruiters board
  • Checked: Checked open todaySmartRecruiters board
  • Checked: No reposts foundSmartRecruiters board
  • Trust score 55 / 100 · Check details
See all 6 checksShow fewer
How we check

What you’ll do

  • Gather and analyze application data requirements with business stakeholders and technical teams; prepare BRDs/SRDs.
  • Design, build, tune, maintain, and test database and data warehouse solutions, models, and data structures.
  • Profile and validate datasets; define data dictionaries, transformation rules, integration requirements, and source-to-target mappings.
  • Coordinate acceptance testing and production rollouts, review test plans and data, and support performance and data integrity.

Summarised from the posting by AI and can be wrong. The full description is the source.

Requirements

Experience

  • At least 6–8 years of experience in data analysis
  • Minimum 5 years’ experience working with Oracle, SQL Server databases, and SQL
  • Minimum 5 years of experience gathering business requirements
  • Experience designing and developing enterprise-level operational and data warehouse database systems
  • Experience designing and developing enterprise-level operational and reporting systems and dashboards
  • Strong database design experience and experience with data modeling tools such as Erwin
  • Experience leading design sessions and business requirements sessions
  • Mathematical background with knowledge of pricing and risk calculation
  • Fundamental understanding of project management, SDLC, and Agile methodologies
  • Experience in the securities or financial services industry (preferred)

Skills

  • Expert-level skills in Microsoft Outlook, Word, Excel, PowerPoint, and Visio
  • R programming experience (preferred)

Other requirements

  • Must not be a candidate on an H1B visa
  • Must not be represented by a third party

Your match

Sign in and add your resume to see which of this job's requirements it shows.

Sign in to check your match

Saved to your account, encrypted. The AI that reads it doesn't keep it or train on it.

Full job description

From Procom Services’ careers site

Company Description

Procom is a leading provider of professional IT services and staffing to businesses and governments in Canada.

With revenues over $500 million, the Branham Group has recognized Procom as the 3rd largest professional services firm in Canada and is now the largest “Canadian-Owned” IT staffing/consulting company.

Procom’s areas of staffing expertise include:

  • Application Development
  • Project Management
  • Quality Assurance
  • Business/Systems Analysis
  • Datawarehouse & Business Intelligence
  • Infrastructure & Network Services
  • Risk Management & Compliance
  • Business Continuity & Disaster Recovery
  • Security & Privacy

Specialties• Contract Staffing (Staff Augmentation)

Show full descriptionShow less
  • Permanent Placement (Staff Augmentation)
  • ICAP (Contractor Payroll)
  • Flextrack (Vendor Management System)

Job Description

A senior data analyst is required to develop, design, construct, and maintain data structures, models and physical databases. The data analyst will collaborate across stakeholders (product managers, project managers, business analysts, and testers) to elicit and analyze requirements. The analyst will analyze, design, tune, maintain and test data and database solutions.

  • Meet with business stakeholders and other technical team members to gather and analyze application data requirements.
  • Design and build data solutions to satisfy application (business and technical) requirements.
  • Perform data analysis where requirements need to be derived from available documentation, user interviews, and file specifications/samples.
  • Perform data analysis activities (data profiling, creation of data dictionaries, data transformation rules, integration requirements)
  • Support and apply data standardization policies
  • Responsible for requirements gathering and BRD/SRD preparation.
  • Has thorough knowledge of the Software Development Life Cycle.
  • Conducts reviews of the test Plan and test Data.
  • Ensures that expected application performance levels are achieved.
  • Contributes to defining time tables and project plans.
  • Analyze and document upstream financial and risk measures
  • Validate new datasets for completeness and correctness
  • Coordinate acceptance testing and production roll-out
  • Provide custom datasets for analysis and ad hoc reporting
  • Participate in control reporting and data governance development
  • Help to enforce data integrity
  • Research and document data mapping from source to target systems
  • Assist with data modeling as necessary
  • Work closely with Project Management, Data Architects, Data Modelers, other analysts and ETL Development Team to design and implement the requirements for the Enterprise Data Warehouse.
  • Work closely with business users to verify data requirements and access needs.
  • A senior data analyst is required to develop, design, construct, and maintain data structures, models and physical databases. The data analyst will collaborate across stakeholders (product managers, project managers, business analysts, and testers) to elicit and analyze requirements. The analyst will analyze, design, tune, maintain and test data and database solutions.
  • Meet with business stakeholders and other technical team members to gather and analyze application data requirements.
  • Design and build data solutions to satisfy application (business and technical) requirements.
  • Perform data analysis where requirements need to be derived from available documentation, user interviews, and file specifications/samples.
  • Perform data analysis activities (data profiling, creation of data dictionaries, data transformation rules, integration requirements)
  • Support and apply data standardization policies
  • Responsible for requirements gathering and BRD/SRD preparation.
  • Has thorough knowledge of the Software Development Life Cycle.
  • Conducts reviews of the test Plan and test Data.
  • Ensures that expected application performance levels are achieved.
  • Contributes to defining time tables and project plans.
  • Analyze and document upstream financial and risk measures
  • Validate new datasets for completeness and correctness
  • Coordinate acceptance testing and production roll-out
  • Provide custom datasets for analysis and ad hoc reporting
  • Participate in control reporting and data governance development
  • Help to enforce data integrity
  • Research and document data mapping from source to target systems
  • Assist with data modeling as necessary
  • Work closely with Project Management, Data Architects, Data Modelers, other analysts and ETL Development Team to design and implement the requirements for the Enterprise Data Warehouse.
  • Work closely with business users to verify data requirements and access needs.

Qualifications

  • PLEASE NOTE THAT WE ARE NOT ABLE TO WORK WITH CANDIDATES ON H1B VISAS OR CANDIDATES REPRESENTED BY THIRD PARTIES.
  • Must have at least 6-8 years of experience in data analysis. Experience in the securities or financial services industry is a plus
  • Minimum 5 years’ experience working with Oracle, SQL Server Databases, and SQL
  • Minimum 5 years of experience gathering business requirements
  • Experience in both design and develop of enterprise level operational and data warehouse database systems
  • Experience in both design and develop of enterprise level operational and reporting systems and dashboards
  • Strong database design experience and experience with data modeling tools like Erwin etc.
  • Experience leading design sessions
  • Experience leading business requirements sessions
  • Mathematical background with knowledge of pricing, risk calculation, etc.
  • Solid experience with SQL, R programming experience a plus.
  • Excellent communication and presentation skills
  • Must be a self-starter that does not require direct supervision
  • Have a strong fundamental understanding of project management, specifically in the SDLC and Agile methodologies
  • Have expert level skills in Microsoft products that include Outlook, Word, Excel, PowerPoint, Visio
  • Excellent written and verbal communication skills to enable them to:
  • Facilitate meetings with technical peers regarding the requirements definition
  • Communicate effectively with business, vendor, and project management staff
  • Participate in ongoing decisions regarding study design, data collection, data analysis, and methodology

Additional Information

PLEASE NOTE THAT WE ARE NOT ABLE TO WORK WITH CANDIDATES ON H1B VISAS OR CANDIDATES REPRESENTED BY THIRD PARTIES.

Something wrong with this job? Report it · This flag looks wrong

Similar jobs nearby

Data Analyst III

Fanatics Betting & Gaming · New York, NY

$130k–$150k/yr

StrongChecked open todayPosted 8 days ago

Customer Data Analyst

L'Occitane En Provence · New York, NY

$75k–$85k/yrFull-time

StrongChecked open todayPosted 16 days ago

Senior Data Analyst

Known · New York, NY

$90k–$110k/yrHybrid

StrongChecked open todayPosted 25 days ago

See more like this