Bi Data Functional Consultant - Etl, Talend, Alteryx, Marketo, Tableau

Temporary - Business Intelligence Data Engineer (Job Number: 230260)

BI Data Functional Consultant - ETL, Talend, Alteryx, Marketo, Tableau

Description

Job Summary

The overall purpose of this position is to support business and data-related initiatives taken on by the department. The incumbent in this position is expected to play an active role in the support, design, and implementation of data repositories, data pipelines, applications, and APIs that enable innovative and optimal ways of utilizing CLIENT data in the Enterprise Data Warehouse and the Adobe Marketo Engage application. The role would be ideally suited for a competent Data Engineer who is looking to move into data ingestion pipelines, data visualizations, and data analytics applications.

You are responsible for responding to incoming requests for data services and recommending solutions with respect to target lists.

You will apply your passion for detail and understanding of business data and data architecture to providing data-based solutions to address various use cases presented by our customers.

Superior Service delivery requires a conceptual understanding of business ownership of various customer departments as well as an ability Co verify and validate results.

Service delivery is managed through our team activity tracking system.

Your work is largely directed at incoming requests from customers. Proposed solutions and resolution delivery are observable by email cc and the request management system. Work volume is self-managed and in collaboration with peers and their managers.

This role has no reports.

The successful candidate will work under supervision and should be a self-starter with good technical, analytical, and problem-solving skills and a passion for learning and adopting innovative technologies to support business needs efficiently. The candidate should also have strong skills in communication and collaboration with peers and internal customers.

Key Responsibilities

Respond to work requests that result in carefully constructed Business Intelligence reports, target lists, ad hocs, and counts based on internal customer needs.

Perform data querying and validating functions.

Write general queries, views, stored procedures, and functions.

Provide best practices support and guidance to end users regarding usage of data output.

Collaborate with business stakeholders and internal customers to understand their needs and define or enhance reporting requirements.

Demonstrate outstanding communication skills to translate reporting requests in order to accurately meet the actual information and deadline needs of users.

Analyze data in the data warehouse and related sources to establish knowledge of data for accurate retrieval and use in data outputs.

Assist in troubleshooting and facilitating solutions for data issues.

Design, develop, and deploy visualizations built using the Tableau business intelligence tool.

An ability to grasp the fundamentals of converting data that is not natively intuitive and converting or "wrangling" it into a usable format.

Understanding of data warehousing concepts such as data migration and data integration in cloud platforms such as AWS and Azure.

Excellent data troubleshooting skills.

Ability to draft simple business documents describing processes, data investigation results, and confirmation of business requests involving data.

Ability to describe challenges and solutions in both technical and business terms.

Ability to develop and maintain excellent working relationships at all organizational levels.

Qualifications

Education

Bachelor's degree or equivalent experience in Computer Science, Mathematics, Engineering, or similar discipline preferred. Req

Work Experience

· 2 to 4 years of Relevant experience with data structures, queries, and BI tools such as Tableau, QlikView, Cognos, Python, SQL, etc. Req

· 2 years of Basic understanding of analysis and/or data ETL tools. (Ability to question and evaluate data quality in reports. Req

· 2 years of Familiarity with relating data from different and disparate data sources. Plus

· 4 years of Experience with data visualization tools. Plus

· 2 years of Experience in a collaborative Agile environment. Pref

Skills and Requirements

· Advanced Excel skills

· Solid MSWord, PowerPoint, Visio (for workflow documentation), and Google skills

· Solid presentation, public speaking, and communication skills

· Solid analytic, problem-solving, conceptual, and data interpretation skills

· Strong written and verbal communication skills including the ability to communicate complex information effectively to technical and non-technical users.

· Demonstrated understanding of business intelligence best practices

· Ability to work successfully in a team environment and independently, effectively handling detail-oriented work while meeting schedules and deadlines.

· Ability to prioritize and manage time effectively, thrive in a fast-paced work environment, and manage multiple projects simultaneously.

· Ability to take ownership and initiative on projects.

· Exhibits professional demeanor, interpersonal skills, and excellent customer service

· Demonstrates a willingness and ability to learn and contribute.

· Must be a technologically and communications-savvy knowledge worker who seeks out technology solutions to business challenges and processes.

· Foundation in database technologies and related query languages.

Other Requirements:

Data cleansing, analysis, and visualization skills, with the ability to grasp complex data relationships and patterns.

Good communication skills, with the ability to understand complex business user requirements and present solutions clearly and concisely.

Demonstrable history of seeking, acquiring, and applying new skills and remaining current on emerging data engineering technologies.

Sound problem-solving and critical thinking skills

Key Skills required

• BDRS – Business and Data Related Service
• Data – Siebel, membership data
• Talend- ETL tool, Alteryx another ETL tool) and Tableau
• AWS redshift
• Marketo (marketing automation tool)
• Build queries within marketo with Alteryx(drag and drop Scenario)
• Internal customers to ticketing system (with internal co-ordination)
• Campaign team
• Data Privacy

Soft Skills

• Collaboration
• Concentration - Understand the business purpose
• Communication
• Consult and Recommend
• Strategic Thinking

Requited technical skills

• Cleaning messy data
• Data solutions for business objectives
• Data visualization in must Tableau (power BI, Qulik view is also good)
• ETL tool is a plus (Informatica, Alteryx, Talend)
• SQL hands on is must
• Any marketing tools is a plus (Marketo, MailChimp, constant contact)
• ODBC connector is good enough (AWS redshift)

Other Details

• Technical and Non Technical split (50/50 Data/Business mix)
• Techno - Functional - Business consultant
• Prefer somebody near NJ (not NY city or PA)

Soft Skills required

• Collaboration
• Concentrated on business purpose
• Communication
• Consult and Recommend
• Strategic Thinking