Data Engineer
Company Description
Sagence is a data focused consulting firm working with clients in information-intensive industries such as Healthcare, Financial Services, Insurance and Retail. We specialize in data management and analytics, assisting our clients with the acquisition, evaluation and development of data assets.
Our People:
Passionate, diverse, creative, genuine, curious, hands-on…these are just a few of the words that describe who we are. We have a high-energy workplace with a focus on producing high-quality, impactful results for our clients. We build teamwork through small, dedicated teams who constantly communicate and continuously teach each other and learn from one another. We promote an entrepreneurial spirit by encouraging individual initiative and foster a collaborative culture and work environment which includes open communication and on-going learning. We are committed to equality of opportunity, fairness, work and lifestyle balance, and mutual respect. We strongly believe these characteristics enable our employees to develop to their fullest potential.
Job Overview
Sagence is looking for Data Engineers to help us build and sustain our client’s data capabilities and our competitive advantage. Our Data Engineers are responsible for implementing repositories and building and maintaining data pipeline systems that are used in Data Analytics. Along with the requirements below, candidates must possess deep, practical experience in one or more of the following Data Management competencies; data warehousing, data lakes, data architecture. Additionally, and equally as important, as a Sagence Data Consultant, you must have the skills and experience necessary to effectively communicate with our clients
Skills & Requirements:
MUST BE HANDS ON. Candidates should have system development experience and proficiency with system development methodologies and possess the following skills and knowledge:
· Must have significant hands-on experience with various IT concepts of data management/engineering (ETL, data modeling, data warehousing, etc.)
· Must have significant hands-on experience with SQL, data profiling, and data discovery
· Must have a strong understanding of data analytics and data wrangling
· Hands on experience with cloud-based data solutions (AWS, Azure) and integrating with data sources
· Experience with at least one data manipulating programming languages (e.g. Python)
· Familiar with building business intelligence, analytics, or reporting solutions - either front-end consumption tools (e.g., Microsoft Power BI, Tableau & Qlik) or supply of data for these purposes
· Deep knowledge of data architecture principles/approaches, data environment infrastructure considerations. Additional knowledge in data modeling principles/approaches preferred
· Ability to drive out technical requirements with business and IT stakeholders for implementations of data solutions
· Hands-on experience with Agile delivery methodology
· Demonstrated ability in effectively engaging, communicating, and presenting to stakeholders across both business and technology functions
· Conceptual and analytical thinker with the ability to define business requirements and extract, analyze, and synthesize complex business insights
· Prior professional experience in a management consulting, an IT management, or client facing role strongly preferred
· Ability to perform knowledge transfer to support a team
· Knowledge of the Financial Services, Insurance, Healthcare or Retail industries is preferred
Tools and Technology:
Proficient at leveraging tools and technology to drive value for clients. Examples include the following;
· Database Management Tools (preferred with cloud):
o Relational – e.g. Oracle, MySQL, Microsoft SQL Server, PostgreSQL or similar
o NoSQL – e.g. MongoDB, Apache Cassandra, Couchbase or similar
o Cloud-based – e.g. AWS (Redshift or DynamoDB), Azure (SQL Server or Cosmos DB) or similar
· ETL Tools - e.g. Informatica, Talend, Microsoft SSIS, or similar
· Python Data Manipulation/Analysis – e.g., Pandas, NumPy
· Familiar with at least one Industry Leading BI tools - e.g., Microsoft PowerBI, Tableau, Qlik, Looker, or similar
General:
· Must be currently authorized to work in the US on a full-time basis. Sagence does not provide sponsorship for work visas
· 2+ years of professional experience working in a related role
· Strong strategic business acumen and a passion for solving problems with data-driven solutions
· Client centric focus with strong relationship management skills and the ability to influence business decisions
· Intellectually curious and independently resourceful with the ability to prioritize and execute in a fast-paced and dynamic environment
· Willingness to travel to client sites as needed
· Chicago or New York area candidates preferred, but will consider candidates in other parts of U.S.