Opportunity Awaits
Careers at NCP
(updated Dec 07, 2022)
Job Title:
Location: Tri-State Area
Date Posted: December 7, 2022
Posted December 7, 2022 The National Consumer Panel has an exciting opportunity available for a Junior Solutions Architect. Our office is in Syosset, New York, however remote employment is an option. Do you have experience with performance optimization and data modeling? Interested in putting your skills to work for a company that has been celebrated as one of the “Best Companies to Work for in New York” for 7 years in a row? The Junior Solutions Architect will work closely with the Architect Leader managing Server upgrades, troubleshooting issues, database querying and creating and maintaining T-SQL stored procedures. Qualified candidates are self-motivated and have 3-5 years demonstrable experience developing in T-SQL in Sybase ASE or SQL Server. The candidate will have experience in Data Modeling, OLTP and OLAP databases. Experience reading source code in Objective –C, Java, Python is also required. The ideal candidate produces results, takes initiative, has strong analytical, communications, problem-solving skills, and can work effectively as a team member. The candidate must be comfortable interfacing with internal clients and have the ability to convey technical terminology to nontechnical audiences. • Gain an understanding of NCP’s infrastructure components and then assist in managing the Server Upgrade and replacement process by partnering with Hosting team members to execute on new server installation and setup and other maintenance tasks. • Assist in troubleshooting efforts for issues with Database, Java web services, CRM, AWS, and other technologies and platforms used by NCP. • Perform advanced database querying to analyze and troubleshoot data issues and business issues related to the databases. • Create Analysis and Design documents and associated project documentation. • Create and maintain T-SQL stored procedures and advise other developers on creating complex and efficient SQL queries. • BA/BS degree or equivalent work experience • Experience with performance optimizations such as improving scalability, availability, throughput, failover, etc. in databases. • Experience in Data Modeling, OLTP and OLAP databases. • 3+ years’ experience developing in T-SQL in Sybase ASE or SQL Server. • Must be able to read source code in languages other than SQL (e.g., Objective-C, Java, Python) and understand & interpret the code. • Experience with writing high quality, testable, maintainable, and well documented code. • Experience in writing Unix shell scripts. • Experience with Cloud based database technologies (Redshift, Aurora, Azure Data, Postgres). • Familiarity with database/ETL tools (e.g., Linux, RedShift, SQL, Talend) a plus • Knowledge of web service integration technologies (REST, SOAP, JSON, XML). • Experience of using JDBC and other database connection technologies with Java • Familiar with defect tracking software, networking troubleshooting • Familiar with Windows and Linux server administration. • Familiar with version control (Git/Subversion) and branching strategies • Experience conducting design and code reviews with the Development teams. • Familiar with ETL tools, e.g. Talend • SQL Certification • Ability to work with both business users and development teams. • Self-starter with excellent analytical, communication, and problem solving skills • Ability to facilitate a highly collaborative and productive work environment • Ability to multi-task in a fast-paced environment • Independent worker Jane SlaterIn the Junior Solutions Architect role, you will:
Required knowledge/skills:
Additional knowledge/skills preferred:
Tools/Certifications Preferred:
Competencies:
Contact
Director, Human Resources
[email protected]
(516) 682-6086
Job Title:
Location: Tri-State Area
Date Posted: December 7, 2022
Posted December 7, 2022 The National Consumer Panel has an exciting opportunity available for a Business Intelligence Analyst on our Data Science Team. Our office is in Syosset, New York, however remote employment is an option. Are you skilled at developing data-driven solutions and using analytics to recommend best practices? Do you have experience with business intelligence and analytics tools? Interested in putting your skills to work for a company that has been celebrated as one of the “Best Companies to Work for in New York” for 7 years in a row? The Business Intelligence Analyst actively works as part of a small data science team, often in collaboration with a cross-functional team to support the operations of NCP’s consumer market research panel. Data Science initiatives include data handling, analytics and reporting of findings to support business objectives. • Work closely with Data Science VP/team and other subject matter experts (SMEs) to develop data-driven business solutions and deliver value-added insights • Use a range of analytics to answer internal and external client inquiries and recommend best practices to implement • Track key performance indicators (KPIs) to maintain high quality panel market research data • Monitor and interpret data trends and accuracy via panel dashboards / visualizations • Raise concerns with Data Science team and cross-functional stakeholders as needed • Conduct statistical and other analyses including: • Proficiency in one or more business intelligence / analytics tools such as Tableau, Rapid Miner, R or equivalent • Experience with MS Excel, Word and PowerPoint • Skilled at managing and analyzing data sets of various sizes • Excellent analytical and problem-solving skills • Effective organizational, communication and interpersonal skills • Possesses a curious mindset and is attentive to detail • Ability to work independently and interact effectively in team environments • Capacity to work on multiple projects while managing changing priorities • Familiarity with database/ETL tools (e.g., Linux, RedShift, SQL, Talend) a plus • BA/BS, MS/MBA preferred • 1-3 years of quantitative analysis work (and/or grad school) experience Jane SlaterIn the Business Intelligence Analyst role, you will:
Required knowledge/skills:
Qualifications we are looking for:
Contact
Director, Human Resources
[email protected]
(516) 682-6086