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.

In the Junior Solutions Architect role, you will:

• 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.

Required knowledge/skills:

• 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

Additional knowledge/skills preferred:

• 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

Tools/Certifications Preferred:

• SQL Certification

Competencies:

• 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

Contact

Jane Slater
Director, Human Resources
[email protected]
(516) 682-6086

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.

In the Business Intelligence Analyst role, you will:

• 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:

• incentive program effectiveness & cost efficiency evaluations
• test vs. control sample comparisons
• forecast modeling
• panelist recruitment and retention optimization
• exploratory data mining

Required knowledge/skills:

• 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

Qualifications we are looking for:

• BA/BS, MS/MBA preferred

• 1-3 years of quantitative analysis work (and/or grad school) experience

Contact

Jane Slater
Director, Human Resources
[email protected]
(516) 682-6086