Description

• Work with business stakeholders to understand, document, and articulate unstructured issues and develop appropriate solutions. Serve as a technical liaison for business teams to define, estimate and recommend optimized technology solution
• Communicate objective, business value, and status of analytical initiatives to stakeholders and senior leadership. Strong verbal, written, and visual communication abilities
• Lead cross-functional projects using advanced data modeling and analysis techniques to discover insights that will guide strategic decisions
• Design and build infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL, Python and ETL tool.
• Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL), Store Procedures as well as working familiarity with a variety of databases & Big data.
• Must be able to build data pipelines, architectures, and data sets from raw, loosely structured data & build processes supporting data transformation, data structures, metadata, dependency, and workload management.
• Provide guidance to ensure optimized data pipelines for business use cases, analytical modeling, and standard reporting.
• Create high-level design documents with visual diagrams of system architecture, functionality, and process flows.
• Design and implement QA and Production environment and processes allowing end-to-end testing of proposed changes from data ingestion to visualization
• Strong project management and organizational skills and the ability to work independently in a fast-paced, quickly changing environment. Ability to keep up with multiple projects and understand the impact of projects within a larger system.
• Provide input on key database architecture designs based upon expected analytical use cases and business need
• Build, develop, and maintain reporting platforms and automated data pipelines

• Bachelors degree in Computer Science, CIS, IT, Engineering (all branches) or related quantitative field (MS degree preferred)
• 4+ years in related professional experience as a data engineer/architect designing and deploying data systems
• Mastery of database and data warehouse methodologies and techniques from transactional databases to dimensional data modeling, to wide denormalized datamarts
• Deep understanding of SQL and experience building data pipelines with ETL tools
• Ability to handle large datasets with the appropriate technique
• Experience with development in QA & production deployment
• Experience with building OLAP Cubes, dimensions, business-critical KPIs
• Experience with Tableau, Power BI, SAP Business Objects, or similar reporting platform
• Familiarity with cloud technology like Azure is a plus
• Experience working in a strategic role and working with unstructured problems
• Evidence of strong communication skills
• Demonstrated thought leadership and intellectual curiosity

• This is a hybrid position based out of our Schaumburg office, requiring at least 3 days per week in the office.

• Comprehensive Medical, Dental, and Vision Insurance
• Free Life and Disability Insurance
• Health and Dependent Care Flexible Spending Accounts
• 401k with 3% company match and annual employer discretionary contribution
• Paid vacation, holidays and sick time
• Employee Assistance Program
• Access to thousands of free online courses
• Discounts on cell phones, movie tickets, gym memberships, and more!
• Education Assistance (both college degrees and professional certifications)
• Referral Program with cash bonus
• Access to on-demand pay
• Paid parental leave