What are the responsibilities and job description for the Data Engineer position at Colonial Group, Inc.?
Colonial Group, Inc. is a multigenerational, family-owned parent company overseeing a diverse portfolio of subsidiaries. Through our strategic infrastructure, logistics expertise, and a broad range of products and services, we create significant value for our customers while driving innovation and operational excellence.
We are seeking a highly skilled and motivated Data Engineer to join our growing data team. The ideal candidate will have deep expertise in SQL Server Database Administration, Databricks, Microsoft Fabric, and enterprise data architecture. You will play a key role in designing, building, and maintaining scalable data solutions that support business intelligence, analytics, and operational reporting across the organization.
Key Responsibilities
Job conditions require standing, walking, sitting, twisting, stooping, crouching, kneeling, lifting or carryings, pushing or pulling up to 50 lbs., climbing up to 15ft, working in confined spaces, talking or hearing, making visual inspections, making precise hand and finger movements, reaching or grasping; perceiving color differences; ability to wear personal protective equipment.
Eligibility Requirements: Hiring is contingent upon eligibility to work in the United States.
Colonial Group, Inc. is committed to creating an environment that values and supports diversity and inclusiveness across our organizations. We encourage applications from qualified individuals who will help us achieve this mission. Colonial Group, Inc. prohibits discrimination of and will receive consideration for employment without regard to race, color, religion, sex, age, sexual orientation, gender identity, religion, national origin, disability, veteran status, or other legally protected status.
We are seeking a highly skilled and motivated Data Engineer to join our growing data team. The ideal candidate will have deep expertise in SQL Server Database Administration, Databricks, Microsoft Fabric, and enterprise data architecture. You will play a key role in designing, building, and maintaining scalable data solutions that support business intelligence, analytics, and operational reporting across the organization.
Key Responsibilities
- Design, implement, and maintain robust data pipelines using Databricks and Microsoft Fabric.
- Serve as the SQL Server DBA, managing performance tuning, backups, security, and high availability.
- Develop and maintain data models, data lakes, and data warehouses to support analytics and reporting needs.
- Collaborate with data architects and business stakeholders to define and implement scalable data architecture solutions.
- Ensure data quality, integrity, and governance across all data platforms.
- Automate data workflows and optimize ETL/ELT processes for performance and reliability.
- Monitor and troubleshoot data systems, ensuring uptime and data accuracy.
- Stay current with emerging technologies and best practices in data engineering and architecture.
- Proven experience as a SQL Server DBA (administration, tuning, security, and disaster recovery).
- Hands-on experience with Databricks (Spark, Delta Lake, notebooks, and pipelines).
- Proficiency with Microsoft Fabric and its components (Data Factory, Synapse, Power BI integration).
- Strong understanding of data architecture principles, including data modeling, warehousing, and lakehouse design.
- Proficient in SQL, Python, and/or Scala for data processing.
- Experience with cloud platforms (Azure preferred).
- Familiarity with CI/CD pipelines and DevOps practices for data engineering.
- Excellent problem-solving and communication skills.
- Microsoft certifications (e.g., Azure Data Engineer Associate, SQL Server).
- Experience with data governance tools and frameworks.
- Knowledge of data security and compliance standards (e.g., GDPR, HIPAA).
Job conditions require standing, walking, sitting, twisting, stooping, crouching, kneeling, lifting or carryings, pushing or pulling up to 50 lbs., climbing up to 15ft, working in confined spaces, talking or hearing, making visual inspections, making precise hand and finger movements, reaching or grasping; perceiving color differences; ability to wear personal protective equipment.
Eligibility Requirements: Hiring is contingent upon eligibility to work in the United States.
Colonial Group, Inc. is committed to creating an environment that values and supports diversity and inclusiveness across our organizations. We encourage applications from qualified individuals who will help us achieve this mission. Colonial Group, Inc. prohibits discrimination of and will receive consideration for employment without regard to race, color, religion, sex, age, sexual orientation, gender identity, religion, national origin, disability, veteran status, or other legally protected status.
