Process Data Architect
- Database Administration: Install and configure SQL Server instances in line with best practices and security standards. Perform regular database maintenance tasks such as backups, indexing, and updates to maintain database health.
- Data Engineering: Design, implement, and maintain efficient ETL pipelines to ensure seamless data flow between systems. Integrate data from multiple sources and ensure the architecture supports both operational and analytical workloads.
- Data Science & Analytics: Conduct exploratory data analysis, develop predictive models, and deliver actionable insights from complex datasets. Use machine learning algorithms to identify trends, forecast outcomes, and drive business decisions.
- Optimization & Performance: Monitor database performance and implement optimization strategies to enhance efficiency and security. Tune queries and database structures to ensure optimal performance for both real-time and batch data processes.
- Security & Compliance: Design and maintain disaster recovery plans and high availability solutions, regularly testing these systems to ensure reliability. Implement and monitor security protocols to safeguard data integrity and ensure compliance with industry standards.
- Collaboration: Work closely with application developers, system administrators, data analysts, and other stakeholders to address database-related needs, provide technical support, and align data models with business goals.
- Documentation & Reporting: Maintain documentation of database configurations, data pipelines, processes, and procedures. Generate reports on database performance, ETL pipeline metrics, and data science outcomes for management review.
- Bachelor’s degree in computer science, Data Science, Information Technology, or a related field. Equivalent work experience in both SQL Server administration and data science may be considered.
- Minimum of 2-5 years of experience in SQL Server database administration, with expertise in SQL Server 2016/2017/2019/2022 environments.
- Proven experience as a Data Engineer or Data Scientist, with hands-on experience in data pipeline design and advanced data analysis.
- Proficiency in Transact-SQL (T-SQL) scripting.
- Experience in performance tuning, query optimization, and troubleshooting.
- Strong knowledge of SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).
- Experience with cloud-based database solutions, particularly Azure SQL Database.
- Expertise in programming languages such as Python or C#, and experience with data visualization tools.
- Solid understanding of database security principles and data engineering best practices.
- Experience with machine learning algorithms and statistical modeling.
- Experience and working knowledge of Ignition and Ignition SQL
- Experience and skills to ensure quality and integrity of large data sets including identification and resolution of data inconsistencies and errors
- Experience and working knowledge of SAS Viya database requirements and VA and VS analytics. Experience in writing, optimizing and maintaining SAS scripts for data processing and reporting preferred.
- Strong analytical and problem-solving skills with the ability to navigate, manage, and troubleshoot large datasets.
- Excellent communication and teamwork abilities, with the capacity to work cross-functionally.
- Detail-oriented with a focus on continuous improvement and innovation in both database management and data science methodologies.
- Salary $100,000.00-$125,000.00
- 5% quarterly bonus potential
- Positive and collaborative work environment
- Flexible schedule
- Paid training
- Educational Assistance
- 401K with match
- PTO
Recommended Jobs
Regional Operations Manager - Multi-Site (Charter Schools)
The Regional Operations Manager – Multi-Site (Charter Schools NY and Northern Ohio) is responsible for overseeing a broad range of preventive and corrective maintenance and custodial services across …
Client Services Representative
Job Description Job Description Client Services Representative (CSR) Job Description: Summary This position is responsible for telephone, email, and platform-based support for FAST Platf…
Project Manager
The Project Manager provides overall management direction on all types of projects, including large industrial and structural projects. This position establishes project objectives through planning a…
Construction Laborer
Job Description Job Description Job Summary Innovative Labor and Cleaning Service is looking for general construction labor cleaners. Will perform various construction labor task. We are looki…
Dishwasher - LaRosa's Centerville
Job Description Job Description Do you love great Italian food? If you take pride in great teamwork and can work in a fast pace environment, we think we found the perfect job for you! LaRosa’s is…
Pizza Delivery Driver
Welcome to Mile High Pizza Company doing business as Domino's ! Locally owned and operating in Cleveland, Akron, Mansfield, and Columbus, OH. We can do that because we are a people first com…
Class A Driver
$1,500 sign-on/retention bonus! Join our team as a Class A Truck Driver and enjoy the benefits of a stable, full-time position that gets you home every night. We are a logistics company that values sa…
Shift Leader
Job Description Job Description Be a part of what we are building here at Arby's. At Arbys, we are guided by our six core values; Dream Big, Work Hard, Get it Done, Play Fair, Have Fun, and Ma…
General Service Technician
Job Description Job Description Company Description Monro’s family of brands is one of the leading automotive service and tire dealers in the United States. We work on approximately five mil…
Discover Zanesville: Your Next Adventure Awaits!
Radiation Therapist job in Zanesville, OH Embark on an enriching adventure as a Radiation Therapist in Zanesville, where you'll create heartfelt connections with patients while providing essential ca…