For more than 35 years, Luth Research has been advancing next generation consumer intelligence with innovative market research approaches. From survey research to digital tracking, as well as traditional focus group and call center services, our commitment to innovation and technology is driving change in the market research industry. Luth Research seeks team members that model our Core Values: Passionate and Driven, Delivering Excellence, Embracing and Driving Change, Career Growth and Development, and Keeping it Fun. Together, our vision is to connect millions of minds and devices worldwide to inspire business decisions.

Luth Research offers full benefits including medical, dental, vision, life, 401K, paid time off, paid holidays and a flexible and fun work environment

Luth Research seeks a SQL Developer & Database Analyst to serve as a liaison between the business users/research team and the database systems. This person will perform data extraction, analyze and understand the data in data warehouses, and obtain and transform business requirements into functional specifications that result in accurate and quality data output as well as ETL and Report program logic.

The SQL Developer & Database Analyst will be working in a fast paced demanding environment and will report directly to the Senior Executive Vice President of Luth Research.

If you have experience as a SQL Developer & Database Analyst and are interested in working collaboratively in a growth environment, apply to become part of our dedicated team today.

Essential Job Functions and Responsibilities:

• Extract, analyze, review and interpret data in existing databases to support projects for maximum data accuracy and reliability.
• Aggregate complex data sets into easily digestible data sets.
• Flag and resolve data issues, and solve data problems by interpreting SQL stored procedures that update our databases, and by analyzing/validating the data in our databases.
• Integrate data in different formats (e.g., csv, excel, etc.) into Luth’s Postgres SQL and Greenplum database systems with accuracy, efficiency and scalability.
• Create visualizations (charts, maps, etc) using various tools including Tableau, Excel and other BI interfaces.
• Define data quality plans to address data quality issues; work with business users to build business understanding of data issues.
• Perform data analysis with a deep and comprehensive understanding of Luth’s digital intelligence data collection technology, systems and customers.
• Create well-written, clear, concise and accurate document artifacts including functional specifications, mapping documents process diagrams test plans and test scripts for the purposes of data warehouse construction, report development, verification etc.
• Develop and provide superb communication skills in client management, project presentation, company product and service promotion, and team collaboration.
• Practice and demonstrate exemplary work ethics, self-motivation in learning and taking on new challenges to support sales for the company.
• Any special projects as requested by senior management.

Other Job Functions and Responsibilities:

• Commitment: Knowledgeable about market research, dedicated to the goals of the company while promoting a positive culture to ensure good relationships, overall satisfaction and profitability. 
• Accessibility: Must be able to access and function within areas key to productivity. Adequate manual dexterity to operate assigned and shared office equipment. Ability to travel on periodic overnight and extended stays, and work extended hours when necessary.
• Communications: Must speak clearly and fluently to communicate on a wide range of topics. Above average reading comprehension, and grammatically correct written communication skills. Must have the ability to understand and respond intelligently to business correspondence. Interpersonal skills as needed to persuade, manage conflict, debate and negotiate. Response to pressure should be calm and reasonable. 
• Technical: Must demonstrate a high proficiency in understanding and working with basic software and computer skills, to include Microsoft Outlook, Excel, PowerPoint and Word.
• Judgment: Comprehension of job requirements and procedures. Can initiate and perform work assignments under minimal supervision that may be broad, varied, and complex in nature. Employee must have the ability to use educated and intuitive judgment to make decisions.
• Flexibility: Must be able to work in a shifting environment with ability to juggle and prioritize multiple, competing tasks and demands and to seek supervisory assistance as appropriate.
• Analysis: Mathematical aptitude; use of numeric calculations for accuracy of reports and tasks.  
• Organization: Organizational and time management skills sufficient to plan and accomplish assigned goals. 
• Logic: Deductive reasoning ability to enable the appropriate application of general concepts to specific situations. Able to translate theory into business practices. Employee must apply experience, skills and information to identify problems and plan strategic resolutions.
• Work Ethics: Must be willing to work hard, be dependable and responsible, possess a positive attitude and maintain a sense of honesty and integrity. 
• Core Values: Luth Research and its employees are committed to our Core Values; Passionate and Driven * Delivering Excellence * Embracing and Driving Change * Career Growth and Development * Keeping it fun.

Education, Experience & Skills:

• BS or comparable work experience.
• 2-3 years of experience in IT as a Business Systems Analyst and or QA Analyst in a data warehouse environment, focusing on Data Quality.
• Solid understanding of SQL, stored procedures and ad-hoc query development in Postgres and Greenplum environments.
• UNION, INTERSECT, EXCEPT clauses.
• Nested SQL queries.
• Windowing queries (Postgres has a distinct flavor).
• Pivot queries (crosstab function).
• INNER, LEFT, and OUTER JOINs.
• EXPLAIN and how to interpret query plans.
• When/why indexes are useful.
• Compound indexes and query optimization for compound indexes.
• PgAdmin.
• Data loading and dumping.
• Foreign key constraints as they relate to data manipulation.
• Hashing for id generation.
• Understanding of triggers and functions.
• Comprehensive understanding of relational databases and the data in them.
• Ability to write requirements to extract data from existing databases, develop transformation rules based on business requirements gathered from non-technical people and test them.
• Understanding of digital media analytics and reporting is a plus.
• Experience with Data Conversions, Data Profiling and Root Cause Analysis a plus.
• Conceptual understanding of OLTP vs Data Warehousing.
• Experience using Business Objects, Tableau, Excel pivot tables.

Luth Research is committed to the principles of Equal Employment Opportunities and to making employment decisions based on merit and value. We will comply with all Federal, State and Local laws providing Equal Employment Opportunities, as well as all laws related to terms and conditions of employment.

All your information will be kept confidential according to EEO guidelines.