Work closely with Chief Architect, development groups and infrastructure groups to engineer an enterprise data warehouse solution in the Microsoft Azure stack. - Provide production support for BI environment in the areas of security, troubleshooting, system monitoring and performance tuning. - Design, analyze and build ETL programs to populate enterprise data warehouse on a scheduled basis and live. - Design, develop and provide level 2 support to end-users for SSRS, Microsoft Power. BI and othe... more details
Duties and Responsibilities
• Work closely with Chief Architect, development groups and infrastructure groups to engineer an enterprise data warehouse solution in the Microsoft Azure stack.
• Provide production support for BI environment in the areas of security, troubleshooting, system monitoring and performance tuning.
• Design, analyze and build ETL programs to populate enterprise data warehouse on a scheduled basis and live.
• Design, develop and provide level 2 support to end-users for SSRS, Microsoft PowerBI and other internal reporting systems.
• Ensure on-time and continuous data transformation to the Data Warehouse.
• Create and maintain technical documentation of BI environment.
• Perform ad hoc analysis and data query results for various business units.
Competencies
• Demonstrates accuracy, thoroughness, and monitors own work to ensure quality.
• Gathers and analyzes information skillfully, identifies and resolves problems in a timely manner.
• Prioritizes and plans work activities, uses time efficiently and develops realistic action plans.
• Demonstrates excellent written and verbal communication skills. Listens effectively, transmits information accurately and understandably, and actively seeks feedback.
• Have a demonstrated interest in both sharing knowledge and cross-training other team members as well as gaining insight from other team members experience and expertise.
• Customer service skills required to relate to a variety of business users to gather requirements and assist them in displaying the data in in formats relative to the audience.
• Demonstrates professionalism, discretion, and good judgment in all interactions with co-workers, customers, vendors, and others.
• Handles confidential and sensitive information and records with a high degree of discretion, diligence, and good judgment.
• Demonstrates a high degree of self-management and motivation.
• Interest and learning remaining extremely fresh technologically and familiar with new and emerging practices and products
Qualifications
• Bachelor’s Degree in Computer Science, with preference in database administration.
• 5+ years of Database administration and optimization.
• 5+ years of experience in developing automated reports and dashboards using various toolsets including but not limited to Power BI, and SSRS.
• 5+ years of experience in database development experience in a BI and data warehouse environment using the full Microsoft Development stack; recent Microsoft Azure experience required.
• 2+ years of project management experience.
• Ability to plan, organize and management multiple tasks during normal agile sprint environment.
• Demonstrated proficiency in data modeling, both relational and dimensional.
• Demonstrated proficiency in extracting data from and analyzing data in relational database systems creating ETL solutions.
• Proficiency in SQL Server, MySQL, TSQL, JSON, Python and other programming languages.
• Deep experience using Microsoft Excel in reporting, pivot table and graphing.
We encourage you to apply even if you do not meet all qualifications.