Senior Data Analyst Lead

Evangelical Lutheran Church in America•Chicago, IL
•$92,810 - $139,235•Hybrid

About The Position

The Senior Data Analyst Lead, within the Office of the Treasurer, IT and Digital Solutions, serves as the enterprise subject matter expert and steward for the ELCA Data Lake, Snowflake platform, Microsoft SQL Server environments, Azure SQL Managed Instances, Azure Data Factory resources, and enterprise reporting environment. The role ensures the integrity, usability, governance, documentation, and strategic value of organizational data assets while leading the design and evolution of enterprise reporting solutions. The position partners with a database managed service provider and internal stakeholders to maintain SQL environments, enforce data standards, and deliver secure, scalable, well-documented data solutions. It standardizes analytics and advises on performance reporting across ELCA digital systems to improve effectiveness and engagement. The role requires business acumen, advanced SQL and data modeling knowledge, practical Azure Data Factory experience, Power BI reporting architecture skills, and the ability to communicate data concepts to technical and non-technical stakeholders. This is a full-time, exempt, Chicago-based position requiring at least two days per week in the office and possibly more for in-person meetings. Candidates must reside in one of the fifty United States or the District of Columbia and be authorized to work lawfully in the United States. The position requires minimal travel, up to 5% (approximately three weeks).

Requirements

  • At least 5 years of experience in data analytics, business intelligence, reporting, or related disciplines.
  • At least 5 years of experience in data modeling, relational database design, relational database best practices, and database architecture.
  • At least 3 years developing enterprise reporting and dashboard solutions using Microsoft Power BI.
  • Bachelor’s degree in Data Analytics, Computer Science, Information Systems, Statistics, Mathematics, Business Analytics, or a related field, or an equivalent combination of education and professional experience.
  • Familiarity querying Microsoft SQL Server and/or Azure SQL Managed Instance environments.
  • Experience working with Snowflake or comparable cloud-based data lakes.
  • Appreciation for the vision, purpose, and values of the ELCA.
  • Commitment to diversity, equity, inclusion, accessibility, and anti-racism.
  • Computer knowledge sufficient to operate a Windows computer and follow basic troubleshooting instructions; software skills to efficiently use computer programs and applications; and ability to learn new software, follow processes, and identify opportunities for improvement.
  • Experience using Microsoft Office applications such as Word, Excel, Teams, and Outlook.
  • Must reside within the fifty United States or the District of Columbia and be authorized to work lawfully in the United States.

Nice To Haves

  • Valid driver’s license.

Responsibilities

  • Serve as the primary steward for ELCA’s enterprise data platforms, including the Data Lake, Snowflake, Azure Data Factory, SQL Server, Azure SQL Managed Instance, and enterprise reporting infrastructure.
  • Design, develop, monitor, optimize, and document data pipelines, integrations, analytics-ready data structures, databases, reports, dashboards, datasets, semantic models, KPIs, and reusable reporting assets.
  • Partner with application teams, product owners, business stakeholders, enterprise architecture, vendors, and reporting service providers to onboard data sources, define requirements, improve data capabilities, and support organizational decision-making.
  • Conduct advanced analysis to identify trends, risks, opportunities, performance insights, and continuous improvement opportunities supporting leadership, operational, program, digital strategy, and reporting needs.
  • Establish and promote standards for data quality, governance, validation, reporting controls, database design, Power BI development, workspace organization, naming conventions, documentation, and dashboard and report design.
  • Maintain data dictionaries, report catalogs, metadata repositories, data lineage, KPI definitions, business rules, refresh logic, training materials, and knowledge-transfer resources.
  • Provide technical guidance, mentoring, and advisory support to leadership, stakeholders, developers, report developers, application teams, and project teams; collaborate using Agile tools such as Azure DevOps or Jira.
  • Evaluate emerging technologies and practices in analytics, relational databases, cloud data platforms, business intelligence, automation, and artificial intelligence.
  • Perform other duties as required.

Benefits

  • Employer-paid health premiums for employees.
  • Health and dependent care flexible spending accounts.
  • Health savings account with an employer contribution.
  • Life insurance.
  • Substantial employer contribution to a 403(b) retirement plan; no match required.
  • Generous paid time-off policy, including 17 paid holidays.
  • Benefits commence on the start date.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service