Job Summary:
A Data Engineer at TempWorks is responsible for delivering data-driven insights to innovate and drive business success. The Data Engineer plays a crucial role in designing, developing, and maintaining our data architecture to support our growing data needs. The Data Engineer collaborates closely with cross-functional teams including data scientists, analysts, and software engineers to ensure the reliability, scalability, and performance of our data systems.
General Responsibilities:
- Designing and implementing scalable and efficient data pipelines to ingest, process, and transform data from various sources.
- Building and maintaining robust data warehousing solutions to support analytical and reporting requirements.
- Optimizing database performance and ensuring data quality and integrity.
- Developing and maintaining ETL processes to enable efficient data movement across systems.
- Implementing data security and privacy measures to ensure compliance with regulations and company policies.
- Evaluating and adopting new technologies and tools to enhance our data infrastructure and analytics capabilities.
- Performing other related duties as assigned.
Required Skills and Abilities:
- Hands-on experience with SQL database design.
- A deep understanding of relational databases (e.g., MySQL, PostgreSQL).
- Experience with Azure data storage solutions such as Azure SQL Database, Azure Cosmos DB, and Azure Data Lake Storage.
- Knowledge of data integration and analysis tools such as Azure Data Factory, Azure Databricks, Azure Synapse, and Power BI.
- Understanding of data modeling and schema design principles.
- Ability to work with large datasets and perform data analysis.
- Strong experience in common data warehouse modelling principles.
- Knowledge of Dev-Ops processes (including CI/CD).
- Experience in developing NO SQL solutions is desirable.
Education and Experience:
- Bachelor's degree or higher in Computer Science, Engineering preferred.
- 5+ years of SQL experience (No-SQL experience is a plus).
- 5+ years of experience with schema design and dimensional data modeling.
- Experience designing, building, and maintaining data processing systems.
Physical Requirements:
- Prolonged periods sitting and/or standing at desk and working on a computer.
- Must be able to lift to 10 pounds at times.
TempWorks Software offers a comprehensive benefits package and provides eligible employees with an opportunity to enroll in various benefit programs, subject to applicable waiting periods. This includes the following:
- Paid Time Off
- Holiday Pay
- Volunteer Time Off
- Medical Insurance
- Health Savings Account with Employer Contribution
- Dental Insurance
- Vision Insurance
- 401(k) with Employer Match
- Life Insurance and AD&D
- Short-Term and Long-Term Disability Insurance
- Paid and Unpaid Leave of Absences