Data Warehouse Developer

Description

Work in a highly collaborative team environment following the Agile methodology to assist other department personnel in the successful accomplishment of strategic and divisional objectives. Take the necessary steps to ensure our customers' needs are met to the maximum extent possible in an accurate and timely manner. Lead and collaborate in the data management efforts including operational data support to provide a high level of data integrity, security and availability for internal and external customers.
Establish and maintain a scalable, extensible and maintainable architecture for the enterprise data warehouse and business intelligence system. Summarize enterprise data into an intuitive analysis framework for understanding the current and future performance of the company. Provide the design, development, testing and maintenance of ETL processes, reporting and dashboards to support Association strategic objectives.
Collaborate with other business unit leaders for various projects involving enterprise data. Ensure the appropriate capture and retention of enterprise data. Work with Business Analysts to translate various business needs into warehousing, analytics, reporting, and dashboarding requirements. Educate other business units and Information Technology teams about the analytics and reporting advantages available to them through Business Intelligence.
Provide expertise to achieve system integration through database design, including data and dimensional modeling, logical and physical table design, complex queries, stored procedures and triggers, data transformation, aggregation and enterprise application integration.
Develop and implement data warehouse and business intelligence standards and best practices. Mentor, support and provide direction to lesser experienced teammates.
Support the analytical needs of business units by researching and analyzing data from various sources, and incorporate data into existing processes and systems as needed by using expert level understanding of how data, technology and data work together to serve our customers.
Conduct analysis on datasets, including efficient extraction, manipulation, and analysis of complex datasets. Analyze data and information in innovative ways to assist with strategic decisions and optimize process efficiencies. Ensure all necessary data elements are available for model building and strategy analysis.
Research emerging technologies, trends and benchmark data to make recommendations to improve customer experience, architecture, processes and tools.
You bring to the table Bachelors degree in Computer Science, MIS, Statistics, Engineering or equivalent training and experience
5+ years of experience in data warehouse and/or business intelligence development, or comparable IT field. Experience in architecting largescale data warehouse.
5+ years of experience developing in TSQL
Strong computer literacy and proficiency in data manipulation and reporting tools with demonstrated highly skilled knowledge of SSMS, TSQL, SSAS, SSIS, SSRS, Excel and PowerPivot
High level of proficiency with database and data warehouse development including replication, staging, ETL, stored procedures, partitioning, change data capture, triggers, scheduling tools, cubes and data marts
Strong analytical, data mining, data modeling and data management skills, Leadership and judgment to analyze, evaluate, and develop solutions to complex problems
Creative and critical thinking ability; excellent troubleshooting and problemsolving skills
Selfmotivated and driven to produce quality products
Ability to work effectively in a collaborative team environment and effectively demonstrate team building attitude and skills
Demonstrated ability to be flexible and perform a variety of roles such as analyst, tester, and mentor