Name of Employer:     84.51° LLCJob Location:     100 W. 5th Street, Cincinnati, OH 45202 and various unanticipated worksites in U.S.Job Title:     Lead Software Engineer -- (Multiple positions available)Job Duties:     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. Roving employment - Position may be located at any of 84.51 LLC's offices throughout U.S. Limited telecommuting from home office may be authorized for position, subject to 84.51 Flexible Work Option policy.Job Requirements:     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 at least 3 years of professional IT experience, gained at any time, in each of the areas listed below. Depending on degree held, must have 5 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.TO APPLY, please visit https://boards.greenhouse.io/8451 and search for Job Number