Compassion International

  • Senior Business Intelligence Analyst

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




    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


    • 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



    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
    • Base SAS
    • Data stewardship, data quality
    • Netezza and Microsoft SQL Server
    • 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 Environment: Office – Standard Office Environment
    • Physical Demands: Sitting or standing at a desk for up to 8 hours per day
    • Travel Requirements: No travel


    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed

    Need help finding the right job?

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