.We are looking for a BI Developer II with experience in developing and maintaining a business intelligence framework.Must be fluent in EnglishResponsibilitiesWorks 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.).QualificationsStrong 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, MySQL, 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 Bachelor's degree in Computer Science, MIS, or Business Administration.Work LocationThe role can work remotely in the states of Ciudad de Mexico, Jalisco, Nuevo Leon, Aguascalientes, Queretaro, Estado de Mexico, and Puebla
