As a member of the Business Intelligence team, the Data Engineer 3 engages with multiple departments throughout the organization to take their data and transform it into information that will enable them to make better decisions. As an experienced professional, the Data Engineer 3 gathers business requirements and designs, creates, and supports the data warehouse. This individual works with divine guidance to provide or support technology that furthers the mission of the Church and reflects the eternal impact of the gospel.

Required:

Education:

Bachelor's degree in related field or equivalent professional experience

Work Experience:

4 years of data warehouse experience 2 years of professional experience in data analysis and report design/development 1 year of experience in presentation/interface creation

Demonstrated Skills & Abilities:

Great verbal and written communication skills Proven troubleshooting skills Ability to train peers and system users Capable of working under pressure to resolve complex problems General knowledge of engineering best practices Operational understanding and discipline Ability to resolve security issues and requests and implement improvements Proficient in dimensional data modeling Ability to quickly learn new tools and technology Strong problem solving, analytical, and diagnostic skills Good documentation, presentation, and communication skills Refined skills in developing ETL code Can ingest and clean large sets of structured and unstructured data Familiar with DevOps/DataOps process Experienced with SQL Familiar with technologies such as Python, Spark or PowerShell Familiar with cloud services from providers such as AWS, Azure, or Google Working knowledge of the algorithms used for regressions, clustering, classification, forecasting, and constructing graphs Familiar with Bayesian inference This job operates in a professional office environment To successfully perform the essential functions of the job there may be physical requirements which need to be met such as sitting for long periods of time and using computer monitors/equipment

Preferred:

Master's degree Possess and utilize broad knowledge, specific to the data field, to complete significant assignments Maintain a keen understanding of the supported business processes Gather and document requirements for the data warehouse Aid in the design of Star Schema data models Maintain and support ETL jobs, pulling data from various source systems and loading data into the data warehouse Assist in designing semantic layer to support end-user self-service Build complex reports using SQL Server Reporting Services (SSRS) Create complex dashboards using Microsoft Power BI or Tableau Analyze data and trends, and create reports that highlight areas in need of performance improvement Interact with customers as a technical resource to troubleshoot problems with the delivered BI solutions Maintain production documentation