ETL Developer (Lakeville, MN; Rochester, MN; Sun Prairie, WI, or

Job Listing No: 9740000

ETL Developer (Lakeville, MN; Rochester, MN; Sun Prairie, WI, or

Position Overview: This position is responsible for the development, enhancement and effective operations of data movement between various systems using ETL methodologies. Responsible for leading company database development efforts and coordinating with business users, consultants/contractors, vendors and internal team members to maximize the usage and value of company data assets.Essential Functions: * Design, build, deploy and maintain SSIS packages. * Develop, maintain and administer system databases. * Create logical links between databases to as part of an Enterprise Data Warehouse. This may be accomplished by utilizing various SQL tools. * Function as a primary contributor in designing, coding, testing and debugging ETL packages and processes to create a seamless data flow. * Support overall strategy as it relates to database and data warehouse development. * Monitor, troubleshoot and analyze ETL process failures, data anomalies, inconsistencies and other ETL related issues identified by monitoring, technical staff, and end-users. Effectively communicate findings. * Interact with Business Technology department and vendor support personnel to define and resolve systems-related problems. * Actively participate with Business Technology department in preparing and implementing backup and disaster recovery procedures and processes for mission critical databases. * Work with business units/data owners to classify database data for appropriate security, backup, and performance characteristics. * Generate automated, repeatable and stable processes to support data load, data validation, and data synchronizations for the data warehouse. * Create database coding requirements for data warehouse data migrations and business unit and SQL-server projects via programming and the various SQL languages. * Identify and resolve data integrity issues between the data warehouses and the original data sources. * Contribute to data dictionaries and database diagrams for complex in-house databases. * Provide on-call support for problem resolution of database-related issues.Minimum Qualifications & Required Knowledge, Skills and Abilities: * Bachelor”s degree in Computer Science, Engineering, MIS or related field or an equivalent combination of education and experience sufficient to perform the essential functions of the job. * 3+ years of experience with various MS SQL environments (2008, 2012, 2014, 2017), designing and implementing SSIS packages and ETL development using SQL Server Data Tools. * Strong SQL server knowledge of T-SQL and OLTP topics such as normalization, data types, query tuning, indexing, constraints and query plans, etc. * SQL Reporting Services (SSRS) or comparable reporting tools experience. * Ability to translate highly technical information into non-technical terms. * Proven client service skills and effective team skills are essential. * Experience with software deployment, version control, and build automation preferred. * Certifications in SQL Server and/or other Microsoft technologies preferred, but not required.
On July 1, 2017 AgStar Financial Services, Badgerland Financial and 1st Farm Credit Services joined together as Compeer Financial, strengthening our commitment to the agricultural community.Compeer Financial, headquartered in Sun Prairie, WI, exists to champion the hopes and dreams of rural America like never before. If you are interested in empowering those in agriculture and rural communities to achieve their goals and expand their possibilities, we invite you to learn more about our organization. We are looking for innovative, dynamic and collaborative team members to join our team.We offer great benefits including: * Competitive base salary * Health insurance benefits (medical, dental, vision, etc.) * 401k (3% Compeer contribution & up to an additional 6% match) * Paid vacation, sick leave, and holidays * Educational assistance * Training and development programs * Qualified candidates please apply online at www.compeer.com/careers.Compeer Financial is an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, or any other characteristic protected by law.

Apply for this job.




Similar Jobs For "ETL Developer (Lakeville, MN; Rochester, MN; Sun Prairie, WI, or"



 Jobs by Indeed job search

E-Commerce Web Developer

Company: Midwest Veterinary Supply
Location: Lakeville, MN 55044
Is seeking a E-Commerce Web Developer: For our Lakeville, Minnesota corporate office. This position will work closely with the E-Business Director, E-Commerce,… To apply for this job vacancy in Midwest Veterinary Supply you must be qualified and you should prepare the required documents, click on the job link for more details.
Posted 7 days ago

Logistics Analyst

Company: Midwest Veterinary Supply
Location: Lakeville, MN 55044
For our Lakeville, MN corporate office. Work with software developers to provide testing and feedback on pending system changes, upgrades, and installs. To apply for this job vacancy in Midwest Veterinary Supply you must be qualified and you should prepare the required documents, click on the job link for more details.
Posted 13 days ago

Quality Assurance Analyst

Company: Compeer Financial
Location: Lakeville, MN
MN - Lakeville , MN - Mankato , MN - Rochester , IL - Normal Support , WI - Sun Prairie. Communicates with and makes recommendations to business analysts and… To apply for this job vacancy in Compeer Financial you must be qualified and you should prepare the required documents, click on the job link for more details.
Posted 18 days ago

Technology Business Partner

Company: Compeer Financial
Location: Sun Prairie, WI
Mankato, MN or Lakeville, MN). WI - Sun Prairie , MN - Lakeville , MN - Mankato , IL - Normal Support. Working knowledge of developer resources, SSRS, document… To apply for this job vacancy in Compeer Financial you must be qualified and you should prepare the required documents, click on the job link for more details.
Posted 30+ days ago

Business Systems Analyst -Trade & Finance - Lakeville, MN

Company: Post Consumer Brands
Location: Lakeville, MN
The Business Systems Analyst is responsible for collaborating with Business leaders and IT partners to help define business requirements for technological… To apply for this job vacancy in Post Consumer Brands you must be qualified and you should prepare the required documents, click on the job link for more details.
Posted 6 months ago






Note: This job listing with titled "ETL Developer (Lakeville, MN; Rochester, MN; Sun Prairie, WI, or" was indexed from different job portals. This job might be expired or closed for accepting CV's so we suggest to browse it from the new jobs menu of this site. Our website is an open community website for assisting job seeker so if you found some broken links or error in our site don't hesitate to contact us to fix the issue. Thank you for using our free services.