Job Description
Position summary
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.
Required qualifications
- 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.
Preferred Qualifications
- 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.
Monday - Friday 8:00am - 4:30pm Central Technology Services
Numbers & Facts
| Location | Jefferson City, MO |
| Industry | Banking |
| Company Size | 100 to 499 employees |
| Year Founded | 1902 |
| Website | https://www.centralbank.net/ |
Benefits
Paid Sick Days, Performance Bonus, Prescription Drug Coverage, Professional Development, 401K, Employee Referral Program, Flexible Spending Accounts, Employee Events, Tuition Reimbursement, Life Insurance
About Company
Central Bank has been serving the St. Louis metropolitan area for over 115 years. Since our inception we have been a conservative financial institution and have always focused on the basic business of making loans in and attracting deposits from the communities we serve. Today we still take the same approach to our business throughout the metropolitan area.
We offer local management, long-term stability and a full range of deposit and lending products and services coupled with a very personalized approach to providing financial services.
We are one of the top mortgage lending providers in the St Louis area with a knowledgeable and experienced group of loan officers and mortgage staff. Our commercial lending team has a long history of working with businesses to finance their needs today and as they grow in the future.
Central Bank offers a full range of online banking services including online bill pay, mobile check deposit, e-statements and a full complement of checking and savings products
Central Bank is a wonderful place to grow and develop your talent! We are more than a place to work, we encourage teamwork, community involvement, and a family environment rooted in respect and pride for each person who contributes to our success and the success of our customers.
Central Bank is family-owned. We refer to our team as our “Central Bank family.” This comes from a genuine appreciation for the people who dedicate their talent to our company’s success. Providing outstanding benefits is one of the primary ways we strive to be an employer-of-choice. Our overall compensation philosophy is based on pay for performance and ensures our employees are paid competitively. Our employees also have access to a comprehensive package of benefits, rewards and recognition.
Skills
Level up your application
Professional resume templates
Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.
Free resume templatesResume Builder
Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.
Resume Builder