Rolling Meadows, IL (Hybrid Tue-Wed, remote other days)
9 month contract
C2C $70/HR
Notes from Manager:
We’re looking for one or more the following tools: - Apache Ignite (for real-time data processing and decision making) - Apache Druid (for DW, Analytics) - PostgreSQL High Availability (for transaction data) ”
Job Description:
Responsibilities:
· Responsible for the creation of the database architecture for the Smart Manufacturing Platform and its supporting services and choosing the appropriate database technologies based on the requirements of each service.
· Integrate data and analytical capabilities into an overall Platform architecture
· Leverages data expertise to ensure an optimal systems design from a technical performance, efficiency and operating cost perspective in developing the overarching data strategy and vision for data pipelines and data products.
· Execute technical data strategy to handle current and forecasted business requirements.
· Analyze multiple sources of structured and unstructured data to propose and design data architecture solutions for scalability, high availability, fault tolerance, and elasticity
· Perform Proof-of-Concept development and performance testing
· Design and implement scalable Data and Analytical architecture solutions for various public and private cloud platforms as well as virtualization systems used on-prem.
· Drive efficiencies with data architecture patterns and ecosystems including data stores (operational systems, data lakes, data warehouses, data marts, ingress patterns (API, streaming, ETL/ELT), egress patterns (analytics/decision tools, BI tools) and reusable data products such as data services, data mesh, APIs, etc.
· Design, implement, and improve processes in data management.
· Oversee and govern the expansion of existing data architecture and the optimization of data query performance via best practices.
· Drive Continuous improvement + Continuous Delivery – and data management standards to ensure the sustainability and efficiency of the architecture in the long term.
· Maintain a centralized knowledge base for Data and Analytics technology components - This includes documentation, maps, data flows, technical specifications, version control, etc...to keep our knowledge.
· Responsible for analyzing and translating business, application, information, data, reporting, and analytical requirements into an architectural blueprint that outlines solutions to achieve business objectives.
· Optimizes performance of queries and ELT/ETL procedures. Enhances batch routines by optimizing for more modern near real-time capabilities.
Qualifications:
· Deep experience designing and developing data architecture solutions with more than 5+ years specializing in big data architecture or data analytics.
· Experience in a software development environment working closely with developers to create the appropriate database schemas to support require functionality.
· Experience with database technologies required to support large volumes of streaming data Broad based architecture acumen: Database architecture, ETL, Micro services, Cloud, IOT, etc.
· Knowledge and experience with database concepts such as Relational, TimeSeries, NoSQL, Document DBs, and GraphDBs and an excellent grasp on when each technology is preferred.
· Experience with Distributed Databases
· Highly proficient with large data sets and clusters
· Ability to architect performant, resilient, and scalable database architectures.
· Experience working with Cloud Storage solutions such as AWS, GCP, Azure etc. is a plus.
· Customer-centric approach in all interactions with both internal and external stakeholders
· Complex problem-solving and analytical skills
· Strong written and verbal communication skills
· Ability to work in an agile scrum project team
· Bachelor’s degree in CS or related field