Sr. Data AnalystProcom 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), Permanent Placement (Staff Augmentation), ICAP (Contractor Payroll), Flextrack (Vendor Management System).Job DescriptionA 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 policiesResponsible 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 measuresValidate new datasets for completeness and correctnessCoordinate acceptance testing and production roll-outProvide custom datasets for analysis and ad hoc reportingParticipate in control reporting and data governance developmentHelp to enforce data integrityResearch and document data mapping from source to target systemsAssist with data modeling as necessaryWork 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.QualificationsPLEASE 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 plusMinimum 5 years' experience working with Oracle, SQL Server Databases, and SQLMinimum 5 years of experience gathering business requirementsExperience in both design and develop of enterprise level operational and data warehouse database systemsExperience in both design and develop of enterprise level operational and reporting systems and dashboardsStrong database design experience and experience with data modeling tools like Erwin etc.Experience leading design sessionsExperience leading business requirements sessionsMathematical background with knowledge of pricing, risk calculation, etc.Solid experience with SQL, R programming experience a plus.Excellent communication and presentation skillsMust be a self-starter that does not require direct supervisionHave a strong fundamental understanding of project management, specifically in the SDLC and Agile methodologiesHave expert level skills in Microsoft products that include Outlook, Word, Excel, PowerPoint, VisioExcellent written and verbal communication skills to enable them to:Facilitate meetings with technical peers regarding the requirements definitionCommunicate effectively with business, vendor, and project management staffParticipate in ongoing decisions regarding study design, data collection, data analysis, and methodologyAdditional InformationPLEASE NOTE THAT WE ARE NOT ABLE TO WORK WITH CANDIDATES ON H1B VISAS OR CANDIDATES REPRESENTED BY THIRD PARTIES.By clicking the link above or any third-party link within this posting, you are leaving this site and going to a third-party website where the third-party website's terms and privacy policy apply