Sr Data Integration and Warehouse Developer

Company: Regional Recreation Corporation of Wood Buffalo
Location: Saint Paul
Posted on: February 23, 2021

Job Description:

Fairview is proud to be an equal opportunity employer. We do not discriminate against any employee or applicant for employment on the basis of race, color, creed, religion, national origin, sex, sexual orientation, gender or gender identity, age, disability, veteran status, genetic information, or any other characteristic protected under applicable federal, state, or local law. Persons with hearing or speech disabilities may contact us via their preferred Telecommunication Relay Service. Sr Data Integration and Warehouse Developer in Saint Paul, Minnesota - Careers at HE-Midway Corporate Campus Please Enable Cookies to Continue Please enable cookies in your browser to experience all the personalized features of this site, including the ability to apply for a job. Welcome page Welcome page Returning Candidate? Log back in! Sr Data Integration and Warehouse Developer Job Locations US-MN-Saint Paul Requisition Post Information* : Posted Date 4 days ago (1/27/2021 2:59 PM) Requisition ID 2021-67073 Profession Non-Clinical Professional Speciality Information Technology Location Midway Corporate Campus Shift day Hours per 2 weeks 80 Department Data Technologies Overview The Senior Data Integration and Warehouse Developer designs, develops, tests and maintains Extract, Transform, and Load (ETL) processes. The Senior Data Integration and Warehouse Developer also documents, develops, and manages the creation of logical and physical data models. Additionally, technical expertise is applied to the design, development, and support of processing data of multiple databases and data formats involving both internal and external sources and targets. Highly tuned and efficient code, high levels of data quality and delivery excellence, effective and proactive verbal and written communication, excellence in customer service and partnerships, and teamwork are key success factors for this senior role. Responsibilities/Job Description

• Design, develop, test, and production support maintenance of data management and integration processes serving a highly visible, enterprise level customer base.
• Apply initiation and leadership skills with analysts, business owners, and end users to define and document business, technical, financial, and operational support requirements.
• Translate business requirements into technical solutions, dealing well with ambiguity, and concluding how deliverables meet business goals. Perform data analysis and data modelling to create source to target mapping documents. Perform data profiling as one means to output proof of high levels of data quality.--
• Create, publish, distribute, and present design documents and other documentation, including logical or physical data models, end-to-end data integration diagrams, and Service Level Expectation documents.
• Develop effective error handling, perform unit testing, and gain stakeholder acceptance as key implementation and production support readiness criteria.
• Effectively balances and prioritizes workloads among project work development, support maintenance and operations (including on-call rotation), innovation and creativity, and initiative in a proactive, continuous improvement environment.
• Completes complex work assignments independently, takes initiative to flush out gaps in requirements or hopeful business outcomes, documents and confirms key understandings, and produces products with extremely low production support footprints.
• Performs consistently as a team player who shares knowledge, maintains effective working relationships, and puts yourself in service to others-maintaining extremely high customer service levels.
• Contributes to the development of team process and technical standards, including the creation of reusable code base, highly efficient job scheduling and batch performance, service management excellence, and financial improvements.
• As a continuous improvement environment, always seeks to learn, test, and incorporate new methods at any phase of the delivery and service management lifecycle. Qualifications Required: Education
  • Bachelor's Degree in related field or a minimum of six years progressively related experience. Experience
    • 6+ years of ETL and SQL development experience, preferably Data Stage or SSIS.--
    • 6+ years of experience delivering data quality outcomes, performing and presenting data profiling results, working with relational databases and a multitude of file formats.
    • 6+ years of experience using technical expertise to engage customers and recommend and deliver lean, cost-effective solutions.--
    • 6+ years of experience with logical and physical data modelling.--
    • 6+ years of experience with data warehouse design and methodologies, including change data capture, star schemas, snowflakes, cubes and dimensional modeling.
    • Demonstrated excellence using logical, analytical, and creative problem-solving skills.
    • Excellent influence skills, using written and oral communication skills--including the ability to communicate ideas in both technical and business terms.--
    • Proven ability to conduct root cause analysis and research into systems and data issues. Preferred: Education
      • Bachelor's Degree in related field Experience
        • Work history in the healthcare delivery or insurance industry
        • Service Now
        • Oracle SQL Developer
        • Windows Scheduler
        • E xperience with Epic Systems Electronic Health Record software -- License/Certification/Registration
          • Epic Clarity Administration experience or certification
          • Epic Caboodle --Administration-- experience or certification
          • Epic Caboodle Developer experience or certification This position requires remote work. In addition to adhering to all Fairview policies, guidelines, procedures, the Fairview Commitments, and the Code of Conduct, i t is the expectation the following requirements of the remote work policy will be met, including but not limited to:
            • Remote workspace that is clean, safe,--and--professional.
            • Maintains an internet connection consistent with Fairview standards at remote workspace.
            • Remain productive and responsive during their scheduled work hours.
            • Attend primary Fairview location, as needed. Options Apply for this job online Apply Share Email this job to a friend Refer Sorry the Share function is not working properly at this moment. Please refresh the page and try again later. Share on your newsfeed Loading... Need help finding the right job? We can recommend jobs specifically for you!Click here to get started.
              
              Fairview Health Services (fairview.org) is an award-winning, nonprofit health system providing exceptional care across the full spectrum of health care services. Fairview is one of the most comprehensive and geographically accessible systems in the state, with 12 hospitals-including an academic medical center and long-term care hospital-serving the greater Twin Cities metro area and north-central Minnesota.
              
              Its broad continuum also includes 56 primary care clinics, specialty clinics, senior living communities, retail and specialty pharmacies, pharmacy benefit management services, rehabilitation centers, counseling and home health care services, medical transportation, an integrated provider network and health insurer PreferredOne. In partnership with the University of Minnesota, Fairview's 32,000 employees and 2,400 affiliated providers embrace innovation to drive a healthier future through healing, discovery and education.
              
              EEO/AA Employer/Vet/Disabled All qualified applicants will receive consideration without regard to any lawfully protected status. Application FAQs Software Powered by iCIMS
              www.icims.com

Keywords: Regional Recreation Corporation of Wood Buffalo, St. Paul , Sr Data Integration and Warehouse Developer, IT / Software / Systems , Saint Paul, Minnesota