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