What are the responsibilities and job description for the Data Engineer position at ForTec Medical?
Company Description
ForTec Medical is an industry leader dedicated to improving patient health by delivering innovative surgical technologies to our healthcare customers on demand. Our dedicated team provides service excellence, and we take pride in what we do each and every day. ForTec’s commitment to excellence, integrity, and positive culture defines our organization. These core values and our entrepreneurial spirit are the foundation of ForTec.
Job Description
ForTec is seeking a Data Engineer to work out of our Home Office in Hudson, Ohio, two to three times per week and additionally as needed.
The Data Engineer is responsible for designing, developing, and maintaining robust data solutions to support enterprise applications, analytics and business intelligence. This role involves creating and optimizing relational databases, implementing ETL processes, managing data pipelines using Azure Data Factory, and developing data warehouse solutions. The Data Engineer will also design and deliver reports and dashboards, execute CI/CD pipelines, and ensure seamless data integration. Collaborating with cross-functional teams, this role delivers scalable, high-performance data solutions that meet organizational needs.
- Design, develop, and optimize relational databases using SQL
- Ensure data integrity and security across all databases
- Develop ETL processes to ingest and transform data from various sources
- Develop and maintain data warehouse solutions to support business intelligence initiatives
- Create and manage data pipelines using Azure Data Factory
- Automate data workflows and ensure seamless data integration across systems
- Design and implement fact and dimension tables using dimensional modeling techniques
- Optimize data models for reporting and analytics performance
- Develop reports and dashboards using SSRS and Power BI
- Collaborate with stakeholders to gather requirements and translate them into technical solutions
- Implement continuous integration and continuous deployment (CI/CD) pipelines using Azure DevOps
- Automate deployment processes for databases, data warehouses, and reporting solutions
Qualifications
- 3 or more years of experience in Data Engineering or Data Warehousing
- Knowledge of cloud services, particularly Microsoft Azure
- Strong proficiency in SQL and database design
- Extensive experience with database design, development, and optimization
- Proficient in creating and managing data pipelines using Azure Data Factory
- Extensive experience in ETL processes, including data ingestion and transformation from diverse sources
- Proficient in designing and implementing fact and dimension tables using dimensional modeling techniques
- Hands-on experience with Azure DevOps for implementing CI/CD pipelines
- Familiarity with Power BI and SSRS for developing reports and dashboards
- Familiarity with Agile/Scrum methodologies
- Certifications in Microsoft technologies or Azure is a plus
Additional Information
Our continued growth and success have allowed us to provide exciting career opportunities for passionate, customer-focused, and highly motivated individuals. We provide our employees with a generous benefits package, including:
- Competitive compensation package
- 401(k) plan with generous company match; Annual Profit-Sharing opportunity
- Medical, dental, vision, disability, and life insurance plan options
- Free Teladoc Health Account
- Generous Paid Time Off (PTO)
- Company Paid Holidays
- Health and Wellness Rewards Program
- Employee Referral Bonuses
- Service Milestone Awards
Join ForTec Medical – make YOUR impact today!
The Company is an equal opportunity employer. As such, we provide equal employment opportunities to all employees and applicants for employment without regard to race, color, religion, gender, citizenship, ethnicity, national origin, age, disability, pregnancy, genetic information, sexual orientation, status as a member of the United States armed forces, veteran status, or any other protected characteristic in accordance with applicable federal, state, and local laws.
