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
Full Time Gastroenterology Job Cincinnati, OH
A prestigious hospital in Montgomery, Ohio, is seeking a GI Hospitalist to join its collegial team. This 100% inpatient role offers strong mentorship, teaching flexibility, and advanced procedural opp…
Infusion Sales Executive - IVIG
Our client is a leading provider of infusion therapy services across the U.S. With a focus on patient-centered care and clinical excellence, our client partners with specialty clinics to deliver high-…
Strategy and planning director
IAM Strategy and Planning Director Location: This role requires associates to be in-office 3 days per week, fostering collaboration and connectivity, while providing flexibility to support pro…
Production worker
NOW HIRING: Fabrication & Assembly Technician (Part-Time or Full-Time) ~ Location: Bainbridge Township, OH Pay: $16.00 - $19.00 per hour (based on experience) Join our team and be pa…
MTM Pharmacist
MTM Pharmacist – Help Patients Get the Most Out of Their Medications Are you passionate about patient care and looking for a role with strong clinical impact and better work-life balance? We’re see…
Regional Administrative Supervisor
Regional Administrative Supervisor Location Columbus, OH (Woodland Park area) : Who We Are: Since 1946, we've been providing compassionate treatment to support the behavioral, physical and emotional…
Assistant Community Manager - Kenyon Square Apartments
ABOUT GREYSTAR Greystar is a leading, fully integrated global real estate company offering expertise in property management, investment management, development, and construction services in ins…
Assistant athletic trainer
Assistant athletic trainer Full time/10 months, evening and/or weekend duties as required The following statements are intended to describe the general nature and level of …
RN / REGISTERED NURSE - PROGRESSIVE CARE UNIT (PCU)
Why Beebe? Become part of the Beebe team - an inclusive team positioned in a vibrant, coastal community. Enjoy a fulfilling career as you support the health of our patients and a team focused on ex…
Assistant General Manager
If you have an interest in being part of one of the fastest growing industries in the nation in you may consider wanting to work for Trulieve! If you have a desire to help others in need through yo…