Data Engineer

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 SQLEnsure data integrity and security across all databasesDevelop ETL processes to ingest and transform data from various sourcesDevelop and maintain data warehouse solutions to support business intelligence initiativesCreate and manage data pipelines using Azure Data FactoryAutomate data workflows and ensure seamless data integration across systemsDesign and implement fact and dimension tables using dimensional modeling techniquesOptimize data models for reporting and analytics performanceDevelop reports and dashboards using SSRS and Power BICollaborate with stakeholders to gather requirements and translate them into technical solutionsImplement continuous integration and continuous deployment (CI/CD) pipelines using Azure DevOpsAutomate deployment processes for databases, data warehouses, and reporting solutions