Senior Consultant - Data Engineering

Location: Austin, TX
Job Type:

IQ Workforce is a leading recruiting firm for the analytics community. We are working with one of the fastest growing consulting companies in the world on this interesting role. This is a client-facing role within their global digital business, which has over 3500 employees globally.

In this role you will have a big impact on helping Fortune 500 companies compete more effectively in their digital businesses.

Responsibilities:

Document, assess, influence and synthesize business requirements to develop, enable and advance data engineering & data infrastructure capabilities

Design future-state architectures of their data platforms enabling analytical intelligence and then play a role to implement a roadmap to reach that state

Work with business partners in cross functional teams to assist with data-related technical issues and support their data infrastructure needs

Collaborate with development teams to create data tools for analytics and data sciences

Contribute to new business pilots/proposals and products/solutions development

Collect requirements and inputs from client stakeholders to define objectives and processes. Define interdependencies across multiple organizations, understand risks and develop mitigation plans and data models

Successfully develop and take ownership of conceptual and logical architecture designs for Business Intelligence and Data Warehouse systems

Collaborate with Client Engagement Manager and delivery team to identify expansion opportunities within assigned customer accounts; this role does not have a business development requirement, but rather an entrepreneurial mindset to proactively identify unmet and unarticulated business problems while working with the client

Collaborate with multiple stakeholders and participate in meetings to define/identify business requirements and data mapping sessions to understand business needs

Requirements:

Significant professional experience in data management, data engineering, data infrastructure or relevant consulting experience for an enterprise scale company

Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as familiarity with a variety of relational databases. Teradata, NoSQL, Hadoop, Spark and R/Python experience is a plus

Experience with Data Cataloging, data lineage mapping and establishing best practices

Experience in establishing and successfully implementing Data Governance programs: heavy emphasis on developing and implementing data standards, policies, practices, and procedures that lead to substantive improvements in data quality

Masters in Information Systems or another technical discipline… or Bachelor’s degree with equivalent professional experience

Client-facing experience in managing analytical projects and teams

Successful history of manipulating, processing and extracting value from large disconnected datasets

Proficient in designing and scheduling complex SSIS packages for transferring data from multiple data sources and integrate data based on business logic and to load it in data warehouse

Experience in using various reporting or BI tools to create analytical dashboards that depict critical KPI’s for business needs

Ability to automate data reconciliation checks from source to reporting systems using various tools and technologies

Understanding of data manipulation technologies & data platforms (based on either prepackaged ETL tools and/or custom programming).

Excellent communications skills, both written and spoken, as well as being able to present complex technical concepts to a non-technical audience

Strong project management and organizational skills

Demonstrate strong interpersonal skills and a comfort interacting with clients from the C-suite to managers to technical specialists

Be comfortable working autonomously or with broad guidelines; this role will often be working independently at client offices

Ideal candidate will possess strong business acumen and has been in a consulting role previously