Process Data Engineer (Cleveland, OH) (Finance)
As a Process Data Engineer , you will be responsible as a SQL Server Administrator, Data Engineer, and Data Scientist. You will be responsible for the installation, configuration, maintenance, and performance tuning of SQL Server databases, as well as designing, implementing, and maintaining ETL pipelines, and conducting data analysis to support data-driven decision-making. You will ensure the availability, security, and integrity of database environments, support both application development and operational needs, and utilize data science methodologies to extract insights from large datasets. The position also involves collaborating with various teams to provide strategic insights into database architecture, optimization, and predictive modeling.
Who are we?
This is a great opportunity to join a growth-oriented company within the aerospace industry that has been in business for over 100 years! We specialize in manufacturing aluminum and magnesium products for commercial, regional, corporate and military aircraft and engines.
What will you do?
- 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.
What will make you successful?
- 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 $120,000.00-$130,000.00
- 5% quarterly bonus potential
- Positive and collaborative work environment
- Flexible schedule
- Paid training
- Educational Assistance
- 401K with match
- PTO
Sponsorship is not available for this role. Candidates must be legally authorized to work in the U.S. on a permanent and consistent basis without company sponsorship now and in the future.
This position requires use of information or access to hardware which is subject to the International Traffic in Arms Regulations (ITAR). All applicants must be U.S. persons within the meaning of ITAR. ITAR defines a U.S. person as a U.S. Citizen, U.S. Permanent Resident (i.e. 'Green Card Holder'), Political Asylee, or Refugee.
CPP Corporation is an Equal Opportunity Employer that recruits, hires, trains, and promotes employees in all job classifications without regard to race, color, religion, age, sex, sexual orientation, gender identity, marital status, national origin, disability, veteran's status, or other legally protected status.
This is a non-management position
This is a full time position
