Job Description :
Development of software products by writing, testing, and documenting code (80%)
o Develop expertise in both Source and Data Warehouse data.
o Create written communication materials that effectively summarize findings and support recommendations.
o Design and implement the reporting solution through the use of Microsoft technology, e.g., Power BI, Excel 2013, data cubes, or reporting services.
o Assist in enforcing both Company design and coding standards as well as industry best practices.
o Provide support to the business community for self-service BI.
o Provide secondary production support to current and planned Microsoft BI reporting and data layers.
· Generate technical requirements and processes (10%)
o Solicit business reporting and analytical requirements from a variety of business departments.
o Consolidate and coordinate requirements to develop reporting or analytical capabilities to address the business need.
· Provide guidance and training to other functional groups as needed (5%)
· Other duties as assigned by Team leader (5%)
Required Skills and Experience:
· BA/BS degree in Computer Science, Information Technology, Engineering or related field.
· Minimum 5 years of database design or integration experience with SQL Server databases.
· Minimum 3 years of Business Intelligence experience.
· Experience with Microsoft SQL Server 2012, 2014 and/or 2016, including Microsoft SSAS, SSRS, and SSIS.
· Extraction, Transformation and Loading (ETL) (Microsoft SSIS
· Analytics / Cube Development (MDX
· Microsoft Power BI, Excel 2013 PowerPivot, PowerView capabilities.
· Solid analytical and interpersonal skills. Effective listener who can translate business needs into comprehensive solutions.
· Experience with SharePoint integration of Power BI.
· Proficiency with Microsoft Office tools including Word, Outlook, Excel, PowerPoint
· Experience implementing reporting solutions in a large technology oriented organization preferred.
· Excellent verbal and written communication skills.
· Ability to simplify communicating technical information to business users.
· Demonstrated ability to effectively interact and communicate with multiple levels of management.
· Strong organizational skills with ability to manage projects/priorities effectively
Preferred Skills and Experience:
· Master’s degree in Computer Science, Information Technology, Engineering or related field.
· Experience with other BI platforms such as SAP Business Objects and/or IBM Cognos a plus.
· Experience/interaction/Knowledge with Open Source Big Data stack, such as HBase, HIVE, Phoenix and/or MongoDB.
· Experience with other database technologies in addition to Microsoft SQL Server, Oracle, Sybase.
· Familiarity with networking and network devices in a Linux environment
· Familiarity with Agile methodologies.