E-Safe provides top quality Information Technology solutions in hardware, software and project services. We are a leading Information Technology/Data Center VAR in the Pennsylvania, Ohio, and West Virginia region. E-Safe’s customers include leading companies across multiple verticals including healthcare, banking, manufacturing, retail, education, and others. We deliver “best of breed” solutions custom tailored to meet our client's needs. We specialize in core data center functionality, cloud, managed services, backup & disaster recovery services, consulting, and integration solution services. Since 1989 we have established and consistently grown our client base with evolving services, products and consulting.
This is a hands-on technical role. This position requires a resource with proven experience and knowledge of data warehousing and business intelligence, with emphasis on data architecture, sourcing, reporting and analytics through the entire project lifecycle. The Business Intelligence (BI) Developer will play a key role in the architecture, delivery and governance of reporting and data delivery. This resource will be responsible for ensuring that organization creates and adheres to Business Intelligence best practices and principles.
Key contributor to Business Intelligence (BI) & Data Management Strategy including: Information Architecture, Data Architecture, Master Data Management Architecture, Metadata Architecture and Information Delivery Life Cycle (IDLC).
Participates in the creation and maintenance of Data Standards, Best Practices, Disciplines & Methods for Data Architecture, Data Modeling, Data Management & Data Governance (including Data Quality & Metadata) and Data Security (including PII).
Works with the Data Warehouse and Business Intelligence teams to produce BI Solutions that meet business information requirements and objectives.
Participates in the implementation and enhancement of the Enterprise Business Glossary used to document Business Terms, Business Rules, etc.
Participates in Business Intelligence tool and evaluations, selections, implementation and support.
Implement changes to reporting, warehouse, MDX Queries, and other components of the BI path.
Proven experience with front-end reporting tools, preferably LogiAnalytics (formerly LogiXML) along with SQL Server Reporting Services (SSRS), web application development, design, and implementation.
Understand, formulate and create MDX Queries to prepare data for presentation within the reporting tools.
Provide dashboard/reporting functionality and create key performance indicators, calculations, and metrics on web and mobile applications
Work in conjunction with offshore data architects/modelers on the backend data warehouse reporting solution running on SQL Server 2012
Extract, transform, and load (ETL) data from various source systems to the data warehouse covering a variety of technical scenarios encountered in the construction of complex data warehousing solutions, including T-SQL, SSIS, and other data manipulation tools within the Microsoft Suite of Products.
SQL Server Analysis Services (SSAS) design and build experience including multi-tier infrastructures, partitioning, aggregations, proactive caching, actions, and role and data-level security.
Proven experience sourcing data from a variety of applications, creating OLAP models, and generating multi-dimensional cubes using SSAS
Prepare deliverables such as source to target mappings and transformation rules documentation
Minimum 4 years of relevant work experience as a technical BI Developer
Four-year college diploma or university degree in computer science or computer engineering is preferred
Technically fluent with relational databases - SQL Server 2008, SQL Server 2012
Experience with SAS business analytics software preferred
Will interact with all IT employees on a regular basis as well as other cross-functional team-members at the Administrative Offices and Centers.
Non-Center Based. Requires: The ability to sit at a computer for hours at a time (with some bending and stooping) and travel to Centers (if so, the noise level is moderate and there is potential for exposure to infectious diseases and blood-borne pathogens).
E-Safe provides top quality Information Technology solutions in hardware, software and project services. We are a leading Information Technology Data Center VAR in the Pennsylvania, Ohio and West Virginia region. E=Safe’s customers include leading companies across multiple verticals including healthcare, banking, manufacturing, retail, education and others. We deliver “best of breed” solutions ...custom tailored to meet our client’s needs. We specialize in core data center functionality, cloud, managed services, backup & disaster recovery services, and consulting and integration solution services. Since 1989 we have established and consistently grown our client base with evolving services, products and consulting.