FEG Investment Advisors
Data Warehouse Developer (Full-Time)
FEG Investment Advisors, Cincinnati, Ohio, United States, 45208
Overview
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. Location:
Cincinnati, OH (On-site) What Youll 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. Provide on-call support during off hours, evenings, and weekends for critical incidents affecting data processing environments and/or production systems. 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.
Youll 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
Bachelors 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.
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 clients, 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 140+ professionals across offices in Cincinnati, Ohio, Dallas, Texas, and Indianapolis, Indiana, with approximately $92.5 billion in client assets under advisement. 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. #J-18808-Ljbffr
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. Location:
Cincinnati, OH (On-site) What Youll 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. Provide on-call support during off hours, evenings, and weekends for critical incidents affecting data processing environments and/or production systems. 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.
Youll 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
Bachelors 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.
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 clients, 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 140+ professionals across offices in Cincinnati, Ohio, Dallas, Texas, and Indianapolis, Indiana, with approximately $92.5 billion in client assets under advisement. 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. #J-18808-Ljbffr