The Data Engineer plays a critical, hands-on role in Microsoft Fabric and data modernization at Central Technology Services. This role applies Microsoft Fabric, Python/PySpark and SQL skills to migrate legacy SQL Server datamarts into reliable, modern analytics solutions. The Data Engineer takes meaningful ownership of development and delivery, collaborating with experienced teammates and business experts to turn complex data into trusted insights.
Key Responsibilities- Re-engineer legacy SQL Server datamarts in Fabric, working with business experts to understand rules and dependencies and deliver tested migrations, parallel runs and controlled cutovers.
- Develop reusable Python, PySpark and Spark SQL transformations in Fabric notebooks and Lakehouses; build reliable pipelines with dependencies, retries, monitoring and safe reruns.
- Tune Spark workloads for performance and efficient Fabric capacity use, including joins, shuffles, skew, partitioning and memory.
- Implement incremental ingestion, change capture, upserts, schema evolution and backfills; build BI-ready dimensional models with clear grain, keys and history.
- Protect data accuracy with automated testing, quality checks and source-to-target reconciliation; troubleshoot production issues and improve reliability.
- Use Git, code review and CI/CD for deployment across environments; apply access controls, secure connectivity and data-protection practices with platform and security colleagues.
- Provide pragmatic support for selected legacy workloads during transition; Microsoft SQL Data marts.
- 5+ years of relevant data engineering or development experience, or equivalent demonstrated capability, with strong production Python/PySpark and SQL development skills.
- Bachelor’s degree in Computer Science, Engineering or a related field, or equivalent relevant work experience.
- Hands-on Microsoft Fabric experience with Lakehouses, OneLake/Delta tables, notebooks and pipelines, plus production Python, PySpark and Spark SQL transformation, troubleshooting and performance tuning.
- Strong SQL Server and T-SQL skills, including stored procedures, execution-plan analysis and indexing; ability to translate existing business logic into modern pipelines.
- Practical dimensional-modeling skills and experience with incremental processing, schema changes, automated testing, data-quality controls and migration reconciliation.
- Proficiency with Git, CI/CD and environment-based deployment; practical knowledge of the on-premises data gateway for secure source connectivity.
- Ability to independently develop, test, deploy and troubleshoot assigned work within team architecture, seek design review and communicate clearly with technical and business colleagues.
- Sound judgment in protecting sensitive data and applying privacy, security and regulatory safeguards; commitment to documentation and knowledge sharing.
- Experience migrating SQL Server datamarts or transferable Spark experience from Microsoft Fabric, Databricks, or Azure Synapse.
- Advanced Power BI semantic-model development, including DAX, row-level security and Direct Lake.
- Banking or financial-services experience, or relevant Microsoft Fabric or data engineering certifications. Certifications are not required.
Skills Required
- 5+ years of relevant data engineering or development experience, or equivalent demonstrated capability
- Strong production Python, PySpark, and SQL development skills
- Bachelor's degree in Computer Science, Engineering, or a related field, or equivalent relevant work experience
- Hands-on Microsoft Fabric experience with Lakehouses, OneLake/Delta tables, notebooks, and pipelines
- Production experience with Python, PySpark, and Spark SQL transformation, troubleshooting, and performance tuning
- Strong SQL Server and T-SQL skills, including stored procedures, execution-plan analysis, and indexing
- Practical dimensional-modeling experience
- Experience with incremental processing, schema changes, automated testing, data-quality controls, and migration reconciliation
- Proficiency with Git, CI/CD, and environment-based deployment
- Practical knowledge of the on-premises data gateway for secure source connectivity
- Ability to independently develop, test, deploy, and troubleshoot assigned work within team architecture
- Ability to communicate clearly with technical and business colleagues
- Knowledge of sensitive-data protection, privacy, security, and regulatory safeguards
- Commitment to documentation and knowledge sharing
- Experience migrating SQL Server datamarts or transferable Spark experience from Microsoft Fabric, Databricks, or Azure Synapse
- Advanced Power BI semantic-model development, including DAX, row-level security, and Direct Lake
- Banking or financial-services experience
- Microsoft Fabric or data engineering certifications
Central Bank Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Central Bank and has not been reviewed or approved by Central Bank.
-
Retirement Support — A two-part 401(k) combines a 50% match on the first 6% contributed with an automatic 4% nonelective employer contribution, with auto-enrollment and auto-escalation. Employer funds vest on a graded schedule reaching 100% at five years.
-
Leave & Time Off Breadth — PTO for full-time staff starts at 18 days per year and increases with service up to 27 days, and the organization follows the Federal Reserve holiday schedule. Part-time employees accrue PTO on a pro‑rata basis.
-
Healthcare Strength — Medical, dental, vision, and prescription coverage are offered with eligibility typically beginning the first of the month after hire, alongside HSA and FSA options. Life, AD&D, and short- and long-term disability plus an EAP enhance health and protection.
Central Bank Insights
What We Do
Central Bank is a privately held $20 billion bank headquartered in Jefferson City, Missouri. Serving 13 markets in 8 states. Central Bank specializes in community banking, with a particular focus on delivering leading-edge technology through its network of more than 150 facilities operating in Missouri, Kansas, Illinois, Colorado, Iowa, Tennessee, North Carolina, Florida, and Oklahoma, as well as more than 22,000 ATMs nationwide. Member FDIC. "Strong Roots. Endless Possibilities." reflects our long-standing commitment to the communities we serve, as well as our commitment to delivering high-quality, leading-edge financial products and services that help our customers and communities grow and succeed. As our product and service offerings continue to expand, we assure you that our commitment to the community will only grow stronger. All of our lending decisions are made locally in the community you live. Equal Opportunity Employer–minorities/females/veterans/individuals with disabilities/sexual orientation/gender identity.
