Data Engineer 3 - Part-time
About the role
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 to provide or support technology that furthers the mission of the Church and reflects the eternal impact of the gospel.
Responsibilities
- 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
Requirements
- Bachelor's degree in related field or equivalent professional 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
Skills
- 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
Work Environment
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.
About Us
Church employees find joy and satisfaction in using their unique talents and abilities to further the Lord’s work. From the IT professional who develops an app that sends the gospel message worldwide, to the facilities manager who maintains our buildings—giving Church members places to worship, teach, learn, and receive sacred ordinances—our employees seek innovative ways to share the gospel of Jesus Christ with the world. They are literally working in His kingdom. Only members of the Church who are worthy of a temple recommend qualify for employment.