drjobs Data Warehouse Developer

Data Warehouse Developer

Employer Active

1 Vacancy
drjobs

Job Alert

You will be updated with latest job alerts via email
Valid email field required
Send jobs
Send me jobs like this
drjobs

Job Alert

You will be updated with latest job alerts via email

Valid email field required
Send jobs
Job Location drjobs

Cincinnati, OH - USA

Monthly Salary drjobs

Not Disclosed

drjobs

Salary Not Disclosed

Vacancy

1 Vacancy

Job Description

Location: Cincinnati OH
Department: Technology
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 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.
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.
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 135professionals 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 clientsinclude Charitable organizations Community Foundations Corporate Healthcare Higher Education Independent Schools Insurance Native American Tribes Private Foundations Public Funds Religious organizations and Taft Hartley.Nonprofit clientsinclude Charitable organizations Community Foundations Healthcare (nonprofit) Higher Education Independent Schools Private Foundations and Religious Organizations.
2As of December 312024 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 quarters values were used and may be higher or lower depending on current market conditions. Of the $91.4bn in AUA FEGs 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.

Employment Type

Full Time

Company Industry

About Company

Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.