Data Warehouse Developer Job Details | Farm Credit Mid-America
FCS of Mid America - Jeffersontown, KY
posted 6 days ago
About the position
Farm Credit Mid-America is a financial services cooperative serving financial needs of farmers and rural residents in Arkansas, Indiana, Kentucky, Missouri, Ohio, and Tennessee. Our purpose is to secure the future of rural communities and agriculture. We are passionate about serving the needs of our rural communities and creating positive customer experiences. Our Data Warehouse developer is responsible for developing multi-dimensional data models to support analytics and reporting. Coordinates with departmental analysts and enterprise stakeholders to build and curate a collection of data objects that allow business units to optimize delivery via self service reporting, dashboards, and analytics.
Responsibilities
- Designing, developing and modifying multidimensional database structures in support of reporting and analytics.
- Maintaining data lineage through source-to-target mapping documentation and documenting rules and procedures to transform, process and load data into the data warehouse and data marts.
- Analyzing data quality concerns in the data warehouse in collaboration with application and business process owners.
- Empowering business users by building and maintaining a user-friendly self-service analytics platform.
- Optimizing data models and query performance to maintain up time and agreed upon data refresh timelines.
- Collaborating with business stakeholders to identify data needs and translate them into actionable analytic solutions.
- Adhering to SQL coding standards alongside a healthy and robust peer review process.
Requirements
- Bachelor's Degree (or equivalent relevant work experience) in computer science, data sciences or related field.
- 4 years relevant work experience building, deploying, and supporting Enterprise Data Warehouse capabilities.
- Providing clean, transformed data ready for analysis to other areas in collaboration with our data warehouse architect.
- Applying software engineering best practices to analytics code (e.g., Version control, testing, continuous integration).
- Maintaining data documentation and definitions.
Benefits
- Competitive total rewards package
- Award winning 401(k) Plan
- Health and Financial wellness benefits providing safety, security and peace of mind for you and your family.
