Technical Business Analyst – Jericho, NYPCH is looking for a Technical Business Analyst to join our team in Jericho, NY. The Technical Business Analyst will be responsible for business requirements documentation, designing system process flow as well as providing functional requirements for development teams. This technical business analyst is required to effectively communicate between end users and technical teams and be able to triage issues using tools like SQL.Responsibilities include but are not limited to:Develop business process models and documentation for compliance initiatives by working with business groups and technical teams.Effectively communicate and document business and IT information in line with agreed upon process/procedures.Conduct independent analysis and review requirements utilizing knowledge of business systems and requirements, with ability to supply alternative suggestions/improvements to requirementsPlay a crucial role as part of Data Governance team to develop, implement and maintain data strategies that ensure data quality, provide standardization and improve business information valueProvide data stewardship support of company wide data from any/all sources into new Hadoop data lakeConvert business rules from subject matter experts into technical rules for ETL processes and data quality analysisWork with, develop and update workflows utilized MDM tools (Talend, Informatica, Collibra) for CCPA, compliance and data quality initiativesWork in a consultative manner with the business to design and define the entities, attributes, relationships, data matching rules, data model & workflows necessary to support business data flow, test analysis and enterprise KPI development.Help maintain/improve upon Data Management Policy and Data Governance Framework via standards and procedures.Must-Have Skills/Experience:Bachelor's degree in Information and Data Management or related field2-5 years' experience in a Business Analyst type roleStrong SQL skills.
Ability to write SQL to query complex data structuresStrong business requirements documentation skills. Ability to assess the needs of users and translate these into accurate and accessible reportsExcellent understanding of data and data relationships/dependenciesDemonstrated ability to be proficient at querying and managing dataAbility to analyze data including comparing direct marketing metrics and factors to determine effectiveness of testsExperience using large databases to solve problemsConceptual and practical knowledge of data dimensions, facts, database architecture, etc.Excellent communication skills both written and verbalNice-To-Have Skills/Experience:Experience with TableauExperience with MDM / Data Governance tools (Talend, Informatica, Collibra)Data Modeling and/or process data flow experienceExperience with implementation of Enterprise Data Governance and Master Data programsExperience working with Big Data