Compassion International

  • Business Intelligence Analyst III

    Job ID
    2018-17773
    Location Name
    Colorado Springs - GMC
    Category
    Business Analysis
  • Overview

     

     

    JOB BRIEF

    This role will be a part of the USA Consumer Insights organization, serving on the Business Intelligence team. You will make marketing data more accessible, accurate, and efficient as you support fellow team members and the operational needs of the USA Marketing division. You will execute these functions through problem analysis, code development, and partnership with coworkers from many parts of the organization, so that Compassion USA can meet and exceed industry-leading growth to accomplish the organizational mission of releasing children from poverty in Jesus’ name.

    Essential Job Functions

    ESSENTIAL JOB FUNCTIONS

    • Maintains a personal relationship with Jesus Christ. Is a consistent witness for Jesus Christ, maintains a courteous, Christ-like attitude in dealing with people within and outside of Compassion, and faithfully upholds Compassion’s ministry in prayer.
    • Acts as an advocate for children – raising the awareness of the needs, neglect, nurture, and potential of children in poverty and challenging and enabling those within one’s influence to greater involvement and effectiveness on behalf of children.
    • Builds and maintains BI data infrastructure (which includes ETLs, macros, and SQL views) to make data accessible, accurate, and efficient for other members of the Consumer Insights Team
    • Becomes an expert on the systems and business processes that create and consume data
    • Uncovers, analyzes, and monitors issues to improve data integrity for USA Marketing
    • Resolves data integrity issues using multiple methods: through data loads to the source system of record; by partnering with IT to improve system integrations, form validations, data replication, and performance issues; and by partnering with business training teams for end-user education; and by developing reports for business QA teams for manual correction
    • Prepares data files to send to vendors for data enhancement services
    • Prepares data files for bulk loading to the source system of record
    • Advocates in business projects and other system changes to improve data integrity and data accessibility
    • Reports on the extent and business impact of data quality issues
    • Builds and maintains documentation for use by fellow team members
    • Contributes to team culture, team efforts, and team development

    Qualifications

    JOB QUALIFICATIONS

    Required Qualifications:

    • Has a personal relationship with Jesus Christ.
    • Accountable for supporting, upholding, and engaging in Compassion's core "Cultural Behaviors" in all internal and external communication and relationships.
    • Relevant work experience required to enable the individual to be able to successfully perform the job as listed.
    • Problem solving
    • Attention to detail
    • Task management
    • Relational databases, SQL queries, and DDL commands
    • Data analysis
    • Data transformation
    • Root cause analysis

    Desired Qualifications:

    • Data warehousing, ETL systems, and data virtualization
    • Data stewardship, data quality
    • Netezza and Microsoft SQL Server
    • Base SAS
    • Salesforce and NetSuite data or similar CRM and ERP systems in a marketing environment
    • A general programming language such as C#, Java, or Python

     

    WORKING CONDITIONS

    • Working Environment: Office – Standard Office Environment
    • Physical Demands: Sitting or standing at a desk for up to 8 hours per day
    • Travel Requirements: No travel

    Need help finding the right job?

    We can recommend jobs specifically for you! Click here to get started.