Epikso - San Ramon, CA

posted 3 months ago

Full-time - Mid Level
Hybrid - San Ramon, CA

About the position

The Power BI Developer/Analyst position at Epik Solutions in San Ramon, CA, is a hybrid role that combines both onsite and remote work, requiring employees to be onsite three days a week and work remotely for two days. This position is crucial for building and maintaining automated and static reports using tools such as Excel, SQL, and Power BI. The successful candidate will be responsible for developing and managing data pipelines, performing data analysis, and creating business-critical dashboards that facilitate decision-making processes within the organization. The role demands a strong background in data warehousing and business intelligence, particularly in Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP). Candidates should have experience in data extraction, cleansing, profiling, mining, and consolidation, ensuring data quality across various business data feeds. The position also requires expertise in SQL, including the ability to create complex stored procedures, user-defined functions, and optimize queries for performance. In addition to technical skills, the ideal candidate will possess strong problem-solving abilities and analytical skills, enabling them to design and develop complex data engineering projects. Excellent communication and interpersonal skills are essential, as the role involves collaboration with team members and stakeholders. A bachelor's or master's degree in computer science, data engineering, data science, data analytics, or a related field is required for this position.

Responsibilities

  • Build and maintain automated and static reports using Excel, SQL, and Power BI.
  • Develop and manage data pipelines for data extraction, cleansing, and transformation.
  • Create business-critical dashboards using Power BI Desktop Service.
  • Design and implement efficient end-to-end data migration pipelines using Azure Data Factory or similar tools.
  • Perform complex SQL query building and optimizations for data manipulation and integrity.
  • Develop complex stored procedures, user-defined functions, DML triggers, views, and indexes.
  • Conduct data analysis for OLTP and OLAP environments, ensuring data quality and accuracy.
  • Collaborate with team members to design and develop complex data engineering projects.

Requirements

  • Experience in building and maintaining automated and static reports using Excel, SQL, and Power BI.
  • Knowledge of data warehousing and business intelligence applications.
  • Expertise in predictive and prescriptive analytics.
  • In-depth knowledge of SQL query building and optimizations.
  • Experience in creating complex stored procedures and user-defined functions.
  • Proficiency in developing data pipelines and data migration processes.
  • Strong problem-solving and analytical skills.
  • Excellent communication and interpersonal skills.
  • Bachelor's or master's degree in computer science, data engineering, data science, data analytics, or a related field.

Nice-to-haves

  • Experience with Azure Functions as webhooks to consume data from APIs.
  • Familiarity with performance tuning in MS SQL and SSRS/SSIS.
  • Knowledge of DAX queries and data visualization techniques in Power BI.

Benefits

  • Competitive salary range of $100,000 - $140,000 annually plus benefits.
  • Hybrid work schedule (3 days onsite, 2 days remote).
  • Equal Opportunity Employer with a commitment to diversity and inclusion.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service