Job TitleWork Location: ONSITE - Houston, TXResponsibilitiesResponsible for building, implementing, and supporting reporting solutions for our enterprise clients. The right individual will possess experience in all stages of BI project work requirements and logical design, physical design, implementation, testing, and deployment.Develop data models, ETL packages, OLAP cubes, and reports utilizing Power BI, applying best practices to the development lifecycle. Documentation of source-to-target mappings, data dictionaries, and database design. Identify areas of improvement to optimize data flows.Analyze data models and optimize data structures. Investigate and implement business intelligence for your entire organization. Collaborate with data management.Demonstrates proficiency in the development and administration at least one of the following areas:Backend data integration and architecture including dimensional data modeling, database design, data warehousing, ETL development, and performance tuningFrontend reporting and analytics platforms including OLAP cube design, tabular data modeling, Performance Point, Power Pivot, Power View, Power BI Report, and Dashboard developmentSkillsExtremely strong SQL skillsPower On with Power BICandidate should be able to Use the platform to plan, forecast, and analyze dataCandidate should be able to Edit data in dashboards, reports, or appsCandidate should be able to Save changes to the underlying data repositoryCandidate should be able to Use the platform to experiment with planning scenariosCandidate should be able to Use the platform to add comments, remarks, or annotations to data pointsCandidate should be able to Use the platform to create statistical, operational, or financial metricsCandidate should be able to Use the platform to create actual forecast and planning data in the same matrixCandidate should be able to Use the platform to adjust numbers with a mouse or touch screenSnowflakeMastery of SQL especially within cloud-based data warehouses like Snowflake.
Experience on Snowflake with data architecture design, analytics, and developmentDetailed knowledge and hands-on working experience in SnowProc, SnowSqlAbility to write Snow Procedures in preferable language to handle data transformationsStrong development background having 2-3 years of rich hands-on development experience in snowflakeStrong hands-on experience on IICS with Data Extraction, transformation, and data loading from different sources to SnowflakeWorking knowledge of Data engineering best practices. Should be willing to work in implementation support projects. Flexible with working timings if required to coordinate with Onsite teamMandatory SkillsANSI-SQL, Dimensional Data Modeling, PowerBIRequired SkillsPowerBIBasic QualificationAdditional Skills:Background Check: NoDrug Screen: No