BI/ETL Developer

Stamford, CT-- 5 Days onsite - Local candidates only ( 35-40 miles radius)

This position is responsible for supporting and managing a program of business unit-focused initiatives designed to help business partners drive value from information. Contributes to client’s success by ensuring business needs and goals are realized through analysis and reporting activities of the Business Intelligence Group. Responsible for supporting the Manager or Director of Business Intelligence to empower client business leaders with concise, high-quality information, helping them leverage it to identify and address business opportunities and threats. Provides consultation on the interpretation of data to various business partners throughout the organization.

Actively and consistently support all efforts to simplify and enhance the customer experience

Provide advice and education in the usage and interpretation of business data relevant to the business unit

Communicate data nuances and insights to all levels of the company in a clear and concise manner

Instill best practices and assists users at all levels within the company on how to leverage BI capabilities for accurate reporting and analysis

Leverage knowledge of Business Intelligence capabilities and familiarity with business trends in identifying patterns, opportunities and threats

Work closely with business partners in gathering detailed business requirements, establishing business definitions, translating to technical requirements for development team and gaining approval

Interact with senior management or executive level customers and provides support as needed

Create report mock ups based on requirements and coordinates with technical team in finalizing design and receiving sign off

Support all scheduled and non-recurring information needs of the business users

Understand data elements in the warehouse at a very detailed grain to support any form of user needs from research to adhoc querying to managing large information projects

Query large datasets and tables comfortably to provide information requested by business users

Present data in a fashion that is easy to understand with proper documentation for successful user adoption

Manage detailed plans on small to medium sized projects to ensure successful completion

Maintain metadata dictionaries and report definitions

Work with cross functional teams to ensure alignment in business needs, timelines and department standards

Create test plans and scenarios and conducts testing to ensure quality and requirements traceability to final deliverable

Actively identify solutions to enhance the existing Business Intelligence infrastructure processes and technology

Required Skills

Ability to read, write, speak and understand English

Exceptionally strong communication skills both written and verbal

Proven experience and passion for leveraging data to drive business impact

Intermediate to advanced statistical knowledge and intuition ideally utilized in A/B or multivariate testing (or related analytics)

Advanced SQL skills

Experience with reporting/Business Intelligence tools is preferred (MicroStrategy, Teradata is a plus)

Ability to speak to large groups with excellent presentation skills

Ability to perform critical thinking in the area of data analysis with advanced analytical skills

Strong team and relationship building skills

High attention to detail and quality

Ability to work independently with minimal guidance, prioritize and organize effectively and manage multiple projects/assignments

Ability to perform in a fast-paced environment

Project management skills

Ability to understand complex business processes, rules and gain business acumen to become subject matter expert

Experience with data visualization standards and techniques to visually summarize data and insights is a plus

Expertise with BI Data Modeling concepts such as Star/Snowflake Schema, Dimensions and Facts