Technical Business Analyst

Technical Business Analyst Jericho, NY

PCH 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 requirements
• Play 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 value
• Provide data stewardship support of company wide data from any/all sources into new Hadoop data lake
• Convert business rules from subject matter experts into technical rules for ETL processes and data quality analysis
• Work with, develop and update workflows utilized MDM tools (Talend, Informatica, Collibra) for CCPA, compliance and data quality initiatives
• Work 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 field
• 2-5 years' experience in a Business Analyst type role
• Strong SQL skills. Ability to write SQL to query complex data structures
• Strong business requirements documentation skills. Ability to assess the needs of users and translate these into accurate and accessible reports
• Excellent understanding of data and data relationships/dependencies
• Demonstrated ability to be proficient at querying and managing data
• Ability to analyze data including comparing direct marketing metrics and factors to determine effectiveness of tests
• Experience using large databases to solve problems
• Conceptual and practical knowledge of data dimensions, facts, database architecture, etc.
• Excellent communication skills both written and verbal

Nice-To-Have Skills/Experience:

• Experience with Tableau
• Experience with MDM / Data Governance tools (Talend, Informatica, Collibra)
• Data Modeling and/or process data flow experience
• Experience with implementation of Enterprise Data Governance and Master Data programs
• Experience working with Big Data