Contact: HR Manager
Email: [email protected]
Phone: (630)-799-1556
Sr. Consultant - Data Engineer
Insygnum needs a Consultant - Data Engineer to help our clients for data analysis, data integration and data quality. Our Chicago-based team is small but growing fast and we need to complement our in-house experts who knows how to tame challenging data. This is a unique opportunity to not only work with cool technology, but also to create a new methodologies and techniques. You'll get in on the ground floor of a new company, help shape its future, and benefit directly from your work.
Why work here
Joining insygnum now offers several unique opportunities
You will receive competitive salary, benefits, and stock options
You will be working on hard, interesting problems
You will help shape the culture of the company as we grow
You will have the opportunity to apply your skills in a meaningful way and have a real-world impact
Responsibilities
Identify data warehouse needs and develop strategy for implementing a warehousing solution including investigating data sources, rationalizing information sources, identifying technology components, building roadmaps and reference architecture stacks
Work with Business Analysts and other information management professionals through all phases of project development, from envisioning to architecture definition and end solution realization
Provide direction and collaborate with Data Engineers to implement enterprise solutions that will support organizational business intelligence and analytics requirements
Work with the business to identify opportunities where technology can be leveraged to solve existing problems and can assist with new market opportunities
Meet with technology vendors, convey technical requirements and business use cases, develop scorecards, install vendor products in a lab environment, and summarize findings and results of testing
Technologies to be used may include some combination of relational databases (PostgreSQL, Teradata, Aster, HANA), NoSQL, Hadoop, Object-based stores, and OLAP.
Specific responsibilities include:
Help design an architecture for federated data stores and data fusion
Help design methods for storing data in a way that facilitates extremely fast data parsing and management
Implement "glue code" that connects middle tier components with backend components
Implement data management and analytics code utilizing data architecture (e.g. map reduce)
Collaborate with machine learning folks to determine how to analyze various data sets and set up methods for querying data stores
Collaborate with enterprise architects to understand the applications we integrate with and the data they produce
Review requirements for new approaches to big data storage and analytics
Design methods for caching, paging, and integrating real-time data with historical data stores
Desired Skills and Experience
Requirements
Minimum ten years of experience in an IT environment with at least five years designing and working with large enterprise database warehouses, designing robust data models and partitioning strategies
Minimum five years of data architecture experience, including data modeling with project teams, data governance strategy, metadata management, system architecture, design, and implementation
Minimum five years experience using one or more data integration tools including Data Quality and ETL
Development knowledge for integrating components and contributing to core code base - Java preferred
Solid understanding of database and data warehousing technologies
Experienced in advanced SQL as well as NoSQL queries, syntax, and technologies
Experienced in big data requirements, applications, and technologies such as Hadoop
Proficient in ETL methods and approaches including triggers, named views, temporary tables, etc.
Experienced in Linux environments
Bonus Points
Experience working with IT strategy teams, business teams and business analysts to define information systems, services and management
Experience with RDBMS including SQL Server, Oracle 11g, MySQL; Big Data including SQL Data Warehouse Appliance, Oracle Exadata, Netezza, Greenplum, Vertica, Teradata, Aster Data, SAP HANA, Hadoop a plus; Analytics including SAS, SPSS, Spotfire, Tableau, Qlikview, R, Oracle Endeca; BI Tools including Oracle OBIEE, SAP Business Objects, SAS and other Analytics Vendors with BI components; ETL & MDM including Informatica, SAS Dataflux, IBM, Siperion, Rochade, Map/Reduce for ETL is a plus
Java is strongly preferred (e.g. for working with map reduce) but not ultimately a requirement if you excel in other areas
Strong SQL skills are highly desirable
OLAP experience
