BI Developer II

Responsibilities

• 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.)

Qualifications

• 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.
• Requires a Bachelors degree in Computer Science, MIS, or Business Administration.


Discover your inner Racker: Racker Life