Colonial Group, Inc. is seeking a Data Engineer to design, build, and maintain scalable data solutions that support business intelligence, analytics, and operational reporting across the organization.
Requirements
- 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.
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.
Other
- Excellent problem-solving and communication skills.
- 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.
- 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.
