BI Developer II

September 14

Apply Now

Receive Emails with Similar Jobs

Rackspace Technology

WebsiteLinkedInAll Job Openings

IT as a Service • Multi-Cloud • Managed Hosting • Managed AWS/Azure/Google Cloud Platform/OpenStack/Alibaba • Managed Private Cloud for VMware/Microsoft/OpenStack

5001 - 10000

Description

• Works with business requirement team, analysts, and developers to ensure stakeholder requirements are addressed through integration solutions in a manner that aligns with timelines, budgets, and quality expectations. • Leads the design and development of the Business Intelligence (BI) architecture and continually refines the BI strategy to align with corporate direction. • Serves as the subject matter expert in the extraction of information from EFD, Star, and Snowflake schemas. • Builds operational and ad-hoc reports. • Builds reports that take advantage of OLAP/Dimensional Modeling capabilities. • Build executive dashboards and corporate scorecards. • Works with customers to define their requirements and create information delivery solutions that meet their needs utilizing “best practices.” • Develops and implements data integration strategy and associated policies as it pertains to lean integration practices. • Participates in design and development reviews. • Works with system owners to resolve data transformation issues and to refine transformation. • Writes software in an open-source setting (number of branches merged). • Writes design documents. • Reviews proposed software branches (number of reviews). • Reviews design documents (number of reviews). • Participates in project discussions (number of emails etc.)

Requirements

• Strong skills in Excel and T-SQL recommended. • Comfort using Qlikview is desirable. • Advanced level of competence with database structures and design as well as possessing strong SQL development skills with the ability to build reporting tables, stored procedures, and Chron Jobs. • Basic understanding of relational and columnar database platforms such as MSSQL, My SQL, Oracle, Postgresql, and Cassandra. • Working knowledge of CORE and Salesforce. • Advanced QV skills such as set analysis, variables, actions, triggers, and QVD building. • Business analysis skills to allow for the creation of report definitions and specifications. • Basic proficiency in one or more of the following tools: MS Access, .Net, ASP, VB, MongoDB, Hadoop, etc. • Ability to communicate technical information and ideas so that others will understand. • Must be able to make appropriate decisions considering the relative costs and benefits of potential actions. • Must successfully work and promote inclusiveness in small groups. • Excellent communication skills, both oral and written. • Ability to develop work plans and follow through on assignments with minimal guidance. • Ability to work with business and system owners to obtain requirements and manage expectations.