Data Warehouse Developer

Data Warehouse Developer

Location: Cincinnati, OH

Department: Technology

Join to apply for the Data Warehouse Developer role at Achievers Network. For additional information or to apply for this opportunity, please visit

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.

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

• 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.

• 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.

• 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.

• 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.

• 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, Power Shell, 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…