Data Warehouse Developer

Data Warehouse Developer
Location: Cincinnati, OH
Department: Technology

For additional information or to apply for this opportunity, please visit feg.com/careers.

About the Role / Position Summary

The Data Warehouse Developer is accountable for designing, developing, testing, deploying, and maintaining high-quality cloud-based solutions using Power Platform tools and services following Agile development methodologies. Ideal candidates possess a strong understanding of software development and the software development life cycle, excel in collaborating within small technical teams, and focus on code reusability and solution flexibility. Experience in building relational and multidimensional databases, developing and testing ETL/ELT processes, and working within Microsoft Azure is essential for success in this role.

What You’ll Do / Position Responsibilities

Administration

• Database Administrator; configuration, maintenance and support of Azure production database environment ensuring strong security/compliance enforcement, following best practices and continuous improvement.

Development

• SQL Server SME, ETL SME and Data Governance agent.
• Translate business requirements into well-architected deliverables using Microsoft Power Platform.
• Build, test, deploy, and support Microsoft Power Platform custom applications in accordance with established standards and best practices.
• Participate in technical design sessions; develop detailed technical solution documentation that is aligned with client business objectives.
• Design and develop transactional and dimensional (Kimball methodology) data models, and create database tables, views, stored procedures, SSAS Tabular models, PBI datasets and ETL processes.
• Analyzing and resolving application or system issues.

Integrations

• Manage and support integrations of solutions while understanding cloud architecture, data integration, security, and performance optimization.
• Understand business difficulties to provide solutions by applying problem-solving skills to automate business processes.
• Keep abreast of new technologies and be aware of best practices around data engineering/processing.

Overall

• Consistently follow Agile project management methodology.
• Consistently recognize the Microsoft Power Platform Center of Excellence (CoE).
• Work in close collaboration with other engineers, designers, analysts, and other teams and stakeholders.
• Maintain up-to-date and extensive knowledge of cloud technology.
• Project Management on assigned projects.

You’ll Enjoy This Job If You… / Skills & Characteristics

• Listen and learn while still taking full ownership of the individual scope of work and working with a team.
• Take pride in having and continuing to develop expert financial data domain knowledge.
• Enjoy ensuring clients have excellent customer service.
• Care about data quality and consistency.
• Create & follow processes while thinking through efficiencies.
• Engage collaboratively with clients, investment teams and peers.
• Prioritize effectively and decisively across complex teams and competing priorities.
• Enjoy working in and learning about the financial investment industry.

What We Expect / Qualifications

• Bachelor’s degree in Computer Science, Engineering, Information Systems, or equivalent experience. For certain positions, we accept a high school diploma, GED, or National Career Readiness Certificate (NCRC).
• 5+ years’ work experience in technology solutions/IT function.
• 5+ years’ work experience using MS SQL Server 2016 or higher and exemplary knowledge of T-SQL.
• Previous implementation of a production data warehouse environment (databases and ETL).
• 3 years’ work experience using SSAS Tabular, DAX and JSON.
• Knowledge of SQL Server 2017 or higher, REST API, PowerShell, JavaScript, HTML.
• 3 years’ work experience using MS SQL Server Integration Services (SSIS).
• Work experience developing Azure Data Factory pipelines.
• 3+ years’ development experience with Power Platform (Power Apps/Logic Apps/Power Automate).
• Work experience developing Power BI dashboards and Paginated reports (SSRS) desired.
• Exceptional attention to detail.
• Ability to identify and resolve/escalate complex problems with minimal guidance.
• Ability to work independently as well as in a team environment.
• Experience working with business teams to gather business requirements.
• Project Management experience (SEI CMM level 2 or higher).
• Experienced in Microsoft Office, Excel, PowerPoint and SharePoint, excellent written and verbal communication skills, and high work ethic.

What We Offer / Benefits & Compensation

• Competitive compensation and bonus opportunities commensurate with qualifications and performance.
• Employer Paid Life/STD/LTD and subsidized Medical, Dental & Vision plans.
• Wealth Benefits including company contributions into 401(k) and ESOP programs.
• Paid Time Off (Holidays, PTO, Parental Leave) and flexible/hybrid working.
• Employee Led Culture Committees dedicated to enabling a happy and healthy company culture.

Why FEG? / About the Company

FEG is an independently owned advisory firm that provides investment consulting, outsourced chief investment officer (OCIO), and research services to predominantly institutional clients1, such as university endowments, private and public foundations, religious organizations, healthcare institutions, corporate retirement plans, and select family offices.

Founded in 1988, FEG has served communities, both directly and by helping our clients fulfill their missions, for over 35 years. FEG employs 135+ professionals across offices in Cincinnati, Ohio, Dallas, Texas, and Indianapolis, Indiana, with approximately $91.4 billion2 in client assets under advisement.

LIMITATIONS AND DISCLAIMER

The above job description is meant to describe the general nature and level of work being performed; it is not intended to be construed as an exhaustive list of all responsibilities, duties and skills required for the position.

All job requirements are subject to possible modification to reasonably accommodate individuals with disabilities. Some requirements may exclude individuals who pose a direct threat or significant risk to the health and safety of themselves or other employees.

This job description in no way states or implies that these are the only duties to be performed by the employee occupying this position. Employees will be required to follow any other job-related instructions and to perform other job-related duties requested by their supervisor in compliance with Federal and State Laws.

Requirements are representative of minimum levels of knowledge, skills and/or abilities. To perform this job successfully, the employee must possess the abilities or aptitudes to perform each duty proficiently. Continued employment remains on an “at-will” basis.

1Institutional clients include Charitable organizations, Community Foundations, Corporate, Healthcare, Higher Education, Independent Schools, Insurance, Native American Tribes, Private Foundations, Public Funds, Religious organizations, and Taft Hartley. Nonprofit clients include Charitable organizations, Community Foundations, Healthcare (nonprofit), Higher Education, Independent Schools, Private Foundations, and Religious Organizations.

2As of December 31,2024, Assets under Advisement (AUA) include discretionary and non-discretionary assets of FEG and its affiliated entities. These assets are typically non-discretionary. Some asset values may not be readily available at the most recent quarter-end; therefore, the previous quarter's values were used and may be higher or lower depending on current market conditions. Of the $91.4bn in AUA, FEG's total assets under management (AUM) of $16.6bn includes discretionary of ($14.3bn) and non-discretionary AUM ($2.3bn).

FEG Investment Advisors is an Equal Opportunity Employer. FEG Investment Advisors does not discriminate in its employment decisions based on race, religion, color, national origin, sex (including pregnancy, gender identity and sexual orientation), age (40 or older), disability, veteran or military status, genetic information, or any other basis that would violate any applicable federal, state, or local law.