• Green Bay, Wisconsin
    21 days ago

    Job Description

    ETL Developer
    Jack Schroeder and Associates, LLC
    Green Bay, WI 54304
     
    About Us:
    At Jack Schroeder and Associates (JSA), we take pride in fostering a supportive environment where our employees' dedication directly impacts the exceptional service we
    provide to our partners. For over 50 years, we've stood out as a brokerage that goes above and beyond to support our agents. With an unmatched back-office support system, advanced technology, and a dedicated team, we make doing business easy and efficient.
     
    Primary Responsibilities:
    ETL Design & Development:
    • Develop and implement ETL processes to extract data from various sources, transform it as per business requirements, and load it into target systems.
    • Design and develop complex SQL queries, scripts, and procedures to support data transformation and manipulation.
    Data Integration:
    • Integrate data from multiple sources including databases, flat files, APIs, and cloud services.
    • Ensure seamless data flow between systems while maintaining data quality and consistency.
    Performance Optimization:
    • Optimize ETL processes for performance, scalability, and reliability.
    • Troubleshoot and resolve ETL performance issues, data discrepancies, and failures.
    Data Quality & Validation:
    • Implement data validation and cleansing processes to ensure data accuracy and integrity.
    • Monitor ETL jobs and workflows to ensure data loads are completed successfully and in a timely manner.
    Documentation & Reporting:
    • Create and maintain detailed documentation for ETL processes, workflows, and data mappings.
    • Generate reports and dashboards to provide insights into ETL performance and data quality.
    Collaboration:
    • Work closely with business analysts and data scientists to understand data requirements and deliver solutions that meet their needs.
    • Participate in data architecture and design discussions to ensure alignment with overall data strategy.
    What We Offer
    At JSA we recognize how critical our team’s hard work and dedication is in providing our partners with exceptional service. We are proud to offer our employee’s a competitive salary and benefits!
    • Competitive salary tailored to your experience
    • A comprehensive benefits package that includes PTO, medical, dental, vision, retirement savings, disability insurance, and life insurance.
    • Half-day Fridays from January through September, with full-day pay, to support work-life balance
    • Paid company holidays
    • Opportunities for professional development to grow your skills and advance your career
     
    Qualifications, Skills & Abilities:
    • Solid understanding of data warehousing concepts and methodologies.
    • Familiarity with scripting languages (e.g., Python, Shell) is desirable.
    • Experience with cloud-based ETL tools and services (e.g., Azure Data Factory or DataBricks) is a plus.
    • Strong problem-solving skills and attention to detail.
    • Excellent communication and teamwork skills.

    Experience:
    • Proven experience as an ETL Developer or in a similar role.
    • Hands-on experience with ETL tools such as [e.g., Datafactory, Tableau, PowerBI].
    • Strong proficiency in SQL and database management systems (e.g., Oracle, SQL Server, MySQL).
     
    Equal Employment Opportunity Statement
    We are an Equal Opportunity Employer and value diversity at all levels of the organization. All employment decisions are made without regard to race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), sexual orientation, gender identity or expression, age, national origin, ancestry, disability, genetic information, marital status, veteran or military status, or any other protected characteristic under applicable federal, state, or local law. We are committed to providing an inclusive, equitable, and respectful workplace where all employees can thrive.
     
    Americans with Disabilities Act (ADA) Statement
    We are committed to full compliance with the Americans with Disabilities Act (ADA) and all applicable state and local disability laws. Reasonable accommodations are available to qualified applicants and employees with disabilities throughout the application and employment process. Requests for accommodation will be handled confidentially. If you require assistance or accommodation during the application process, please contact us at HR@AmeriLife.com.
     
    Pay Transparency Statement
    We are committed to pay transparency and equity, in accordance with applicable federal, state, and local laws. Compensation for this role will be determined based on skills, qualifications, experience, and market factors. Where required by law, the pay range for this position will be disclosed in the job posting or provided upon request. Additional compensation information, such as benefits, bonuses, and commissions, will be provided as required by law. We do not discriminate or retaliate against employees or applicants for inquiring about, discussing, or disclosing their pay or the pay of another employee or applicant, as protected under applicable law. Pay ranges are available upon request.
     
    Background Screening Statement
    Employment offers are contingent upon the successful completion of a background screening, which may include employment verification, education verification, criminal history check, and other job-related inquiries, as permitted by law. All screenings are conducted in accordance with applicable federal, state, and local laws, and information collected will be kept confidential. If any adverse decision is made based on the results, applicants will be notified and given an opportunity to respond.

    Numbers & Facts

    LocationGreen Bay, Wisconsin

    Skills

    • Administrative Skillsunmatched
    • Application Programming Interface (API)unmatched
    • Brokerageunmatched
    • Business Analysisunmatched
    • Cloud Computingunmatched
    • Communication Skillsunmatched
    • Data Processingunmatched
    • Data Qualityunmatched
    • Data Scienceunmatched
    • Data Warehousingunmatched
    • Database Extract Transform and Load (ETL)unmatched
    • Database Management Software/Systems (DBMS)unmatched
    • Detail Orientedunmatched
    • Diversityunmatched
    • Equal Employment Opportunity (EEO)unmatched
    • Federal Laws and Regulationsunmatched
    • Identify Issuesunmatched
    • Legalunmatched
    • Microsoft SQL Serverunmatched
    • Microsoft Windows Azureunmatched
    • MySQLunmatched
    • Oracle Databaseunmatched
    • Performance Tuning/Optimizationunmatched
    • Power BIunmatched
    • Problem Solving Skillsunmatched
    • Process Improvementunmatched
    • Python Programming/Scripting Languageunmatched
    • Quality Managementunmatched
    • Reporting Dashboardsunmatched
    • Reporting Skillsunmatched
    • SQL (Structured Query Language)unmatched
    • SQL Databasesunmatched
    • Scripting (Scripting Languages)unmatched
    • State Laws and Regulationsunmatched
    • Tableauunmatched
    • Team Playerunmatched
    • Time Managementunmatched
    • Unix Shell Programmingunmatched

    Be found by employers

    5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

    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 templates

    Free resume builder

    Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

    Free resume builder