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
Plumbing Service Technician
Anderson Heating, Cooling, Plumbing & Electrical is looking for a residential Plumbing Service Technician to service and repair residential plumbing and drain systems. Position Overview: Our resi…
Caregivers, Aides & Personal Care Assistants
Become a Caregiver and Make a Difference Are you someone who believes in the power of compassion? Do you have a gentle spirit and a deep desire to help others live with dignity and joy? If so, w…
Sr. Engineer, Safety Electronics
Leading the future in luxury electric and mobility At Lucid, we set out to introduce the most captivating, luxury electric vehicles that elevate the human experience and transcend the perceived li…
Personal Fitness Trainer
Are you passionate about fitness and dedicated to helping others achieve their health and wellness goals? Join our team as a Personal Fitness Trainer and make a positive impact on people’s lives throu…
Clinical Manager of Care Management - LISW
Job Description Job Description Overview AMAZING INDIVIDUALS WORKING FOR POSITIVE PEOPLE at AIDS Healthcare Foundation! Does the idea of doing something that really makes a difference in p…
Twos Assistant Teacher
Center: Polaris, OH Job Type: Full-Time, Part-Time Pay Range: $16 - $19 hourly No evenings or weekends! Build your career in the early childhood education field and become a valued member …
Licensed Practical Nurses (LPN) - Otterbein Staffing Agency
Job Description Job Description **Now Offering DailyPay** Take control of your work schedule with Otterbein Staffing Agency (OSA) and earn some of the highest wages in the industry! The benefit…
PREMIUM CATERING ATTENDANT - THE OHIO STATE UNIVERSITY - OHIO STADIUM (PT)
Position Title: [[title]] Pay Range : $16.00 to $20.00 We Make Applying Easy! Want to apply to this job via text messaging? Text JOB to 75000 and search requisition ID number 1436216 …
Aerospace Quality Manager (#10223TB)
Job Description Job Description Company Description Company has over 70 years of experience! One of the largest companies in their industry! Company has long tenured employees! Job Descr…
Senior Project Manager / Estimator
Job ID: 513841 The Shelly Company, a CRH company, is a vertically integrated supplier of aggregates, asphalt, ready mix concrete and paving services throughout the state of Ohio. Our commi…