The Data Warehouse Senior Software Engineer role will work with data and code to deliver exceptional data analytics to our partners. The position will work on the reporting and analytics in an agile team to plan, design, and execute on business intelligence solutions. The solutions include Azure Cloud and Power BI, AWS, SQL Server on the back end with visualization and UX provided through a C# website with Angular components for our external partners.
Plan, create, coordinate, and deploy data warehouse databases and transformations
Create and apply best practices for data loading and transformation
Develop data architecture, data modeling, and mapping solutions within a structured data warehouse environment
Prepare PowerQuery data models in Power BI
Design/code applications following specifications using the appropriate tools
Maintain and modify existing applications (independently or under direction from senior staff members)
Assume responsibility for ongoing data architecture for the product
Ability to effectively communicate technical concepts to other technical staff members.
Ability to interface well with Professional Service staff and other non-technical members of the organization.
Demonstrated aptitude for learning new technologies.
Knowledge relating to the area in which analysis and coding is performed.
Experience with data modeling in a database or visualization tool
Experience with Power BI or other visualization tools, including DAX and MDX
Bachelor’s degree in Computer Science or related area or equivalent education or work experience.
4+ years of experience working in business intelligence
Experience in relational database development, specifically SQL
Experience with cloud data solutions such as Azure/PowerBI, Snowflake or AWS data warehouse solutions.
Experience with SQL Server and Transact-SQL
Experience developing in a .NET framework.
Experience with Angular or Javascript
Experience with Azure DevOps and Git repositories
Experience with Scrum