Lead Software Engineer (IM-200)

Responsibilities

Design and build software products and features for both internal and external clients through all phases of the entire software design life cycle.  Participate in design and development of data solutions, including data architecture and modelling, building data pipelines and implementing data visualization based solutions.  Perform detailed analysis of source system data and model that into data warehousing by designing, developing and testing scripts to import structured and unstructured data from cloud-based systems.  Create and implement real-time data warehouse to minimize data latency with history data captured by Slowly Changing Dimension methodology.  Create, manage, and automate data-driven subscriptions with daily, weekly, monthly, quarterly, yearly schedules with various rendering formats.  Perform data profiling, cleansing and transformation of delimited or structured data files support data and analytical needs.  Create and maintain technical architecture diagrams, business models, data flows and information relationship model documents to support application design and changes.  Develop scorecard and multi-metric reports based on key performance indicators (KPIs) to assess performance and summary of business statistics.  Proactively manage incidents as they occur and investigate, identify the cause and appropriately resolve the incident in a timely manner.  Develop test cases and test plans and perform unit and pre-integration test for new and/or modified middleware integrations.  Maintain and support existing enterprise applications in 24x7 environment and provide on-call support.  Develop integrations with other web applications.  Position may be located at any of 84.51 LLC’s offices in U.S.  Telecommuting from home office may be authorized for position, subject to 84.51 Flexible Work Option policy.

Basic Qualifications

Bachelor’s degree (or foreign educational equivalent) in Computer Science or a closely related field with at least 5 years of post-degree, professional IT experience in each of the areas listed below; OR, alternatively, a Master’s degree (or foreign educational equivalent) in Computer Science or a closely related field with 3 years of professional IT experience, gained at any time, in each of the areas listed below.  Depending on degree held, must have 5 years or 3 years of professional IT experience as described above in each of the following:  developing software using Agile principles as part of scrum team; augmenting and implementing data warehouse/data-marts; performing conceptual, logical and physical data modelling and data architecture; performing automated testing with SQL Test or Oracle SQL Developer; utilizing VCS including Git, SVN, and TFS; utilizing database management systems, online analytical processing (OLTP), and ETL (Extract, Transform, Load) framework; performance tuning, optimizing databases, normalization and adhering to enterprise standards to improve the responsiveness of the applications; scripting complex SQL queries, dynamic SQL, Stored procedures, triggers, UDF, views, indexes and other database objects; debugging enterprise applications; analyzing large datasets and prioritizing them into actionable insights to bring full analytical capabilities; understanding CI/CD and automate builds and deployment processes using SSDT, VSTS; Data Modelling with ERWIN/ER Studio tools including hands on experience with fact tables and dimension tables; and utilizing JavaScript Object Notation, VB.net, C# programming, and Object Oriented Principles.

IMPORTANT INFO

This is a Hybrid position. Candidates must be able to come into the office on Monday, Tuesday, and Wednesday of each week. We have locations in Cincinnati, OH, Chicago, IL, Deerfield, IL, New York, NY, and Portland, OR. There are no remote options for this position. 

#LI-DNI